/**Begin D:\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\SIM_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_VATINVO_ITEM_FGOODSCODE') CREATE INDEX IDX_VATINVO_ITEM_FGOODSCODE ON T_SIM_VATINVOICE_ITEM ( FGOODSCODE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_VATINVOICE_FISSUETIME') CREATE INDEX IDX_VATINVOICE_FISSUETIME ON T_SIM_VATINVOICE ( FISSUETIME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_VATINVOICE_ORDERNO') CREATE INDEX IDX_VATINVOICE_ORDERNO ON T_SIM_VATINVOICE ( FORDERNO );

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