CREATE TABLE `member_money_charge_sms` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `deposit_name` varchar(45) DEFAULT NULL COMMENT '입금자 명 ',
  `bank_id` int(11) DEFAULT 0 COMMENT '은행번호',
  `bank_name` varchar(45) DEFAULT 0 COMMENT '은행명',
  `money` int(11) DEFAULT NULL COMMENT '충전 금액 ',
  `status` int(11) DEFAULT NULL COMMENT '1: 입금 전 (신청) 2: 시간초과(완료) 3: 자동충전 완료 (완료) 4: 운영자 완료 \\\\n999: 오류',
  `create_dt` datetime DEFAULT current_timestamp(),
  `update_dt` datetime DEFAULT NULL COMMENT '처리 일자',
  `ori` text DEFAULT '' comment '원문',
  PRIMARY KEY (`idx`),
  KEY `st_bk_idx` (`deposit_name`,`bank_id`,`money`,`create_dt`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='입금sms 내역';

ALTER TABLE `mydb`.`lsports_sports` 
ADD COLUMN `display_order` INT(11) NULL DEFAULT 0 AFTER `input_refund_rate`;

UPDATE `mydb`.`lsports_sports` SET `display_order` = '1' WHERE (`idx` = '10');
UPDATE `mydb`.`lsports_sports` SET `display_order` = '1' WHERE (`idx` = '129');
UPDATE `mydb`.`lsports_sports` SET `display_order` = '2' WHERE (`idx` = '130');
UPDATE `mydb`.`lsports_sports` SET `display_order` = '3' WHERE (`idx` = '169');
UPDATE `mydb`.`lsports_sports` SET `display_order` = '2' WHERE (`idx` = '11');
UPDATE `mydb`.`lsports_sports` SET `display_order` = '3' WHERE (`idx` = '50');
UPDATE `mydb`.`lsports_sports` SET `display_order` = '4' WHERE (`idx` = '14');
UPDATE `mydb`.`lsports_sports` SET `display_order` = '4' WHERE (`idx` = '133');
UPDATE `mydb`.`lsports_sports` SET `display_order` = '5' WHERE (`idx` = '15');
UPDATE `mydb`.`lsports_sports` SET `display_order` = '6' WHERE (`idx` = '6');
UPDATE `mydb`.`lsports_sports` SET `display_order` = '6' WHERE (`idx` = '125');

INSERT INTO `mydb`.`account` (`idx`, `account_code`, `account_name`, `bank_id`) VALUES ('26', 'PaySharp', 'PaySharp', '7');

ALTER TABLE `mydb`.`account_level_list` 
ADD COLUMN `display_account_bank` VARCHAR(45) NULL DEFAULT '' AFTER `account_number`;


UPDATE `mydb`.`t_game_config` SET `set_type_val` = '5' WHERE (`idx` = '156');
UPDATE `mydb`.`t_game_config` SET `set_type_val` = '5' WHERE (`idx` = '157');
UPDATE `mydb`.`t_game_config` SET `set_type_val` = '5' WHERE (`idx` = '158');
UPDATE `mydb`.`t_game_config` SET `set_type_val` = '5' WHERE (`idx` = '159');
UPDATE `mydb`.`t_game_config` SET `set_type_val` = '5' WHERE (`idx` = '160');
UPDATE `mydb`.`t_game_config` SET `set_type_val` = '5' WHERE (`idx` = '161');
