ALTER TABLE `mydb`.`lsports_markets` 
ADD COLUMN `display_order` INT(11) NULL DEFAULT 0 COMMENT '프론트 정렬 순서' AFTER `not_period`;

ALTER TABLE `mydb`.`member_bet_detail` 
ADD COLUMN `fixture_sport_id` INT(11) NULL DEFAULT 0 AFTER `fixture_start_date`,
ADD COLUMN `fixture_location_id` INT(11) NULL DEFAULT 0 AFTER `fixture_sport_id`,
ADD COLUMN `fixture_league_id` INT(11) NULL DEFAULT 0 AFTER `fixture_location_id`,
ADD COLUMN `fixture_participants_1_id` INT(11) NULL DEFAULT 0 AFTER `fixture_league_id`,
ADD COLUMN `fixture_participants_2_id` INT(11) NULL DEFAULT 0 AFTER `fixture_participants_1_id`;


-- 실시간
-- 축구
UPDATE `mydb`.`lsports_markets` SET `display_order` = '1' WHERE (`idx` = '2796');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '2' WHERE (`idx` = '2876');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '3' WHERE (`idx` = '2878');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '4' WHERE (`idx` = '2882');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '5' WHERE (`idx` = '25');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '6' WHERE (`idx` = '2877');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '7' WHERE (`idx` = '2879');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '8' WHERE (`idx` = '26');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '9' WHERE (`idx` = '2880');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '10' WHERE (`idx` = '2881');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '11' WHERE (`idx` = '2885');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '12' WHERE (`idx` = '2886');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '13' WHERE (`idx` = '2883');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '14' WHERE (`idx` = '2884');


-- 농구
UPDATE `mydb`.`lsports_markets` SET `display_order` = '1' WHERE (`idx` = '2806');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '2' WHERE (`idx` = '263');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '3' WHERE (`idx` = '2805');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '4' WHERE (`idx` = '2852');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '5' WHERE (`idx` = '2851');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '6' WHERE (`idx` = '46');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '7' WHERE (`idx` = '29');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '8' WHERE (`idx` = '47');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '9' WHERE (`idx` = '30');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '10' WHERE (`idx` = '48');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '11' WHERE (`idx` = '31');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '12' WHERE (`idx` = '2808');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '13' WHERE (`idx` = '2807');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '14' WHERE (`idx` = '44');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '15' WHERE (`idx` = '58');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '16' WHERE (`idx` = '37');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '17' WHERE (`idx` = '376');


-- 배구
UPDATE `mydb`.`lsports_markets` SET `display_order` = '1' WHERE (`idx` = '2853');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '3' WHERE (`idx` = '2854');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '2' WHERE (`idx` = '2859');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '4' WHERE (`idx` = '2860');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '6' WHERE (`idx` = '2861');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '8' WHERE (`idx` = '2862');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '5' WHERE (`idx` = '2855');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '7' WHERE (`idx` = '2856');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '9' WHERE (`idx` = '2857');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '10' WHERE (`idx` = '619');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '11' WHERE (`idx` = '2858');

-- 야구
UPDATE `mydb`.`lsports_markets` SET `display_order` = '1' WHERE (`idx` = '2873');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '2' WHERE (`idx` = '2867');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '3' WHERE (`idx` = '27');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '4' WHERE (`idx` = '2868');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '5' WHERE (`idx` = '28');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '6' WHERE (`idx` = '2869');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '7' WHERE (`idx` = '33');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '8' WHERE (`idx` = '32');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '9' WHERE (`idx` = '269');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '10' WHERE (`idx` = '273');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '11' WHERE (`idx` = '270');
UPDATE `mydb`.`lsports_markets` SET `display_order` = '12' WHERE (`idx` = '274');
