INSERT INTO `mydb`.`events` (`idx`, `name`, `thumbnail`, `status`) VALUES ('3', '1폴미당,올미당첨 이벤트', 'event/03.jpg', '1');
INSERT INTO `mydb`.`events` (`idx`, `name`, `thumbnail`, `status`) VALUES ('4', '다폴더 연승, 연패 이벤트', 'event/04.jpg', '0');
INSERT INTO `mydb`.`events` (`idx`, `name`, `thumbnail`, `status`) VALUES ('5', '지인추천 이벤트', 'event/05.jpg', '0');

CREATE TABLE `notices` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT '',
  `thumbnail` varchar(1024) DEFAULT '',
  `detail` varchar(1024) DEFAULT '',
  `status` tinyint(4) DEFAULT 1 COMMENT '0-미사용, 1-사용',
  `del_flag` tinyint(4) DEFAULT 0 COMMENT '0-존재, 1-삭제됨',
  `create_dt` datetime DEFAULT current_timestamp(),
  `update_dt` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `delete_dt` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`idx`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='공지테이블';

INSERT INTO `mydb`.`notices` (`name`, `thumbnail`, `status`, `del_flag`) VALUES ('경기별 베팅 금액 안내', 'notice/11.jpg', '1', '0');
INSERT INTO `mydb`.`notices` (`name`, `thumbnail`, `status`, `del_flag`) VALUES ('마틴, 루틴 허용', 'notice/02.jpg', '1', '0');
INSERT INTO `mydb`.`notices` (`name`, `thumbnail`, `status`, `del_flag`) VALUES ('롤링 규정', 'notice/03.jpg', '1', '0');
INSERT INTO `mydb`.`notices` (`name`, `thumbnail`, `status`, `del_flag`) VALUES ('텔레그램 알림방', 'notice/04.jpg', '1', '0');
INSERT INTO `mydb`.`notices` (`name`, `thumbnail`, `status`, `del_flag`) VALUES ('코인 충전 안내', 'notice/12.jpg', '1', '0');
INSERT INTO `mydb`.`notices` (`name`, `thumbnail`, `status`, `del_flag`) VALUES ('양방베팅 제재 안내', 'notice/13.jpg', '1', '0');

ALTER TABLE `mydb`.`events` 
CHANGE COLUMN `detail` `detail` TEXT NULL DEFAULT '' ;

ALTER TABLE `mydb`.`events` 
ADD INDEX `thumbnail` (`thumbnail` ASC);

-- 미사용
CREATE TABLE `leagues_image_name` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL COMMENT '이미지명',
  PRIMARY KEY (`idx`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('AFC-Champion-league.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('eredivisie.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('kbl.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('laliga.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('mlb.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('NHL.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('serie-a.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('uefa-euro-2020.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('v-league.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('worldcup.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('bundesliga.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('euro21.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('kbo.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('ligue1.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('nba.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('nbp.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('starcraft2.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('uefa-europa.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('v-league-w.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('epl.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('hockey-chl.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('k-league.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('lol.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('NFL.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('olympic.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('uefa-cl.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('ufc.png');
INSERT INTO `mydb`.`leagues_image_name` (`name`) VALUES ('wkbl.png');

