/**Begin D:\PDM\pdm_upgrade\pdm_dev\ER_constraint.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_HOTEL_ORG_TIME') CREATE INDEX IDX_ER_HOTEL_ORG_TIME ON T_ER_HOTELBILL ( FCHECKINDATE ,FEXPCOMMITCOMNUM ,FEXPCOMMITDEPNUM );

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_PLANE_ORG_TIME') CREATE INDEX IDX_ER_PLANE_ORG_TIME ON T_ER_PLANEBILL ( FTAKEOFFTIME ,FEXPCOMMITCOMNUM ,FEXPCOMMITDEPNUM );


/**End D:\PDM\pdm_upgrade\pdm_dev\ER_constraint.sql **/
