/****** Object:  Table [dbo].[LogTraEspPro]    Script Date: 29/12/2017 15:06:47 ******/
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].[LogTraEspPro]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[LogTraEspPro](
	[IdLog] [int] NOT NULL DEFAULT ((0)),
	[IdPro] [varchar](20) NOT NULL,
	[IdCia] [char](2) NOT NULL DEFAULT ('01'),
	[Fecha] [smalldatetime] NOT NULL,
	[TimeSys] [smalldatetime] NOT NULL,
	[IdUsuario] [varchar](11) NOT NULL,
	[Nombre] [varchar](50) NOT NULL,
	[NomTabla] [varchar](20) NOT NULL,
	[Observacion] [varchar](250) NOT NULL,
	[nModulo] [varchar](20) NOT NULL,
	[Dsname] [varchar](20) NULL,
 CONSTRAINT [PK_LogTraEspPro] PRIMARY KEY CLUSTERED 
(
	[IdLog] ASC,
	[IdPro] ASC,
	[IdCia] 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].[LogTraEspPrograma]    Script Date: 29/12/2017 15:06:47 ******/
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].[LogTraEspPrograma]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[LogTraEspPrograma](
	[Numero] [int] NOT NULL DEFAULT ((0)),
	[Fecha] [smalldatetime] NOT NULL,
	[EstadoProc] [int] NOT NULL DEFAULT ((0)),
	[Observacion] [varchar](250) NULL,
	[TimeSys] [smalldatetime] NOT NULL,
	[IdUsuario] [varchar](11) NOT NULL,
	[Nombre] [varchar](50) NOT NULL,
 CONSTRAINT [PK_LogTraEspPrograma] PRIMARY KEY CLUSTERED 
(
	[Numero] 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].[LogTraEspProgramaDet]    Script Date: 29/12/2017 15:06:47 ******/
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].[LogTraEspProgramaDet]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[LogTraEspProgramaDet](
	[Numero] [int] NOT NULL,
	[Item] [int] NOT NULL,
	[TipDoc] [varchar](3) NOT NULL,
	[Programa] [int] NOT NULL,
	[IdCia] [char](2) NOT NULL,
	[FechaIni] [smalldatetime] NOT NULL,
	[FechaFin] [smalldatetime] NOT NULL,
	[IdVehiculo] [varchar](10) NOT NULL DEFAULT ((0)),
	[Reservas] [int] NOT NULL,
	[IdCiaRes] [char](2) NOT NULL,
	[ItemRes] [int] NOT NULL,
	[Comentarios] [varchar](max) NULL,
 CONSTRAINT [PK_LogTraEspProgramaDet] PRIMARY KEY CLUSTERED 
(
	[Numero] ASC,
	[Item] 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
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_LogTraEspProgramaDet_LogTraEspPrograma]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspProgramaDet]'))
ALTER TABLE [dbo].[LogTraEspProgramaDet]  WITH CHECK ADD  CONSTRAINT [FK_LogTraEspProgramaDet_LogTraEspPrograma] FOREIGN KEY([Numero])
REFERENCES [dbo].[LogTraEspPrograma] ([Numero])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_LogTraEspProgramaDet_LogTraEspPrograma]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspProgramaDet]'))
ALTER TABLE [dbo].[LogTraEspProgramaDet] CHECK CONSTRAINT [FK_LogTraEspProgramaDet_LogTraEspPrograma]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProIdCia]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProIdCia] CHECK  ((len([IdCia])>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProIdCia]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro] CHECK CONSTRAINT [CK_LogTraEspProIdCia]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProIdPro]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProIdPro] CHECK  ((len([IdPro])>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProIdPro]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro] CHECK CONSTRAINT [CK_LogTraEspProIdPro]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProIdUsuario]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProIdUsuario] CHECK  ((len([IdUsuario])>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProIdUsuario]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro] CHECK CONSTRAINT [CK_LogTraEspProIdUsuario]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspPronModulo]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspPronModulo] CHECK  ((len([nModulo])>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspPronModulo]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro] CHECK CONSTRAINT [CK_LogTraEspPronModulo]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProNombre]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProNombre] CHECK  ((len([Nombre])>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProNombre]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro] CHECK CONSTRAINT [CK_LogTraEspProNombre]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProNomTabla]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProNomTabla] CHECK  ((len([NomTabla])>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProNomTabla]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro] CHECK CONSTRAINT [CK_LogTraEspProNomTabla]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProObservacion]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProObservacion] CHECK  ((len([Observacion])>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProObservacion]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPro]'))
ALTER TABLE [dbo].[LogTraEspPro] CHECK CONSTRAINT [CK_LogTraEspProObservacion]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaIdUsuario]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPrograma]'))
ALTER TABLE [dbo].[LogTraEspPrograma]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProgramaIdUsuario] CHECK  ((len([IdUsuario])>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaIdUsuario]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPrograma]'))
ALTER TABLE [dbo].[LogTraEspPrograma] CHECK CONSTRAINT [CK_LogTraEspProgramaIdUsuario]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaNombre]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPrograma]'))
ALTER TABLE [dbo].[LogTraEspPrograma]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProgramaNombre] CHECK  ((len([Nombre])>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaNombre]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspPrograma]'))
ALTER TABLE [dbo].[LogTraEspPrograma] CHECK CONSTRAINT [CK_LogTraEspProgramaNombre]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaDetIdCiaRes]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspProgramaDet]'))
ALTER TABLE [dbo].[LogTraEspProgramaDet]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProgramaDetIdCiaRes] CHECK  ((len([IdCiaRes])>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaDetIdCiaRes]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspProgramaDet]'))
ALTER TABLE [dbo].[LogTraEspProgramaDet] CHECK CONSTRAINT [CK_LogTraEspProgramaDetIdCiaRes]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaDetItemRes]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspProgramaDet]'))
ALTER TABLE [dbo].[LogTraEspProgramaDet]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProgramaDetItemRes] CHECK  (([ItemRes]>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaDetItemRes]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspProgramaDet]'))
ALTER TABLE [dbo].[LogTraEspProgramaDet] CHECK CONSTRAINT [CK_LogTraEspProgramaDetItemRes]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaDetPrograma]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspProgramaDet]'))
ALTER TABLE [dbo].[LogTraEspProgramaDet]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProgramaDetPrograma] CHECK  (([Programa]>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaDetPrograma]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspProgramaDet]'))
ALTER TABLE [dbo].[LogTraEspProgramaDet] CHECK CONSTRAINT [CK_LogTraEspProgramaDetPrograma]
GO
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaDetReservas]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspProgramaDet]'))
ALTER TABLE [dbo].[LogTraEspProgramaDet]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspProgramaDetReservas] CHECK  (([Reservas]>(0)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_LogTraEspProgramaDetReservas]') AND parent_object_id = OBJECT_ID(N'[dbo].[LogTraEspProgramaDet]'))
ALTER TABLE [dbo].[LogTraEspProgramaDet] CHECK CONSTRAINT [CK_LogTraEspProgramaDetReservas]
GO