GO
ALTER TABLE CLCRD DROP CONSTRAINT DF_CLCRD_CONTAB_ID  
GO
ALTER TABLE CLREC DROP CONSTRAINT DF_CLREC_CONTAB_ID  
GO
ALTER TABLE REQ_FUND_CAB DROP CONSTRAINT DF_REQ_FUND_CAB_CONTAB_ID  
GO
ALTER TABLE FRMOV DROP CONSTRAINT DF_FRMOV_CONTAB_ID  
GO
ALTER TABLE FRCRD DROP CONSTRAINT DF_FRCRD_CONTAB_ID  
GO
ALTER TABLE FRREC DROP CONSTRAINT DF_FRREC_CONTAB_ID  
GO
ALTER TABLE CLMOV DROP COLUMN CONTAB_ID
GO
ALTER TABLE FRMOV DROP COLUMN CONTAB_ID
GO
ALTER TABLE CLCRD DROP COLUMN CONTAB_ID
GO
ALTER TABLE CLREC DROP COLUMN CONTAB_ID
GO
ALTER TABLE FRCRD DROP COLUMN CONTAB_ID
GO
ALTER TABLE FRREC DROP COLUMN CONTAB_ID
GO
ALTER TABLE STCAB DROP COLUMN CONTAB_ID
GO
ALTER TABLE BCMOV DROP COLUMN CONTAB_ID
GO
ALTER TABLE IPCAB DROP COLUMN CONTAB_ID
GO
ALTER TABLE REQ_FUND_CAB DROP COLUMN CONTAB_ID
GO


ALTER TABLE FRREC ADD   CONTAB_ID uniqueidentifier NOT NULL CONSTRAINT DF_FRREC_CONTAB_ID DEFAULT NEWID()
ALTER TABLE STCAB ADD   CONTAB_ID uniqueidentifier NOT NULL CONSTRAINT DF_STCAB_CONTAB_ID DEFAULT NEWID()
ALTER TABLE IPCAB ADD   CONTAB_ID uniqueidentifier NOT NULL CONSTRAINT DF_IPCAB_CONTAB_ID DEFAULT NEWID()
ALTER TABLE FRCRD ADD   CONTAB_ID uniqueidentifier NOT NULL CONSTRAINT DF_FRCRD_CONTAB_ID DEFAULT NEWID()
ALTER TABLE CLMOV ADD   CONTAB_ID uniqueidentifier NOT NULL CONSTRAINT DF_CLMOV_CONTAB_ID DEFAULT NEWID()
ALTER TABLE REQ_FUND_CAB ADD   CONTAB_ID uniqueidentifier NOT NULL CONSTRAINT DF_REQ_FUND_CAB_CONTAB_ID DEFAULT NEWID()
ALTER TABLE CLCRD ADD   CONTAB_ID uniqueidentifier NOT NULL CONSTRAINT DF_CLCRD_CONTAB_ID DEFAULT NEWID()
ALTER TABLE BCMOV ADD   CONTAB_ID uniqueidentifier NOT NULL CONSTRAINT DF_BCMOV_CONTAB_ID DEFAULT NEWID()
ALTER TABLE FRMOV ADD   CONTAB_ID uniqueidentifier NOT NULL CONSTRAINT DF_FRMOV_CONTAB_ID DEFAULT NEWID()
ALTER TABLE CLREC ADD   CONTAB_ID uniqueidentifier NOT NULL CONSTRAINT DF_CLREC_CONTAB_ID DEFAULT NEWID()


CREATE NONCLUSTERED INDEX IX_STCAB_CONTAB_ID ON dbo.STCAB
	(
	CONTAB_ID
	) ON [PRIMARY]

CREATE NONCLUSTERED INDEX IX_FRREC_CONTAB_ID ON dbo.FRREC
	(
	CONTAB_ID
	) ON [PRIMARY]


CREATE NONCLUSTERED INDEX IX_IPCAB_CONTAB_ID ON dbo.IPCAB
	(
	CONTAB_ID
	) ON [PRIMARY]

CREATE NONCLUSTERED INDEX IX_FRCRD_CONTAB_ID ON dbo.FRCRD
	(
	CONTAB_ID
	) ON [PRIMARY]

CREATE NONCLUSTERED INDEX IX_CLMOV_CONTAB_ID ON dbo.CLMOV
	(
	CONTAB_ID
	) ON [PRIMARY]

CREATE NONCLUSTERED INDEX IX_REQ_FUND_CAB_CONTAB_ID ON dbo.REQ_FUND_CAB
	(
	CONTAB_ID
	) ON [PRIMARY]

CREATE NONCLUSTERED INDEX IX_CLCRD_CONTAB_ID ON dbo.CLCRD
	(
	CONTAB_ID
	) ON [PRIMARY]

CREATE NONCLUSTERED INDEX IX_BCMOV_CONTAB_ID ON dbo.BCMOV
	(
	CONTAB_ID
	) ON [PRIMARY]

CREATE NONCLUSTERED INDEX IX_FRMOV_CONTAB_ID ON dbo.FRMOV
	(
	CONTAB_ID
	) ON [PRIMARY]

CREATE NONCLUSTERED INDEX IX_CLREC_CONTAB_ID ON dbo.CLREC
	(
	CONTAB_ID
	) ON [PRIMARY]