TFS_ANTIGUO/PrendarioDavivienda/ESTRUCTURA_BD/ESTRUCTURA_Ultimus.ComponentManager.txt

<EFBFBD><EFBFBD>USE [Ultimus.ComponentManager]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_FormInView_Form]') AND parent_object_id = OBJECT_ID(N'[View].[FormInView]'))
ALTER TABLE [View].[FormInView] DROP CONSTRAINT [FK_FormInView_Form]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_FormInView_Filter]') AND parent_object_id = OBJECT_ID(N'[View].[FormInView]'))
ALTER TABLE [View].[FormInView] DROP CONSTRAINT [FK_FormInView_Filter]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_FormInView_ComplementView]') AND parent_object_id = OBJECT_ID(N'[View].[FormInView]'))
ALTER TABLE [View].[FormInView] DROP CONSTRAINT [FK_FormInView_ComplementView]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_ControlInForm_FormInView]') AND parent_object_id = OBJECT_ID(N'[View].[ControlInForm]'))
ALTER TABLE [View].[ControlInForm] DROP CONSTRAINT [FK_ControlInForm_FormInView]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_ControlInForm_Controls]') AND parent_object_id = OBJECT_ID(N'[View].[ControlInForm]'))
ALTER TABLE [View].[ControlInForm] DROP CONSTRAINT [FK_ControlInForm_Controls]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Theme].[FK_ThemeProcess_Themes]') AND parent_object_id = OBJECT_ID(N'[Theme].[ThemeProcess]'))
ALTER TABLE [Theme].[ThemeProcess] DROP CONSTRAINT [FK_ThemeProcess_Themes]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Theme].[FK_ThemeProcess_CatProcesses]') AND parent_object_id = OBJECT_ID(N'[Theme].[ThemeProcess]'))
ALTER TABLE [Theme].[ThemeProcess] DROP CONSTRAINT [FK_ThemeProcess_CatProcesses]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Document].[FK_DocumentosProceso_ConfiguracionGeneralDocumentos]') AND parent_object_id = OBJECT_ID(N'[Document].[DocumentosProceso]'))
ALTER TABLE [Document].[DocumentosProceso] DROP CONSTRAINT [FK_DocumentosProceso_ConfiguracionGeneralDocumentos]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Document].[FK_ConfiguracionGeneralDocumentos_CatProcesses]') AND parent_object_id = OBJECT_ID(N'[Document].[ConfiguracionGeneralDocumentos]'))
ALTER TABLE [Document].[ConfiguracionGeneralDocumentos] DROP CONSTRAINT [FK_ConfiguracionGeneralDocumentos_CatProcesses]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.WebAplicationDetails_dbo.CatWebAplications_IdWebAplication]') AND parent_object_id = OBJECT_ID(N'[dbo].[WebAplicationDetails]'))
ALTER TABLE [dbo].[WebAplicationDetails] DROP CONSTRAINT [FK_dbo.WebAplicationDetails_dbo.CatWebAplications_IdWebAplication]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.WebAplicationDetails_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[WebAplicationDetails]'))
ALTER TABLE [dbo].[WebAplicationDetails] DROP CONSTRAINT [FK_dbo.WebAplicationDetails_dbo.CatProcesses_IdProcess]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.HistoryConfiguration_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[HistoryConfiguration]'))
ALTER TABLE [dbo].[HistoryConfiguration] DROP CONSTRAINT [FK_dbo.HistoryConfiguration_dbo.CatProcesses_IdProcess]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.HelpProcess_dbo.CatForms_IdForm]') AND parent_object_id = OBJECT_ID(N'[dbo].[HelpProcess]'))
ALTER TABLE [dbo].[HelpProcess] DROP CONSTRAINT [FK_dbo.HelpProcess_dbo.CatForms_IdForm]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.FormsProcess_dbo.CatSteps_IdStep]') AND parent_object_id = OBJECT_ID(N'[dbo].[FormsProcess]'))
ALTER TABLE [dbo].[FormsProcess] DROP CONSTRAINT [FK_dbo.FormsProcess_dbo.CatSteps_IdStep]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.FormsProcess_dbo.CatForms_IdForm]') AND parent_object_id = OBJECT_ID(N'[dbo].[FormsProcess]'))
ALTER TABLE [dbo].[FormsProcess] DROP CONSTRAINT [FK_dbo.FormsProcess_dbo.CatForms_IdForm]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Conditions_BusinessRules]') AND parent_object_id = OBJECT_ID(N'[dbo].[Conditions]'))
ALTER TABLE [dbo].[Conditions] DROP CONSTRAINT [FK_Conditions_BusinessRules]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.CatSteps_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatSteps]'))
ALTER TABLE [dbo].[CatSteps] DROP CONSTRAINT [FK_dbo.CatSteps_dbo.CatProcesses_IdProcess]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.CatForms_dbo.CatWebAplications_IdWebAplication]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatForms]'))
ALTER TABLE [dbo].[CatForms] DROP CONSTRAINT [FK_dbo.CatForms_dbo.CatWebAplications_IdWebAplication]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Email_Processes]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatEmailProcess]'))
ALTER TABLE [dbo].[CatEmailProcess] DROP CONSTRAINT [FK_Email_Processes]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.CatConnections_dbo.CatConnectionTypes_IdConnectionType]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatConnections]'))
ALTER TABLE [dbo].[CatConnections] DROP CONSTRAINT [FK_dbo.CatConnections_dbo.CatConnectionTypes_IdConnectionType]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BusinessRules_CatSteps1]') AND parent_object_id = OBJECT_ID(N'[dbo].[BusinessRules]'))
ALTER TABLE [dbo].[BusinessRules] DROP CONSTRAINT [FK_BusinessRules_CatSteps1]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BusinessRules_CatSteps]') AND parent_object_id = OBJECT_ID(N'[dbo].[BusinessRules]'))
ALTER TABLE [dbo].[BusinessRules] DROP CONSTRAINT [FK_BusinessRules_CatSteps]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditTablesVsSteps_dbo.CatSteps_IdStep]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditTablesVsSteps]'))
ALTER TABLE [dbo].[AuditTablesVsSteps] DROP CONSTRAINT [FK_dbo.AuditTablesVsSteps_dbo.CatSteps_IdStep]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditTablesVsSteps_dbo.AuditTablesDefinition_IdTableDefinition]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditTablesVsSteps]'))
ALTER TABLE [dbo].[AuditTablesVsSteps] DROP CONSTRAINT [FK_dbo.AuditTablesVsSteps_dbo.AuditTablesDefinition_IdTableDefinition]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditTablesDefinition_dbo.CatAuditTablesStatus_IdTablesStatus]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditTablesDefinition]'))
ALTER TABLE [dbo].[AuditTablesDefinition] DROP CONSTRAINT [FK_dbo.AuditTablesDefinition_dbo.CatAuditTablesStatus_IdTablesStatus]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditConnectionProcess_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]'))
ALTER TABLE [dbo].[AuditConnectionProcess] DROP CONSTRAINT [FK_dbo.AuditConnectionProcess_dbo.CatProcesses_IdProcess]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionOrigin]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]'))
ALTER TABLE [dbo].[AuditConnectionProcess] DROP CONSTRAINT [FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionOrigin]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionDestination]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]'))
ALTER TABLE [dbo].[AuditConnectionProcess] DROP CONSTRAINT [FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionDestination]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditColumnsDefinition_dbo.AuditTablesDefinition_IdTableDefinition]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditColumnsDefinition]'))
ALTER TABLE [dbo].[AuditColumnsDefinition] DROP CONSTRAINT [FK_dbo.AuditColumnsDefinition_dbo.AuditTablesDefinition_IdTableDefinition]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Group_Proceso]') AND parent_object_id = OBJECT_ID(N'[Controls].[Group]'))
ALTER TABLE [Controls].[Group] DROP CONSTRAINT [FK_Group_Proceso]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Form_Process]') AND parent_object_id = OBJECT_ID(N'[Controls].[Form]'))
ALTER TABLE [Controls].[Form] DROP CONSTRAINT [FK_Form_Process]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Filter_Process]') AND parent_object_id = OBJECT_ID(N'[Controls].[Filter]'))
ALTER TABLE [Controls].[Filter] DROP CONSTRAINT [FK_Filter_Process]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_ConfiguracionControles_Formulario]') AND parent_object_id = OBJECT_ID(N'[Controls].[ControlsSettings]'))
ALTER TABLE [Controls].[ControlsSettings] DROP CONSTRAINT [FK_ConfiguracionControles_Formulario]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_ConfiguracionControles_Filtro]') AND parent_object_id = OBJECT_ID(N'[Controls].[ControlsSettings]'))
ALTER TABLE [Controls].[ControlsSettings] DROP CONSTRAINT [FK_ConfiguracionControles_Filtro]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_ConfiguracionControles_CatContol]') AND parent_object_id = OBJECT_ID(N'[Controls].[ControlsSettings]'))
ALTER TABLE [Controls].[ControlsSettings] DROP CONSTRAINT [FK_ConfiguracionControles_CatContol]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Controls_Group]') AND parent_object_id = OBJECT_ID(N'[Controls].[Controls]'))
ALTER TABLE [Controls].[Controls] DROP CONSTRAINT [FK_Controls_Group]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_CatControles_Formulario]') AND parent_object_id = OBJECT_ID(N'[Controls].[Controls]'))
ALTER TABLE [Controls].[Controls] DROP CONSTRAINT [FK_CatControles_Formulario]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_CatControles_CatTipoDato]') AND parent_object_id = OBJECT_ID(N'[Controls].[Controls]'))
ALTER TABLE [Controls].[Controls] DROP CONSTRAINT [FK_CatControles_CatTipoDato]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_PersonaProceso_TipoPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[PersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[PersonaProceso] DROP CONSTRAINT [FK_PersonaProceso_TipoPersona]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_PersonaProceso_CatProcesses]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[PersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[PersonaProceso] DROP CONSTRAINT [FK_PersonaProceso_CatProcesses]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_ParametrosPersonaProceso_PersonaProceso]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[ParametrosPersonaProceso] DROP CONSTRAINT [FK_ParametrosPersonaProceso_PersonaProceso]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_ParametrosPersonaProceso_ParametrosGeneralesPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[ParametrosPersonaProceso] DROP CONSTRAINT [FK_ParametrosPersonaProceso_ParametrosGeneralesPersona]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_ParametrosGeneralesPersona_TipoParametroPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosGeneralesPersona]'))
ALTER TABLE [ConfiguracionPersona].[ParametrosGeneralesPersona] DROP CONSTRAINT [FK_ParametrosGeneralesPersona_TipoParametroPersona]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_FormularioPersonaProceso_PersonaProceso1]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[FormularioPersonaProceso] DROP CONSTRAINT [FK_FormularioPersonaProceso_PersonaProceso1]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_FormularioPersonaProceso_FormularioPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[FormularioPersonaProceso] DROP CONSTRAINT [FK_FormularioPersonaProceso_FormularioPersona]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_FormularioPersona_TipoPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersona]'))
ALTER TABLE [ConfiguracionPersona].[FormularioPersona] DROP CONSTRAINT [FK_FormularioPersona_TipoPersona]
GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__Cat_DiasF__fecha__150615B5]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Cat_DiasFestivos] DROP CONSTRAINT [DF__Cat_DiasF__fecha__150615B5]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__ASPStateT__Flags__7EE1CA6C]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ASPStateTempSessions] DROP CONSTRAINT [DF__ASPStateT__Flags__7EE1CA6C]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__ASPStateT__Creat__7DEDA633]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ASPStateTempSessions] DROP CONSTRAINT [DF__ASPStateT__Creat__7DEDA633]
END

GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[ConfiguracionPersona].[DF_PersonaProceso_CodigoTipoPersona]') AND type = 'D')
BEGIN
ALTER TABLE [ConfiguracionPersona].[PersonaProceso] DROP CONSTRAINT [DF_PersonaProceso_CodigoTipoPersona]
END

