ALTER TABLE dbo.SCOProveedor ADD
	UltimaEncuesta datetime NULL,
	CalificacionPromedio decimal(18, 2) NOT NULL CONSTRAINT DF_SCOProveedor_CalificacionPromedio DEFAULT 0
GO

ALTER TABLE dbo.SCOContrato ADD
	Encuesta bit NOT NULL CONSTRAINT DF_SCOContrato_Encuesta DEFAULT 0,
	UltimaEncuesta datetime NULL,
	CalificacionPromedio decimal(18, 2) NOT NULL CONSTRAINT DF_SCOContrato_CalificacionPromedio DEFAULT 0
GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SCOContratoCalificacion]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SCOContratoCalificacion]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SCOProveedorCalificacion]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SCOProveedorCalificacion]
GO

CREATE TABLE [dbo].[SCOContratoCalificacion] (
	[Cia] [varchar] (6)  NOT NULL ,
	[Oficina] [varchar] (6)  NOT NULL ,
	[Contrato] [varchar] (15)  NOT NULL ,
	[Folio] [int] NOT NULL ,
	[Proveedor] [varchar] (6)  NOT NULL ,
	[FechaEncuesta] [datetime] NOT NULL ,
	[Calificacion] [decimal](18, 2) NOT NULL ,
	[CapturoCambio] [varchar] (20)  NULL ,
	[UltimoCambio] [datetime] NULL ,
	[UltimoCambioHora] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SCOProveedorCalificacion] (
	[Oficina] [varchar] (6)  NOT NULL ,
	[Proveedor] [varchar] (6)  NOT NULL ,
	[Folio] [int] NOT NULL ,
	[FechaEncuesta] [datetime] NOT NULL ,
	[Calificacion] [decimal](18, 2) NOT NULL ,
	[CapturoCambio] [varchar] (20)  NULL ,
	[UltimoCambio] [datetime] NULL ,
	[UltimoCambioHora] [datetime] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SCOContratoCalificacion] WITH NOCHECK ADD 
	CONSTRAINT [PK_SCOContratoCalificacion] PRIMARY KEY  CLUSTERED 
	(
		[Cia],
		[Oficina],
		[Contrato],
		[Folio]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SCOProveedorCalificacion] WITH NOCHECK ADD 
	CONSTRAINT [PK_SCOProveedorCalificacion] PRIMARY KEY  CLUSTERED 
	(
		[Oficina],
		[Proveedor],
		[Folio]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SCOContratoCalificacion] ADD 
	CONSTRAINT [DF_SCOContratoCalificacion_Calificacion] DEFAULT (0) FOR [Calificacion]
GO

ALTER TABLE [dbo].[SCOProveedorCalificacion] ADD 
	CONSTRAINT [DF_SCOProveedorCalificacion_Calificacion] DEFAULT (0) FOR [Calificacion]
GO