/****** Object:  Table [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO]    Script Date: 05/05/2013 23:06:12 ******/
IF NOT  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO]') AND type in (N'U'))
begin
		CREATE TABLE [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO](
			[CD_CTR_ERROS] [int] IDENTITY(1,1) NOT NULL,
			[CD_CTR] [int] NOT NULL,
			[DT_CAD] [datetime] NOT NULL,
			[ERROS_VALIDACAO] [xml] NOT NULL,
			[STS_ERRO] [int] NOT NULL,
			[CD_USU] [int] NOT NULL,
			[DT_CAD_CORRECAO] [datetime] NOT NULL,
			[DANFE] [int] NULL,
		 CONSTRAINT [PK_EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO] PRIMARY KEY CLUSTERED 
		(
			[CD_CTR_ERROS] ASC
		)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
		) ON [PRIMARY]


	ALTER TABLE [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO]  WITH CHECK ADD  CONSTRAINT [FK_EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO_EST_NF_ENT_DANFE_PROVISORIO] FOREIGN KEY([CD_CTR])
	REFERENCES [dbo].[EST_NF_ENT_DANFE_PROVISORIO] ([CD_CTR])
	ON UPDATE CASCADE
	ON DELETE CASCADE

	ALTER TABLE [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO] CHECK CONSTRAINT [FK_EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO_EST_NF_ENT_DANFE_PROVISORIO]

	ALTER TABLE [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO] ADD  CONSTRAINT [DF_EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO_CD_CTR]  DEFAULT ((0)) FOR [CD_CTR]

	ALTER TABLE [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO] ADD  CONSTRAINT [DF_EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO_DT_CAD]  DEFAULT (getdate()) FOR [DT_CAD]

	ALTER TABLE [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO] ADD  CONSTRAINT [DF_EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO_STS_ERRO]  DEFAULT ((0)) FOR [STS_ERRO]

	ALTER TABLE [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO] ADD  CONSTRAINT [DF_EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO_CD_USU]  DEFAULT ((0)) FOR [CD_USU]

	ALTER TABLE [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO] ADD  CONSTRAINT [DF_EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO_DT_CAD_CORRECAO]  DEFAULT (getdate()) FOR [DT_CAD_CORRECAO]

	ALTER TABLE [dbo].[EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO] ADD  CONSTRAINT [EST_NF_ENT_DANFE_PROVISORIO_ERROS_VALIDACAO_DANFE]  DEFAULT ((0)) FOR [DANFE]
end

