/**Begin D:\softwaresetup\PDM_UPGRADE\PDM1\kd_1.5.82_2_fpm_constraint.sql **/

 EXEC P_ALTERPK 'PK_T_FPM_TEMPLATE_CURRENCY', 'T_FPM_TEMPLATE_CURRENCY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_FPM_TEMPLATE_L', 'T_FPM_TEMPLATE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_FPM_TEMPLATE_DIMSET', 'T_FPM_TEMPLATE_DIMSET', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_T_FPM_TEMPLATE_SUBJECT', 'T_FPM_TEMPLATE_SUBJECT', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_T_FPM_TEMPLATE_USEORG', 'T_FPM_TEMPLATE_USEORG', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_T_FPM_TEMPLATE_EXPAND', 'T_FPM_TEMPLATE_EXPAND', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_FPM_TEMPLATE_MEMBER', 'T_FPM_TEMPLATE_MEMBER', 'FPKID', '1';

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



/**End D:\softwaresetup\PDM_UPGRADE\PDM1\kd_1.5.82_2_fpm_constraint.sql **/
