etrade / dili-xtrade · Files

ALTER TABLE `dili_etrade`.`shop_cart_message` 
ADD INDEX `shopCartId`(`shop_cart_id`);

UPDATE dili_etrade.`order`  SET verify_state = 0 WHERE verify_state is null;
UPDATE dili_etrade.`order`  SET `state` = 2 WHERE `state` = 1;