/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\ER_constraint.sql 商旅各个订单表增加(预订人)索引 wenyue_chi **/


 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_AOB_FSOURCEBOOKEDID') CREATE INDEX IDX_ER_AOB_FSOURCEBOOKEDID ON T_ER_ALLORDERBILL ( FSOURCEBOOKEDID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_HBFSOURCEBOOKEDID') CREATE INDEX IDX_ER_HBFSOURCEBOOKEDID ON T_ER_HOTELBILL ( FSOURCEBOOKEDID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_PBFSOURCEBOOKEDID') CREATE INDEX IDX_ER_PBFSOURCEBOOKEDID ON T_ER_PLANEBILL ( FSOURCEBOOKEDID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_VBFSOURCEBOOKEDID') CREATE INDEX IDX_ER_VBFSOURCEBOOKEDID ON T_ER_VEHICLEBILL ( FSOURCEBOOKEDID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_TR_FSOURCEBOOKEDID') CREATE INDEX IDX_ER_TR_FSOURCEBOOKEDID ON T_ER_TRAINBILL ( FSOURCEBOOKEDID );


/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\ER_constraint.sql **/
