/**Begin D:\PDM_UPGRADE\PDM1\CAS_constraint.sql **/
 EXEC P_ALTERPK 'PK_CAS_COREBILL_SETTING', 'T_CAS_COREBILL_SETTING', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_COREBILL_SETTING') CREATE  CLUSTERED INDEX IDX_CAS_COREBILL_SETTING ON T_CAS_COREBILL_SETTING ( FNUMBER ,FENABLE );


 EXEC P_ALTERPK 'PK_CAS_COREBILL_SETTING_L', 'T_CAS_COREBILL_SETTING_L', 'FPKID', '0';

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


 EXEC P_ALTERPK 'PK_CAS_COREBILL_SETTING_OE', 'T_CAS_COREBILL_SETTING_OE', 'FENTRYID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_COREBILL_SETTING_OE') CREATE  CLUSTERED INDEX IDX_CAS_COREBILL_SETTING_OE ON T_CAS_COREBILL_SETTING_OE ( FID );


 EXEC P_ALTERPK 'PK_CAS_COREBILL_SETTING_PE', 'T_CAS_COREBILL_SETTING_PE', 'FENTRYID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_COREBILL_SETTING_PE') CREATE  CLUSTERED INDEX IDX_CAS_COREBILL_SETTING_PE ON T_CAS_COREBILL_SETTING_PE ( FID );


 EXEC P_ALTERPK 'PK_CAS_COREBILL_SETTING_QE', 'T_CAS_COREBILL_SETTING_QE', 'FENTRYID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_COREBILL_SETTING_QE') CREATE  CLUSTERED INDEX IDX_CAS_COREBILL_SETTING_QE ON T_CAS_COREBILL_SETTING_QE ( FID );


 EXEC P_ALTERPK 'PK_CAS_COREBILL_SETTING_RE', 'T_CAS_COREBILL_SETTING_RE', 'FENTRYID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_COREBILL_SETTING_RE') CREATE  CLUSTERED INDEX IDX_CAS_COREBILL_SETTING_RE ON T_CAS_COREBILL_SETTING_RE ( FID );



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