/**Begin D:\tmc\PDM_UPGRADE\pdm1\IFM_constraint.sql **/
EXEC P_ALTERPK 'PK_T_IFM_ACCOUNTFROZEN', 'T_IFM_ACCOUNTFROZEN', 'FID', '1';


IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_IFM_ACCOUNTFROZEN_FORGID') CREATE INDEX IDX_T_IFM_ACCOUNTFROZEN_FORGID ON T_IFM_ACCOUNTFROZEN ( FORGID );


IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_IFM_ACCOUNTFROZEN_FACCOUNTID') CREATE INDEX IDX_T_IFM_ACCOUNTFROZEN_FACCOUNTID ON T_IFM_ACCOUNTFROZEN ( FACCOUNTID );


EXEC P_ALTERPK 'PK_T_IFM_ACCOUNTFROZEN_L', 'T_IFM_ACCOUNTFROZEN_L', 'FPKID', '1';

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


/**End D:\tmc\PDM_UPGRADE\pdm1\IFM_constraint.sql **/
