/**Begin D:\PDM_UPGRADE\PDM1\HBSS_constraint.sql **/
 EXEC P_ALTERPK 'PK_HBSS_PERFORMANCECYCLE', 'T_HBSS_PERFORMANCECYCLE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_PERFORMANCECYCLE_N') CREATE INDEX IDX_HBSS_PERFORMANCECYCLE_N ON T_HBSS_PERFORMANCECYCLE ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_PCYCLETYPE_L', 'T_HBSS_PCYCLETYPE_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_PCYCLETYPE_L') CREATE INDEX IDX_HBSS_PCYCLETYPE_L ON T_HBSS_PCYCLETYPE_L ( FID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_HBSS_PCYCLETYPE', 'T_HBSS_PCYCLETYPE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_PCYCLETYPE_NUM') CREATE INDEX IDX_HBSS_PCYCLETYPE_NUM ON T_HBSS_PCYCLETYPE ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_PASSESSNODE_L', 'T_HBSS_PASSESSNODE_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_PASSESSNODE_L') CREATE INDEX IDX_HBSS_PASSESSNODE_L ON T_HBSS_PASSESSNODE_L ( FID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_HBSS_PASSESSNODE', 'T_HBSS_PASSESSNODE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_PASSESSNODE_NUM') CREATE INDEX IDX_HBSS_PASSESSNODE_NUM ON T_HBSS_PASSESSNODE ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_PERFORMANCECYCLE_L', 'T_HBSS_PERFORMANCECYCLE_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_PERFORMANCECYCLE_L') CREATE INDEX IDX_HBSS_PERFORMANCECYCLE_L ON T_HBSS_PERFORMANCECYCLE_L ( FID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_HBSS_PCECYCLEENTRY', 'T_HBSS_PCECYCLEENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_PCECYCLEENTRY_FID') CREATE INDEX IDX_HBSS_PCECYCLEENTRY_FID ON T_HBSS_PCECYCLEENTRY ( FID );



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