/**Begin D:\PDM_UPGRADE\PDM1\LIC_constraint.sql **/
 EXEC P_ALTERPK 'PK_HRCS_LICDECRDETAIL', 'T_HRCS_LICDECRDETAIL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_LICDECRDETAIL_NUM') CREATE INDEX IDX_HRCS_LICDECRDETAIL_NUM ON T_HRCS_LICDECRDETAIL ( FORGNIZEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_LICDECRDETAIL_NAME') CREATE INDEX IDX_HRCS_LICDECRDETAIL_NAME ON T_HRCS_LICDECRDETAIL ( FCOMNAME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_LICDECRDETAIL_CNUM') CREATE INDEX IDX_HRCS_LICDECRDETAIL_CNUM ON T_HRCS_LICDECRDETAIL ( FCONTRACTNUM );


 EXEC P_ALTERPK 'PK_HRCS_LICGRPDETAIL', 'T_HRCS_LICGRPDETAIL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_LICGRPDETAIL_NUM') CREATE INDEX IDX_HRCS_LICGRPDETAIL_NUM ON T_HRCS_LICGRPDETAIL ( FCOMID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_LICGRPDETAIL_NAME') CREATE INDEX IDX_HRCS_LICGRPDETAIL_NAME ON T_HRCS_LICGRPDETAIL ( FCOMNAME );



/**End D:\PDM_UPGRADE\PDM1\LIC_constraint.sql **/