GO
/****** Object:  Table [View].[FormInView]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[View].[FormInView]') AND type in (N'U'))
DROP TABLE [View].[FormInView]
GO
/****** Object:  Table [View].[ControlInForm]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[View].[ControlInForm]') AND type in (N'U'))
DROP TABLE [View].[ControlInForm]
GO
/****** Object:  Table [View].[ComplementView]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[View].[ComplementView]') AND type in (N'U'))
DROP TABLE [View].[ComplementView]
GO
/****** Object:  Table [Theme].[Themes]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Theme].[Themes]') AND type in (N'U'))
DROP TABLE [Theme].[Themes]
GO
/****** Object:  Table [Theme].[ThemeProcess]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Theme].[ThemeProcess]') AND type in (N'U'))
DROP TABLE [Theme].[ThemeProcess]
GO
/****** Object:  Table [Profile].[Profile]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Profile].[Profile]') AND type in (N'U'))
DROP TABLE [Profile].[Profile]
GO
/****** Object:  Table [Process].[DocumentosAdjuntos]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Process].[DocumentosAdjuntos]') AND type in (N'U'))
DROP TABLE [Process].[DocumentosAdjuntos]
GO
/****** Object:  Table [Process].[BitacoraCorreos]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Process].[BitacoraCorreos]') AND type in (N'U'))
DROP TABLE [Process].[BitacoraCorreos]
GO
/****** Object:  Table [Process].[BitacoraComentarios]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Process].[BitacoraComentarios]') AND type in (N'U'))
DROP TABLE [Process].[BitacoraComentarios]
GO
/****** Object:  Table [Document].[DocumentosProceso]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Document].[DocumentosProceso]') AND type in (N'U'))
DROP TABLE [Document].[DocumentosProceso]
GO
/****** Object:  Table [Document].[ConfiguracionGeneralDocumentos]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Document].[ConfiguracionGeneralDocumentos]') AND type in (N'U'))
DROP TABLE [Document].[ConfiguracionGeneralDocumentos]
GO
/****** Object:  Table [dbo].[WebAplicationDetails]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WebAplicationDetails]') AND type in (N'U'))
DROP TABLE [dbo].[WebAplicationDetails]
GO
/****** Object:  Table [dbo].[HistoryConfiguration]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[HistoryConfiguration]') AND type in (N'U'))
DROP TABLE [dbo].[HistoryConfiguration]
GO
/****** Object:  Table [dbo].[HelpProcess]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[HelpProcess]') AND type in (N'U'))
DROP TABLE [dbo].[HelpProcess]
GO
/****** Object:  Table [dbo].[FormsProcess]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FormsProcess]') AND type in (N'U'))
DROP TABLE [dbo].[FormsProcess]
GO
/****** Object:  Table [dbo].[Conditions]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Conditions]') AND type in (N'U'))
DROP TABLE [dbo].[Conditions]
GO
/****** Object:  Table [dbo].[CatWebAplications]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatWebAplications]') AND type in (N'U'))
DROP TABLE [dbo].[CatWebAplications]
GO
/****** Object:  Table [dbo].[CatSteps]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatSteps]') AND type in (N'U'))
DROP TABLE [dbo].[CatSteps]
GO
/****** Object:  Table [dbo].[CatProcesses]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatProcesses]') AND type in (N'U'))
DROP TABLE [dbo].[CatProcesses]
GO
/****** Object:  Table [dbo].[CatForms]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatForms]') AND type in (N'U'))
DROP TABLE [dbo].[CatForms]
GO
/****** Object:  Table [dbo].[CatEmailProcess]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatEmailProcess]') AND type in (N'U'))
DROP TABLE [dbo].[CatEmailProcess]
GO
/****** Object:  Table [dbo].[CatConnectionTypes]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatConnectionTypes]') AND type in (N'U'))
DROP TABLE [dbo].[CatConnectionTypes]
GO
/****** Object:  Table [dbo].[CatConnections]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatConnections]') AND type in (N'U'))
DROP TABLE [dbo].[CatConnections]
GO
/****** Object:  Table [dbo].[CatAuditTablesStatus]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatAuditTablesStatus]') AND type in (N'U'))
DROP TABLE [dbo].[CatAuditTablesStatus]
GO
/****** Object:  Table [dbo].[Cat_JornadaLaboral]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Cat_JornadaLaboral]') AND type in (N'U'))
DROP TABLE [dbo].[Cat_JornadaLaboral]
GO
/****** Object:  Table [dbo].[Cat_DiasFestivos]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Cat_DiasFestivos]') AND type in (N'U'))
DROP TABLE [dbo].[Cat_DiasFestivos]
GO
/****** Object:  Table [dbo].[BusinessRules]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BusinessRules]') AND type in (N'U'))
DROP TABLE [dbo].[BusinessRules]
GO
/****** Object:  Table [dbo].[AuditTablesVsSteps]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AuditTablesVsSteps]') AND type in (N'U'))
DROP TABLE [dbo].[AuditTablesVsSteps]
GO
/****** Object:  Table [dbo].[AuditTablesDefinition]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AuditTablesDefinition]') AND type in (N'U'))
DROP TABLE [dbo].[AuditTablesDefinition]
GO
/****** Object:  Table [dbo].[AuditConnectionProcess]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]') AND type in (N'U'))
DROP TABLE [dbo].[AuditConnectionProcess]
GO
/****** Object:  Table [dbo].[AuditColumnsDefinition]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AuditColumnsDefinition]') AND type in (N'U'))
DROP TABLE [dbo].[AuditColumnsDefinition]
GO
/****** Object:  Table [dbo].[ASPStateTempSessions]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ASPStateTempSessions]') AND type in (N'U'))
DROP TABLE [dbo].[ASPStateTempSessions]
GO
/****** Object:  Table [dbo].[ASPStateTempApplications]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ASPStateTempApplications]') AND type in (N'U'))
DROP TABLE [dbo].[ASPStateTempApplications]
GO
/****** Object:  Table [Controls].[Group]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[Group]') AND type in (N'U'))
DROP TABLE [Controls].[Group]
GO
/****** Object:  Table [Controls].[Form]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[Form]') AND type in (N'U'))
DROP TABLE [Controls].[Form]
GO
/****** Object:  Table [Controls].[Filter]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[Filter]') AND type in (N'U'))
DROP TABLE [Controls].[Filter]
GO
/****** Object:  Table [Controls].[Datatype]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[Datatype]') AND type in (N'U'))
DROP TABLE [Controls].[Datatype]
GO
/****** Object:  Table [Controls].[ControlsSettings]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[ControlsSettings]') AND type in (N'U'))
DROP TABLE [Controls].[ControlsSettings]
GO
/****** Object:  Table [Controls].[Controls]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[Controls]') AND type in (N'U'))
DROP TABLE [Controls].[Controls]
GO
/****** Object:  Table [ConfiguracionPersona].[TipoPersona]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[TipoPersona]') AND type in (N'U'))
DROP TABLE [ConfiguracionPersona].[TipoPersona]
GO
/****** Object:  Table [ConfiguracionPersona].[TipoParametroPersona]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[TipoParametroPersona]') AND type in (N'U'))
DROP TABLE [ConfiguracionPersona].[TipoParametroPersona]
GO
/****** Object:  Table [ConfiguracionPersona].[PersonaProceso]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[PersonaProceso]') AND type in (N'U'))
DROP TABLE [ConfiguracionPersona].[PersonaProceso]
GO
/****** Object:  Table [ConfiguracionPersona].[ParametrosPersonaProceso]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosPersonaProceso]') AND type in (N'U'))
DROP TABLE [ConfiguracionPersona].[ParametrosPersonaProceso]
GO
/****** Object:  Table [ConfiguracionPersona].[ParametrosGeneralesPersona]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosGeneralesPersona]') AND type in (N'U'))
DROP TABLE [ConfiguracionPersona].[ParametrosGeneralesPersona]
GO
/****** Object:  Table [ConfiguracionPersona].[FormularioPersonaProceso]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersonaProceso]') AND type in (N'U'))
DROP TABLE [ConfiguracionPersona].[FormularioPersonaProceso]
GO
/****** Object:  Table [ConfiguracionPersona].[FormularioPersona]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersona]') AND type in (N'U'))
DROP TABLE [ConfiguracionPersona].[FormularioPersona]
GO
/****** Object:  UserDefinedFunction [dbo].[ufn_DiaHabil]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ufn_DiaHabil]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[ufn_DiaHabil]
GO
/****** Object:  StoredProcedure [dbo].[usp_co_fechas_pagos]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_co_fechas_pagos]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_co_fechas_pagos]
GO
/****** Object:  StoredProcedure [dbo].[TempUpdateStateItemShortNullLong]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempUpdateStateItemShortNullLong]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempUpdateStateItemShortNullLong]
GO
/****** Object:  StoredProcedure [dbo].[TempUpdateStateItemShort]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempUpdateStateItemShort]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempUpdateStateItemShort]
GO
/****** Object:  StoredProcedure [dbo].[TempUpdateStateItemLongNullShort]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempUpdateStateItemLongNullShort]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempUpdateStateItemLongNullShort]
GO
/****** Object:  StoredProcedure [dbo].[TempUpdateStateItemLong]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempUpdateStateItemLong]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempUpdateStateItemLong]
GO
/****** Object:  StoredProcedure [dbo].[TempResetTimeout]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempResetTimeout]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempResetTimeout]
GO
/****** Object:  StoredProcedure [dbo].[TempRemoveStateItem]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempRemoveStateItem]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempRemoveStateItem]
GO
/****** Object:  StoredProcedure [dbo].[TempReleaseStateItemExclusive]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempReleaseStateItemExclusive]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempReleaseStateItemExclusive]
GO
/****** Object:  StoredProcedure [dbo].[TempInsertUninitializedItem]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempInsertUninitializedItem]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempInsertUninitializedItem]
GO
/****** Object:  StoredProcedure [dbo].[TempInsertStateItemShort]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempInsertStateItemShort]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempInsertStateItemShort]
GO
/****** Object:  StoredProcedure [dbo].[TempInsertStateItemLong]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempInsertStateItemLong]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempInsertStateItemLong]
GO
/****** Object:  StoredProcedure [dbo].[TempGetVersion]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetVersion]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempGetVersion]
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItemExclusive3]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItemExclusive3]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempGetStateItemExclusive3]
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItemExclusive2]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItemExclusive2]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempGetStateItemExclusive2]
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItemExclusive]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItemExclusive]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempGetStateItemExclusive]
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItem3]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItem3]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempGetStateItem3]
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItem2]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItem2]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempGetStateItem2]
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItem]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItem]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempGetStateItem]
GO
/****** Object:  StoredProcedure [dbo].[TempGetAppID]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetAppID]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[TempGetAppID]
GO
/****** Object:  StoredProcedure [dbo].[pp_co_fechas_de_pago]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pp_co_fechas_de_pago]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pp_co_fechas_de_pago]
GO
/****** Object:  StoredProcedure [dbo].[pp_co_fecha_habil]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pp_co_fecha_habil]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pp_co_fecha_habil]
GO
/****** Object:  StoredProcedure [dbo].[pp_co_dia_habil]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pp_co_dia_habil]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pp_co_dia_habil]
GO
/****** Object:  StoredProcedure [dbo].[GetMajorVersion]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetMajorVersion]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[GetMajorVersion]
GO
/****** Object:  StoredProcedure [dbo].[GetHashCode]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetHashCode]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[GetHashCode]
GO
/****** Object:  StoredProcedure [dbo].[DeleteExpiredSessions]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteExpiredSessions]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[DeleteExpiredSessions]
GO
/****** Object:  StoredProcedure [dbo].[CreateTempTables]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CreateTempTables]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[CreateTempTables]
GO
/****** Object:  UserDefinedDataType [dbo].[tTextPtr]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'tTextPtr' AND ss.name = N'dbo')
DROP TYPE [dbo].[tTextPtr]
GO
/****** Object:  UserDefinedDataType [dbo].[tSessionItemShort]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'tSessionItemShort' AND ss.name = N'dbo')
DROP TYPE [dbo].[tSessionItemShort]
GO
/****** Object:  UserDefinedDataType [dbo].[tSessionItemLong]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'tSessionItemLong' AND ss.name = N'dbo')
DROP TYPE [dbo].[tSessionItemLong]
GO
/****** Object:  UserDefinedDataType [dbo].[tSessionId]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'tSessionId' AND ss.name = N'dbo')
DROP TYPE [dbo].[tSessionId]
GO
/****** Object:  UserDefinedDataType [dbo].[tAppName]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'tAppName' AND ss.name = N'dbo')
DROP TYPE [dbo].[tAppName]
GO
/****** Object:  Schema [View]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'View')
DROP SCHEMA [View]
GO
/****** Object:  Schema [Theme]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'Theme')
DROP SCHEMA [Theme]
GO
/****** Object:  Schema [Profile]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'Profile')
DROP SCHEMA [Profile]
GO
/****** Object:  Schema [Process]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'Process')
DROP SCHEMA [Process]
GO
/****** Object:  Schema [Document]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'Document')
DROP SCHEMA [Document]
GO
/****** Object:  Schema [Controls]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'Controls')
DROP SCHEMA [Controls]
GO
/****** Object:  Schema [ConfiguracionPersona]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF  EXISTS (SELECT * FROM sys.schemas WHERE name = N'ConfiguracionPersona')
DROP SCHEMA [ConfiguracionPersona]
GO
/****** Object:  Schema [ConfiguracionPersona]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'ConfiguracionPersona')
EXEC sys.sp_executesql N'CREATE SCHEMA [ConfiguracionPersona]'

GO
/****** Object:  Schema [Controls]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Controls')
EXEC sys.sp_executesql N'CREATE SCHEMA [Controls]'

GO
/****** Object:  Schema [Document]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Document')
EXEC sys.sp_executesql N'CREATE SCHEMA [Document]'

GO
/****** Object:  Schema [Process]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Process')
EXEC sys.sp_executesql N'CREATE SCHEMA [Process]'

GO
/****** Object:  Schema [Profile]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Profile')
EXEC sys.sp_executesql N'CREATE SCHEMA [Profile]'

GO
/****** Object:  Schema [Theme]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Theme')
EXEC sys.sp_executesql N'CREATE SCHEMA [Theme]'

GO
/****** Object:  Schema [View]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'View')
EXEC sys.sp_executesql N'CREATE SCHEMA [View]'

GO
/****** Object:  UserDefinedDataType [dbo].[tAppName]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'tAppName' AND ss.name = N'dbo')
CREATE TYPE [dbo].[tAppName] FROM [varchar](280) NOT NULL
GO
/****** Object:  UserDefinedDataType [dbo].[tSessionId]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'tSessionId' AND ss.name = N'dbo')
CREATE TYPE [dbo].[tSessionId] FROM [nvarchar](88) NOT NULL
GO
/****** Object:  UserDefinedDataType [dbo].[tSessionItemLong]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'tSessionItemLong' AND ss.name = N'dbo')
CREATE TYPE [dbo].[tSessionItemLong] FROM [image] NULL
GO
/****** Object:  UserDefinedDataType [dbo].[tSessionItemShort]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'tSessionItemShort' AND ss.name = N'dbo')
CREATE TYPE [dbo].[tSessionItemShort] FROM [varbinary](7000) NULL
GO
/****** Object:  UserDefinedDataType [dbo].[tTextPtr]    Script Date: 16/02/2018 02:48:39 p.m. ******/
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'tTextPtr' AND ss.name = N'dbo')
CREATE TYPE [dbo].[tTextPtr] FROM [varbinary](16) NULL
GO
/****** Object:  StoredProcedure [dbo].[CreateTempTables]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CreateTempTables]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[CreateTempTables]
        AS
            CREATE TABLE [Ultimus.ComponentManager].dbo.ASPStateTempSessions (
                SessionId           nvarchar(88)    NOT NULL PRIMARY KEY,
                Created             datetime        NOT NULL DEFAULT GETUTCDATE(),
                Expires             datetime        NOT NULL,
                LockDate            datetime        NOT NULL,
                LockDateLocal       datetime        NOT NULL,
                LockCookie          int             NOT NULL,
                Timeout             int             NOT NULL,
                Locked              bit             NOT NULL,
                SessionItemShort    VARBINARY(7000) NULL,
                SessionItemLong     image           NULL,
                Flags               int             NOT NULL DEFAULT 0,
            ) 

            CREATE NONCLUSTERED INDEX Index_Expires ON [Ultimus.ComponentManager].dbo.ASPStateTempSessions(Expires)

            CREATE TABLE [Ultimus.ComponentManager].dbo.ASPStateTempApplications (
                AppId               int             NOT NULL PRIMARY KEY,
                AppName             char(280)       NOT NULL,
            ) 

            CREATE NONCLUSTERED INDEX Index_AppName ON [Ultimus.ComponentManager].dbo.ASPStateTempApplications(AppName)

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[DeleteExpiredSessions]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteExpiredSessions]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[DeleteExpiredSessions]
        AS
            SET NOCOUNT ON
            SET DEADLOCK_PRIORITY LOW 

            DECLARE @now datetime
            SET @now = GETUTCDATE() 

            CREATE TABLE #tblExpiredSessions 
            ( 
                SessionId nvarchar(88) NOT NULL PRIMARY KEY
            )

            INSERT #tblExpiredSessions (SessionId)
                SELECT SessionId
                FROM [Ultimus.ComponentManager].dbo.ASPStateTempSessions WITH (READUNCOMMITTED)
                WHERE Expires < @now

            IF @@ROWCOUNT <> 0 
            BEGIN 
                DECLARE ExpiredSessionCursor CURSOR LOCAL FORWARD_ONLY READ_ONLY
                FOR SELECT SessionId FROM #tblExpiredSessions 

                DECLARE @SessionId nvarchar(88)

                OPEN ExpiredSessionCursor

                FETCH NEXT FROM ExpiredSessionCursor INTO @SessionId

                WHILE @@FETCH_STATUS = 0 
                    BEGIN
                        DELETE FROM [Ultimus.ComponentManager].dbo.ASPStateTempSessions WHERE SessionId = @SessionId AND Expires < @now
                        FETCH NEXT FROM ExpiredSessionCursor INTO @SessionId
                    END

                CLOSE ExpiredSessionCursor

                DEALLOCATE ExpiredSessionCursor

            END 

            DROP TABLE #tblExpiredSessions

        RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
END
GO
/****** Object:  StoredProcedure [dbo].[GetHashCode]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetHashCode]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
/*****************************************************************************/

