
EXEC P_ALTERPK 'PK_FMM_MILESTONETPL', 'T_FMM_MILESTONETPL', 'FID', '1';

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


EXEC P_ALTERPK 'PK_FMM_MILESTONETPL_L', 'T_FMM_MILESTONETPL_L', 'FPKID', '1'; 

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


EXEC P_ALTERPK 'PK_FMM_MSTENTRY', 'T_FMM_MSTENTRY', 'FENTRYID', '1';
 
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FMM_MSTENTRY_FID') CREATE INDEX IDX_FMM_MSTENTRY_FID ON T_FMM_MSTENTRY ( FID );

           	
