

 EXEC P_ALTERPK 'PK_PMPD_ASSPJMGINFO', 'T_PMPD_ASSPJMGINFO', 'FID', '1';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PMPD_ASSPFO_FNUMBER') CREATE INDEX IDX_PMPD_ASSPFO_FNUMBER ON T_PMPD_ASSPJMGINFO ( FNUMBER );
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PMPD_ASSPFO_FCREATETIME') CREATE INDEX IDX_PMPD_ASSPFO_FCREATETIME ON T_PMPD_ASSPJMGINFO ( FCREATETIME );
 
 
 EXEC P_ALTERPK 'PK_PMPD_ASSPJMGINFO_L', 'T_PMPD_ASSPJMGINFO_L', 'FPKID', '1';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PMPD_ASSPFOL_FID') CREATE INDEX IDX_PMPD_ASSPFOL_FID ON T_PMPD_ASSPJMGINFO_L ( FID,FLOCALEID );
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PMPD_ASSPFOL_FNAME') CREATE INDEX IDX_PMPD_ASSPFOL_FNAME ON T_PMPD_ASSPJMGINFO_L ( FNAME );
 
 
 EXEC P_ALTERPK 'PK_PMPD_ASSPJMGORG', 'T_PMPD_ASSPJMGORG', 'FPKID', '1';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PMPD_ASSPRG_FID') CREATE INDEX IDX_PMPD_ASSPRG_FID ON T_PMPD_ASSPJMGORG ( FID,FBASEDATAID );
 