/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCTB_constraint.sql **/


 EXEC P_ALTERPK 'PK_TCTB_LIC_REQ', 'T_TCTB_LIC_REQ', 'FID', '1';
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCTB_LIC_REQ' AND KSQL_INDNAME = 'IDX_TCTB_LICREQ_NO') CREATE INDEX IDX_TCTB_LICREQ_NO ON T_TCTB_LIC_REQ ( FBILLNO );


 EXEC P_ALTERPK 'PK_TCTB_LIC_REQ_ENTRY', 'T_TCTB_LIC_REQ_ENTRY', 'FENTRYID', '1';
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCTB_LIC_REQ_ENTRY' AND KSQL_INDNAME = 'IDX_TCTB_LIC_REQ_ENTRY_FK') CREATE INDEX IDX_TCTB_LIC_REQ_ENTRY_FK ON T_TCTB_LIC_REQ_ENTRY ( FID );


/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCTB_constraint.sql **/
