/**Begin C:\PDM_UPGRADE\PDM1\SRM_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_SRM_COMPCONFIG', 'T_SRM_COMPCONFIG', 'FID', '1';


 EXEC P_ALTERPK 'PK_T_SRM_COMPCONFIGENTRY', 'T_SRM_COMPCONFIGENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_T_SRM_COMPCONFIG_L', 'T_SRM_COMPCONFIG_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_SRM_COMPGROUP', 'T_SRM_COMPGROUP', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_T_SRM_COMPGROUP_L', 'T_SRM_COMPGROUP_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_SRM_COMPONENT', 'T_SRM_COMPONENT', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_T_SRM_COMPONENT_L', 'T_SRM_COMPONENT_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_SRM_SHOWFILEDENTRY', 'T_SRM_SHOWFILEDENTRY', 'FENTRYID', '1';


 EXEC P_ALTERPK 'PK_T_SRM_SHOWFILEDENTRY_L', 'T_SRM_SHOWFILEDENTRY_L', 'FPKID', '1';



 EXEC P_ALTERPK 'PK_T_SRM_SUBSHOWFILEDENTRY', 'T_SRM_SUBSHOWFILEDENTRY', 'FDETAILID', '1';



 EXEC P_ALTERPK 'PK_T_SRM_ABOUTENTRY', 'T_SRM_ABOUTENTRY', 'FENTRYID', '1';


 EXEC P_ALTERPK 'PK_T_SRM_ABOUTENTRY_L', 'T_SRM_ABOUTENTRY_L', 'FPKID', '1';



 EXEC P_ALTERPK 'PK_T_SRM_FRINDLINKENTRY', 'T_SRM_FRINDLINKENTRY', 'FENTRYID', '1';



 EXEC P_ALTERPK 'PK_T_SRM_FRINDLINKENTRY_L', 'T_SRM_FRINDLINKENTRY_L', 'FPKID', '1';



 EXEC P_ALTERPK 'PK_T_SRM_SWIPERSENTRY', 'T_SRM_SWIPERSENTRY', 'FENTRYID', '1';



 EXEC P_ALTERPK 'PK_T_SRM_PROCESSENTRY', 'T_SRM_PROCESSENTRY', 'FENTRYID', '1';



 EXEC P_ALTERPK 'PK_T_SRM_PROCESSENTRY_L', 'T_SRM_PROCESSENTRY_L', 'FPKID', '1';


 EXEC P_ALTERPK 'PK_T_SRM_SRCTYPE', 'T_SRM_SRCTYPE', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_SRM_LEFTSRCTYPE', 'T_SRM_LEFTSRCTYPE', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_SRM_RIGHTSRCTYPE', 'T_SRM_RIGHTSRCTYPE', 'FPKID', '1';

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



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