
IF	OBJECT_ID('PDV_MAPA_RESUMO_AUDIT_EXCLUSAO') IS NULL
BEGIN

	CREATE TABLE PDV_MAPA_RESUMO_AUDIT_EXCLUSAO
		(CD_EMP INT NOT NULL,
		CD_CTR INT IDENTITY (1,1) NOT NULL,
		CD_FILIAL INT NOT NULL,
		DT_MOV DATETIME NOT NULL,
		DT_CAD DATETIME NOT NULL,
		STS_MOV INT NOT NULL
		)  ON [PRIMARY]

	ALTER TABLE PDV_MAPA_RESUMO_AUDIT_EXCLUSAO ADD CONSTRAINT
		PK_PDV_MAPA_RESUMO_AUDIT_EXCLUSAO PRIMARY KEY CLUSTERED 
		(CD_EMP ASC,
		CD_CTR ASC,
		CD_FILIAL ASC,
		DT_MOV ASC
		) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

END


