ALTER TABLE PLATRANS ADD PLA_MVZ MONEY DEFAULT(0),PLA_VHR MONEY DEFAULT(0)
GO
ALTER TABLE CUMPLIDOS ADD CUM_VTC MONEY DEFAULT(0),CUM_VTD MONEY DEFAULT(0),CUM_VSC MONEY DEFAULT(0),CUM_VSD MONEY DEFAULT(0),CUM_TSD DECIMAL(14,4) DEFAULT(0)
GO
CREATE TABLE CUM_TIEMPOS ( 
HOR_TIP VARCHAR(3) DEFAULT ('CUM') NOT NULL,
HOR_NUM INT DEFAULT ((0)) NOT NULL,
HOR_CIA CHAR(2) NOT NULL,
HOR_ITM INT DEFAULT ((0)) NOT NULL,
HOR_PTO INT DEFAULT ((0)) NOT NULL,
HOR_TCD CHAR(1) NOT NULL,
HOR_PCA DECIMAL(14,4) DEFAULT ((0)) NOT NULL,
HOR_PDE DECIMAL(14,4) DEFAULT ((0)) NOT NULL,
HOR_FLC SMALLDATETIME,
HOR_FSC SMALLDATETIME,
HOR_FLD SMALLDATETIME,
HOR_FSD SMALLDATETIME,
HOR_CHC DECIMAL(14,4) DEFAULT ((0)) NOT NULL,
HOR_CHD DECIMAL(14,4) DEFAULT ((0)) NOT NULL,
HOR_CAC DECIMAL(14,4) DEFAULT ((0)) NOT NULL,
HOR_CAD DECIMAL(14,4) DEFAULT ((0)) NOT NULL,
HOR_CSC DECIMAL(14,4) DEFAULT ((0)) NOT NULL,
HOR_CSD DECIMAL(14,4) DEFAULT ((0)) NOT NULL,
HOR_REM INT DEFAULT ((0)) NOT NULL,
HOR_CRM CHAR(2)
 CONSTRAINT PK_CUM_TIEMPOS PRIMARY KEY CLUSTERED (HOR_TIP,HOR_NUM,HOR_CIA,HOR_ITM),
 CONSTRAINT CK_CUM_TIEMPOSHOR_CIA CHECK ((len([HOR_CIA])>(0))),
 CONSTRAINT CK_CUM_TIEMPOSHOR_TCD CHECK (([HOR_TCD]='D' OR [HOR_TCD]='C')),
 CONSTRAINT CK_CUM_TIEMPOSHOR_TIP CHECK ((len([HOR_TIP])>(0))))
GO
--mayo 14
ALTER TABLE REMCON ADD RCO_IM1 INT DEFAULT(0),RCO_IM2 INT DEFAULT(0)
GO