
 EXEC P_ALTERPK 'PK_PMPD_PROJECMCC', 'T_PMPD_PROJECT_MCC', 'FID', '1';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PMPD_PROJCT_FNUMBER') CREATE INDEX IDX_PMPD_PROJCT_FNUMBER ON T_PMPD_PROJECT_MCC ( FNUMBER );
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PMPD_PROJCT_FCREATETIME') CREATE INDEX IDX_PMPD_PROJCT_FCREATETIME ON T_PMPD_PROJECT_MCC ( FCREATETIME );
 
EXEC P_ALTERPK 'PK_PMPD_PROJECT_MCC_L', 'T_PMPD_PROJECT_MCC_L', 'FPKID', '1';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PMPD_PROJCTL_FID') CREATE INDEX IDX_PMPD_PROJCTL_FID ON T_PMPD_PROJECT_MCC_L ( FID,FLOCALEID );
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PMPD_PROJCTL_FNAME') CREATE INDEX IDX_PMPD_PROJCTL_FNAME ON T_PMPD_PROJECT_MCC_L ( FNAME );

