/**Begin C:\PDM_UPGRADE\PDM1\SRC_constraint.sql **/
 EXEC P_ALTERPK 'PK_SRC_TENDENCY', 'T_SRC_TENDENCY', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_TENDENCY_PID') CREATE INDEX IDX_SRC_TENDENCY_PID ON T_SRC_TENDENCY ( FPROJECTID );


 EXEC P_ALTERPK 'PK_SRC_DECISIONLIST', 'T_SRC_DECISIONLIST', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONLIST_EKEY') CREATE INDEX IDX_SRC_DECISIONLIST_EKEY ON T_SRC_DECISIONLIST ( FENTITYKEY );


 EXEC P_ALTERPK 'PK_SRC_DECISIONLISTENTRY', 'T_SRC_DECISIONLISTENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_TENDENCY_L', 'T_SRC_TENDENCY_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONPURLIST', 'T_SRC_DECISIONPURLIST', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONPACKAGE', 'T_SRC_DECISIONPACKAGE', 'FPKID', '1';

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



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