CR_Atesa_Software/TFS_ANTIGUO
4
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
TFS_ANTIGUO/PrendarioDavivienda/ESTRUCTURA_BD/ESTRUCTURA_Ultimus.ComponentManager.txt

3102 lines
400 KiB
Text
Raw Permalink Blame History

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
Reference in a new issue View git blame Copy permalink