-- migrate:up
CREATE TABLE shop_action (
    id INT AUTO_INCREMENT PRIMARY KEY,
    shop_code VARCHAR(255) NOT NULL,
    shop_id VARCHAR(255) NOT NULL,
    shop_group VARCHAR(255) NULL,
    UNIQUE KEY unique_shop_id (shop_code, shop_id)
);

INSERT INTO shop_action (shop_code, shop_id) VALUES
('lazada', '401802688820'),
('lazada', '400604394286'),
('lazada', '400704840868'),
('tiktok_wiselie', '7494083458844100167'),
('tiktok_wiselie', '7495864327563610976'),
('tiktok_bacuya', '7495478115225471808'),
('shopee_bacuya', '994714165'),
('shopee_bacuya', '1446472869'),
('shopee_bacuya', '1447835562'),
('shopee_bacuya', '1447873552'),
('shopee_bacuya', '1447851623'),
('shopee_wiselie', '45731173'),
('shopee_wiselie', '1392461066'),
('shopee_wiselie', '1140703925'),
('shopee_wiselie', '1140669011'),
('shopee_wiselie', '1152755857'),
('shopee_wiselie', '1170456475'),
('shopee_wiselie', '1156725610'),
('shopee_wiselie', '1140743965'),
('shopee_wiselie', '1148080842'),
('shopee_wiselie', '1140716776'),
('shopee_wiselie', '1367886351'),
('shopee_wiselie', '1367899595'),
('shopee_wiselie', '1386218153'),
('shopee_wiselie', '1152869841'),
('shopee_wiselie', '1392470592'),
('shopee_wiselie', '1152760017'),
('shopee_wiselie', '1392480508'),
('shopee_wiselie', '1392373475'),
('shopee_wiselie', '1392371861'),
('shopee_wiselie', '1386230063'),
('shopee_wiselie', '1386229042'),
('shopee_wiselie', '1386228324'),
('shopee_wiselie', '1386227815'),
('shopee_wiselie', '1338717299'),
('shopee_wiselie', 'WII-70054');

-- migrate:down
DROP TABLE IF EXISTS shop_action;