SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LogImagenes](
	[TipoReg] [varchar](10) NOT NULL,
	[IdRegistro] [varchar](16) NOT NULL,
	[ImagenBin] [image] NOT NULL,
	[NomArchivo] [varchar](50) NULL,
	[DescRegistro] [varchar](100) NULL,
 CONSTRAINT [PK_LogImagenes] PRIMARY KEY CLUSTERED 
(
	[TipoReg] ASC,
	[IdRegistro] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LogEgrBancos](
	[TipEgr] [varchar](3) NOT NULL,
	[NumEgreso] [int] NOT NULL DEFAULT ((0)),
	[IdCia] [char](2) NOT NULL,
	[Estado] [int] NOT NULL DEFAULT ((0)),
	[NomArchivo] [varchar](100) NULL,
	[TimeSys] [smalldatetime] NOT NULL,
	[IdUsuario] [varchar](11) NOT NULL,
	[Nombre] [varchar](50) NOT NULL,
 CONSTRAINT [PK_LogEgrBancos] PRIMARY KEY CLUSTERED 
(
	[TipEgr] ASC,
	[NumEgreso] ASC,
	[IdCia] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[LogEgrBancos]  WITH CHECK ADD  CONSTRAINT [CK_LogEgrBancosIdCia] CHECK  ((len([IdCia])>(0)))
GO
ALTER TABLE [dbo].[LogEgrBancos]  WITH CHECK ADD  CONSTRAINT [CK_LogEgrBancosIdUsuario] CHECK  ((len([IdUsuario])>(0)))
GO
ALTER TABLE [dbo].[LogEgrBancos]  WITH CHECK ADD  CONSTRAINT [CK_LogEgrBancosNombre] CHECK  ((len([Nombre])>(0)))
GO
ALTER TABLE [dbo].[LogEgrBancos]  WITH CHECK ADD  CONSTRAINT [CK_LogEgrBancosTipEgr] CHECK  ((len([TipEgr])>(0)))