ALTER TABLE Emp_Contrato DROP CONSTRAINT CK_Emp_ContratoBasePrest
GO
ALTER TABLE Emp_Contrato DROP CONSTRAINT CK_Emp_ContratoBaseSeg
GO
ALTER TABLE Emp_Contrato ADD CONSTRAINT CK_Emp_ContratoBasePrest CHECK (([BasePrest] = 'BA' or ([BasePrest] = 'SM' or ([BasePrest] = 'SB' or ([BasePrest] = 'IB' or [BasePrest] = 'PM')))))
GO
ALTER TABLE Emp_Contrato ADD CONSTRAINT CK_Emp_ContratoBaseSeg CHECK (([BaseSeg] = 'BA' or ([BaseSeg] = 'SM' or ([BaseSeg] = 'SB' or ([BaseSeg] = 'IB' or [BaseSeg] = 'PM')))))
GO
ALTER TABLE Emp_Contrato ADD DsoSabado BIT DEFAULT(0) NOT NULL
GO
CREATE TABLE Emp_Centros ( 
NContrato INT DEFAULT (0) NOT NULL,
IdCCosto VARCHAR(16) NOT NULL,
Tarifa DECIMAL(14,4) DEFAULT (0) NOT NULL
 CONSTRAINT PK_Emp_Centros PRIMARY KEY CLUSTERED (NContrato,IdCCosto),
 CONSTRAINT CK_Emp_CentrosIdCCosto CHECK ((len([IdCCosto]) > 0)))
GO