INSERT INTO `t_game_config` (`u_level`, `set_type`, `set_type_val`, `title`) VALUES ('0', 'first_charge_status_onoff', 'ON', '첫 충전이후 상태변경');
INSERT INTO `t_game_config` (`u_level`, `set_type`, `set_type_val`, `title`) VALUES ('0', 'first_exchange_status_onoff', 'OFF', '첫 환전이후 상태변경');
INSERT INTO `t_game_config` (`u_level`, `set_type`, `set_type_val`, `title`) VALUES ('0', 'first_charge_exchange_status_onoff', 'OFF', '첫 충환전이후 상태변경');

ALTER TABLE `lsports_game_type` 
CHANGE COLUMN `name` `name` VARCHAR(24) NOT NULL DEFAULT '' ,
CHANGE COLUMN `ko_name` `ko_name` VARCHAR(24) NULL DEFAULT NULL ;

ALTER TABLE `lsports_game_type` 
ADD COLUMN `group_id` TINYINT(4) NULL DEFAULT 1 AFTER `id`,
ADD COLUMN `status_condition` ENUM('ON', 'OFF') NOT NULL DEFAULT 'ON' AFTER `status`,
ADD COLUMN `sort_order` TINYINT(4) NULL DEFAULT 0 COMMENT '어드민에서 사용' AFTER `status_condition`,
ADD COLUMN `is_use` ENUM('ON', 'OFF') NOT NULL DEFAULT 'ON' AFTER `sort_order`;



UPDATE `lsports_game_type` SET `name` = 'premiumship', `ko_name` = '가상축구(프리미어쉽)' WHERE (`id` = '8');


-- group
-- 2-파워볼 3-사다리, 4-레이싱 5-바카라
-- 6-가상축구 7-경마 8-개경주

INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('50', 'horse_festival', '가상경마(페스티발 다운스)', 'ON', 7);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('51', 'dog_hillside', '가상개경주(힐사이드 파크)', 'ON', 8);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('52', 'red_powerball', '네임드 레드파워볼', 'ON', 2);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('53', 'nxt_powerball', '넥스트게임 파워볼', 'ON', 2);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('54', 'sh_powerball_1', '슈어맨 파워볼(1분)', 'ON', 2);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('55', 'sh_powerball_2', '슈어맨 파워볼(2분)', 'ON', 2);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('56', 'sh_powerball_3', '슈어맨 파워볼(3분)', 'ON', 2);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('57', 'red_ladder', '네임드 레드파워사다리', 'ON', 3);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('58', 'nxt_ladder', '넥스트게임 사다리', 'ON', 3);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('59', 'sh_dadder_1', '슈어맨 사다리(1분)', 'ON', 3);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('60', 'sh_dadder_2', '슈어맨 사다리(2분)', 'ON', 3);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('61', 'sh_dadder_3', '슈어맨 사다리(3분)', 'ON', 3);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('62', 'nxt_bakara', '넥스트게임 바카라', 'ON', 5);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('63', 'sh_race_1', '슈어맨 레이싱(1분)', 'ON', 4);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('64', 'sh_race_2', '슈어맨 레이싱(2분)', 'ON', 4);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('65', 'sh_race_3', '슈어맨 레이싱(3분)', 'ON', 4);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('66', 'superleague', '가상축구(슈퍼리그)', 'ON', 6);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('67', 'worldcup', '가상축구(월드컵)', 'ON', 6);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('68', 'eurocup', '가상축구(유로컵)', 'ON', 6);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('69', 'dog_goldenhill', '가상개경주(골든힐 파크)', 'ON', 8);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('70', 'horse_britannia', '가상경마(브리티니아 웨이)', 'ON', 7);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('71', 'horse_victoria', '가상경마(빅토리아 파크)', 'ON', 7);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('72', 'prematch_combin_onoff', '스포츠 동일경기 조합', 'ON', 1);
INSERT INTO `lsports_game_type` (`id`, `name`, `ko_name`, `status`, `group_id`) VALUES ('73', 'realtime_combin_onoff', '실시간 동일경기 조합', 'ON', 1);