CREATE PROCEDURE [dbo].[GetHashCode]
    @input tAppName,
    @hash int OUTPUT
AS
    /* 
       This sproc is based on this C# hash function:

        int GetHashCode(string s)
        {
            int     hash = 5381;
            int     len = s.Length;

            for (int i = 0; i < len; i++) {
                int     c = Convert.ToInt32(s[i]);
                hash = ((hash << 5) + hash) ^ c;
            }

            return hash;
        }

        However, SQL 7 doesn''t provide a 32-bit integer
        type that allows rollover of bits, we have to
        divide our 32bit integer into the upper and lower
        16 bits to do our calculation.
    */
       
    DECLARE @hi_16bit   int
    DECLARE @lo_16bit   int
    DECLARE @hi_t       int
    DECLARE @lo_t       int
    DECLARE @len        int
    DECLARE @i          int
    DECLARE @c          int
    DECLARE @carry      int

    SET @hi_16bit = 0
    SET @lo_16bit = 5381
    
    SET @len = DATALENGTH(@input)
    SET @i = 1
    
    WHILE (@i <= @len)
    BEGIN
        SET @c = ASCII(SUBSTRING(@input, @i, 1))

        /* Formula:                        
           hash = ((hash << 5) + hash) ^ c */

        /* hash << 5 */
        SET @hi_t = @hi_16bit * 32 /* high 16bits << 5 */
        SET @hi_t = @hi_t & 0xFFFF /* zero out overflow */
        
        SET @lo_t = @lo_16bit * 32 /* low 16bits << 5 */
        
        SET @carry = @lo_16bit & 0x1F0000 /* move low 16bits carryover to hi 16bits */
        SET @carry = @carry / 0x10000 /* >> 16 */
        SET @hi_t = @hi_t + @carry
        SET @hi_t = @hi_t & 0xFFFF /* zero out overflow */

        /* + hash */
        SET @lo_16bit = @lo_16bit + @lo_t
        SET @hi_16bit = @hi_16bit + @hi_t + (@lo_16bit / 0x10000)
        /* delay clearing the overflow */

        /* ^c */
        SET @lo_16bit = @lo_16bit ^ @c

        /* Now clear the overflow bits */	
        SET @hi_16bit = @hi_16bit & 0xFFFF
        SET @lo_16bit = @lo_16bit & 0xFFFF

        SET @i = @i + 1
    END

    /* Do a sign extension of the hi-16bit if needed */
    IF (@hi_16bit & 0x8000 <> 0)
        SET @hi_16bit = 0xFFFF0000 | @hi_16bit

    /* Merge hi and lo 16bit back together */
    SET @hi_16bit = @hi_16bit * 0x10000 /* << 16 */
    SET @hash = @hi_16bit | @lo_16bit

    RETURN 0' 
END
GO
/****** Object:  StoredProcedure [dbo].[GetMajorVersion]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetMajorVersion]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
/*****************************************************************************/

CREATE PROCEDURE [dbo].[GetMajorVersion]
    @@ver int OUTPUT
AS
BEGIN
	DECLARE @version        nchar(100)
	DECLARE @dot            int
	DECLARE @hyphen         int
	DECLARE @SqlToExec      nchar(4000)

	SELECT @@ver = 7
	SELECT @version = @@Version
	SELECT @hyphen  = CHARINDEX(N'' - '', @version)
	IF (NOT(@hyphen IS NULL) AND @hyphen > 0)
	BEGIN
		SELECT @hyphen = @hyphen + 3
		SELECT @dot    = CHARINDEX(N''.'', @version, @hyphen)
		IF (NOT(@dot IS NULL) AND @dot > @hyphen)
		BEGIN
			SELECT @version = SUBSTRING(@version, @hyphen, @dot - @hyphen)
			SELECT @@ver     = CONVERT(int, @version)
		END
	END
END' 
END
GO
/****** Object:  StoredProcedure [dbo].[pp_co_dia_habil]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pp_co_dia_habil]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =================================================================
-- Author:		Ariel Reyna.	
-- Create date: 15-Junio-2012
-- Description:	Consultar la primera fecha habil a partir de la fecha 
--				enviada (fecha de referencia).
-- ==================================================================
create PROCEDURE [dbo].[pp_co_dia_habil]
					  (@i_fecha_referencia	DateTime	out,
					   @o_num_error			int			output,
					   @o_mensaje_error		varchar(200)output)
AS
BEGIN
	SET @o_num_error = 0
	SET @o_mensaje_error =''''
	
	SET @i_fecha_referencia = dbo.ufn_DiaHabil(@i_fecha_referencia)
		
	SET @o_num_error = @@ERROR
END
' 
END
GO
/****** Object:  StoredProcedure [dbo].[pp_co_fecha_habil]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pp_co_fecha_habil]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
-- =================================================================
-- Author:		Ariel Reyna.	
-- Create date: 13-Julio-2011
-- Description:	Consultar la primera fecha habil a partir de la fecha 
--				enviada (fecha de referencia).
-- ==================================================================
create PROCEDURE [dbo].[pp_co_fecha_habil]
					  (@i_fecha_referencia	varchar(15)		out,
					   @o_num_error			int				output,
					   @o_mensaje_error		varchar(200)	output)
AS
BEGIN
	SET @o_num_error = 0
	SET @o_mensaje_error =''''
	
	SELECT	@i_fecha_referencia	= CONVERT(VARCHAR(15),MIN(hd_fecha),101)
	FROM WF_HOLIDAYS
	WHERE hd_estado = ''S''
		AND hd_fecha >= @i_fecha_referencia
		
	SET @o_num_error = @@ERROR
	
END

' 
END
GO
/****** Object:  StoredProcedure [dbo].[pp_co_fechas_de_pago]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pp_co_fechas_de_pago]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
-- =================================================================
-- Author:		Matteo Portanova.	
-- Create date: 10-Abril-2012
-- ==================================================================
create PROCEDURE [dbo].[pp_co_fechas_de_pago]
					  (	@i_fecha_referencia		datetime		out,
						@i_periodo				int				out,
						@o_num_error			int				output,
						@o_mensaje_error		varchar(200)	output)
AS
BEGIN	
	DECLARE @count				INT,
			@fecha				DATETIME,
			@fecha_referencia	DATETIME,
			@periodo			INT

	DECLARE @return		TABLE (
	  fecha datetime
	)
 
	SET @fecha_referencia	= DATEADD(month,1,@i_fecha_referencia)
	SET @periodo			= @i_periodo
	SET @o_num_error		= 0
	SET @o_mensaje_error	= ''''	

	SET @count = 1	
	WHILE(@count <= @periodo)
	BEGIN
		SELECT	@fecha = MIN(hd_fecha)
		FROM WF_HOLIDAYS
		WHERE HD_FECHA >= @fecha_referencia
		AND HD_ESTADO = ''S''

		IF @fecha IS NULL
		BEGIN
			SET @fecha = @fecha_referencia
		END

		INSERT INTO @return (fecha) VALUES (@fecha)

		SET @fecha_referencia = DATEADD(month,@count+1,@i_fecha_referencia)
	
		SET @count = @count + 1 
	END	
		
	SET @o_num_error = @@ERROR
	
	SELECT * FROM @return
END' 
END
GO
/****** Object:  StoredProcedure [dbo].[TempGetAppID]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetAppID]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
    CREATE PROCEDURE [dbo].[TempGetAppID]
    @appName    tAppName,
    @appId      int OUTPUT
    AS
    SET @appName = LOWER(@appName)
    SET @appId = NULL

    SELECT @appId = AppId
    FROM [Ultimus.ComponentManager].dbo.ASPStateTempApplications
    WHERE AppName = @appName

    IF @appId IS NULL BEGIN
        BEGIN TRAN        

        SELECT @appId = AppId
        FROM [Ultimus.ComponentManager].dbo.ASPStateTempApplications WITH (TABLOCKX)
        WHERE AppName = @appName
        
        IF @appId IS NULL
        BEGIN
            EXEC GetHashCode @appName, @appId OUTPUT
            
            INSERT [Ultimus.ComponentManager].dbo.ASPStateTempApplications
            VALUES
            (@appId, @appName)
            
            IF @@ERROR = 2627 
            BEGIN
                DECLARE @dupApp tAppName
            
                SELECT @dupApp = RTRIM(AppName)
                FROM [Ultimus.ComponentManager].dbo.ASPStateTempApplications 
                WHERE AppId = @appId
                
                RAISERROR(''SQL session state fatal error: hash-code collision between applications ''''%s'''' and ''''%s''''. Please rename the 1st application to resolve the problem.'', 
                            18, 1, @appName, @dupApp)
            END
        END

        COMMIT
    END

    RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
END
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItem]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItem]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempGetStateItem]
            @id         tSessionId,
            @itemShort  tSessionItemShort OUTPUT,
            @locked     bit OUTPUT,
            @lockDate   datetime OUTPUT,
            @lockCookie int OUTPUT
        AS
            DECLARE @textptr AS tTextPtr
            DECLARE @length AS int
            DECLARE @now AS datetime
            SET @now = GETUTCDATE()

            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, Timeout, @now), 
                @locked = Locked,
                @lockDate = LockDateLocal,
                @lockCookie = LockCookie,
                @itemShort = CASE @locked
                    WHEN 0 THEN SessionItemShort
                    ELSE NULL
                    END,
                @textptr = CASE @locked
                    WHEN 0 THEN TEXTPTR(SessionItemLong)
                    ELSE NULL
                    END,
                @length = CASE @locked
                    WHEN 0 THEN DATALENGTH(SessionItemLong)
                    ELSE NULL
                    END
            WHERE SessionId = @id
            IF @length IS NOT NULL BEGIN
                READTEXT [Ultimus.ComponentManager].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length
            END

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItem2]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItem2]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempGetStateItem2]
            @id         tSessionId,
            @itemShort  tSessionItemShort OUTPUT,
            @locked     bit OUTPUT,
            @lockAge    int OUTPUT,
            @lockCookie int OUTPUT
        AS
            DECLARE @textptr AS tTextPtr
            DECLARE @length AS int
            DECLARE @now AS datetime
            SET @now = GETUTCDATE()

            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, Timeout, @now), 
                @locked = Locked,
                @lockAge = DATEDIFF(second, LockDate, @now),
                @lockCookie = LockCookie,
                @itemShort = CASE @locked
                    WHEN 0 THEN SessionItemShort
                    ELSE NULL
                    END,
                @textptr = CASE @locked
                    WHEN 0 THEN TEXTPTR(SessionItemLong)
                    ELSE NULL
                    END,
                @length = CASE @locked
                    WHEN 0 THEN DATALENGTH(SessionItemLong)
                    ELSE NULL
                    END
            WHERE SessionId = @id
            IF @length IS NOT NULL BEGIN
                READTEXT [Ultimus.ComponentManager].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length
            END

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItem3]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItem3]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempGetStateItem3]
            @id         tSessionId,
            @itemShort  tSessionItemShort OUTPUT,
            @locked     bit OUTPUT,
            @lockAge    int OUTPUT,
            @lockCookie int OUTPUT,
            @actionFlags int OUTPUT
        AS
            DECLARE @textptr AS tTextPtr
            DECLARE @length AS int
            DECLARE @now AS datetime
            SET @now = GETUTCDATE()

            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, Timeout, @now), 
                @locked = Locked,
                @lockAge = DATEDIFF(second, LockDate, @now),
                @lockCookie = LockCookie,
                @itemShort = CASE @locked
                    WHEN 0 THEN SessionItemShort
                    ELSE NULL
                    END,
                @textptr = CASE @locked
                    WHEN 0 THEN TEXTPTR(SessionItemLong)
                    ELSE NULL
                    END,
                @length = CASE @locked
                    WHEN 0 THEN DATALENGTH(SessionItemLong)
                    ELSE NULL
                    END,

                /* If the Uninitialized flag (0x1) if it is set,
                   remove it and return InitializeItem (0x1) in actionFlags */
                Flags = CASE
                    WHEN (Flags & 1) <> 0 THEN (Flags & ~1)
                    ELSE Flags
                    END,
                @actionFlags = CASE
                    WHEN (Flags & 1) <> 0 THEN 1
                    ELSE 0
                    END
            WHERE SessionId = @id
            IF @length IS NOT NULL BEGIN
                READTEXT [Ultimus.ComponentManager].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length
            END

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItemExclusive]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItemExclusive]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempGetStateItemExclusive]
            @id         tSessionId,
            @itemShort  tSessionItemShort OUTPUT,
            @locked     bit OUTPUT,
            @lockDate   datetime OUTPUT,
            @lockCookie int OUTPUT
        AS
            DECLARE @textptr AS tTextPtr
            DECLARE @length AS int
            DECLARE @now AS datetime
            DECLARE @nowLocal AS datetime

            SET @now = GETUTCDATE()
            SET @nowLocal = GETDATE()
            
            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, Timeout, @now), 
                LockDate = CASE Locked
                    WHEN 0 THEN @now
                    ELSE LockDate
                    END,
                @lockDate = LockDateLocal = CASE Locked
                    WHEN 0 THEN @nowLocal
                    ELSE LockDateLocal
                    END,
                @lockCookie = LockCookie = CASE Locked
                    WHEN 0 THEN LockCookie + 1
                    ELSE LockCookie
                    END,
                @itemShort = CASE Locked
                    WHEN 0 THEN SessionItemShort
                    ELSE NULL
                    END,
                @textptr = CASE Locked
                    WHEN 0 THEN TEXTPTR(SessionItemLong)
                    ELSE NULL
                    END,
                @length = CASE Locked
                    WHEN 0 THEN DATALENGTH(SessionItemLong)
                    ELSE NULL
                    END,
                @locked = Locked,
                Locked = 1
            WHERE SessionId = @id
            IF @length IS NOT NULL BEGIN
                READTEXT [Ultimus.ComponentManager].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length
            END

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItemExclusive2]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItemExclusive2]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempGetStateItemExclusive2]
            @id         tSessionId,
            @itemShort  tSessionItemShort OUTPUT,
            @locked     bit OUTPUT,
            @lockAge    int OUTPUT,
            @lockCookie int OUTPUT
        AS
            DECLARE @textptr AS tTextPtr
            DECLARE @length AS int
            DECLARE @now AS datetime
            DECLARE @nowLocal AS datetime

            SET @now = GETUTCDATE()
            SET @nowLocal = GETDATE()
            
            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, Timeout, @now), 
                LockDate = CASE Locked
                    WHEN 0 THEN @now
                    ELSE LockDate
                    END,
                LockDateLocal = CASE Locked
                    WHEN 0 THEN @nowLocal
                    ELSE LockDateLocal
                    END,
                @lockAge = CASE Locked
                    WHEN 0 THEN 0
                    ELSE DATEDIFF(second, LockDate, @now)
                    END,
                @lockCookie = LockCookie = CASE Locked
                    WHEN 0 THEN LockCookie + 1
                    ELSE LockCookie
                    END,
                @itemShort = CASE Locked
                    WHEN 0 THEN SessionItemShort
                    ELSE NULL
                    END,
                @textptr = CASE Locked
                    WHEN 0 THEN TEXTPTR(SessionItemLong)
                    ELSE NULL
                    END,
                @length = CASE Locked
                    WHEN 0 THEN DATALENGTH(SessionItemLong)
                    ELSE NULL
                    END,
                @locked = Locked,
                Locked = 1
            WHERE SessionId = @id
            IF @length IS NOT NULL BEGIN
                READTEXT [Ultimus.ComponentManager].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length
            END

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempGetStateItemExclusive3]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetStateItemExclusive3]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempGetStateItemExclusive3]
            @id         tSessionId,
            @itemShort  tSessionItemShort OUTPUT,
            @locked     bit OUTPUT,
            @lockAge    int OUTPUT,
            @lockCookie int OUTPUT,
            @actionFlags int OUTPUT
        AS
            DECLARE @textptr AS tTextPtr
            DECLARE @length AS int
            DECLARE @now AS datetime
            DECLARE @nowLocal AS datetime

            SET @now = GETUTCDATE()
            SET @nowLocal = GETDATE()
            
            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, Timeout, @now), 
                LockDate = CASE Locked
                    WHEN 0 THEN @now
                    ELSE LockDate
                    END,
                LockDateLocal = CASE Locked
                    WHEN 0 THEN @nowLocal
                    ELSE LockDateLocal
                    END,
                @lockAge = CASE Locked
                    WHEN 0 THEN 0
                    ELSE DATEDIFF(second, LockDate, @now)
                    END,
                @lockCookie = LockCookie = CASE Locked
                    WHEN 0 THEN LockCookie + 1
                    ELSE LockCookie
                    END,
                @itemShort = CASE Locked
                    WHEN 0 THEN SessionItemShort
                    ELSE NULL
                    END,
                @textptr = CASE Locked
                    WHEN 0 THEN TEXTPTR(SessionItemLong)
                    ELSE NULL
                    END,
                @length = CASE Locked
                    WHEN 0 THEN DATALENGTH(SessionItemLong)
                    ELSE NULL
                    END,
                @locked = Locked,
                Locked = 1,

                /* If the Uninitialized flag (0x1) if it is set,
                   remove it and return InitializeItem (0x1) in actionFlags */
                Flags = CASE
                    WHEN (Flags & 1) <> 0 THEN (Flags & ~1)
                    ELSE Flags
                    END,
                @actionFlags = CASE
                    WHEN (Flags & 1) <> 0 THEN 1
                    ELSE 0
                    END
            WHERE SessionId = @id
            IF @length IS NOT NULL BEGIN
                READTEXT [Ultimus.ComponentManager].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length
            END

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 ' 
END
GO
/****** Object:  StoredProcedure [dbo].[TempGetVersion]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempGetVersion]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
/*****************************************************************************/

