/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\SRC_constraint.sql **/
 EXEC P_ALTERPK 'PK_SRC_AFTERCHANGEENTRY', 'T_SRC_AFTERCHANGEENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_AFTERCHANGEENTRY_COPY', 'T_SRC_AFTERCHANGEENTRY_COPY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_AMOUNT', 'T_SRC_AMOUNT', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_AMOUNT_SUB', 'T_SRC_AMOUNT_SUB', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_AMOUNT_SUB_FSIGNRATE') CREATE INDEX IDX_SRC_AMOUNT_SUB_FSIGNRATE ON T_SRC_AMOUNT_SUB ( FSIGNRATE );


 EXEC P_ALTERPK 'PK_SRC_AMOUNTCHANGE', 'T_SRC_AMOUNTCHANGE', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_APPLY', 'T_SRC_APPLY', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_APPLY_FBILLNO') CREATE INDEX IDX_SRC_APPLY_FBILLNO ON T_SRC_APPLY ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_APPLY_FECPNO') CREATE INDEX IDX_SRC_APPLY_FECPNO ON T_SRC_APPLY ( FECPNO );


 EXEC P_ALTERPK 'PK_SRC_APPLY_L', 'T_SRC_APPLY_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_APPLY_L_FTITLE') CREATE INDEX IDX_SRC_APPLY_L_FTITLE ON T_SRC_APPLY_L ( FTITLE );


 EXEC P_ALTERPK 'PK_SRC_APPLYATTACHMENT', 'T_SRC_APPLYATTACHMENT', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_APPLYATTACHMENT_BID') CREATE INDEX IDX_SRC_APPLYATTACHMENT_BID ON T_SRC_APPLYATTACHMENT ( FBASEDATAID );


 EXEC P_ALTERPK 'PK_SRC_APPLYDEPTYEAR', 'T_SRC_APPLYDEPTYEAR', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_APPLYENTRY', 'T_SRC_APPLYENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_APPLYENTRY_FJ', 'T_SRC_APPLYENTRY_FJ', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_APPLYENTRY_EID') CREATE INDEX IDX_SRC_APPLYENTRY_EID ON T_SRC_APPLYENTRY_FJ ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_APPLYENTRY_L', 'T_SRC_APPLYENTRY_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_APPLYENTRY_L_EID') CREATE INDEX IDX_SRC_APPLYENTRY_L_EID ON T_SRC_APPLYENTRY_L ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_APPLYPURORG', 'T_SRC_APPLYPURORG', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_APPLYSUBENTRY', 'T_SRC_APPLYSUBENTRY', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_APPLYSUBENTRY_FID') CREATE INDEX IDX_SRC_APPLYSUBENTRY_FID ON T_SRC_APPLYSUBENTRY ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_APPLYUSERID', 'T_SRC_APPLYUSERID', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_ASSESSCONFIG', 'T_SRC_ASSESSCONFIG', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ASSESSCONFIG_FPACK') CREATE INDEX IDX_SRC_ASSESSCONFIG_FPACK ON T_SRC_ASSESSCONFIG ( FPACKAGEID );


 EXEC P_ALTERPK 'PK_SRC_ASSESSCONFIG_FJ', 'T_SRC_ASSESSCONFIG_FJ', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ASSESSCONFIG_FJ') CREATE INDEX IDX_SRC_ASSESSCONFIG_FJ ON T_SRC_ASSESSCONFIG_FJ ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_ASSESSSCORER', 'T_SRC_ASSESSSCORER', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ASSESSSCORER_FENTRYID') CREATE INDEX IDX_SRC_ASSESSSCORER_FENTRYID ON T_SRC_ASSESSSCORER ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_ASSESSSUM', 'T_SRC_ASSESSSUM', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ASSESSSUM_PACKID') CREATE INDEX IDX_SRC_ASSESSSUM_PACKID ON T_SRC_ASSESSSUM ( FPACKAGEID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ASSESSSUM_TASKID') CREATE INDEX IDX_SRC_ASSESSSUM_TASKID ON T_SRC_ASSESSSUM ( FSCORETASKID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ASSESSSUM_SUPID') CREATE INDEX IDX_SRC_ASSESSSUM_SUPID ON T_SRC_ASSESSSUM ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_ATTACHMENTYEAR', 'T_SRC_ATTACHMENTYEAR', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_BEFORECHANGEENTRY', 'T_SRC_BEFORECHANGEENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_BIDCHANGE', 'T_SRC_BIDCHANGE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDCHANGE_FBILLDATE') CREATE INDEX IDX_SRC_BIDCHANGE_FBILLDATE ON T_SRC_BIDCHANGE ( FBILLDATE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDCHANGE_FBILLNO') CREATE INDEX IDX_SRC_BIDCHANGE_FBILLNO ON T_SRC_BIDCHANGE ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDCHANGE_FPARENTID') CREATE INDEX IDX_SRC_BIDCHANGE_FPARENTID ON T_SRC_BIDCHANGE ( FPARENTID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDCHANGE_FTEMPLATEID') CREATE INDEX IDX_SRC_BIDCHANGE_FTEMPLATEID ON T_SRC_BIDCHANGE ( FTEMPLATEID );


 EXEC P_ALTERPK 'PK_SRC_BIDCHANGE_CONDITION', 'T_SRC_BIDCHANGE_CONDITION', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_BIDCHANGE_HANDLER', 'T_SRC_BIDCHANGE_HANDLER', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_BIDCHANGE_LOG', 'T_SRC_BIDCHANGE_LOG', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_BIDCHANGE_ORG', 'T_SRC_BIDCHANGE_ORG', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_BIDCOMP_MATGROUP', 'T_SRC_BIDCOMP_MATGROUP', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_BIDDINGPROJECT', 'T_SRC_BIDDINGPROJECT', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_BIDDINGPROJECT_PRO', 'T_SRC_BIDDINGPROJECT_PRO', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_PRO_FNAME') CREATE INDEX IDX_SRC_PROJECT_PRO_FNAME ON T_SRC_BIDDINGPROJECT_PRO ( FBIDNAME );


 EXEC P_ALTERPK 'PK_SRC_BIDDINGPROJECTENTRY', 'T_SRC_BIDDINGPROJECTENTRY', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ENTRY_FPARENTID') CREATE INDEX IDX_SRC_ENTRY_FPARENTID ON T_SRC_BIDDINGPROJECTENTRY ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_BIDDOC', 'T_SRC_BIDDOC', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDDOC_FBILLNO') CREATE INDEX IDX_SRC_BIDDOC_FBILLNO ON T_SRC_BIDDOC ( FBILLNO );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDDOC_FPARENTID') CREATE INDEX IDX_SRC_BIDDOC_FPARENTID ON T_SRC_BIDDOC ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_BIDDOCBILL', 'T_SRC_BIDDOCBILL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDDOCBILL_FBILLDATE') CREATE INDEX IDX_SRC_BIDDOCBILL_FBILLDATE ON T_SRC_BIDDOCBILL ( FBILLDATE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDDOCBILL_FBILLNO') CREATE INDEX IDX_SRC_BIDDOCBILL_FBILLNO ON T_SRC_BIDDOCBILL ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDDOCBILL_FPARENTID') CREATE INDEX IDX_SRC_BIDDOCBILL_FPARENTID ON T_SRC_BIDDOCBILL ( FPARENTID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDDOCBILL_FSUPPLIERID') CREATE INDEX IDX_SRC_BIDDOCBILL_FSUPPLIERID ON T_SRC_BIDDOCBILL ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_BIDDOCENTRY', 'T_SRC_BIDDOCENTRY', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDDOCENTRY_PACKID') CREATE INDEX IDX_SRC_BIDDOCENTRY_PACKID ON T_SRC_BIDDOCENTRY ( FPACKAGEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDDOCENTRY_SUPID') CREATE INDEX IDX_SRC_BIDDOCENTRY_SUPID ON T_SRC_BIDDOCENTRY ( FSUPPLIERID );

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


 EXEC P_ALTERPK 'PK_SRC_BIDDOCENTRY_FJ', 'T_SRC_BIDDOCENTRY_FJ', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDDOCENTRY_FJ') CREATE INDEX IDX_SRC_BIDDOCENTRY_FJ ON T_SRC_BIDDOCENTRY_FJ ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_CATEGORYCHANGE', 'T_SRC_CATEGORYCHANGE', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CATEGORYCHG', 'T_SRC_CATEGORYCHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_CATEGORYCHG_PID') CREATE INDEX IDX_SRC_CATEGORYCHG_PID ON T_SRC_CATEGORYCHG ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_CATEGORYCHGENTRY', 'T_SRC_CATEGORYCHGENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CATEGORYDECISION', 'T_SRC_CATEGORYDECISION', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_CATEGORYDECISION_FID') CREATE INDEX IDX_SRC_CATEGORYDECISION_FID ON T_SRC_CATEGORYDECISION ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_CATEGORYMANY', 'T_SRC_CATEGORYMANY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CERTIFICATENTRY', 'T_SRC_CERTIFICATENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CERTIFICATSUBENTRY', 'T_SRC_CERTIFICATSUBENTRY', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_CERTIFICATSUBENTRY_FID') CREATE INDEX IDX_SRC_CERTIFICATSUBENTRY_FID ON T_SRC_CERTIFICATSUBENTRY ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_CHANGECONDITION', 'T_SRC_CHANGECONDITION', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CHANGEENTRY', 'T_SRC_CHANGEENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CHANGEHANDLER', 'T_SRC_CHANGEHANDLER', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CHANGELOG', 'T_SRC_CHANGELOG', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CHANGEPURORGAFTER', 'T_SRC_CHANGEPURORGAFTER', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CHANGEPURORGBEFORE', 'T_SRC_CHANGEPURORGBEFORE', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CHANGETYPE', 'T_SRC_CHANGETYPE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_TYPE_FCREATORID') CREATE INDEX IDX_SRC_TYPE_FCREATORID ON T_SRC_CHANGETYPE ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_CHANGETYPE_L', 'T_SRC_CHANGETYPE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CHGCONDITION', 'T_SRC_CHGCONDITION', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CHGCONDITION_L', 'T_SRC_CHGCONDITION_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CHGHANDLER', 'T_SRC_CHGHANDLER', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_CHGHANDLER_BID') CREATE INDEX IDX_SRC_CHGHANDLER_BID ON T_SRC_CHGHANDLER ( FBIZNODEID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_CHGHANDLER_SID') CREATE INDEX IDX_SRC_CHGHANDLER_SID ON T_SRC_CHGHANDLER ( FSOURCETYPEID );


 EXEC P_ALTERPK 'PK_SRC_CHGHANDLER_L', 'T_SRC_CHGHANDLER_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_COMPARE_SET', 'T_SRC_COMPARE_SET', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPARE_SET_PID') CREATE INDEX IDX_SRC_COMPARE_SET_PID ON T_SRC_COMPARE_SET ( FPACKAGEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPARE_SET_SID') CREATE INDEX IDX_SRC_COMPARE_SET_SID ON T_SRC_COMPARE_SET ( FPKGSCHEMEID );


 EXEC P_ALTERPK 'PK_SRC_COMPAREATTACH', 'T_SRC_COMPAREATTACH', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_COMPAREATTACH_FJ', 'T_SRC_COMPAREATTACH_FJ', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COM_FJ_FENTRYID') CREATE INDEX IDX_SRC_COM_FJ_FENTRYID ON T_SRC_COMPAREATTACH_FJ ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_COMPARESUM', 'T_SRC_COMPARESUM', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPARESUM_FPACKAGEID') CREATE INDEX IDX_SRC_COMPARESUM_FPACKAGEID ON T_SRC_COMPARESUM ( FPACKAGEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPARESUM_FPARENTID') CREATE INDEX IDX_SRC_COMPARESUM_FPARENTID ON T_SRC_COMPARESUM ( FPARENTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPARESUM_FPKGGROUPID') CREATE INDEX IDX_SRC_COMPARESUM_FPKGGROUPID ON T_SRC_COMPARESUM ( FPKGGROUPID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPARESUM_FPURLISTID') CREATE INDEX IDX_SRC_COMPARESUM_FPURLISTID ON T_SRC_COMPARESUM ( FPURLISTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPARESUM_FSUPPLIERID') CREATE INDEX IDX_SRC_COMPARESUM_FSUPPLIERID ON T_SRC_COMPARESUM ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_COMPENTRY', 'T_SRC_COMPENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_COMPONENT', 'T_SRC_COMPONENT', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPONENT_FBIZOBJECT') CREATE INDEX IDX_SRC_COMPONENT_FBIZOBJECT ON T_SRC_COMPONENT ( FBIZOBJECT );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPONENT_FCREATETIME') CREATE INDEX IDX_SRC_COMPONENT_FCREATETIME ON T_SRC_COMPONENT ( FCREATETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPONENT_FGROUPID') CREATE INDEX IDX_SRC_COMPONENT_FGROUPID ON T_SRC_COMPONENT ( FGROUPID );

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


 EXEC P_ALTERPK 'PK_SRC_COMPONENT_L', 'T_SRC_COMPONENT_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_COMPONENT_L_FLOCALEID') CREATE INDEX IDX_SRC_COMPONENT_L_FLOCALEID ON T_SRC_COMPONENT_L ( FLOCALEID );


 EXEC P_ALTERPK 'PK_SRC_CONTRACEEND', 'T_SRC_CONTRACEEND', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_CONTRACEEND_PID') CREATE INDEX IDX_SRC_CONTRACEEND_PID ON T_SRC_CONTRACEEND ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_CONTRACEENDENTRY', 'T_SRC_CONTRACEENDENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CONTRACTCONDITION', 'T_SRC_CONTRACTCONDITION', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_CONTRACTPURLIST', 'T_SRC_CONTRACTPURLIST', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLIST_FPACKAGEID') CREATE INDEX IDX_SRC_PURLIST_FPACKAGEID ON T_SRC_CONTRACTPURLIST ( FPACKAGEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLIST_FSUPPLIERID') CREATE INDEX IDX_SRC_PURLIST_FSUPPLIERID ON T_SRC_CONTRACTPURLIST ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_CONTRACTSUPPLIER', 'T_SRC_CONTRACTSUPPLIER', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SUPPLIER_FSUPPLIERID') CREATE INDEX IDX_SRC_SUPPLIER_FSUPPLIERID ON T_SRC_CONTRACTSUPPLIER ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_DECFORMCATEGORY', 'T_SRC_DECFORMCATEGORY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECFORMPURDEPT', 'T_SRC_DECFORMPURDEPT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECFORMPURGROUP', 'T_SRC_DECFORMPURGROUP', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECIDE', 'T_SRC_DECIDE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECIDE_FBILLNO') CREATE INDEX IDX_SRC_DECIDE_FBILLNO ON T_SRC_DECIDE ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECIDE_FBILLSTATUS') CREATE INDEX IDX_SRC_DECIDE_FBILLSTATUS ON T_SRC_DECIDE ( FBILLSTATUS );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECIDE_FDECISIONTYPE') CREATE INDEX IDX_SRC_DECIDE_FDECISIONTYPE ON T_SRC_DECIDE ( FDECISIONTYPE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECIDE_FISFUNCTION') CREATE INDEX IDX_SRC_DECIDE_FISFUNCTION ON T_SRC_DECIDE ( FISFUNCTION );


 EXEC P_ALTERPK 'PK_SRC_DECIDE_L', 'T_SRC_DECIDE_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECIDE_L_FTITLE') CREATE INDEX IDX_SRC_DECIDE_L_FTITLE ON T_SRC_DECIDE_L ( FTITLE );


 EXEC P_ALTERPK 'PK_SRC_DECIDEATTACHMENT', 'T_SRC_DECIDEATTACHMENT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISION_CATEGORY', 'T_SRC_DECISION_CATEGORY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISION_DISPOSE', 'T_SRC_DECISION_DISPOSE', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISION_DUP', 'T_SRC_DECISION_DUP', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISION_PURORG', 'T_SRC_DECISION_PURORG', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONCHANGELOG', 'T_SRC_DECISIONCHANGELOG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECHLOG_FBILLNO') CREATE INDEX IDX_SRC_DECHLOG_FBILLNO ON T_SRC_DECISIONCHANGELOG ( FBILLNO );


 EXEC P_ALTERPK 'PK_SRC_DECISIONCHANGETYPE', 'T_SRC_DECISIONCHANGETYPE', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONCHG', 'T_SRC_DECISIONCHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONCHG_FBILLNO') CREATE INDEX IDX_SRC_DECISIONCHG_FBILLNO ON T_SRC_DECISIONCHG ( FBILLNO );


 EXEC P_ALTERPK 'PK_SRC_DECISIONCHGENTRY', 'T_SRC_DECISIONCHGENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONCHGENTRY_FID') CREATE INDEX IDX_SRC_DECISIONCHGENTRY_FID ON T_SRC_DECISIONCHGENTRY ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_DECISIONDEMAND', 'T_SRC_DECISIONDEMAND', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONFORM', 'T_SRC_DECISIONFORM', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONFORM_L', 'T_SRC_DECISIONFORM_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONITEM', 'T_SRC_DECISIONITEM', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONITEM_FID') CREATE INDEX IDX_SRC_DECISIONITEM_FID ON T_SRC_DECISIONITEM ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_DECISIONLEVEL', 'T_SRC_DECISIONLEVEL', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONLEVEL_DEPT', 'T_SRC_DECISIONLEVEL_DEPT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONLEVEL_L', 'T_SRC_DECISIONLEVEL_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONSCENE', 'T_SRC_DECISIONSCENE', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONSCENEORG', 'T_SRC_DECISIONSCENEORG', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISCENEORG_EID') CREATE INDEX IDX_SRC_DECISCENEORG_EID ON T_SRC_DECISIONSCENEORG ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_DECISIONSCORER', 'T_SRC_DECISIONSCORER', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONSUM', 'T_SRC_DECISIONSUM', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUM_FBILLDATE') CREATE INDEX IDX_SRC_DECISIONSUM_FBILLDATE ON T_SRC_DECISIONSUM ( FBILLDATE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUM_FBILLNO') CREATE INDEX IDX_SRC_DECISIONSUM_FBILLNO ON T_SRC_DECISIONSUM ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUM_FPARENTID') CREATE INDEX IDX_SRC_DECISIONSUM_FPARENTID ON T_SRC_DECISIONSUM ( FPARENTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUM_FSOURCEID') CREATE INDEX IDX_SRC_DECISIONSUM_FSOURCEID ON T_SRC_DECISIONSUM ( FSOURCEID );


 EXEC P_ALTERPK 'PK_SRC_DECISIONSUM_L', 'T_SRC_DECISIONSUM_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUM_L_BNAME') CREATE INDEX IDX_SRC_DECISIONSUM_L_BNAME ON T_SRC_DECISIONSUM_L ( FBIDNAME );


 EXEC P_ALTERPK 'PK_SRC_DECISIONSUM_PRO', 'T_SRC_DECISIONSUM_PRO', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONSUMSIGN', 'T_SRC_DECISIONSUMSIGN', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUMSIGN_FCID') CREATE INDEX IDX_SRC_DECISIONSUMSIGN_FCID ON T_SRC_DECISIONSUMSIGN ( FCONTRACTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUMSIGN_FSUP') CREATE INDEX IDX_SRC_DECISIONSUMSIGN_FSUP ON T_SRC_DECISIONSUMSIGN ( FSUPPLIERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUMSIGN_FEID') CREATE INDEX IDX_SRC_DECISIONSUMSIGN_FEID ON T_SRC_DECISIONSUMSIGN ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_DECISIONSUMSIGN_FJ', 'T_SRC_DECISIONSUMSIGN_FJ', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISUMSIGN_FJ_FBID') CREATE INDEX IDX_SRC_DECISUMSIGN_FJ_FBID ON T_SRC_DECISIONSUMSIGN_FJ ( FBASEDATAID );


 EXEC P_ALTERPK 'PK_SRC_DECISIONSUMSUP', 'T_SRC_DECISIONSUMSUP', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUMSUP_FCID') CREATE INDEX IDX_SRC_DECISIONSUMSUP_FCID ON T_SRC_DECISIONSUMSUP ( FCATEGORYID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUMSUP_FPAG') CREATE INDEX IDX_SRC_DECISIONSUMSUP_FPAG ON T_SRC_DECISIONSUMSUP ( FPACKAGEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUMSUP_FPID') CREATE INDEX IDX_SRC_DECISIONSUMSUP_FPID ON T_SRC_DECISIONSUMSUP ( FPARENTID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONSUMSUP_FSUP') CREATE INDEX IDX_SRC_DECISIONSUMSUP_FSUP ON T_SRC_DECISIONSUMSUP ( FSUPPLIERID );

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONSUP', 'T_SRC_DECISIONSUP', 'FENTRYIDTWO', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONTPL', 'T_SRC_DECISIONTPL', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONTPL_L', 'T_SRC_DECISIONTPL_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONTPLCATEGORY', 'T_SRC_DECISIONTPLCATEGORY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONTPLENTRY', 'T_SRC_DECISIONTPLENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONTPLPURDEPT', 'T_SRC_DECISIONTPLPURDEPT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONTPLPURGROUP', 'T_SRC_DECISIONTPLPURGROUP', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DECISIONWIN', 'T_SRC_DECISIONWIN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DECISIONWIN_FPID') CREATE INDEX IDX_SRC_DECISIONWIN_FPID ON T_SRC_DECISIONWIN ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_DECLEVDEPT', 'T_SRC_DECLEVDEPT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMAND', 'T_SRC_DEMAND', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DEMAND_FBILLNO') CREATE INDEX IDX_SRC_DEMAND_FBILLNO ON T_SRC_DEMAND ( FBILLNO );


 EXEC P_ALTERPK 'PK_SRC_DEMAND_A', 'T_SRC_DEMAND_A', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DEMAND_A_FID') CREATE INDEX IDX_SRC_DEMAND_A_FID ON T_SRC_DEMAND_A ( FDECIDENUMBER );


 EXEC P_ALTERPK 'PK_SRC_DEMAND_CHASSTYPE', 'T_SRC_DEMAND_CHASSTYPE', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMAND_L', 'T_SRC_DEMAND_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DEMAND_L_FTITLE') CREATE INDEX IDX_SRC_DEMAND_L_FTITLE ON T_SRC_DEMAND_L ( FTITLE );


 EXEC P_ALTERPK 'PK_SRC_DEMANDAMOUNT', 'T_SRC_DEMANDAMOUNT', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDAMOUNT_L', 'T_SRC_DEMANDAMOUNT_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDBIZNODE', 'T_SRC_DEMANDBIZNODE', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDBIZNODE_L', 'T_SRC_DEMANDBIZNODE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDCHANGE', 'T_SRC_DEMANDCHANGE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DEMANDCHANGE_FBILLNO') CREATE INDEX IDX_SRC_DEMANDCHANGE_FBILLNO ON T_SRC_DEMANDCHANGE ( FBILLNO );


 EXEC P_ALTERPK 'PK_SRC_DEMANDCHG', 'T_SRC_DEMANDCHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DEMANDCHG_PID') CREATE INDEX IDX_SRC_DEMANDCHG_PID ON T_SRC_DEMANDCHG ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_DEMANDCHGENTRY', 'T_SRC_DEMANDCHGENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDCOMP', 'T_SRC_DEMANDCOMP', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDCOMP_L', 'T_SRC_DEMANDCOMP_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDCOMPPURORG', 'T_SRC_DEMANDCOMPPURORG', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDINFO', 'T_SRC_DEMANDINFO', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DEMANDINFO_FPARENTID') CREATE INDEX IDX_SRC_DEMANDINFO_FPARENTID ON T_SRC_DEMANDINFO ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_DEMANDINFO_BODY', 'T_SRC_DEMANDINFO_BODY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDPURORG', 'T_SRC_DEMANDPURORG', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDSUMMARY', 'T_SRC_DEMANDSUMMARY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DEMANDTRANSLOG', 'T_SRC_DEMANDTRANSLOG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DEMANDTRANSLOG_FBILLNO') CREATE INDEX IDX_SRC_DEMANDTRANSLOG_FBILLNO ON T_SRC_DEMANDTRANSLOG ( FBILLNO );


 EXEC P_ALTERPK 'PK_SRC_DIRECTATTACH', 'T_SRC_DIRECTATTACH', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DIRECTATTACH_FJ', 'T_SRC_DIRECTATTACH_FJ', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_DIRECTATTACH_FJ_FEID') CREATE INDEX IDX_SRC_DIRECTATTACH_FJ_FEID ON T_SRC_DIRECTATTACH_FJ ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_DMDAMOUNT_CATEGORY', 'T_SRC_DMDAMOUNT_CATEGORY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_DMDAMOUNT_DEPT', 'T_SRC_DMDAMOUNT_DEPT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_ENROLLSUPPLIER', 'T_SRC_ENROLLSUPPLIER', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ENROLLSUPPLIER_FEPAG') CREATE INDEX IDX_SRC_ENROLLSUPPLIER_FEPAG ON T_SRC_ENROLLSUPPLIER ( FENROLLPACKAGEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ENROLLSUPPLIER_FESUP') CREATE INDEX IDX_SRC_ENROLLSUPPLIER_FESUP ON T_SRC_ENROLLSUPPLIER ( FENROLLSUPPLIERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ENROLLSUPPLIER_FPID') CREATE INDEX IDX_SRC_ENROLLSUPPLIER_FPID ON T_SRC_ENROLLSUPPLIER ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_EXPORT', 'T_SRC_EXPORT', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_EXPORT_L', 'T_SRC_EXPORT_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_EXPORTEDUCATION', 'T_SRC_EXPORTEDUCATION', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_EXPORTEXC', 'T_SRC_EXPORTEXC', 'FDATAID,FUSEORGID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_EXPORTEXC_OID') CREATE INDEX IDX_SRC_EXPORTEXC_OID ON T_SRC_EXPORTEXC ( FCREATEORGID );


 EXEC P_ALTERPK 'PK_SRC_EXPORTPROJECT', 'T_SRC_EXPORTPROJECT', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_EXPORTTYPE', 'T_SRC_EXPORTTYPE', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_EXPORTUSEREG', 'T_SRC_EXPORTUSEREG', 'FUSEORGID,FDATAID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_EXPORTUSEREG') CREATE INDEX IDX_SRC_EXPORTUSEREG ON T_SRC_EXPORTUSEREG ( FCREATEORGID );


 EXEC P_ALTERPK 'PK_SRC_EXPORTWORK', 'T_SRC_EXPORTWORK', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_FIELDENTRY', 'T_SRC_FIELDENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_FREQUENCY', 'T_SRC_FREQUENCY', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_FREQUENCY_FBNO') CREATE INDEX IDX_SRC_FREQUENCY_FBNO ON T_SRC_FREQUENCY ( FBILLNO );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_FREQUENCY_FPID') CREATE INDEX IDX_SRC_FREQUENCY_FPID ON T_SRC_FREQUENCY ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_FREQUENCYENTRY', 'T_SRC_FREQUENCYENTRY', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_FREQUENCYENTRY_FSUP') CREATE INDEX IDX_SRC_FREQUENCYENTRY_FSUP ON T_SRC_FREQUENCYENTRY ( FSUPPLIERID );

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


 EXEC P_ALTERPK 'PK_SRC_GETCAT', 'T_SRC_GETCAT', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_GETCAT_L', 'T_SRC_GETCAT_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_HISTORYENTRY', 'T_SRC_HISTORYENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_INCREASEENTRY', 'T_SRC_INCREASEENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_INDEX', 'T_SRC_INDEX', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_INDEX_L', 'T_SRC_INDEX_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_INDEXCATEGORY', 'T_SRC_INDEXCATEGORY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_INDEXCLASS', 'T_SRC_INDEXCLASS', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INDEXCLASS_FCREATETIME') CREATE INDEX IDX_SRC_INDEXCLASS_FCREATETIME ON T_SRC_INDEXCLASS ( FCREATETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INDEXCLASS_FMASTERID') CREATE INDEX IDX_SRC_INDEXCLASS_FMASTERID ON T_SRC_INDEXCLASS ( FMASTERID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INDEXCLASS_FPARENTID') CREATE INDEX IDX_SRC_INDEXCLASS_FPARENTID ON T_SRC_INDEXCLASS ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_INDEXCLASS_L', 'T_SRC_INDEXCLASS_L', 'FPKID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INDEXCLASS_L_FNAME') CREATE INDEX IDX_SRC_INDEXCLASS_L_FNAME ON T_SRC_INDEXCLASS_L ( FNAME );


 EXEC P_ALTERPK 'PK_SRC_INDEXENTRY', 'T_SRC_INDEXENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_INDEXPURDEPT', 'T_SRC_INDEXPURDEPT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_INDEXPURGROUP', 'T_SRC_INDEXPURGROUP', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_INDEXSUPENTRY', 'T_SRC_INDEXSUPENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INDEXSUPENTRY_FID') CREATE INDEX IDX_SRC_INDEXSUPENTRY_FID ON T_SRC_INDEXSUPENTRY ( FSUPPLIERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ENTRY_FSCORE') CREATE INDEX IDX_SRC_ENTRY_FSCORE ON T_SRC_INDEXSUPENTRY ( FSCORE );


 EXEC P_ALTERPK 'PK_SRC_INVITECONFIG', 'T_SRC_INVITECONFIG', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_INVITECONFIG_L', 'T_SRC_INVITECONFIG_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_INVITESUPPLIER', 'T_SRC_INVITESUPPLIER', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INVITESUPPLIER_FPAG') CREATE INDEX IDX_SRC_INVITESUPPLIER_FPAG ON T_SRC_INVITESUPPLIER ( FPACKAGEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INVITESUPPLIER_FPID') CREATE INDEX IDX_SRC_INVITESUPPLIER_FPID ON T_SRC_INVITESUPPLIER ( FPARENTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INVITESUPPLIER_FSUP') CREATE INDEX IDX_SRC_INVITESUPPLIER_FSUP ON T_SRC_INVITESUPPLIER ( FSUPPLIERID );

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


 EXEC P_ALTERPK 'PK_SRC_INVITESUPPLIER_TEMP', 'T_SRC_INVITESUPPLIER_TEMP', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INVITESUP_TEMP_FPAG') CREATE INDEX IDX_SRC_INVITESUP_TEMP_FPAG ON T_SRC_INVITESUPPLIER_TEMP ( FPACKAGEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INVITESUP_TEMP_FPID') CREATE INDEX IDX_SRC_INVITESUP_TEMP_FPID ON T_SRC_INVITESUPPLIER_TEMP ( FPARENTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_INVITESUP_TEMP_FSUP') CREATE INDEX IDX_SRC_INVITESUP_TEMP_FSUP ON T_SRC_INVITESUPPLIER_TEMP ( FSUPPLIERID );

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


 EXEC P_ALTERPK 'PK_SRC_ITEMSUPENTRY', 'T_SRC_ITEMSUPENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_ITEMSUPENTRY_SUP', 'T_SRC_ITEMSUPENTRY_SUP', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ITEMSUPENTRY_SUP_FID') CREATE INDEX IDX_SRC_ITEMSUPENTRY_SUP_FID ON T_SRC_ITEMSUPENTRY_SUP ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_MANUALSCORE', 'T_SRC_MANUALSCORE', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_MATERIAL', 'T_SRC_MATERIAL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MATERIAL_FCREATETIME') CREATE INDEX IDX_SRC_MATERIAL_FCREATETIME ON T_SRC_MATERIAL ( FCREATETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MATERIAL_FGROUPID') CREATE INDEX IDX_SRC_MATERIAL_FGROUPID ON T_SRC_MATERIAL ( FGROUPID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MATERIAL_FMASTERID') CREATE INDEX IDX_SRC_MATERIAL_FMASTERID ON T_SRC_MATERIAL ( FMASTERID );

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


 EXEC P_ALTERPK 'PK_SRC_MATERIAL_L', 'T_SRC_MATERIAL_L', 'FPKID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MATERIAL_L_FNAME') CREATE INDEX IDX_SRC_MATERIAL_L_FNAME ON T_SRC_MATERIAL_L ( FNAME );


 EXEC P_ALTERPK 'PK_SRC_MATERIALGROUP', 'T_SRC_MATERIALGROUP', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_GROUP_FCREATETIME') CREATE INDEX IDX_SRC_GROUP_FCREATETIME ON T_SRC_MATERIALGROUP ( FCREATETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_GROUP_FGROUPID') CREATE INDEX IDX_SRC_GROUP_FGROUPID ON T_SRC_MATERIALGROUP ( FGROUPID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_GROUP_FMASTERID') CREATE INDEX IDX_SRC_GROUP_FMASTERID ON T_SRC_MATERIALGROUP ( FMASTERID );

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


 EXEC P_ALTERPK 'PK_SRC_MATERIALGROUP_L', 'T_SRC_MATERIALGROUP_L', 'FPKID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MATGROUP_L_FNAME') CREATE INDEX IDX_SRC_MATGROUP_L_FNAME ON T_SRC_MATERIALGROUP_L ( FNAME );


 EXEC P_ALTERPK 'PK_SRC_MEMBER', 'T_SRC_MEMBER', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MEMBER_PID') CREATE INDEX IDX_SRC_MEMBER_PID ON T_SRC_MEMBER ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_MEMBERENTRY', 'T_SRC_MEMBERENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MEMBERENTRY_FBID') CREATE INDEX IDX_SRC_MEMBERENTRY_FBID ON T_SRC_MEMBERENTRY ( FBIDDERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MEMBERENTRY_FBIZ') CREATE INDEX IDX_SRC_MEMBERENTRY_FBIZ ON T_SRC_MEMBERENTRY ( FBIZROLEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MEMBERENTRY_FPID') CREATE INDEX IDX_SRC_MEMBERENTRY_FPID ON T_SRC_MEMBERENTRY ( FPARENTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MEMBERENTRY_FTYPE') CREATE INDEX IDX_SRC_MEMBERENTRY_FTYPE ON T_SRC_MEMBERENTRY ( FTYPE );

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


 EXEC P_ALTERPK 'PK_SRC_MONEYCHG', 'T_SRC_MONEYCHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MONEYCHG_FPID') CREATE INDEX IDX_SRC_MONEYCHG_FPID ON T_SRC_MONEYCHG ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_MONEYCHGENTRY', 'T_SRC_MONEYCHGENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_MONEYCHGSIGN', 'T_SRC_MONEYCHGSIGN', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_MONEYCHGSIGN_EID') CREATE INDEX IDX_SRC_MONEYCHGSIGN_EID ON T_SRC_MONEYCHGSIGN ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_MSGNOTICE', 'T_SRC_MSGNOTICE', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_MSGNOTICE_L', 'T_SRC_MSGNOTICE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_MULSERVICEMSG', 'T_SRC_MULSERVICEMSG', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_NEGOTIATEBILL', 'T_SRC_NEGOTIATEBILL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_NEGOTIATEBILL_BILLDATA') CREATE INDEX IDX_SRC_NEGOTIATEBILL_BILLDATA ON T_SRC_NEGOTIATEBILL ( FBILLDATE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_NEGOTIATEBILL_BILLNO') CREATE INDEX IDX_SRC_NEGOTIATEBILL_BILLNO ON T_SRC_NEGOTIATEBILL ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_NEGOTIATEBILL_PARENTID') CREATE INDEX IDX_SRC_NEGOTIATEBILL_PARENTID ON T_SRC_NEGOTIATEBILL ( FPARENTID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_NEGOTIATEBILL_SUPID') CREATE INDEX IDX_SRC_NEGOTIATEBILL_SUPID ON T_SRC_NEGOTIATEBILL ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_NEGOTIATEBILL_ORG', 'T_SRC_NEGOTIATEBILL_ORG', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_NOTYEARINFO', 'T_SRC_NOTYEARINFO', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_NOTYEARINFO_APPLYNO') CREATE INDEX IDX_SRC_NOTYEARINFO_APPLYNO ON T_SRC_NOTYEARINFO ( FAPPLYNO );

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


 EXEC P_ALTERPK 'PK_SRC_NUMBERCHANGE', 'T_SRC_NUMBERCHANGE', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_OPENAPPLY', 'T_SRC_OPENAPPLY', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_OPENAPPLY_FPID') CREATE INDEX IDX_SRC_OPENAPPLY_FPID ON T_SRC_OPENAPPLY ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_OPERATELOG', 'T_SRC_OPERATELOG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_OPERATELOG_BILLNO') CREATE INDEX IDX_SRC_OPERATELOG_BILLNO ON T_SRC_OPERATELOG ( FBILLNO );


 EXEC P_ALTERPK 'PK_SRC_OPERATELOGENTRY', 'T_SRC_OPERATELOGENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_OPINION', 'T_SRC_OPINION', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_OPINION_BILLNO') CREATE INDEX IDX_SRC_OPINION_BILLNO ON T_SRC_OPINION ( FBILLNO );


 EXEC P_ALTERPK 'PK_SRC_ORDERCHG', 'T_SRC_ORDERCHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ORDERCHG_FPARENTID') CREATE INDEX IDX_SRC_ORDERCHG_FPARENTID ON T_SRC_ORDERCHG ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_ORDERCHGENTRY', 'T_SRC_ORDERCHGENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_ORDERCHGSIGN', 'T_SRC_ORDERCHGSIGN', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ORDERCHGSIGN_EID') CREATE INDEX IDX_SRC_ORDERCHGSIGN_EID ON T_SRC_ORDERCHGSIGN ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_ORGSAFTER', 'T_SRC_ORGSAFTER', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ORGSAFTER_EID') CREATE INDEX IDX_SRC_ORGSAFTER_EID ON T_SRC_ORGSAFTER ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_ORGSBEFORE', 'T_SRC_ORGSBEFORE', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ORGSBEFORE_EID') CREATE INDEX IDX_SRC_ORGSBEFORE_EID ON T_SRC_ORGSBEFORE ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_OUTAREA', 'T_SRC_OUTAREA', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_OUTAREA_L', 'T_SRC_OUTAREA_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_OUTPROCESS', 'T_SRC_OUTPROCESS', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_OUTPROCESS_L', 'T_SRC_OUTPROCESS_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_OVERTIMERULE', 'T_SRC_OVERTIMERULE', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_OVERTIMERULE_DEPT', 'T_SRC_OVERTIMERULE_DEPT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_OVERTIMERULE_L', 'T_SRC_OVERTIMERULE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_OVERTIMERULEDEPT', 'T_SRC_OVERTIMERULEDEPT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PATTERN', 'T_SRC_PATTERN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PATTERN_FCREATETIME') CREATE INDEX IDX_SRC_PATTERN_FCREATETIME ON T_SRC_PATTERN ( FCREATETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PATTERN_FMASTERID') CREATE INDEX IDX_SRC_PATTERN_FMASTERID ON T_SRC_PATTERN ( FMASTERID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PATTERN_FPROJECTD') CREATE INDEX IDX_SRC_PATTERN_FPROJECTD ON T_SRC_PATTERN ( FPROJECTD );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PATTERN_FRULEASSESIDXS') CREATE INDEX IDX_SRC_PATTERN_FRULEASSESIDXS ON T_SRC_PATTERN ( FRULEASSESS );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PATTERN_FWINRULEID') CREATE INDEX IDX_SRC_PATTERN_FWINRULEID ON T_SRC_PATTERN ( FWINRULEID );


 EXEC P_ALTERPK 'PK_SRC_PATTERN_L', 'T_SRC_PATTERN_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PATTERNENTRY', 'T_SRC_PATTERNENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PATTERNSOURCETYPE', 'T_SRC_PATTERNSOURCETYPE', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PAYMENT_ORG', 'T_SRC_PAYMENT_ORG', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PAYMENT_ORG_EID') CREATE INDEX IDX_SRC_PAYMENT_ORG_EID ON T_SRC_PAYMENT_ORG ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PAYMENTENTRY', 'T_SRC_PAYMENTENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PAYMENTENTRY_FCT') CREATE INDEX IDX_SRC_PAYMENTENTRY_FCT ON T_SRC_PAYMENTENTRY ( FCREATETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PAYMENTENTRY_FPG') CREATE INDEX IDX_SRC_PAYMENTENTRY_FPG ON T_SRC_PAYMENTENTRY ( FPACKAGEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PAYMENTENTRY_FSUP') CREATE INDEX IDX_SRC_PAYMENTENTRY_FSUP ON T_SRC_PAYMENTENTRY ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_PAYMENTENTRY_FJ', 'T_SRC_PAYMENTENTRY_FJ', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PAYMENTENTRY_FJ_FEID') CREATE INDEX IDX_SRC_PAYMENTENTRY_FJ_FEID ON T_SRC_PAYMENTENTRY_FJ ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PKGAMOUNT', 'T_SRC_PKGAMOUNT', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PMPAPPLY', 'T_SRC_PMPAPPLY', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PMPAPPLY_BILLNO') CREATE INDEX IDX_SRC_PMPAPPLY_BILLNO ON T_SRC_PMPAPPLY ( FBILLNO );


 EXEC P_ALTERPK 'PK_SRC_PMPAPPLY_L', 'T_SRC_PMPAPPLY_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PORGAFTER', 'T_SRC_PORGAFTER', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PORGAFTER_EID') CREATE INDEX IDX_SRC_PORGAFTER_EID ON T_SRC_PORGAFTER ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PORGBEFORE', 'T_SRC_PORGBEFORE', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PORGBEFOREONE', 'T_SRC_PORGBEFOREONE', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PORGBEFOREONE_EID') CREATE INDEX IDX_SRC_PORGBEFOREONE_EID ON T_SRC_PORGBEFOREONE ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PRCHANGE', 'T_SRC_PRCHANGE', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PRELEVELJUDGE', 'T_SRC_PRELEVELJUDGE', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PRELEVELJUDGE_L', 'T_SRC_PRELEVELJUDGE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PRICECHG', 'T_SRC_PRICECHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PRICECHG_FPARENTID') CREATE INDEX IDX_SRC_PRICECHG_FPARENTID ON T_SRC_PRICECHG ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_PRICECHGENTRY', 'T_SRC_PRICECHGENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PRICECONFIRM', 'T_SRC_PRICECONFIRM', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PRICECONFIRM_NO') CREATE INDEX IDX_SRC_PRICECONFIRM_NO ON T_SRC_PRICECONFIRM ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PRICECONFIRM_SUPID') CREATE INDEX IDX_SRC_PRICECONFIRM_SUPID ON T_SRC_PRICECONFIRM ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_PRICECONFIRM_L', 'T_SRC_PRICECONFIRM_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PRICECONFIRMCOMP', 'T_SRC_PRICECONFIRMCOMP', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PRICECONFIRMCOMP_PID') CREATE INDEX IDX_SRC_PRICECONFIRMCOMP_PID ON T_SRC_PRICECONFIRMCOMP ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_PRICECONFIRMENTRY', 'T_SRC_PRICECONFIRMENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PRICECONFIRMENTRY_CID') CREATE INDEX IDX_SRC_PRICECONFIRMENTRY_CID ON T_SRC_PRICECONFIRMENTRY ( FCATEGORYID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PRICECONFIRMENTRY_SID') CREATE INDEX IDX_SRC_PRICECONFIRMENTRY_SID ON T_SRC_PRICECONFIRMENTRY ( FSUPPLIERID );

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


 EXEC P_ALTERPK 'PK_SRC_PROCHGCONDITION', 'T_SRC_PROCHGCONDITION', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PROCHGCONDITION_L', 'T_SRC_PROCHGCONDITION_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PROCHGHANDLER', 'T_SRC_PROCHGHANDLER', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PROCHGHANDLER_L', 'T_SRC_PROCHGHANDLER_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PROJECT', 'T_SRC_PROJECT', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_PARENTID') CREATE INDEX IDX_SRC_PROJECT_PARENTID ON T_SRC_PROJECT ( FPARENTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_SOURCEID') CREATE INDEX IDX_SRC_PROJECT_SOURCEID ON T_SRC_PROJECT ( FSOURCEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_TYPE') CREATE INDEX IDX_SRC_PROJECT_TYPE ON T_SRC_PROJECT ( FSRCTYPEID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_A', 'T_SRC_PROJECT_A', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_A_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_A_FCREATORID ON T_SRC_PROJECT_A ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_B', 'T_SRC_PROJECT_B', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_B_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_B_FCREATORID ON T_SRC_PROJECT_B ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_C', 'T_SRC_PROJECT_C', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_C_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_C_FCREATORID ON T_SRC_PROJECT_C ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_D', 'T_SRC_PROJECT_D', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_D_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_D_FCREATORID ON T_SRC_PROJECT_D ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_E', 'T_SRC_PROJECT_E', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_E_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_E_FCREATORID ON T_SRC_PROJECT_E ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_F', 'T_SRC_PROJECT_F', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_F_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_F_FCREATORID ON T_SRC_PROJECT_F ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_G', 'T_SRC_PROJECT_G', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_G_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_G_FCREATORID ON T_SRC_PROJECT_G ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_H', 'T_SRC_PROJECT_H', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_H_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_H_FCREATORID ON T_SRC_PROJECT_H ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_I', 'T_SRC_PROJECT_I', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_I_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_I_FCREATORID ON T_SRC_PROJECT_I ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_J', 'T_SRC_PROJECT_J', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_J_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_J_FCREATORID ON T_SRC_PROJECT_J ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_K', 'T_SRC_PROJECT_K', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_K_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_K_FCREATORID ON T_SRC_PROJECT_K ( FCREATORID );


 EXEC P_ALTERPK 'PK__SRC_PROJECT_L', 'T_SRC_PROJECT_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_L_FLOCALEID') CREATE INDEX IDX_SRC_PROJECT_L_FLOCALEID ON T_SRC_PROJECT_L ( FLOCALEID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_M', 'T_SRC_PROJECT_M', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_M_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_M_FCREATORID ON T_SRC_PROJECT_M ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_N', 'T_SRC_PROJECT_N', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_N_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_N_FCREATORID ON T_SRC_PROJECT_N ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_O', 'T_SRC_PROJECT_O', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_O_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_O_FCREATORID ON T_SRC_PROJECT_O ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_P', 'T_SRC_PROJECT_P', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_P_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_P_FCREATORID ON T_SRC_PROJECT_P ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_Q', 'T_SRC_PROJECT_Q', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_Q_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_Q_FCREATORID ON T_SRC_PROJECT_Q ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_R', 'T_SRC_PROJECT_R', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_R_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_R_FCREATORID ON T_SRC_PROJECT_R ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_S', 'T_SRC_PROJECT_S', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_S_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_S_FCREATORID ON T_SRC_PROJECT_S ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_T', 'T_SRC_PROJECT_T', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_T_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_T_FCREATORID ON T_SRC_PROJECT_T ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_T_FJ', 'T_SRC_PROJECT_T_FJ', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PROJECT_X', 'T_SRC_PROJECT_X', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_X_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_X_FCREATORID ON T_SRC_PROJECT_X ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_Y', 'T_SRC_PROJECT_Y', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_Y_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_Y_FCREATORID ON T_SRC_PROJECT_Y ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECT_Z', 'T_SRC_PROJECT_Z', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_Z_FCREATORID') CREATE INDEX IDX_SRC_PROJECT_Z_FCREATORID ON T_SRC_PROJECT_Z ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_PROJECTEND', 'T_SRC_PROJECTEND', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTEND_FPARENTID') CREATE INDEX IDX_SRC_PROJECTEND_FPARENTID ON T_SRC_PROJECTEND ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_PROJECTNODE', 'T_SRC_PROJECTNODE', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTNODE_FNOD') CREATE INDEX IDX_SRC_PROJECTNODE_FNOD ON T_SRC_PROJECTNODE ( FBIZNODEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTNODE_FOBJ') CREATE INDEX IDX_SRC_PROJECTNODE_FOBJ ON T_SRC_PROJECTNODE ( FBIZOBJECT );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTNODE_FEOBJ') CREATE INDEX IDX_SRC_PROJECTNODE_FEOBJ ON T_SRC_PROJECTNODE ( FEXTOBJECT );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTNODE_FTEM') CREATE INDEX IDX_SRC_PROJECTNODE_FTEM ON T_SRC_PROJECTNODE ( FTEMPLATEID );

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


 EXEC P_ALTERPK 'PK_SRC_PROJECTNODESUB', 'T_SRC_PROJECTNODESUB', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTNODESUB_FNOD') CREATE INDEX IDX_SRC_PROJECTNODESUB_FNOD ON T_SRC_PROJECTNODESUB ( FBIZNODEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTNODESUB_FOBJ') CREATE INDEX IDX_SRC_PROJECTNODESUB_FOBJ ON T_SRC_PROJECTNODESUB ( FBIZOBJECT );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTNODESUB_FEOBJ') CREATE INDEX IDX_SRC_PROJECTNODESUB_FEOBJ ON T_SRC_PROJECTNODESUB ( FEXTOBJECT );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTNODESUB_FTEM') CREATE INDEX IDX_SRC_PROJECTNODESUB_FTEM ON T_SRC_PROJECTNODESUB ( FTEMPLATEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTNODESUB_FEID') CREATE INDEX IDX_SRC_PROJECTNODESUB_FEID ON T_SRC_PROJECTNODESUB ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PROJECTORG', 'T_SRC_PROJECTORG', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PROJECTPACKAGE', 'T_SRC_PROJECTPACKAGE', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTPACKAGE_PID') CREATE INDEX IDX_SRC_PROJECTPACKAGE_PID ON T_SRC_PROJECTPACKAGE ( FPACKAGEID );


 EXEC P_ALTERPK 'PK_SRC_PROJECTPURORG', 'T_SRC_PROJECTPURORG', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PROJECTTPL', 'T_SRC_PROJECTTPL', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTTPL_FOBJ') CREATE INDEX IDX_SRC_PROJECTTPL_FOBJ ON T_SRC_PROJECTTPL ( FBIZOBJECT );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTTPL_FCOM') CREATE INDEX IDX_SRC_PROJECTTPL_FCOM ON T_SRC_PROJECTTPL ( FCOMPONENTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTTPL_FSCP') CREATE INDEX IDX_SRC_PROJECTTPL_FSCP ON T_SRC_PROJECTTPL ( FSRCTPLID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECTTPL_FTEM') CREATE INDEX IDX_SRC_PROJECTTPL_FTEM ON T_SRC_PROJECTTPL ( FTEMPLATEID );

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


 EXEC P_ALTERPK 'PK_SRC_PURAPPLYSUBENTRY', 'T_SRC_PURAPPLYSUBENTRY', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURAPPLYSUBENTRY_FID') CREATE INDEX IDX_SRC_PURAPPLYSUBENTRY_FID ON T_SRC_PURAPPLYSUBENTRY ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PURASSESS', 'T_SRC_PURASSESS', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURASSESS_FBILLDATE') CREATE INDEX IDX_SRC_PURASSESS_FBILLDATE ON T_SRC_PURASSESS ( FBILLDATE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURASSESS_FBILLNO') CREATE INDEX IDX_SRC_PURASSESS_FBILLNO ON T_SRC_PURASSESS ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURASSESS_FPARENTID') CREATE INDEX IDX_SRC_PURASSESS_FPARENTID ON T_SRC_PURASSESS ( FPARENTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURASSESS_FSOURCEID') CREATE INDEX IDX_SRC_PURASSESS_FSOURCEID ON T_SRC_PURASSESS ( FSOURCEID );


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_CGZXBMFZR', 'T_SRC_PURASSESS_CGZXBMFZR', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_COM', 'T_SRC_PURASSESS_COM', 'FID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURAS_COM_FPARENTID') CREATE INDEX IDX_SRC_PURAS_COM_FPARENTID ON T_SRC_PURASSESS_COM ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_COM_FJ', 'T_SRC_PURASSESS_COM_FJ', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_COM_FJ1', 'T_SRC_PURASSESS_COM_FJ1', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURAS_COM_FJ1_FENTRYID') CREATE INDEX IDX_SRC_PURAS_COM_FJ1_FENTRYID ON T_SRC_PURASSESS_COM_FJ1 ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_CSFZR', 'T_SRC_PURASSESS_CSFZR', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_CYPSRY', 'T_SRC_PURASSESS_CYPSRY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_IT', 'T_SRC_PURASSESS_IT', 'FID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURAS_IT_FPARENTID') CREATE INDEX IDX_SRC_PURAS_IT_FPARENTID ON T_SRC_PURASSESS_IT ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_IT_FJ', 'T_SRC_PURASSESS_IT_FJ', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_IT_FJ1', 'T_SRC_PURASSESS_IT_FJ1', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURASSESS_IT_FENTRYID') CREATE INDEX IDX_SRC_PURASSESS_IT_FENTRYID ON T_SRC_PURASSESS_IT_FJ1 ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_L', 'T_SRC_PURASSESS_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_PSRY', 'T_SRC_PURASSESS_PSRY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_SEP', 'T_SRC_PURASSESS_SEP', 'FID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURAS_SEP_FPARENTID') CREATE INDEX IDX_SRC_PURAS_SEP_FPARENTID ON T_SRC_PURASSESS_SEP ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_SEP_FJ', 'T_SRC_PURASSESS_SEP_FJ', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_SEP_FJ1', 'T_SRC_PURASSESS_SEP_FJ1', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURAS_SEP_FJ1_FENTRYID') CREATE INDEX IDX_SRC_PURAS_SEP_FJ1_FENTRYID ON T_SRC_PURASSESS_SEP_FJ1 ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_XQBMFZR', 'T_SRC_PURASSESS_XQBMFZR', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_XQFZR', 'T_SRC_PURASSESS_XQFZR', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_XQZYBMFZR', 'T_SRC_PURASSESS_XQZYBMFZR', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_XZCSRY', 'T_SRC_PURASSESS_XZCSRY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESS_ZJPSRY', 'T_SRC_PURASSESS_ZJPSRY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURASSESSPROJECT', 'T_SRC_PURASSESSPROJECT', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURBILL', 'T_SRC_PURBILL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURBILL_FNUMBER') CREATE INDEX IDX_SRC_PURBILL_FNUMBER ON T_SRC_PURBILL ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURBILL_FSUMNO') CREATE INDEX IDX_SRC_PURBILL_FSUMNO ON T_SRC_PURBILL ( FSUMNO );


 EXEC P_ALTERPK 'PK_SRC_PURBILL_L', 'T_SRC_PURBILL_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURLIST', 'T_SRC_PURLIST', 'FID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLIST_FPARENTID') CREATE INDEX IDX_SRC_PURLIST_FPARENTID ON T_SRC_PURLIST ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_PURLIST_ITEM', 'T_SRC_PURLIST_ITEM', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_ITEM_FSID') CREATE INDEX IDX_SRC_PROJECT_ITEM_FSID ON T_SRC_PURLIST_ITEM ( FSUPPLIERID );

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


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY', 'T_SRC_PURLISTENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_BID') CREATE INDEX IDX_SRC_PURLISTENTRY_BID ON T_SRC_PURLISTENTRY ( FBIDMATERIALID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_CID') CREATE INDEX IDX_SRC_PURLISTENTRY_CID ON T_SRC_PURLISTENTRY ( FCATEGORYID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_MID') CREATE INDEX IDX_SRC_PURLISTENTRY_MID ON T_SRC_PURLISTENTRY ( FMATERIALID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_PID') CREATE INDEX IDX_SRC_PURLISTENTRY_PID ON T_SRC_PURLISTENTRY ( FPARENTID );

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


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_A', 'T_SRC_PURLISTENTRY_A', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_B', 'T_SRC_PURLISTENTRY_B', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_C', 'T_SRC_PURLISTENTRY_C', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_D', 'T_SRC_PURLISTENTRY_D', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_E', 'T_SRC_PURLISTENTRY_E', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_F', 'T_SRC_PURLISTENTRY_F', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_FJ', 'T_SRC_PURLISTENTRY_FJ', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_FJ_FID') CREATE INDEX IDX_SRC_PURLISTENTRY_FJ_FID ON T_SRC_PURLISTENTRY_FJ ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_L', 'T_SRC_PURLISTENTRY_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_L_FEID') CREATE INDEX IDX_SRC_PURLISTENTRY_L_FEID ON T_SRC_PURLISTENTRY_L ( FENTRYID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_SUP', 'T_SRC_PURLISTENTRY_SUP', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_SUPFJ', 'T_SRC_PURLISTENTRY_SUPFJ', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_SUPFJ_FID') CREATE INDEX IDX_SRC_PURLISTENTRY_SUPFJ_FID ON T_SRC_PURLISTENTRY_SUPFJ ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_PURLISTENTRY_Z', 'T_SRC_PURLISTENTRY_Z', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURORGCHANGE', 'T_SRC_PURORGCHANGE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURORGCHANGE_FID') CREATE INDEX IDX_SRC_PURORGCHANGE_FID ON T_SRC_PURORGCHANGE ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_PURORGCHANGE01', 'T_SRC_PURORGCHANGE01', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURORGCHANGE02', 'T_SRC_PURORGCHANGE02', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURORGCHG', 'T_SRC_PURORGCHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURORGCHG_PID') CREATE INDEX IDX_SRC_PURORGCHG_PID ON T_SRC_PURORGCHG ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_PURREPORT', 'T_SRC_PURREPORT', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURREPORT_FREQBILLNO') CREATE INDEX IDX_SRC_PURREPORT_FREQBILLNO ON T_SRC_PURREPORT ( FREQBILLNO );


 EXEC P_ALTERPK 'PK_SRC_PURREPORTASSESS', 'T_SRC_PURREPORTASSESS', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURREPORTPROS', 'T_SRC_PURREPORTPROS', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_PURREPORTSOURCE', 'T_SRC_PURREPORTSOURCE', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_QUESTION', 'T_SRC_QUESTION', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_QUESTION_BILLNO') CREATE INDEX IDX_SRC_QUESTION_BILLNO ON T_SRC_QUESTION ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_QUESTION_CREATETIME') CREATE INDEX IDX_SRC_QUESTION_CREATETIME ON T_SRC_QUESTION ( FCREATETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_QUESTION_PACKAGE') CREATE INDEX IDX_SRC_QUESTION_PACKAGE ON T_SRC_QUESTION ( FPACKAGEID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_QUESTION_PUBLISHTYPE') CREATE INDEX IDX_SRC_QUESTION_PUBLISHTYPE ON T_SRC_QUESTION ( FPUBLISHTYPE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_QUESTION_SUPPLIER') CREATE INDEX IDX_SRC_QUESTION_SUPPLIER ON T_SRC_QUESTION ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_QUESTION_L', 'T_SRC_QUESTION_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_QUITENTRY', 'T_SRC_QUITENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_QUOTE_DETAILS', 'T_SRC_QUOTE_DETAILS', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_QUOTE_DETAILS_SUP') CREATE INDEX IDX_SRC_QUOTE_DETAILS_SUP ON T_SRC_QUOTE_DETAILS ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_QUOTEBILL', 'T_SRC_QUOTEBILL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_QUOTEBILL_BILLDATE') CREATE INDEX IDX_SRC_QUOTEBILL_BILLDATE ON T_SRC_QUOTEBILL ( FBILLDATE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_QUOTEBILL_BILLNO') CREATE INDEX IDX_SRC_QUOTEBILL_BILLNO ON T_SRC_QUOTEBILL ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_QUOTEBILL_PARENTID') CREATE INDEX IDX_SRC_QUOTEBILL_PARENTID ON T_SRC_QUOTEBILL ( FPARENTID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_QUOTEBILL_SUPPLIER') CREATE INDEX IDX_SRC_QUOTEBILL_SUPPLIER ON T_SRC_QUOTEBILL ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_RATIOCHG', 'T_SRC_RATIOCHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_RATIOCHG_PARENT') CREATE INDEX IDX_SRC_RATIOCHG_PARENT ON T_SRC_RATIOCHG ( FPARENTID );

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


 EXEC P_ALTERPK 'PK_SRC_RATIOCHGENTRY', 'T_SRC_RATIOCHGENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_REFERENCETYPE', 'T_SRC_REFERENCETYPE', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_REFTYPE_EID') CREATE INDEX IDX_SRC_REFTYPE_EID ON T_SRC_REFERENCETYPE ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_RESDETAILS', 'T_SRC_RESDETAILS', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_RESDETAILS_PID') CREATE INDEX IDX_SRC_RESDETAILS_PID ON T_SRC_RESDETAILS ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_REVIEWHEAD', 'T_SRC_REVIEWHEAD', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_REVIEWHEAD_PARENTID') CREATE INDEX IDX_SRC_REVIEWHEAD_PARENTID ON T_SRC_REVIEWHEAD ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_REVIEWMONEY', 'T_SRC_REVIEWMONEY', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_REVIEWMONEY_PARENTID') CREATE INDEX IDX_SRC_REVIEWMONEY_PARENTID ON T_SRC_REVIEWMONEY ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_REVIEWMONEY_BODY', 'T_SRC_REVIEWMONEY_BODY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_REVIEWTAIL', 'T_SRC_REVIEWTAIL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_REVIEWTAIL_PARENTID') CREATE INDEX IDX_SRC_REVIEWTAIL_PARENTID ON T_SRC_REVIEWTAIL ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_REVIEWTAIL_BODY', 'T_SRC_REVIEWTAIL_BODY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_RISKSUPPLIER', 'T_SRC_RISKSUPPLIER', 'FENTRYID2', '1';

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


 EXEC P_ALTERPK 'PK_SRC_ROLE', 'T_SRC_ROLE', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_ROLE_L', 'T_SRC_ROLE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_ROLEDEPT', 'T_SRC_ROLEDEPT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_ROLEENTRY', 'T_SRC_ROLEENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SCHEME', 'T_SRC_SCHEME', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCHEME_FCREATETIME') CREATE INDEX IDX_SRC_SCHEME_FCREATETIME ON T_SRC_SCHEME ( FCREATETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCHEME_FINDEXTYPEID') CREATE INDEX IDX_SRC_SCHEME_FINDEXTYPEID ON T_SRC_SCHEME ( FINDEXTYPEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCHEME_FMASTERID') CREATE INDEX IDX_SRC_SCHEME_FMASTERID ON T_SRC_SCHEME ( FMASTERID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCHEME_FSOURCEID') CREATE INDEX IDX_SRC_SCHEME_FSOURCEID ON T_SRC_SCHEME ( FSOURCEID );


 EXEC P_ALTERPK 'PK_SRC_SCHEME_L', 'T_SRC_SCHEME_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCHEME_L_FNAME') CREATE INDEX IDX_SRC_SCHEME_L_FNAME ON T_SRC_SCHEME_L ( FNAME );


 EXEC P_ALTERPK 'PK_SRC_SCHEMECATEGORY', 'T_SRC_SCHEMECATEGORY', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SCHEMEINDEX', 'T_SRC_SCHEMEINDEX', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCHEMEINDEX_FINDEX') CREATE INDEX IDX_SRC_SCHEMEINDEX_FINDEX ON T_SRC_SCHEMEINDEX ( FINDEX );


 EXEC P_ALTERPK 'PK_SRC_SCHEMEPROJECT', 'T_SRC_SCHEMEPROJECT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SCHEMEPURDEPT', 'T_SRC_SCHEMEPURDEPT', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SCHEMEPURGROUP', 'T_SRC_SCHEMEPURGROUP', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SCHEMEPURORG', 'T_SRC_SCHEMEPURORG', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SCORE', 'T_SRC_SCORE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCORE_FBILLNO') CREATE INDEX IDX_SRC_SCORE_FBILLNO ON T_SRC_SCORE ( FBILLNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCORE_PACKAGEID') CREATE INDEX IDX_SRC_SCORE_PACKAGEID ON T_SRC_SCORE ( FPACKAGEID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCORE_SUPID') CREATE INDEX IDX_SRC_SCORE_SUPID ON T_SRC_SCORE ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_SCOREDETAIL', 'T_SRC_SCOREDETAIL', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCOREDETAIL_ENTRYID') CREATE INDEX IDX_SRC_SCOREDETAIL_ENTRYID ON T_SRC_SCOREDETAIL ( FENTRYID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCOREDETAIL_PARENTID') CREATE INDEX IDX_SRC_SCOREDETAIL_PARENTID ON T_SRC_SCOREDETAIL ( FPARENTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCOREDETAIL_SCORERID') CREATE INDEX IDX_SRC_SCOREDETAIL_SCORERID ON T_SRC_SCOREDETAIL ( FSCORERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCOREDETAIL_SUPID') CREATE INDEX IDX_SRC_SCOREDETAIL_SUPID ON T_SRC_SCOREDETAIL ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_SCOREENTRY', 'T_SRC_SCOREENTRY', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SCOREENTRY_INDEXID') CREATE INDEX IDX_SRC_SCOREENTRY_INDEXID ON T_SRC_SCOREENTRY ( FINDEXID );


 EXEC P_ALTERPK 'PK_SRC_SELLINVITSUP', 'T_SRC_SELLINVITSUP', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SERVICEMSG', 'T_SRC_SERVICEMSG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SERVICEMSG_FCREATORID') CREATE INDEX IDX_SRC_SERVICEMSG_FCREATORID ON T_SRC_SERVICEMSG ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_SERVICEMSG_L', 'T_SRC_SERVICEMSG_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SERVICEMSG_FLOCALEID') CREATE INDEX IDX_SRC_SERVICEMSG_FLOCALEID ON T_SRC_SERVICEMSG_L ( FLOCALEID );


 EXEC P_ALTERPK 'PK_SRC_SERVICETYPE', 'T_SRC_SERVICETYPE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SERVICETYPE_FCREATORID') CREATE INDEX IDX_SRC_SERVICETYPE_FCREATORID ON T_SRC_SERVICETYPE ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_SERVICETYPE_L', 'T_SRC_SERVICETYPE_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SERVICETYPE_LFLOCALEID') CREATE INDEX IDX_SRC_SERVICETYPE_LFLOCALEID ON T_SRC_SERVICETYPE_L ( FLOCALEID );


 EXEC P_ALTERPK 'PK_SRC_SETTINGTPL', 'T_SRC_SETTINGTPL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SETTINGTPL_FCREATORID') CREATE INDEX IDX_SRC_SETTINGTPL_FCREATORID ON T_SRC_SETTINGTPL ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_SETTINGTPL_L', 'T_SRC_SETTINGTPL_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SIGNCHG', 'T_SRC_SIGNCHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SIGNCHG_PID') CREATE INDEX IDX_SRC_SIGNCHG_PID ON T_SRC_SIGNCHG ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_SIGNCHG_FJ', 'T_SRC_SIGNCHG_FJ', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SIGNCHG_DID') CREATE INDEX IDX_SRC_SIGNCHG_DID ON T_SRC_SIGNCHG_FJ ( FDETAILID );


 EXEC P_ALTERPK 'PK_SRC_SIGNCHGENTRY', 'T_SRC_SIGNCHGENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SIGNCHGSIGN', 'T_SRC_SIGNCHGSIGN', 'FDETAILID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SIGNCHGSIGN_EID') CREATE INDEX IDX_SRC_SIGNCHGSIGN_EID ON T_SRC_SIGNCHGSIGN ( FENTRYID );


 EXEC P_ALTERPK 'PK_SRC_SRMREGIONENTRY', 'T_SRC_SRMREGIONENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SRMREGIONGROUP', 'T_SRC_SRMREGIONGROUP', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SRMREGIONGROUP_L', 'T_SRC_SRMREGIONGROUP_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SUPCERTIFICAT', 'T_SRC_SUPCERTIFICAT', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_SUPPLIER_TMP', 'T_SRC_SUPPLIER_TMP', 'FID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SUPPLIER_TMP_MID') CREATE INDEX IDX_SRC_SUPPLIER_TMP_MID ON T_SRC_SUPPLIER_TMP ( FMASTERID );


 EXEC P_ALTERPK 'PK_SRC_SUPPLIER_TMP_L', 'T_SRC_SUPPLIER_TMP_L', 'FPKID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_SUP_TMP_L_NAME') CREATE INDEX IDX_SRC_SUP_TMP_L_NAME ON T_SRC_SUPPLIER_TMP_L ( FNAME );


 EXEC P_ALTERPK 'PK_SRC_SUPQUIT', 'T_SRC_SUPQUIT', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_TEMPLETE', 'T_SRC_TEMPLETE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_TEMPLETE_FCREATORID') CREATE INDEX IDX_SRC_TEMPLETE_FCREATORID ON T_SRC_TEMPLETE ( FCREATORID );


 EXEC P_ALTERPK 'PK_SRC_TEMPLETE_L', 'T_SRC_TEMPLETE_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_TEMPLETE_L_FLOCALEID') CREATE INDEX IDX_SRC_TEMPLETE_L_FLOCALEID ON T_SRC_TEMPLETE_L ( FLOCALEID );


 EXEC P_ALTERPK 'PK_SRC_TIMECHG', 'T_SRC_TIMECHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_TIMECHG_PID') CREATE INDEX IDX_SRC_TIMECHG_PID ON T_SRC_TIMECHG ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_TRANSFER', 'T_SRC_TRANSFER', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_TRANSFER_PID') CREATE INDEX IDX_SRC_TRANSFER_PID ON T_SRC_TRANSFER ( FPARENTID );

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


 EXEC P_ALTERPK 'PK_SRC_TRANSFERENTRY', 'T_SRC_TRANSFERENTRY', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_TRANENTRY_CID') CREATE INDEX IDX_SRC_TRANENTRY_CID ON T_SRC_TRANSFERENTRY ( FCATEGORYID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_TRANENTRY_PID') CREATE INDEX IDX_SRC_TRANENTRY_PID ON T_SRC_TRANSFERENTRY ( FPACKAGEID );


 EXEC P_ALTERPK 'PK_SRC_USUALUSER', 'T_SRC_USUALUSER', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_USUALUSER_CKEY') CREATE INDEX IDX_SRC_USUALUSER_CKEY ON T_SRC_USUALUSER ( FCOMPKEY );


 EXEC P_ALTERPK 'PK_SRC_USUALUSERENTRY', 'T_SRC_USUALUSERENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_VIE_DETAIL', 'T_SRC_VIE_DETAIL', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_VIE_DETAIL_SID') CREATE INDEX IDX_SRC_VIE_DETAIL_SID ON T_SRC_VIE_DETAIL ( FSUPPLIERID );


 EXEC P_ALTERPK 'PK_SRC_WAITINGDEC', 'T_SRC_WAITINGDEC', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_WAITINGDEC_PID') CREATE INDEX IDX_SRC_WAITINGDEC_PID ON T_SRC_WAITINGDEC ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_WINNUMCHG', 'T_SRC_WINNUMCHG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_WINNUMCHG_PID') CREATE INDEX IDX_SRC_WINNUMCHG_PID ON T_SRC_WINNUMCHG ( FPARENTID );


 EXEC P_ALTERPK 'PK_SRC_YEARINFO', 'T_SRC_YEARINFO', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_YEARINFO_APPLYNO') CREATE INDEX IDX_SRC_YEARINFO_APPLYNO ON T_SRC_YEARINFO ( FAPPLYNO11 );

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



/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\SRC_constraint.sql **/
