/**Begin D:\ProgramFiles\PDM_UPGRADE\pdm1\FMM_constraint.sql **/
 EXEC P_ALTERPK 'PK_FMM_ISSUEENTRY', 'T_FMM_ISSUEENTRY', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FMM_ISSURY_FSEQ') CREATE INDEX IDX_FMM_ISSURY_FSEQ ON T_FMM_ISSUEENTRY ( FSEQ );


 EXEC P_ALTERPK 'PK_FMM_LICENSE', 'T_FMM_LICENSE', 'FID', '1';

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

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


 EXEC P_ALTERPK 'PK_FMM_LICENSE_L', 'T_FMM_LICENSE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_FMM_SIGNEDENTRY', 'T_FMM_SIGNEDENTRY', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FMM_SIGNRY_FSEQ') CREATE INDEX IDX_FMM_SIGNRY_FSEQ ON T_FMM_SIGNEDENTRY ( FSEQ );



/**End D:\ProgramFiles\PDM_UPGRADE\pdm1\FMM_constraint.sql **/