UPDATE `lsports_game_type` SET `sort_order` = '1' WHERE (`id` = '1');
UPDATE `lsports_game_type` SET `sort_order` = '2' WHERE (`id` = '2');
UPDATE `lsports_game_type` SET `sort_order` = '4' WHERE (`id` = '3');
UPDATE `lsports_game_type` SET `sort_order` = '5' WHERE (`id` = '4');
UPDATE `lsports_game_type` SET `sort_order` = '6' WHERE (`id` = '72');
UPDATE `lsports_game_type` SET `sort_order` = '3' WHERE (`id` = '73');
UPDATE `lsports_game_type` SET `sort_order` = '7' WHERE (`id` = '14');
UPDATE `lsports_game_type` SET `sort_order` = '9' WHERE (`id` = '11');
UPDATE `lsports_game_type` SET `sort_order` = '12' WHERE (`id` = '13');
UPDATE `lsports_game_type` SET `sort_order` = '13' WHERE (`id` = '9');
UPDATE `lsports_game_type` SET `sort_order` = '14' WHERE (`id` = '10');
UPDATE `lsports_game_type` SET `sort_order` = '15' WHERE (`id` = '5');
UPDATE `lsports_game_type` SET `sort_order` = '16' WHERE (`id` = '15');
UPDATE `lsports_game_type` SET `sort_order` = '17' WHERE (`id` = '52');
UPDATE `lsports_game_type` SET `sort_order` = '18' WHERE (`id` = '53');
UPDATE `lsports_game_type` SET `sort_order` = '19' WHERE (`id` = '54');
UPDATE `lsports_game_type` SET `sort_order` = '20' WHERE (`id` = '55');
UPDATE `lsports_game_type` SET `sort_order` = '21' WHERE (`id` = '56');
UPDATE `lsports_game_type` SET `sort_order` = '22' WHERE (`id` = '6');
UPDATE `lsports_game_type` SET `sort_order` = '23' WHERE (`id` = '7');
UPDATE `lsports_game_type` SET `sort_order` = '24' WHERE (`id` = '57');
UPDATE `lsports_game_type` SET `sort_order` = '25' WHERE (`id` = '58');
UPDATE `lsports_game_type` SET `sort_order` = '26' WHERE (`id` = '59');
UPDATE `lsports_game_type` SET `sort_order` = '27' WHERE (`id` = '60');
UPDATE `lsports_game_type` SET `sort_order` = '28' WHERE (`id` = '61');
UPDATE `lsports_game_type` SET `sort_order` = '29' WHERE (`id` = '63');
UPDATE `lsports_game_type` SET `sort_order` = '30' WHERE (`id` = '64');
UPDATE `lsports_game_type` SET `sort_order` = '31' WHERE (`id` = '65');
UPDATE `lsports_game_type` SET `sort_order` = '32' WHERE (`id` = '62');
UPDATE `lsports_game_type` SET `sort_order` = '33' WHERE (`id` = '8');
UPDATE `lsports_game_type` SET `sort_order` = '34' WHERE (`id` = '51');
UPDATE `lsports_game_type` SET `sort_order` = '35' WHERE (`id` = '50');
UPDATE `lsports_game_type` SET `sort_order` = '36' WHERE (`id` = '66');
UPDATE `lsports_game_type` SET `sort_order` = '41' WHERE (`id` = '67');
UPDATE `lsports_game_type` SET `sort_order` = '19' WHERE (`id` = '68');
UPDATE `lsports_game_type` SET `sort_order` = '37' WHERE (`id` = '69');
UPDATE `lsports_game_type` SET `sort_order` = '40' WHERE (`id` = '70');

UPDATE `lsports_game_type` SET `sort_order` = '38' WHERE (`id` = '70');
UPDATE `lsports_game_type` SET `sort_order` = '39' WHERE (`id` = '68');
UPDATE `lsports_game_type` SET `sort_order` = '40' WHERE (`id` = '71');

UPDATE `lsports_game_type` SET `is_use` = 'OFF' WHERE (`id` = '5');
UPDATE `lsports_game_type` SET `ko_name` = '엔트리 파워볼' WHERE (`id` = '15');
UPDATE `lsports_game_type` SET `ko_name` = '엔트리 파워사다리' WHERE (`id` = '6');
UPDATE `lsports_game_type` SET `ko_name` = '엔트리 키노사다리' WHERE (`id` = '7');

UPDATE `lsports_game_type` SET `group_id` = '3' WHERE (`id` = '6');
UPDATE `lsports_game_type` SET `group_id` = '3' WHERE (`id` = '7');
UPDATE `lsports_game_type` SET `group_id` = '6' WHERE (`id` = '8');
UPDATE `lsports_game_type` SET `group_id` = '7' WHERE (`id` = '50');
UPDATE `lsports_game_type` SET `group_id` = '8' WHERE (`id` = '51');

/*UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '3' WHERE (`id` = '57');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '3' WHERE (`id` = '58');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '3' WHERE (`id` = '59');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '3' WHERE (`id` = '60');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '3' WHERE (`id` = '61');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '5' WHERE (`id` = '62');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '4' WHERE (`id` = '63');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '4' WHERE (`id` = '64');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '4' WHERE (`id` = '65');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '6' WHERE (`id` = '66');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '6' WHERE (`id` = '67');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '6' WHERE (`id` = '68');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '8' WHERE (`id` = '69');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '7' WHERE (`id` = '70');
UPDATE `mydb_betgo`.`lsports_game_type` SET `group_id` = '7' WHERE (`id` = '71');*/





