IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PDV_FECHA_MOV_AUDIT]') AND type in (N'U'))
begin
	DROP TABLE PDV_FECHA_MOV_AUDIT
end
	CREATE TABLE [dbo].[PDV_FECHA_MOV_AUDIT](
		[CD_CTR] [int] IDENTITY(1,1) NOT NULL,
		[CD_EMP] [int] NOT NULL,
		[CD_FILIAL] [int] NOT NULL,
		[DT_MOV] [datetime] NULL,
		[DT_CAD_AUDIT] [datetime] NULL,
		[CD_USU] [int] NOT NULL,
		[OBS] [varchar](100) NULL,
	 CONSTRAINT [PK_PDV_FECHA_MOV_AUDIT] PRIMARY KEY CLUSTERED 
	(
		[CD_CTR] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
	) ON [PRIMARY]

	GO

	SET ANSI_PADDING OFF
	GO

	ALTER TABLE [dbo].[PDV_FECHA_MOV_AUDIT] ADD  CONSTRAINT [DF_PDV_FECHA_MOV_AUDIT_CD_EMP]  DEFAULT ((0)) FOR [CD_EMP]
	GO

	ALTER TABLE [dbo].[PDV_FECHA_MOV_AUDIT] ADD  CONSTRAINT [DF_PDV_FECHA_MOV_AUDIT_CD_FILIAL]  DEFAULT ((0)) FOR [CD_FILIAL]
	GO

	ALTER TABLE [dbo].[PDV_FECHA_MOV_AUDIT] ADD  CONSTRAINT [DF_PDV_FECHA_MOV_AUDIT_CD_USU]  DEFAULT ((0)) FOR [CD_USU]
	GO

	ALTER TABLE [dbo].[PDV_FECHA_MOV_AUDIT] ADD  CONSTRAINT [DF_PDV_FECHA_MOV_AUDIT_OBS]  DEFAULT ('') FOR [OBS]
	GO
