-- migrate:up
CREATE INDEX idx_orders_shop_id ON orders (shop_id);
CREATE INDEX idx_orders_order_sn ON orders (order_sn);
CREATE INDEX idx_shop_platform_id ON shop (platform_id);
CREATE INDEX idx_orders_packing_queue_order_sn ON orders_packing_queue (order_sn);
CREATE INDEX idx_warehouse_zipcode ON warehouse (zipcode);
CREATE INDEX idx_orders_zipcode ON orders (zipcode);

-- migrate:down
ALTER TABLE orders DROP INDEX idx_orders_shop_id;
ALTER TABLE orders DROP INDEX idx_orders_order_sn;
ALTER TABLE shop DROP INDEX idx_shop_platform_id;
ALTER TABLE orders_packing_queue DROP INDEX idx_orders_packing_queue_order_sn;
ALTER TABLE warehouse DROP INDEX idx_warehouse_zipcode;
ALTER TABLE orders DROP INDEX idx_orders_zipcode;
