/**Begin D:\PDM_UPGRADE\PDM1\FCS_constraint.sql **/
 EXEC P_ALTERPK 'PK_FCS_BALANCEMODEL', 'T_FCS_BALANCEMODEL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FCS_BALANCEMODEL') CREATE INDEX IDX_FCS_BALANCEMODEL ON T_FCS_BALANCEMODEL ( FMODELTYPEID ,FBALANCETYPE );


 EXEC P_ALTERPK 'PK_FCS_BALANCEMODEL_ENTRY', 'T_FCS_BALANCEMODEL_ENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_FCS_BALANCEMODEL_L', 'T_FCS_BALANCEMODEL_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_FCS_BALANCEMODEL_TYPE', 'T_FCS_BALANCEMODEL_TYPE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FCS_BALANCEMODEL_TYPE') CREATE INDEX IDX_FCS_BALANCEMODEL_TYPE ON T_FCS_BALANCEMODEL_TYPE ( FNUMBER ,FSTATUS );


 EXEC P_ALTERPK 'PK_FCS_BALANCEMODEL_TYPE_L', 'T_FCS_BALANCEMODEL_TYPE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_FCS_BALANCEMODEL_BIZ', 'T_FCS_BALANCEMODEL_BIZ', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_FCS_BALANCEMODEL_BIZ') CREATE INDEX IDX_T_FCS_BALANCEMODEL_BIZ ON T_FCS_BALANCEMODEL_BIZ ( FID ,FBIZBILLID ,FACCOUNTBANKPROP );



/**End D:\PDM_UPGRADE\PDM1\FCS_constraint.sql **/
