/**Begin D:\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\SIM_constraint.sql **/
EXEC p_DropIdx 'IDX_SIM_ORIGINAL_BILL_E', 'T_SIM_ORIGINAL_BILL_E';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SIM_ORIGINAL_BILL_E_CODENO') CREATE INDEX IDX_SIM_ORIGINAL_BILL_E_CODENO ON T_SIM_ORIGINAL_BILL_E ( FINVOICECODE ,FINVOICENO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SIM_ORIGINAL_BILL_E_CREATE') CREATE  CLUSTERED INDEX IDX_SIM_ORIGINAL_BILL_E_CREATE ON T_SIM_ORIGINAL_BILL_E ( FCREATEDATE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SIM_ORIGINAL_BILL_E_SEQ') CREATE INDEX IDX_SIM_ORIGINAL_BILL_E_SEQ ON T_SIM_ORIGINAL_BILL_E ( FORIGINBILLSEQ );


/**End D:\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\SIM_constraint.sql **/
