/**Begin C:\PDM_UPGRADE\PDM1\PUR_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_BD_QUALIFICATION_CLASS', 'T_BD_QUALIFICATION_CLASS', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_T_BD_COMPANY_TYPE', 'T_BD_COMPANY_TYPE', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_T_BD_QUALIFICATION_CFG', 'T_BD_QUALIFICATION_CFG', 'FID', '1';

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



 EXEC P_ALTERPK 'PK_T_BD_QUALIFICATION_TYPE', 'T_BD_QUALIFICATION_TYPE', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_T_BD_QUALIFICATION_TYPE_L', 'T_BD_QUALIFICATION_TYPE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_BD_QUALIFICATION_CFG_L', 'T_BD_QUALIFICATION_CFG_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_BD_COMPANY_TYPE_L', 'T_BD_COMPANY_TYPE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_BD_QUALIFICATION_CLASS_L', 'T_BD_QUALIFICATION_CLASS_L', 'FPKID', '1';

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



/**End C:\PDM_UPGRADE\PDM1\PUR_constraint.sql **/