ALTER TABLE PUC ADD PUC_NIF VARCHAR(16)
GO
ALTER TABLE TIPOSCOMP ADD TIP_CLA VARCHAR(10)
GO
ALTER TABLE CONCEPTOS ADD CON_NIF VARCHAR(10),CON_TCN VARCHAR(3),CON_TCF VARCHAR(3)
GO
CREATE TABLE PUCNIIF ( 
PUC_COD VARCHAR(16) NOT NULL,
PUC_DES VARCHAR(250) NOT NULL,
PUC_CLV VARCHAR(16) NOT NULL,
PUC_FEC SMALLDATETIME NOT NULL,
PUC_MAY BIT DEFAULT ((0)) NOT NULL,
PUC_MOV BIT DEFAULT ((0)) NOT NULL,
PUC_BAN BIT DEFAULT ((0)) NOT NULL,
PUC_NIT BIT DEFAULT ((0)) NOT NULL,
PUC_BAS BIT DEFAULT ((0)) NOT NULL,
PUC_VEN BIT DEFAULT ((0)) NOT NULL,
PUC_NAT CHAR(1) DEFAULT ('D') NOT NULL,
PUC_AJU BIT DEFAULT ((0)) NOT NULL,
PUC_AJD VARCHAR(16) DEFAULT ('0'),
PUC_AJC VARCHAR(16) DEFAULT ('0'),
PUC_CC BIT DEFAULT ((0)) NOT NULL,
PUC_TAR DECIMAL(14,4) DEFAULT ((0))
 CONSTRAINT PK_PUCNIIF PRIMARY KEY CLUSTERED (PUC_COD),
 CONSTRAINT CK_PUCNIIFPUC_CLV CHECK ((len([PUC_CLV])>(0))),
 CONSTRAINT CK_PUCNIIFPUC_COD CHECK ((len([PUC_COD])>(0))),
 CONSTRAINT CK_PUCNIIFPUC_DES CHECK ((len([PUC_DES])>(0))),
 CONSTRAINT CK_PUCNIIFPUC_NAT CHECK ((len([PUC_NAT])>(0))))
GO