ALTER TABLE Mercancias ADD EstadoMcia VARCHAR(20) DEFAULT('SOLIDO') NOT NULL
,IdEmp VARCHAR(4) DEFAULT('0') NOT NULL
GO
ALTER TABLE tm_OccComp ADD tmDescProd VARCHAR(50)
,tmComp2 INT DEFAULT(0),tmIdProd2 VARCHAR(16),tmDescProd2 VARCHAR(50),tmCantidad2 DECIMAL(14,4) DEFAULT(0)
,tmComp3 INT DEFAULT(0),tmIdProd3 VARCHAR(16),tmDescProd3 VARCHAR(50),tmCantidad3 DECIMAL(14,4) DEFAULT(0)
,tmComp4 INT DEFAULT(0),tmIdProd4 VARCHAR(16),tmDescProd4 VARCHAR(50),tmCantidad4 DECIMAL(14,4) DEFAULT(0)
,tmComp5 INT DEFAULT(0),tmIdProd5 VARCHAR(16),tmDescProd5 VARCHAR(50),tmCantidad5 DECIMAL(14,4) DEFAULT(0)
GO
--ALTER TABLE tm_IntAhorro ADD tmVrAbono MONEY DEFAULT(0) NOT NULL
--GO
CREATE TABLE TercClieCond ( 
IdClie VARCHAR(16) NOT NULL,
Item INT DEFAULT (0) NOT NULL,
DescripCond VARCHAR(3000) NOT NULL
 CONSTRAINT PK_TercClieCond PRIMARY KEY CLUSTERED (IdClie,Item),
 CONSTRAINT CK_TercClieCondIdClie CHECK ((len([IdClie]) > 0)))
GO
ALTER TABLE TercClieCond ADD 
 CONSTRAINT FK_TercClieCond_Terceros FOREIGN KEY (IdClie) REFERENCES [dbo].[Terceros] (IdTercero)
GO

