/**Begin D:\idea_workspace\pdm\PDM1\HRCS_constraint.sql **/
 EXEC p_AlterPK 'PK_HRCS_ACTSCHEMEREF', 'T_HRCS_ACTSCHEMEREF', 'FPKID', '1';
EXEC p_DropIdx 'IDX_BLANK', 'T_HRCS_ACTSCHEMEREF';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_ACTSCHEMEREF_BLANK') CREATE INDEX IDX_HRCS_ACTSCHEMEREF_BLANK ON T_HRCS_ACTSCHEMEREF ( FID ,FBASEDATAID );

 EXEC P_ALTERPK 'PK_T_HRCS_ACTIVITYNODECONF', 'T_HRCS_ACTIVITYNODECONF', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_ACTIVITYNODECONF_NUM') CREATE INDEX IDX_HRCS_ACTIVITYNODECONF_NUM ON T_HRCS_ACTIVITYNODECONF ( FNODENUMBER );



/**End D:\idea_workspace\pdm\PDM1\HRCS_constraint.sql **/