CREATE PROCEDURE [dbo].[TempGetVersion]
    @ver      char(10) OUTPUT
AS
    SELECT @ver = "2"
    RETURN 0' 
END
GO
/****** Object:  StoredProcedure [dbo].[TempInsertStateItemLong]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempInsertStateItemLong]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempInsertStateItemLong]
            @id         tSessionId,
            @itemLong   tSessionItemLong,
            @timeout    int
        AS    
            DECLARE @now AS datetime
            DECLARE @nowLocal AS datetime
            
            SET @now = GETUTCDATE()
            SET @nowLocal = GETDATE()

            INSERT [Ultimus.ComponentManager].dbo.ASPStateTempSessions 
                (SessionId, 
                 SessionItemLong, 
                 Timeout, 
                 Expires, 
                 Locked, 
                 LockDate,
                 LockDateLocal,
                 LockCookie) 
            VALUES 
                (@id, 
                 @itemLong, 
                 @timeout, 
                 DATEADD(n, @timeout, @now), 
                 0, 
                 @now,
                 @nowLocal,
                 1)

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempInsertStateItemShort]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempInsertStateItemShort]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempInsertStateItemShort]
            @id         tSessionId,
            @itemShort  tSessionItemShort,
            @timeout    int
        AS    

            DECLARE @now AS datetime
            DECLARE @nowLocal AS datetime
            
            SET @now = GETUTCDATE()
            SET @nowLocal = GETDATE()

            INSERT [Ultimus.ComponentManager].dbo.ASPStateTempSessions 
                (SessionId, 
                 SessionItemShort, 
                 Timeout, 
                 Expires, 
                 Locked, 
                 LockDate,
                 LockDateLocal,
                 LockCookie) 
            VALUES 
                (@id, 
                 @itemShort, 
                 @timeout, 
                 DATEADD(n, @timeout, @now), 
                 0, 
                 @now,
                 @nowLocal,
                 1)

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempInsertUninitializedItem]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempInsertUninitializedItem]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempInsertUninitializedItem]
            @id         tSessionId,
            @itemShort  tSessionItemShort,
            @timeout    int
        AS    

            DECLARE @now AS datetime
            DECLARE @nowLocal AS datetime
            
            SET @now = GETUTCDATE()
            SET @nowLocal = GETDATE()

            INSERT [Ultimus.ComponentManager].dbo.ASPStateTempSessions 
                (SessionId, 
                 SessionItemShort, 
                 Timeout, 
                 Expires, 
                 Locked, 
                 LockDate,
                 LockDateLocal,
                 LockCookie,
                 Flags) 
            VALUES 
                (@id, 
                 @itemShort, 
                 @timeout, 
                 DATEADD(n, @timeout, @now), 
                 0, 
                 @now,
                 @nowLocal,
                 1,
                 1)

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempReleaseStateItemExclusive]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempReleaseStateItemExclusive]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempReleaseStateItemExclusive]
            @id         tSessionId,
            @lockCookie int
        AS
            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, Timeout, GETUTCDATE()), 
                Locked = 0
            WHERE SessionId = @id AND LockCookie = @lockCookie

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempRemoveStateItem]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempRemoveStateItem]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
    CREATE PROCEDURE [dbo].[TempRemoveStateItem]
        @id     tSessionId,
        @lockCookie int
    AS
        DELETE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
        WHERE SessionId = @id AND LockCookie = @lockCookie
        RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
END
GO
/****** Object:  StoredProcedure [dbo].[TempResetTimeout]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempResetTimeout]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempResetTimeout]
            @id     tSessionId
        AS
            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, Timeout, GETUTCDATE())
            WHERE SessionId = @id
            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempUpdateStateItemLong]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempUpdateStateItemLong]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempUpdateStateItemLong]
            @id         tSessionId,
            @itemLong   tSessionItemLong,
            @timeout    int,
            @lockCookie int
        AS    
            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, @timeout, GETUTCDATE()), 
                SessionItemLong = @itemLong,
                Timeout = @timeout,
                Locked = 0
            WHERE SessionId = @id AND LockCookie = @lockCookie

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempUpdateStateItemLongNullShort]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempUpdateStateItemLongNullShort]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempUpdateStateItemLongNullShort]
            @id         tSessionId,
            @itemLong   tSessionItemLong,
            @timeout    int,
            @lockCookie int
        AS    
            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, @timeout, GETUTCDATE()), 
                SessionItemLong = @itemLong, 
                SessionItemShort = NULL,
                Timeout = @timeout,
                Locked = 0
            WHERE SessionId = @id AND LockCookie = @lockCookie

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempUpdateStateItemShort]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempUpdateStateItemShort]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempUpdateStateItemShort]
            @id         tSessionId,
            @itemShort  tSessionItemShort,
            @timeout    int,
            @lockCookie int
        AS    
            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, @timeout, GETUTCDATE()), 
                SessionItemShort = @itemShort, 
                Timeout = @timeout,
                Locked = 0
            WHERE SessionId = @id AND LockCookie = @lockCookie

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[TempUpdateStateItemShortNullLong]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TempUpdateStateItemShortNullLong]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
        CREATE PROCEDURE [dbo].[TempUpdateStateItemShortNullLong]
            @id         tSessionId,
            @itemShort  tSessionItemShort,
            @timeout    int,
            @lockCookie int
        AS    
            UPDATE [Ultimus.ComponentManager].dbo.ASPStateTempSessions
            SET Expires = DATEADD(n, @timeout, GETUTCDATE()), 
                SessionItemShort = @itemShort, 
                SessionItemLong = NULL, 
                Timeout = @timeout,
                Locked = 0
            WHERE SessionId = @id AND LockCookie = @lockCookie

            RETURN 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
END
GO
/****** Object:  StoredProcedure [dbo].[usp_co_fechas_pagos]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_co_fechas_pagos]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
-- =================================================================
-- Author:		Ariel Reyna	
-- Create date: 15-Junio-2012
-- ==================================================================
CREATE PROCEDURE [dbo].[usp_co_fechas_pagos]
					  (	@i_fecha_referencia		DateTime		out,
						@i_periodo				int				out,
						@o_num_error			int				output,
						@o_mensaje_error		varchar(200)	output)
AS
BEGIN
	
	DECLARE @count				INT

	SET @o_num_error		= 0
	SET @o_mensaje_error	= ''''
	
	CREATE TABLE #FechasPagos(fecha DateTime NOT NULL);

	SET @count = 1	
	WHILE(@count <= @i_periodo)
	BEGIN
		INSERT INTO  #FechasPagos(fecha) VALUES (dbo.ufn_DiaHabil(DATEADD(month,@count,@i_fecha_referencia)))
		SET @count = @count + 1 
	END	
		
	SET @o_num_error = @@ERROR
	
	SELECT * FROM #FechasPagos ORDER BY fecha
	DROP TABLE #FechasPagos
END

' 
END
GO
/****** Object:  UserDefinedFunction [dbo].[ufn_DiaHabil]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ufn_DiaHabil]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
BEGIN
execute dbo.sp_executesql @statement = N'CREATE FUNCTION [dbo].[ufn_DiaHabil] 
				(@i_fecha DateTime = NULL)
RETURNS datetime
AS
BEGIN

	DECLARE @w_diaHabil DateTime
	
	IF(@i_fecha is null)
		SET @i_fecha = getdate() 
	
	---VALIDACION DIA FERIADO
	IF EXISTS(SELECT IdSecuenciaFecha FROM Cat_DiasFestivos  
				WHERE IdSecuenciaFecha = CONVERT(VARCHAR(10), @i_fecha, 112))
		OR 
		EXISTS(SELECT id_dia_semana FROM Cat_JornadaLaboral 
				WHERE id_dia_semana = DatePart(WeekDay, @i_fecha) AND excluir = 1)
	BEGIN
		SET @w_diaHabil = dbo.ufn_DiaHabil(DATEADD(DAY,1,@i_fecha))
	END
	ELSE
	BEGIN
		SET @w_diaHabil = @i_fecha
	END
	
	RETURN @w_diaHabil
END

' 
END

GO
/****** Object:  Table [ConfiguracionPersona].[FormularioPersona]    Script Date: 16/02/2018 02:48:39 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersona]') AND type in (N'U'))
BEGIN
CREATE TABLE [ConfiguracionPersona].[FormularioPersona](
	[CodigoTipoPersona] [int] NOT NULL,
	[CodigoFormulario] [int] NOT NULL,
	[NombreFormulario] [varchar](250) NOT NULL,
	[Descripcion] [nvarchar](max) NULL,
 CONSTRAINT [PK_FormularioPersona] PRIMARY KEY CLUSTERED 
(
	[CodigoTipoPersona] ASC,
	[CodigoFormulario] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [ConfiguracionPersona].[FormularioPersonaProceso]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersonaProceso]') AND type in (N'U'))
BEGIN
CREATE TABLE [ConfiguracionPersona].[FormularioPersonaProceso](
	[IdProcess] [int] NOT NULL,
	[CodigoTipoPersona] [int] NOT NULL,
	[CodigoFormulario] [int] NOT NULL,
	[IdStep] [int] NOT NULL,
	[Habilitado] [bit] NOT NULL,
 CONSTRAINT [PK_FormularioPersonaProceso] PRIMARY KEY CLUSTERED 
(
	[IdProcess] ASC,
	[CodigoTipoPersona] ASC,
	[CodigoFormulario] ASC,
	[IdStep] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [ConfiguracionPersona].[ParametrosGeneralesPersona]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosGeneralesPersona]') AND type in (N'U'))
BEGIN
CREATE TABLE [ConfiguracionPersona].[ParametrosGeneralesPersona](
	[CodigoParametro] [int] NOT NULL,
	[Nombre] [varchar](150) NOT NULL,
	[Descripcion] [nvarchar](max) NOT NULL,
	[CodigoTipo] [int] NOT NULL,
 CONSTRAINT [PK_ParametrosGeneralesPersona] PRIMARY KEY CLUSTERED 
(
	[CodigoParametro] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [ConfiguracionPersona].[ParametrosPersonaProceso]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosPersonaProceso]') AND type in (N'U'))
BEGIN
CREATE TABLE [ConfiguracionPersona].[ParametrosPersonaProceso](
	[IdProcess] [int] NOT NULL,
	[CodigoTipoPersona] [int] NOT NULL,
	[IdStep] [int] NOT NULL,
	[CodigoParametro] [int] NOT NULL,
	[Valor] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_ParametrosPersonaProceso] PRIMARY KEY CLUSTERED 
(
	[IdProcess] ASC,
	[CodigoTipoPersona] ASC,
	[IdStep] ASC,
	[CodigoParametro] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [ConfiguracionPersona].[PersonaProceso]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[PersonaProceso]') AND type in (N'U'))
BEGIN
CREATE TABLE [ConfiguracionPersona].[PersonaProceso](
	[IdProcess] [int] NOT NULL,
	[CodigoTipoPersona] [int] NOT NULL,
	[Habilitado] [bit] NOT NULL,
 CONSTRAINT [PK_PersonaProceso] PRIMARY KEY CLUSTERED 
(
	[IdProcess] ASC,
	[CodigoTipoPersona] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [ConfiguracionPersona].[TipoParametroPersona]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[TipoParametroPersona]') AND type in (N'U'))
BEGIN
CREATE TABLE [ConfiguracionPersona].[TipoParametroPersona](
	[CodigoTipo] [int] NOT NULL,
	[Descripcion] [varchar](50) NOT NULL,
 CONSTRAINT [PK_TipoParametroPersona] PRIMARY KEY CLUSTERED 
(
	[CodigoTipo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [ConfiguracionPersona].[TipoPersona]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[TipoPersona]') AND type in (N'U'))
BEGIN
CREATE TABLE [ConfiguracionPersona].[TipoPersona](
	[CodigoTipoPersona] [int] NOT NULL,
	[Nombre] [varchar](50) NOT NULL,
 CONSTRAINT [PK_TipoPersona] PRIMARY KEY CLUSTERED 
(
	[CodigoTipoPersona] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [Controls].[Controls]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[Controls]') AND type in (N'U'))
BEGIN
CREATE TABLE [Controls].[Controls](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[IdControl] [varchar](100) NULL,
	[CodTipoDato] [int] NOT NULL,
	[DireccionAPI] [nchar](300) NULL,
	[IdFormulario] [int] NULL,
	[Status] [bit] NULL,
	[ValorAtributo1] [varchar](100) NULL,
	[ValorAtributo2] [varchar](100) NULL,
	[ValorAtributo3] [varchar](100) NULL,
	[ValorAtributo4] [varchar](100) NULL,
	[ValorAtributo5] [varchar](100) NULL,
	[ValorAtributo6] [varchar](100) NULL,
	[ValorAtributo7] [varchar](100) NULL,
	[ValorAtributo8] [varchar](100) NULL,
	[ValorAtributo9] [varchar](100) NULL,
	[ValorAtributo10] [varchar](100) NULL,
	[IdGrupo] [int] NULL,
	[GridSettings] [ntext] NULL,
	[ControlLabel] [varchar](250) NULL,
	[DestinationElement] [varchar](max) NULL,
	[SourceElement] [varchar](max) NULL,
 CONSTRAINT [PK_CatControles] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [Controls].[ControlsSettings]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[ControlsSettings]') AND type in (N'U'))
BEGIN
CREATE TABLE [Controls].[ControlsSettings](
	[IdControl] [int] NOT NULL,
	[IdFormulario] [int] NOT NULL,
	[IdFiltro] [int] NOT NULL,
	[Readonly] [bit] NULL,
	[Requerido] [bit] NULL,
	[Hidden] [bit] NULL,
	[Disabled] [bit] NULL,
	[Checked] [bit] NULL,
	[Column] [int] NULL,
	[Row] [int] NULL,
	[Clear] [bit] NULL,
	[CustomSettingsJSON] [nvarchar](max) NULL,
 CONSTRAINT [PK_ConfiguracionControles] PRIMARY KEY CLUSTERED 
(
	[IdControl] ASC,
	[IdFormulario] ASC,
	[IdFiltro] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [Controls].[Datatype]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[Datatype]') AND type in (N'U'))
BEGIN
CREATE TABLE [Controls].[Datatype](
	[CodTipoDato] [int] IDENTITY(1,1) NOT NULL,
	[DescripcionTipoDato] [varchar](100) NULL,
	[CodTipoNumerico] [int] NULL,
	[Status] [bit] NULL,
	[Html] [varchar](1000) NULL,
	[Atributo1] [varchar](100) NULL,
	[Atributo2] [varchar](100) NULL,
	[Atributo3] [varchar](100) NULL,
	[Atributo4] [varchar](100) NULL,
	[Atributo5] [varchar](100) NULL,
	[Atributo6] [varchar](100) NULL,
	[Atributo7] [varchar](100) NULL,
	[Atributo8] [varchar](100) NULL,
	[Atributo9] [varchar](100) NULL,
	[Atributo10] [varchar](100) NULL,
 CONSTRAINT [PK_CatTipoDato] PRIMARY KEY CLUSTERED 
(
	[CodTipoDato] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [Controls].[Filter]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[Filter]') AND type in (N'U'))
BEGIN
CREATE TABLE [Controls].[Filter](
	[IdFiltro] [int] IDENTITY(1,1) NOT NULL,
	[DescripcionFiltro] [varchar](100) NULL,
	[KeyFiltro] [nchar](100) NULL,
	[DataModel] [bit] NULL,
	[Status] [bit] NULL,
	[IdProcess] [int] NULL,
 CONSTRAINT [PK_Filtros] PRIMARY KEY CLUSTERED 
(
	[IdFiltro] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [Controls].[Form]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[Form]') AND type in (N'U'))
BEGIN
CREATE TABLE [Controls].[Form](
	[IdFormulario] [int] IDENTITY(1,1) NOT NULL,
	[DescripcionFormulario] [varchar](100) NULL,
	[KeyFormulario] [varchar](100) NULL,
	[Status] [bit] NULL,
	[IdProcess] [int] NULL,
	[Icono] [varchar](100) NULL,
 CONSTRAINT [PK_Formulario] PRIMARY KEY CLUSTERED 
(
	[IdFormulario] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [Controls].[Group]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Controls].[Group]') AND type in (N'U'))
BEGIN
CREATE TABLE [Controls].[Group](
	[IdGrupo] [int] IDENTITY(1,1) NOT NULL,
	[DescripcionGrupo] [varchar](100) NULL,
	[Status] [bit] NULL,
	[IdProcess] [int] NULL,
 CONSTRAINT [PK_Group] PRIMARY KEY CLUSTERED 
(
	[IdGrupo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ASPStateTempApplications]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ASPStateTempApplications]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ASPStateTempApplications](
	[AppId] [int] NOT NULL,
	[AppName] [char](280) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[AppId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ASPStateTempSessions]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ASPStateTempSessions]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ASPStateTempSessions](
	[SessionId] [nvarchar](88) NOT NULL,
	[Created] [datetime] NOT NULL,
	[Expires] [datetime] NOT NULL,
	[LockDate] [datetime] NOT NULL,
	[LockDateLocal] [datetime] NOT NULL,
	[LockCookie] [int] NOT NULL,
	[Timeout] [int] NOT NULL,
	[Locked] [bit] NOT NULL,
	[SessionItemShort] [varbinary](7000) NULL,
	[SessionItemLong] [image] NULL,
	[Flags] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[SessionId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[AuditColumnsDefinition]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AuditColumnsDefinition]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AuditColumnsDefinition](
	[IdTableDefinition] [int] NOT NULL,
	[ColumnName] [nvarchar](128) NOT NULL,
	[IsKey] [bit] NOT NULL,
	[wasPublished] [bit] NOT NULL,
	[isDisable] [bit] NOT NULL,
	[DataType] [nvarchar](100) NULL,
	[DataLength] [int] NOT NULL,
 CONSTRAINT [PK_dbo.AuditColumnsDefinition] PRIMARY KEY CLUSTERED 
(
	[IdTableDefinition] ASC,
	[ColumnName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[AuditConnectionProcess]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AuditConnectionProcess](
	[IdProcess] [int] NOT NULL,
	[IdConnectionOrigin] [int] NOT NULL,
	[IdConnectionDestination] [int] NOT NULL,
 CONSTRAINT [PK_dbo.AuditConnectionProcess] PRIMARY KEY CLUSTERED 
(
	[IdProcess] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[AuditTablesDefinition]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AuditTablesDefinition]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AuditTablesDefinition](
	[IdTableDefinition] [int] IDENTITY(1,1) NOT NULL,
	[TableName] [nvarchar](200) NOT NULL,
	[IdTablesStatus] [char](4) NOT NULL,
 CONSTRAINT [PK_dbo.AuditTablesDefinition] PRIMARY KEY CLUSTERED 
(
	[IdTableDefinition] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[AuditTablesVsSteps]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AuditTablesVsSteps]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[AuditTablesVsSteps](
	[IdTableDefinition] [int] NOT NULL,
	[IdStep] [int] NOT NULL,
	[isDisabled] [bit] NOT NULL,
 CONSTRAINT [PK_dbo.AuditTablesVsSteps] PRIMARY KEY CLUSTERED 
(
	[IdTableDefinition] ASC,
	[IdStep] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[BusinessRules]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BusinessRules]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[BusinessRules](
	[IdBusinessRule] [int] IDENTITY(1,1) NOT NULL,
	[IdStep] [int] NOT NULL,
	[IdNextStep] [int] NOT NULL,
	[Priority] [int] NOT NULL,
 CONSTRAINT [PK_BusinessRules] PRIMARY KEY CLUSTERED 
(
	[IdBusinessRule] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[Cat_DiasFestivos]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Cat_DiasFestivos]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Cat_DiasFestivos](
	[IdSecuenciaFecha] [int] NOT NULL,
	[fecha] [datetime] NOT NULL,
	[fechaCreacion] [datetime] NOT NULL,
 CONSTRAINT [PK_Cat_DiasFestivos] PRIMARY KEY CLUSTERED 
(
	[IdSecuenciaFecha] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[Cat_JornadaLaboral]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Cat_JornadaLaboral]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Cat_JornadaLaboral](
	[Id_dia_semana] [int] NOT NULL,
	[descripcion] [varchar](20) NOT NULL,
	[excluir] [bit] NOT NULL,
 CONSTRAINT [PK_Cat_JornadaLaboral] PRIMARY KEY CLUSTERED 
(
	[Id_dia_semana] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CatAuditTablesStatus]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatAuditTablesStatus]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CatAuditTablesStatus](
	[IdTablesStatus] [char](4) NOT NULL,
	[StatusName] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_dbo.CatAuditTablesStatus] PRIMARY KEY CLUSTERED 
(
	[IdTablesStatus] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CatConnections]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatConnections]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CatConnections](
	[IdConnections] [int] IDENTITY(1,1) NOT NULL,
	[ConnectionString] [nvarchar](max) NOT NULL,
	[ConnectionName] [nvarchar](100) NOT NULL,
	[IdConnectionType] [int] NOT NULL,
 CONSTRAINT [PK_dbo.CatConnections] PRIMARY KEY CLUSTERED 
(
	[IdConnections] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[CatConnectionTypes]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatConnectionTypes]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CatConnectionTypes](
	[IdConnectionType] [int] NOT NULL,
	[ConnectionName] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_dbo.CatConnectionTypes] PRIMARY KEY CLUSTERED 
(
	[IdConnectionType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[CatEmailProcess]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatEmailProcess]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CatEmailProcess](
	[IdFiltro] [int] IDENTITY(1,1) NOT NULL,
	[IdProcess] [int] NOT NULL,
	[Nombre] [varchar](300) NOT NULL,
	[Descripcion] [nvarchar](max) NULL,
	[DatosJSON] [nvarchar](max) NULL,
 CONSTRAINT [PK__CatEmail__0772E7B28CFA7C79] PRIMARY KEY CLUSTERED 
(
	[IdFiltro] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CatForms]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatForms]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CatForms](
	[IdForm] [int] IDENTITY(1,1) NOT NULL,
	[FormFile] [nvarchar](max) NOT NULL,
	[FormLabel] [nvarchar](200) NOT NULL,
	[IdWebAplication] [int] NOT NULL,
 CONSTRAINT [PK_dbo.CatForms] PRIMARY KEY CLUSTERED 
(
	[IdForm] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[CatProcesses]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatProcesses]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CatProcesses](
	[IdProcess] [int] IDENTITY(1,1) NOT NULL,
	[ProcessName] [nvarchar](100) NOT NULL,
	[ProcessVersion] [int] NOT NULL,
 CONSTRAINT [PK_dbo.CatProcesses] PRIMARY KEY CLUSTERED 
(
	[IdProcess] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[CatSteps]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatSteps]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CatSteps](
	[IdStep] [int] IDENTITY(1,1) NOT NULL,
	[StepName] [nvarchar](200) NOT NULL,
	[IdProcess] [int] NOT NULL,
 CONSTRAINT [PK_dbo.CatSteps] PRIMARY KEY CLUSTERED 
(
	[IdStep] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[CatWebAplications]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CatWebAplications]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CatWebAplications](
	[IdWebAplication] [int] IDENTITY(1,1) NOT NULL,
	[WebAplicationName] [nvarchar](300) NOT NULL,
	[WebAplicationPath] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_dbo.CatWebAplications] PRIMARY KEY CLUSTERED 
(
	[IdWebAplication] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[Conditions]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Conditions]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Conditions](
	[IdCondition] [int] IDENTITY(1,1) NOT NULL,
	[IdBusinessRule] [int] NOT NULL,
	[Variable] [nvarchar](50) NOT NULL,
	[Operator] [nvarchar](50) NOT NULL,
	[Value] [nvarchar](50) NOT NULL,
	[Type] [int] NOT NULL,
 CONSTRAINT [PK_Conditions] PRIMARY KEY CLUSTERED 
(
	[IdCondition] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[FormsProcess]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FormsProcess]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[FormsProcess](
	[IdFormProcess] [int] IDENTITY(1,1) NOT NULL,
	[IdStep] [int] NOT NULL,
	[FormOrder] [int] NOT NULL,
	[IdForm] [int] NOT NULL,
 CONSTRAINT [PK_dbo.FormsProcess] PRIMARY KEY CLUSTERED 
(
	[IdFormProcess] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[HelpProcess]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[HelpProcess]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[HelpProcess](
	[IdHelpProcess] [int] IDENTITY(1,1) NOT NULL,
	[IdForm] [int] NOT NULL,
	[Control] [nvarchar](300) NOT NULL,
	[Text] [text] NOT NULL,
	[ControlLabel] [nvarchar](300) NOT NULL,
 CONSTRAINT [PK_dbo.HelpProcess] PRIMARY KEY CLUSTERED 
(
	[IdHelpProcess] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[HistoryConfiguration]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[HistoryConfiguration]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[HistoryConfiguration](
	[IdConfiguration] [int] IDENTITY(1,1) NOT NULL,
	[IdProcess] [int] NOT NULL,
	[CompletedTaskDeleted] [bit] NOT NULL,
	[IncidentAborted] [bit] NOT NULL,
	[IncidentCompleted] [bit] NOT NULL,
	[IncidentInitiated] [bit] NOT NULL,
	[StepAborted] [bit] NOT NULL,
	[TaskActivated] [bit] NOT NULL,
	[TaskAssigned] [bit] NOT NULL,
	[TaskCompleted] [bit] NOT NULL,
	[TaskConferred] [bit] NOT NULL,
	[TaskDelayed] [bit] NOT NULL,
	[TaskLate] [bit] NOT NULL,
	[TaskResubmitted] [bit] NOT NULL,
	[TaskReturned] [bit] NOT NULL,
	[TaskSubmitFailed] [bit] NOT NULL,
	[TasksPerDayThresholdReached] [bit] NOT NULL,
	[QueueTaskActivated] [bit] NOT NULL,
	[TaskDeletedOnMinResponseComplete] [bit] NOT NULL,
	[IncidentVariables] [varchar](500) NULL,
	[TaskVariables] [varchar](500) NULL,
 CONSTRAINT [PK_dbo.HistoryConfiguration] PRIMARY KEY CLUSTERED 
(
	[IdConfiguration] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[WebAplicationDetails]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WebAplicationDetails]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[WebAplicationDetails](
	[IdProcess] [int] NOT NULL,
	[IdWebAplication] [int] NOT NULL,
 CONSTRAINT [PK_dbo.WebAplicationDetails] PRIMARY KEY CLUSTERED 
(
	[IdProcess] ASC,
	[IdWebAplication] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [Document].[ConfiguracionGeneralDocumentos]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Document].[ConfiguracionGeneralDocumentos]') AND type in (N'U'))
BEGIN
CREATE TABLE [Document].[ConfiguracionGeneralDocumentos](
	[IdProcess] [int] NOT NULL,
	[RutaFisicaPlantillas] [nvarchar](max) NULL,
	[ConectorRegistroBD_Default] [nvarchar](max) NULL,
	[CodigoTipoDB] [int] NULL,
	[FechaCreacion] [datetime] NOT NULL,
 CONSTRAINT [PK_ConfiguracionGeneralDocumentos] PRIMARY KEY CLUSTERED 
(
	[IdProcess] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [Document].[DocumentosProceso]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Document].[DocumentosProceso]') AND type in (N'U'))
BEGIN
CREATE TABLE [Document].[DocumentosProceso](
	[IdProcess] [int] NOT NULL,
	[CodigoDocumneto] [int] NOT NULL,
	[Nombre] [varchar](50) NOT NULL,
	[Descripcion] [nvarchar](max) NULL,
	[JSON] [nvarchar](max) NOT NULL,
	[FechaCreacion] [datetime] NOT NULL,
 CONSTRAINT [PK_DocumentosProceso] PRIMARY KEY CLUSTERED 
(
	[IdProcess] ASC,
	[CodigoDocumneto] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [Process].[BitacoraComentarios]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Process].[BitacoraComentarios]') AND type in (N'U'))
BEGIN
CREATE TABLE [Process].[BitacoraComentarios](
	[CodComentario] [int] IDENTITY(1,1) NOT NULL,
	[CodProceso] [int] NOT NULL,
	[CodSolicitud] [int] NOT NULL,
	[Incidente] [int] NOT NULL,
	[UserID] [varchar](100) NOT NULL,
	[Etapa] [varchar](100) NULL,
	[Fecha] [datetime] NULL,
	[Comentario] [ntext] NULL,
 CONSTRAINT [PK_Process.BitacoraComentarios] PRIMARY KEY CLUSTERED 
(
	[CodComentario] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [Process].[BitacoraCorreos]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Process].[BitacoraCorreos]') AND type in (N'U'))
BEGIN
CREATE TABLE [Process].[BitacoraCorreos](
	[IdBitacora] [bigint] IDENTITY(1,1) NOT NULL,
	[UserID] [varchar](300) NOT NULL,
	[CodSolicitud] [bigint] NULL,
	[Incidente] [int] NOT NULL,
	[NombreProceso] [varchar](300) NOT NULL,
	[NombreFiltro] [varchar](300) NOT NULL,
	[DescripcionCorreo] [nvarchar](max) NOT NULL,
	[Destinatario] [nvarchar](max) NULL,
	[CC] [nvarchar](max) NULL,
	[Asunto] [nvarchar](max) NULL,
	[CuerpoCorreo] [nvarchar](max) NULL,
	[Fecha] [datetime] NOT NULL,
 CONSTRAINT [PK__Bitacora__ED3A1B13D6E2BBAC] PRIMARY KEY CLUSTERED 
(
	[IdBitacora] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [Process].[DocumentosAdjuntos]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Process].[DocumentosAdjuntos]') AND type in (N'U'))
BEGIN
CREATE TABLE [Process].[DocumentosAdjuntos](
	[CodDocumento] [int] IDENTITY(1,1) NOT NULL,
	[CodProceso] [int] NOT NULL,
	[CodSolicitud] [int] NOT NULL,
	[Incidente] [int] NOT NULL,
	[NombreProceso] [varchar](300) NOT NULL,
	[NombreDocumento] [ntext] NOT NULL,
	[UserID] [varchar](100) NULL,
	[Etapa] [varchar](100) NULL,
	[Fecha] [datetime] NOT NULL,
	[RutaFisica] [ntext] NULL,
	[RutaDescarga] [ntext] NULL,
	[TipoArchivo] [varchar](10) NULL,
 CONSTRAINT [PK_Process.DocumentosAdjuntos] PRIMARY KEY CLUSTERED 
(
	[CodDocumento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [Profile].[Profile]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Profile].[Profile]') AND type in (N'U'))
BEGIN
CREATE TABLE [Profile].[Profile](
	[IdProfile] [int] IDENTITY(1,1) NOT NULL,
	[UltimusName] [nvarchar](500) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[LastName] [nvarchar](50) NOT NULL,
	[ProfileImage] [nvarchar](max) NULL,
	[AboutMe] [nvarchar](500) NULL,
	[CreationDate] [datetime] NULL,
	[UpdateDate] [datetime] NULL,
	[ProfileImageSmall] [nvarchar](max) NULL,
 CONSTRAINT [PK_Profile] PRIMARY KEY CLUSTERED 
(
	[IdProfile] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [Theme].[ThemeProcess]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Theme].[ThemeProcess]') AND type in (N'U'))
BEGIN
CREATE TABLE [Theme].[ThemeProcess](
	[IdThemeProcess] [int] IDENTITY(1,1) NOT NULL,
	[IdTheme] [int] NOT NULL,
	[IdProcess] [int] NOT NULL,
 CONSTRAINT [PK_ThemeProcess] PRIMARY KEY CLUSTERED 
(
	[IdThemeProcess] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [Theme].[Themes]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Theme].[Themes]') AND type in (N'U'))
BEGIN
CREATE TABLE [Theme].[Themes](
	[IdTheme] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](200) NOT NULL,
	[Description] [nvarchar](max) NOT NULL,
	[BackgroundColor] [nvarchar](10) NOT NULL,
	[FontColor] [nvarchar](10) NOT NULL,
	[MenuColor] [nvarchar](10) NOT NULL,
	[Logo] [nvarchar](max) NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[UpdateDate] [datetime] NULL,
 CONSTRAINT [PK_Themes] PRIMARY KEY CLUSTERED 
(
	[IdTheme] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object:  Table [View].[ComplementView]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[View].[ComplementView]') AND type in (N'U'))
BEGIN
CREATE TABLE [View].[ComplementView](
	[IdComplementView] [int] IDENTITY(1,1) NOT NULL,
	[ViewName] [nvarchar](100) NOT NULL,
	[ViewKey] [varchar](100) NOT NULL,
	[ViewDescription] [nvarchar](250) NULL,
	[IdProcess] [int] NOT NULL,
	[RenderLayoutType] [nchar](1) NOT NULL,
	[EnableSaveButton] [bit] NULL,
	[WebApiSave] [nvarchar](max) NULL,
	[EnableSendButton] [bit] NULL,
	[WebApiSend] [nvarchar](max) NULL,
	[DynamicJavascript] [nvarchar](max) NULL,
	[EnableLoadEvent] [bit] NULL,
	[WebApiLoad] [nvarchar](max) NULL,
 CONSTRAINT [PK_ComplementView] PRIMARY KEY CLUSTERED 
(
	[IdComplementView] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [View].[ControlInForm]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[View].[ControlInForm]') AND type in (N'U'))
BEGIN
CREATE TABLE [View].[ControlInForm](
	[IdComplementView] [int] NOT NULL,
	[IdFormulario] [int] NOT NULL,
	[IdFiltro] [int] NOT NULL,
	[IdControl] [int] NOT NULL,
	[RenderOrder] [int] NOT NULL,
	[RenderColumn] [int] NOT NULL,
 CONSTRAINT [PK_ControlInForm] PRIMARY KEY CLUSTERED 
(
	[IdComplementView] ASC,
	[IdFormulario] ASC,
	[IdFiltro] ASC,
	[IdControl] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [View].[FormInView]    Script Date: 16/02/2018 02:48:40 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[View].[FormInView]') AND type in (N'U'))
BEGIN
CREATE TABLE [View].[FormInView](
	[IdComplementView] [int] NOT NULL,
	[IdFormulario] [int] NOT NULL,
	[IdFiltro] [int] NOT NULL,
	[RenderOrder] [int] NOT NULL,
 CONSTRAINT [PK_FormInView] PRIMARY KEY CLUSTERED 
(
	[IdComplementView] ASC,
	[IdFormulario] ASC,
	[IdFiltro] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[ConfiguracionPersona].[DF_PersonaProceso_CodigoTipoPersona]') AND type = 'D')
BEGIN
ALTER TABLE [ConfiguracionPersona].[PersonaProceso] ADD  CONSTRAINT [DF_PersonaProceso_CodigoTipoPersona]  DEFAULT ((1)) FOR [CodigoTipoPersona]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__ASPStateT__Creat__7DEDA633]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ASPStateTempSessions] ADD  DEFAULT (getutcdate()) FOR [Created]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__ASPStateT__Flags__7EE1CA6C]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ASPStateTempSessions] ADD  DEFAULT ((0)) FOR [Flags]
END

GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF__Cat_DiasF__fecha__150615B5]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Cat_DiasFestivos] ADD  DEFAULT (getdate()) FOR [fechaCreacion]
END

GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_FormularioPersona_TipoPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersona]'))
ALTER TABLE [ConfiguracionPersona].[FormularioPersona]  WITH CHECK ADD  CONSTRAINT [FK_FormularioPersona_TipoPersona] FOREIGN KEY([CodigoTipoPersona])
REFERENCES [ConfiguracionPersona].[TipoPersona] ([CodigoTipoPersona])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_FormularioPersona_TipoPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersona]'))
ALTER TABLE [ConfiguracionPersona].[FormularioPersona] CHECK CONSTRAINT [FK_FormularioPersona_TipoPersona]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_FormularioPersonaProceso_FormularioPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[FormularioPersonaProceso]  WITH CHECK ADD  CONSTRAINT [FK_FormularioPersonaProceso_FormularioPersona] FOREIGN KEY([CodigoTipoPersona], [CodigoFormulario])
REFERENCES [ConfiguracionPersona].[FormularioPersona] ([CodigoTipoPersona], [CodigoFormulario])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_FormularioPersonaProceso_FormularioPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[FormularioPersonaProceso] CHECK CONSTRAINT [FK_FormularioPersonaProceso_FormularioPersona]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_FormularioPersonaProceso_PersonaProceso1]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[FormularioPersonaProceso]  WITH CHECK ADD  CONSTRAINT [FK_FormularioPersonaProceso_PersonaProceso1] FOREIGN KEY([IdProcess], [CodigoTipoPersona])
REFERENCES [ConfiguracionPersona].[PersonaProceso] ([IdProcess], [CodigoTipoPersona])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_FormularioPersonaProceso_PersonaProceso1]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[FormularioPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[FormularioPersonaProceso] CHECK CONSTRAINT [FK_FormularioPersonaProceso_PersonaProceso1]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_ParametrosGeneralesPersona_TipoParametroPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosGeneralesPersona]'))
ALTER TABLE [ConfiguracionPersona].[ParametrosGeneralesPersona]  WITH CHECK ADD  CONSTRAINT [FK_ParametrosGeneralesPersona_TipoParametroPersona] FOREIGN KEY([CodigoTipo])
REFERENCES [ConfiguracionPersona].[TipoParametroPersona] ([CodigoTipo])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_ParametrosGeneralesPersona_TipoParametroPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosGeneralesPersona]'))
ALTER TABLE [ConfiguracionPersona].[ParametrosGeneralesPersona] CHECK CONSTRAINT [FK_ParametrosGeneralesPersona_TipoParametroPersona]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_ParametrosPersonaProceso_ParametrosGeneralesPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[ParametrosPersonaProceso]  WITH CHECK ADD  CONSTRAINT [FK_ParametrosPersonaProceso_ParametrosGeneralesPersona] FOREIGN KEY([CodigoParametro])
REFERENCES [ConfiguracionPersona].[ParametrosGeneralesPersona] ([CodigoParametro])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_ParametrosPersonaProceso_ParametrosGeneralesPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[ParametrosPersonaProceso] CHECK CONSTRAINT [FK_ParametrosPersonaProceso_ParametrosGeneralesPersona]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_ParametrosPersonaProceso_PersonaProceso]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[ParametrosPersonaProceso]  WITH CHECK ADD  CONSTRAINT [FK_ParametrosPersonaProceso_PersonaProceso] FOREIGN KEY([IdProcess], [CodigoTipoPersona])
REFERENCES [ConfiguracionPersona].[PersonaProceso] ([IdProcess], [CodigoTipoPersona])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_ParametrosPersonaProceso_PersonaProceso]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[ParametrosPersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[ParametrosPersonaProceso] CHECK CONSTRAINT [FK_ParametrosPersonaProceso_PersonaProceso]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_PersonaProceso_CatProcesses]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[PersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[PersonaProceso]  WITH CHECK ADD  CONSTRAINT [FK_PersonaProceso_CatProcesses] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_PersonaProceso_CatProcesses]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[PersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[PersonaProceso] CHECK CONSTRAINT [FK_PersonaProceso_CatProcesses]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_PersonaProceso_TipoPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[PersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[PersonaProceso]  WITH CHECK ADD  CONSTRAINT [FK_PersonaProceso_TipoPersona] FOREIGN KEY([CodigoTipoPersona])
REFERENCES [ConfiguracionPersona].[TipoPersona] ([CodigoTipoPersona])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[ConfiguracionPersona].[FK_PersonaProceso_TipoPersona]') AND parent_object_id = OBJECT_ID(N'[ConfiguracionPersona].[PersonaProceso]'))
ALTER TABLE [ConfiguracionPersona].[PersonaProceso] CHECK CONSTRAINT [FK_PersonaProceso_TipoPersona]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_CatControles_CatTipoDato]') AND parent_object_id = OBJECT_ID(N'[Controls].[Controls]'))
ALTER TABLE [Controls].[Controls]  WITH CHECK ADD  CONSTRAINT [FK_CatControles_CatTipoDato] FOREIGN KEY([CodTipoDato])
REFERENCES [Controls].[Datatype] ([CodTipoDato])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_CatControles_CatTipoDato]') AND parent_object_id = OBJECT_ID(N'[Controls].[Controls]'))
ALTER TABLE [Controls].[Controls] CHECK CONSTRAINT [FK_CatControles_CatTipoDato]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_CatControles_Formulario]') AND parent_object_id = OBJECT_ID(N'[Controls].[Controls]'))
ALTER TABLE [Controls].[Controls]  WITH CHECK ADD  CONSTRAINT [FK_CatControles_Formulario] FOREIGN KEY([IdFormulario])
REFERENCES [Controls].[Form] ([IdFormulario])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_CatControles_Formulario]') AND parent_object_id = OBJECT_ID(N'[Controls].[Controls]'))
ALTER TABLE [Controls].[Controls] CHECK CONSTRAINT [FK_CatControles_Formulario]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Controls_Group]') AND parent_object_id = OBJECT_ID(N'[Controls].[Controls]'))
ALTER TABLE [Controls].[Controls]  WITH CHECK ADD  CONSTRAINT [FK_Controls_Group] FOREIGN KEY([IdGrupo])
REFERENCES [Controls].[Group] ([IdGrupo])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Controls_Group]') AND parent_object_id = OBJECT_ID(N'[Controls].[Controls]'))
ALTER TABLE [Controls].[Controls] CHECK CONSTRAINT [FK_Controls_Group]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_ConfiguracionControles_CatContol]') AND parent_object_id = OBJECT_ID(N'[Controls].[ControlsSettings]'))
ALTER TABLE [Controls].[ControlsSettings]  WITH CHECK ADD  CONSTRAINT [FK_ConfiguracionControles_CatContol] FOREIGN KEY([IdControl])
REFERENCES [Controls].[Controls] ([Id])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_ConfiguracionControles_CatContol]') AND parent_object_id = OBJECT_ID(N'[Controls].[ControlsSettings]'))
ALTER TABLE [Controls].[ControlsSettings] CHECK CONSTRAINT [FK_ConfiguracionControles_CatContol]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_ConfiguracionControles_Filtro]') AND parent_object_id = OBJECT_ID(N'[Controls].[ControlsSettings]'))
ALTER TABLE [Controls].[ControlsSettings]  WITH CHECK ADD  CONSTRAINT [FK_ConfiguracionControles_Filtro] FOREIGN KEY([IdFiltro])
REFERENCES [Controls].[Filter] ([IdFiltro])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_ConfiguracionControles_Filtro]') AND parent_object_id = OBJECT_ID(N'[Controls].[ControlsSettings]'))
ALTER TABLE [Controls].[ControlsSettings] CHECK CONSTRAINT [FK_ConfiguracionControles_Filtro]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_ConfiguracionControles_Formulario]') AND parent_object_id = OBJECT_ID(N'[Controls].[ControlsSettings]'))
ALTER TABLE [Controls].[ControlsSettings]  WITH CHECK ADD  CONSTRAINT [FK_ConfiguracionControles_Formulario] FOREIGN KEY([IdFormulario])
REFERENCES [Controls].[Form] ([IdFormulario])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_ConfiguracionControles_Formulario]') AND parent_object_id = OBJECT_ID(N'[Controls].[ControlsSettings]'))
ALTER TABLE [Controls].[ControlsSettings] CHECK CONSTRAINT [FK_ConfiguracionControles_Formulario]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Filter_Process]') AND parent_object_id = OBJECT_ID(N'[Controls].[Filter]'))
ALTER TABLE [Controls].[Filter]  WITH CHECK ADD  CONSTRAINT [FK_Filter_Process] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Filter_Process]') AND parent_object_id = OBJECT_ID(N'[Controls].[Filter]'))
ALTER TABLE [Controls].[Filter] CHECK CONSTRAINT [FK_Filter_Process]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Form_Process]') AND parent_object_id = OBJECT_ID(N'[Controls].[Form]'))
ALTER TABLE [Controls].[Form]  WITH CHECK ADD  CONSTRAINT [FK_Form_Process] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Form_Process]') AND parent_object_id = OBJECT_ID(N'[Controls].[Form]'))
ALTER TABLE [Controls].[Form] CHECK CONSTRAINT [FK_Form_Process]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Group_Proceso]') AND parent_object_id = OBJECT_ID(N'[Controls].[Group]'))
ALTER TABLE [Controls].[Group]  WITH CHECK ADD  CONSTRAINT [FK_Group_Proceso] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Controls].[FK_Group_Proceso]') AND parent_object_id = OBJECT_ID(N'[Controls].[Group]'))
ALTER TABLE [Controls].[Group] CHECK CONSTRAINT [FK_Group_Proceso]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditColumnsDefinition_dbo.AuditTablesDefinition_IdTableDefinition]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditColumnsDefinition]'))
ALTER TABLE [dbo].[AuditColumnsDefinition]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AuditColumnsDefinition_dbo.AuditTablesDefinition_IdTableDefinition] FOREIGN KEY([IdTableDefinition])
REFERENCES [dbo].[AuditTablesDefinition] ([IdTableDefinition])
ON DELETE CASCADE
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditColumnsDefinition_dbo.AuditTablesDefinition_IdTableDefinition]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditColumnsDefinition]'))
ALTER TABLE [dbo].[AuditColumnsDefinition] CHECK CONSTRAINT [FK_dbo.AuditColumnsDefinition_dbo.AuditTablesDefinition_IdTableDefinition]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionDestination]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]'))
ALTER TABLE [dbo].[AuditConnectionProcess]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionDestination] FOREIGN KEY([IdConnectionDestination])
REFERENCES [dbo].[CatConnections] ([IdConnections])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionDestination]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]'))
ALTER TABLE [dbo].[AuditConnectionProcess] CHECK CONSTRAINT [FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionDestination]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionOrigin]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]'))
ALTER TABLE [dbo].[AuditConnectionProcess]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionOrigin] FOREIGN KEY([IdConnectionOrigin])
REFERENCES [dbo].[CatConnections] ([IdConnections])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionOrigin]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]'))
ALTER TABLE [dbo].[AuditConnectionProcess] CHECK CONSTRAINT [FK_dbo.AuditConnectionProcess_dbo.CatConnections_IdConnectionOrigin]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditConnectionProcess_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]'))
ALTER TABLE [dbo].[AuditConnectionProcess]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AuditConnectionProcess_dbo.CatProcesses_IdProcess] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditConnectionProcess_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditConnectionProcess]'))
ALTER TABLE [dbo].[AuditConnectionProcess] CHECK CONSTRAINT [FK_dbo.AuditConnectionProcess_dbo.CatProcesses_IdProcess]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditTablesDefinition_dbo.CatAuditTablesStatus_IdTablesStatus]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditTablesDefinition]'))
ALTER TABLE [dbo].[AuditTablesDefinition]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AuditTablesDefinition_dbo.CatAuditTablesStatus_IdTablesStatus] FOREIGN KEY([IdTablesStatus])
REFERENCES [dbo].[CatAuditTablesStatus] ([IdTablesStatus])
ON DELETE CASCADE
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditTablesDefinition_dbo.CatAuditTablesStatus_IdTablesStatus]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditTablesDefinition]'))
ALTER TABLE [dbo].[AuditTablesDefinition] CHECK CONSTRAINT [FK_dbo.AuditTablesDefinition_dbo.CatAuditTablesStatus_IdTablesStatus]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditTablesVsSteps_dbo.AuditTablesDefinition_IdTableDefinition]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditTablesVsSteps]'))
ALTER TABLE [dbo].[AuditTablesVsSteps]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AuditTablesVsSteps_dbo.AuditTablesDefinition_IdTableDefinition] FOREIGN KEY([IdTableDefinition])
REFERENCES [dbo].[AuditTablesDefinition] ([IdTableDefinition])
ON DELETE CASCADE
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditTablesVsSteps_dbo.AuditTablesDefinition_IdTableDefinition]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditTablesVsSteps]'))
ALTER TABLE [dbo].[AuditTablesVsSteps] CHECK CONSTRAINT [FK_dbo.AuditTablesVsSteps_dbo.AuditTablesDefinition_IdTableDefinition]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditTablesVsSteps_dbo.CatSteps_IdStep]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditTablesVsSteps]'))
ALTER TABLE [dbo].[AuditTablesVsSteps]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AuditTablesVsSteps_dbo.CatSteps_IdStep] FOREIGN KEY([IdStep])
REFERENCES [dbo].[CatSteps] ([IdStep])
ON DELETE CASCADE
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.AuditTablesVsSteps_dbo.CatSteps_IdStep]') AND parent_object_id = OBJECT_ID(N'[dbo].[AuditTablesVsSteps]'))
ALTER TABLE [dbo].[AuditTablesVsSteps] CHECK CONSTRAINT [FK_dbo.AuditTablesVsSteps_dbo.CatSteps_IdStep]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BusinessRules_CatSteps]') AND parent_object_id = OBJECT_ID(N'[dbo].[BusinessRules]'))
ALTER TABLE [dbo].[BusinessRules]  WITH CHECK ADD  CONSTRAINT [FK_BusinessRules_CatSteps] FOREIGN KEY([IdStep])
REFERENCES [dbo].[CatSteps] ([IdStep])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BusinessRules_CatSteps]') AND parent_object_id = OBJECT_ID(N'[dbo].[BusinessRules]'))
ALTER TABLE [dbo].[BusinessRules] CHECK CONSTRAINT [FK_BusinessRules_CatSteps]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BusinessRules_CatSteps1]') AND parent_object_id = OBJECT_ID(N'[dbo].[BusinessRules]'))
ALTER TABLE [dbo].[BusinessRules]  WITH CHECK ADD  CONSTRAINT [FK_BusinessRules_CatSteps1] FOREIGN KEY([IdNextStep])
REFERENCES [dbo].[CatSteps] ([IdStep])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BusinessRules_CatSteps1]') AND parent_object_id = OBJECT_ID(N'[dbo].[BusinessRules]'))
ALTER TABLE [dbo].[BusinessRules] CHECK CONSTRAINT [FK_BusinessRules_CatSteps1]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.CatConnections_dbo.CatConnectionTypes_IdConnectionType]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatConnections]'))
ALTER TABLE [dbo].[CatConnections]  WITH CHECK ADD  CONSTRAINT [FK_dbo.CatConnections_dbo.CatConnectionTypes_IdConnectionType] FOREIGN KEY([IdConnectionType])
REFERENCES [dbo].[CatConnectionTypes] ([IdConnectionType])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.CatConnections_dbo.CatConnectionTypes_IdConnectionType]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatConnections]'))
ALTER TABLE [dbo].[CatConnections] CHECK CONSTRAINT [FK_dbo.CatConnections_dbo.CatConnectionTypes_IdConnectionType]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Email_Processes]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatEmailProcess]'))
ALTER TABLE [dbo].[CatEmailProcess]  WITH CHECK ADD  CONSTRAINT [FK_Email_Processes] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Email_Processes]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatEmailProcess]'))
ALTER TABLE [dbo].[CatEmailProcess] CHECK CONSTRAINT [FK_Email_Processes]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.CatForms_dbo.CatWebAplications_IdWebAplication]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatForms]'))
ALTER TABLE [dbo].[CatForms]  WITH CHECK ADD  CONSTRAINT [FK_dbo.CatForms_dbo.CatWebAplications_IdWebAplication] FOREIGN KEY([IdWebAplication])
REFERENCES [dbo].[CatWebAplications] ([IdWebAplication])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.CatForms_dbo.CatWebAplications_IdWebAplication]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatForms]'))
ALTER TABLE [dbo].[CatForms] CHECK CONSTRAINT [FK_dbo.CatForms_dbo.CatWebAplications_IdWebAplication]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.CatSteps_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatSteps]'))
ALTER TABLE [dbo].[CatSteps]  WITH CHECK ADD  CONSTRAINT [FK_dbo.CatSteps_dbo.CatProcesses_IdProcess] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.CatSteps_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[CatSteps]'))
ALTER TABLE [dbo].[CatSteps] CHECK CONSTRAINT [FK_dbo.CatSteps_dbo.CatProcesses_IdProcess]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Conditions_BusinessRules]') AND parent_object_id = OBJECT_ID(N'[dbo].[Conditions]'))
ALTER TABLE [dbo].[Conditions]  WITH CHECK ADD  CONSTRAINT [FK_Conditions_BusinessRules] FOREIGN KEY([IdBusinessRule])
REFERENCES [dbo].[BusinessRules] ([IdBusinessRule])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Conditions_BusinessRules]') AND parent_object_id = OBJECT_ID(N'[dbo].[Conditions]'))
ALTER TABLE [dbo].[Conditions] CHECK CONSTRAINT [FK_Conditions_BusinessRules]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.FormsProcess_dbo.CatForms_IdForm]') AND parent_object_id = OBJECT_ID(N'[dbo].[FormsProcess]'))
ALTER TABLE [dbo].[FormsProcess]  WITH CHECK ADD  CONSTRAINT [FK_dbo.FormsProcess_dbo.CatForms_IdForm] FOREIGN KEY([IdForm])
REFERENCES [dbo].[CatForms] ([IdForm])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.FormsProcess_dbo.CatForms_IdForm]') AND parent_object_id = OBJECT_ID(N'[dbo].[FormsProcess]'))
ALTER TABLE [dbo].[FormsProcess] CHECK CONSTRAINT [FK_dbo.FormsProcess_dbo.CatForms_IdForm]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.FormsProcess_dbo.CatSteps_IdStep]') AND parent_object_id = OBJECT_ID(N'[dbo].[FormsProcess]'))
ALTER TABLE [dbo].[FormsProcess]  WITH CHECK ADD  CONSTRAINT [FK_dbo.FormsProcess_dbo.CatSteps_IdStep] FOREIGN KEY([IdStep])
REFERENCES [dbo].[CatSteps] ([IdStep])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.FormsProcess_dbo.CatSteps_IdStep]') AND parent_object_id = OBJECT_ID(N'[dbo].[FormsProcess]'))
ALTER TABLE [dbo].[FormsProcess] CHECK CONSTRAINT [FK_dbo.FormsProcess_dbo.CatSteps_IdStep]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.HelpProcess_dbo.CatForms_IdForm]') AND parent_object_id = OBJECT_ID(N'[dbo].[HelpProcess]'))
ALTER TABLE [dbo].[HelpProcess]  WITH CHECK ADD  CONSTRAINT [FK_dbo.HelpProcess_dbo.CatForms_IdForm] FOREIGN KEY([IdForm])
REFERENCES [dbo].[CatForms] ([IdForm])
ON DELETE CASCADE
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.HelpProcess_dbo.CatForms_IdForm]') AND parent_object_id = OBJECT_ID(N'[dbo].[HelpProcess]'))
ALTER TABLE [dbo].[HelpProcess] CHECK CONSTRAINT [FK_dbo.HelpProcess_dbo.CatForms_IdForm]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.HistoryConfiguration_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[HistoryConfiguration]'))
ALTER TABLE [dbo].[HistoryConfiguration]  WITH CHECK ADD  CONSTRAINT [FK_dbo.HistoryConfiguration_dbo.CatProcesses_IdProcess] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.HistoryConfiguration_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[HistoryConfiguration]'))
ALTER TABLE [dbo].[HistoryConfiguration] CHECK CONSTRAINT [FK_dbo.HistoryConfiguration_dbo.CatProcesses_IdProcess]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.WebAplicationDetails_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[WebAplicationDetails]'))
ALTER TABLE [dbo].[WebAplicationDetails]  WITH CHECK ADD  CONSTRAINT [FK_dbo.WebAplicationDetails_dbo.CatProcesses_IdProcess] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
ON DELETE CASCADE
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.WebAplicationDetails_dbo.CatProcesses_IdProcess]') AND parent_object_id = OBJECT_ID(N'[dbo].[WebAplicationDetails]'))
ALTER TABLE [dbo].[WebAplicationDetails] CHECK CONSTRAINT [FK_dbo.WebAplicationDetails_dbo.CatProcesses_IdProcess]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.WebAplicationDetails_dbo.CatWebAplications_IdWebAplication]') AND parent_object_id = OBJECT_ID(N'[dbo].[WebAplicationDetails]'))
ALTER TABLE [dbo].[WebAplicationDetails]  WITH CHECK ADD  CONSTRAINT [FK_dbo.WebAplicationDetails_dbo.CatWebAplications_IdWebAplication] FOREIGN KEY([IdWebAplication])
REFERENCES [dbo].[CatWebAplications] ([IdWebAplication])
ON DELETE CASCADE
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_dbo.WebAplicationDetails_dbo.CatWebAplications_IdWebAplication]') AND parent_object_id = OBJECT_ID(N'[dbo].[WebAplicationDetails]'))
ALTER TABLE [dbo].[WebAplicationDetails] CHECK CONSTRAINT [FK_dbo.WebAplicationDetails_dbo.CatWebAplications_IdWebAplication]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Document].[FK_ConfiguracionGeneralDocumentos_CatProcesses]') AND parent_object_id = OBJECT_ID(N'[Document].[ConfiguracionGeneralDocumentos]'))
ALTER TABLE [Document].[ConfiguracionGeneralDocumentos]  WITH CHECK ADD  CONSTRAINT [FK_ConfiguracionGeneralDocumentos_CatProcesses] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Document].[FK_ConfiguracionGeneralDocumentos_CatProcesses]') AND parent_object_id = OBJECT_ID(N'[Document].[ConfiguracionGeneralDocumentos]'))
ALTER TABLE [Document].[ConfiguracionGeneralDocumentos] CHECK CONSTRAINT [FK_ConfiguracionGeneralDocumentos_CatProcesses]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Document].[FK_DocumentosProceso_ConfiguracionGeneralDocumentos]') AND parent_object_id = OBJECT_ID(N'[Document].[DocumentosProceso]'))
ALTER TABLE [Document].[DocumentosProceso]  WITH CHECK ADD  CONSTRAINT [FK_DocumentosProceso_ConfiguracionGeneralDocumentos] FOREIGN KEY([IdProcess])
REFERENCES [Document].[ConfiguracionGeneralDocumentos] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Document].[FK_DocumentosProceso_ConfiguracionGeneralDocumentos]') AND parent_object_id = OBJECT_ID(N'[Document].[DocumentosProceso]'))
ALTER TABLE [Document].[DocumentosProceso] CHECK CONSTRAINT [FK_DocumentosProceso_ConfiguracionGeneralDocumentos]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Theme].[FK_ThemeProcess_CatProcesses]') AND parent_object_id = OBJECT_ID(N'[Theme].[ThemeProcess]'))
ALTER TABLE [Theme].[ThemeProcess]  WITH CHECK ADD  CONSTRAINT [FK_ThemeProcess_CatProcesses] FOREIGN KEY([IdProcess])
REFERENCES [dbo].[CatProcesses] ([IdProcess])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Theme].[FK_ThemeProcess_CatProcesses]') AND parent_object_id = OBJECT_ID(N'[Theme].[ThemeProcess]'))
ALTER TABLE [Theme].[ThemeProcess] CHECK CONSTRAINT [FK_ThemeProcess_CatProcesses]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Theme].[FK_ThemeProcess_Themes]') AND parent_object_id = OBJECT_ID(N'[Theme].[ThemeProcess]'))
ALTER TABLE [Theme].[ThemeProcess]  WITH CHECK ADD  CONSTRAINT [FK_ThemeProcess_Themes] FOREIGN KEY([IdTheme])
REFERENCES [Theme].[Themes] ([IdTheme])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Theme].[FK_ThemeProcess_Themes]') AND parent_object_id = OBJECT_ID(N'[Theme].[ThemeProcess]'))
ALTER TABLE [Theme].[ThemeProcess] CHECK CONSTRAINT [FK_ThemeProcess_Themes]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_ControlInForm_Controls]') AND parent_object_id = OBJECT_ID(N'[View].[ControlInForm]'))
ALTER TABLE [View].[ControlInForm]  WITH CHECK ADD  CONSTRAINT [FK_ControlInForm_Controls] FOREIGN KEY([IdControl])
REFERENCES [Controls].[Controls] ([Id])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_ControlInForm_Controls]') AND parent_object_id = OBJECT_ID(N'[View].[ControlInForm]'))
ALTER TABLE [View].[ControlInForm] CHECK CONSTRAINT [FK_ControlInForm_Controls]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_ControlInForm_FormInView]') AND parent_object_id = OBJECT_ID(N'[View].[ControlInForm]'))
ALTER TABLE [View].[ControlInForm]  WITH CHECK ADD  CONSTRAINT [FK_ControlInForm_FormInView] FOREIGN KEY([IdComplementView], [IdFormulario], [IdFiltro])
REFERENCES [View].[FormInView] ([IdComplementView], [IdFormulario], [IdFiltro])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_ControlInForm_FormInView]') AND parent_object_id = OBJECT_ID(N'[View].[ControlInForm]'))
ALTER TABLE [View].[ControlInForm] CHECK CONSTRAINT [FK_ControlInForm_FormInView]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_FormInView_ComplementView]') AND parent_object_id = OBJECT_ID(N'[View].[FormInView]'))
ALTER TABLE [View].[FormInView]  WITH CHECK ADD  CONSTRAINT [FK_FormInView_ComplementView] FOREIGN KEY([IdComplementView])
REFERENCES [View].[ComplementView] ([IdComplementView])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_FormInView_ComplementView]') AND parent_object_id = OBJECT_ID(N'[View].[FormInView]'))
ALTER TABLE [View].[FormInView] CHECK CONSTRAINT [FK_FormInView_ComplementView]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_FormInView_Filter]') AND parent_object_id = OBJECT_ID(N'[View].[FormInView]'))
ALTER TABLE [View].[FormInView]  WITH CHECK ADD  CONSTRAINT [FK_FormInView_Filter] FOREIGN KEY([IdFiltro])
REFERENCES [Controls].[Filter] ([IdFiltro])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_FormInView_Filter]') AND parent_object_id = OBJECT_ID(N'[View].[FormInView]'))
ALTER TABLE [View].[FormInView] CHECK CONSTRAINT [FK_FormInView_Filter]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_FormInView_Form]') AND parent_object_id = OBJECT_ID(N'[View].[FormInView]'))
ALTER TABLE [View].[FormInView]  WITH CHECK ADD  CONSTRAINT [FK_FormInView_Form] FOREIGN KEY([IdFormulario])
REFERENCES [Controls].[Form] ([IdFormulario])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[View].[FK_FormInView_Form]') AND parent_object_id = OBJECT_ID(N'[View].[FormInView]'))
ALTER TABLE [View].[FormInView] CHECK CONSTRAINT [FK_FormInView_Form]
GO