CREATE DATABASE  IF NOT EXISTS `main_chosun_db` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `main_chosun_db`;
-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: 210.175.73.142    Database: main_chosun_db
-- ------------------------------------------------------
-- Server version	5.5.5-10.4.25-MariaDB-1:10.4.25+maria~bionic-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 SET NAMES utf8 ;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `main_banners`
--

DROP TABLE IF EXISTS `main_banners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `main_banners` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `thumbnail` varchar(1024) DEFAULT '',
  `display_type` tinyint(1) DEFAULT NULL COMMENT '표시 타입 (1: PC, 2: 모바일)',
  `status` tinyint(4) DEFAULT 1 COMMENT '0-미사용, 1-사용',
  `rank` tinyint(1) DEFAULT NULL COMMENT '배너순번',
  `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`),
  KEY `thumbnail` (`thumbnail`) USING BTREE
) ENGINE=MEMORY AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 COMMENT='배너 테이블';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `main_banners`
--

LOCK TABLES `main_banners` WRITE;
/*!40000 ALTER TABLE `main_banners` DISABLE KEYS */;
INSERT INTO `main_banners` VALUES (63,'banner/20220908193424_slideshow1_m.jpg',2,1,1,'2022-05-12 14:33:46','2022-09-08 19:35:33','2022-05-12 14:33:46'),(62,'banner/20220908193403_slideshow1_pc.jpg',1,1,1,'2022-05-12 14:33:09','2022-09-08 19:35:12','2022-05-12 14:33:09');
/*!40000 ALTER TABLE `main_banners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `main_events`
--

DROP TABLE IF EXISTS `main_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `main_events` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT '',
  `create_dt` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`idx`)
) ENGINE=MEMORY AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `main_events`
--

LOCK TABLES `main_events` WRITE;
/*!40000 ALTER TABLE `main_events` DISABLE KEYS */;
INSERT INTO `main_events` VALUES (27,'KBO 승패/언옵 이벤트','2023-03-31 19:39:03'),(26,'신규가입 이벤트','2023-02-10 18:50:05'),(25,'복귀자 이벤트','2023-02-09 18:41:06'),(24,'출석체크 이벤트','2023-01-05 15:17:56'),(22,'카지노 롤링규정','2023-01-05 12:37:19'),(18,'첫충/매충 이벤트','2022-10-13 11:18:56'),(15,'보너스 폴더 이벤트','2022-10-04 20:24:32'),(14,'지인 추천 이벤트','2022-10-04 20:23:48');
/*!40000 ALTER TABLE `main_events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `main_meh`
--

DROP TABLE IF EXISTS `main_meh`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `main_meh` (
  `id` varchar(64) NOT NULL,
  `nick_name` varchar(64) DEFAULT NULL COMMENT 't_log_cash u_key 와 연결 ',
  `money` int(11) DEFAULT NULL COMMENT '환전 금액 ',
  `create_dt` datetime DEFAULT current_timestamp()
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='환전 내역 ';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `main_meh`
--

LOCK TABLES `main_meh` WRITE;
/*!40000 ALTER TABLE `main_meh` DISABLE KEYS */;
INSERT INTO `main_meh` VALUES ('pjl9041','조은물',14050000,'2023-04-09 15:43:37'),('tjdtn5959','드가보자아아',2000000,'2023-04-09 15:37:04'),('ajswl4612','먼지맨',150000,'2023-04-09 01:07:14'),('bbogry1','뽀그라',200000,'2023-04-09 01:06:28'),('tjdtn5959','드가보자아아',1000000,'2023-04-08 21:38:46'),('klnrkd','진진지',4000000,'2023-04-08 21:37:13'),('uuu123','최홍만찌흐',500000,'2023-04-08 21:35:16'),('lee249','리쌍현',1500000,'2023-04-08 18:33:53');
/*!40000 ALTER TABLE `main_meh` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `main_menu_board`
--

DROP TABLE IF EXISTS `main_menu_board`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `main_menu_board` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `create_dt` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`idx`),
  KEY `member_idx_create_dt` (`create_dt`)
) ENGINE=MEMORY AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='메뉴 상단 ‘게시판’';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `main_menu_board`
--

LOCK TABLES `main_menu_board` WRITE;
/*!40000 ALTER TABLE `main_menu_board` DISABLE KEYS */;
INSERT INTO `main_menu_board` VALUES (16,'※ 카지노 이용불가 게임 안내','2023-03-12 13:39:00'),(15,'※ 미니게임 이용 규정안내','2023-01-21 02:30:01'),(14,'※ 카지노 이용 규정','2022-12-23 13:48:36'),(13,'※ 보험배팅 안내문','2022-10-14 11:50:59'),(11,'※ 리그별 배팅 금액 관련안내','2022-10-11 14:36:28'),(9,'※ 스포츠 종목별 공통규정','2022-09-26 17:44:43'),(7,'※ 축배팅 관련 안내문','2022-09-23 20:15:06'),(6,'※ 환전 규정 안내문','2022-09-23 19:59:38');
/*!40000 ALTER TABLE `main_menu_board` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `main_popups`
--

DROP TABLE IF EXISTS `main_popups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `main_popups` (
  `idx` int(11) NOT NULL AUTO_INCREMENT,
  `thumbnail` varchar(1024) DEFAULT '',
  `status` tinyint(4) DEFAULT 1 COMMENT '0-미사용, 1-사용',
  `rank` tinyint(1) DEFAULT NULL COMMENT '팝업순번',
  `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`),
  KEY `thumbnail` (`thumbnail`) USING BTREE
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='팝업 테이블';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `main_popups`
--

LOCK TABLES `main_popups` WRITE;
/*!40000 ALTER TABLE `main_popups` DISABLE KEYS */;
/*!40000 ALTER TABLE `main_popups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ppl_bet_game`
--

DROP TABLE IF EXISTS `ppl_bet_game`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `ppl_bet_game` (
  `fixture_id` int(11) NOT NULL,
  `start_dt` datetime DEFAULT current_timestamp(),
  `fixture_location_id` int(11) DEFAULT 0,
  `fixture_sport_id` int(11) DEFAULT 0,
  `bet_type` int(11) DEFAULT 0,
  `league_display_name` varchar(45) DEFAULT '',
  `league_name` varchar(45) DEFAULT '',
  `league_image_path` varchar(200) DEFAULT '',
  `p1_team_name` varchar(45) DEFAULT '',
  `p1_display_name` varchar(45) DEFAULT '',
  `p2_team_name` varchar(45) DEFAULT '',
  `p2_display_name` varchar(45) DEFAULT '',
  `total_bet_money` varchar(45) DEFAULT '',
  `bet_price` decimal(7,2) DEFAULT 0.00,
  `bet_name` varchar(45) DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='인기배팅게임';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ppl_bet_game`
--

LOCK TABLES `ppl_bet_game` WRITE;
/*!40000 ALTER TABLE `ppl_bet_game` DISABLE KEYS */;
INSERT INTO `ppl_bet_game` VALUES (10448409,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Nippon-Ham Fighters','니혼햄','Saitama Seibu Lions','세이부','0',1.82,'1'),(10448409,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Nippon-Ham Fighters','니혼햄','Saitama Seibu Lions','세이부','0',1.90,'2'),(10448387,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Chiba Lotte Marines','지바롯데','Orix Buffaloes','오릭스','0',1.82,'2'),(10448387,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Chiba Lotte Marines','지바롯데','Orix Buffaloes','오릭스','0',1.90,'1'),(10448417,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Hiroshima Toyo Carp','히로시마','Tokyo Yakult Swallows','야쿠르트','0',1.84,'2'),(10448417,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Hiroshima Toyo Carp','히로시마','Tokyo Yakult Swallows','야쿠르트','0',1.89,'1'),(10448418,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Yokohama Bay Stars','요코하마','Hanshin Tigers','한신','0',2.09,'1'),(10448418,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Yokohama Bay Stars','요코하마','Hanshin Tigers','한신','0',1.69,'2'),(10448424,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Rakuten Golden Eagles','라쿠텐','Fukuoka Softbank Hawks','소프트뱅크','0',2.01,'1'),(10448424,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Rakuten Golden Eagles','라쿠텐','Fukuoka Softbank Hawks','소프트뱅크','0',1.74,'2'),(10448413,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Chunichi Dragons','주니치 ','Yomiuri Giants','요미우리','0',1.82,'2'),(10448413,'2023-04-14 18:00:00',148,154914,1,'NPB','NPB','npb.png','Chunichi Dragons','주니치 ','Yomiuri Giants','요미우리','0',1.90,'1'),(10444052,'2023-04-14 18:30:00',154,154914,1,'KBO','KBO','kbo.png','Samsung Lions','삼성 ','Lotte Giants','롯데 ','0',1.67,'1'),(10444052,'2023-04-14 18:30:00',154,154914,1,'KBO','KBO','kbo.png','Samsung Lions','삼성 ','Lotte Giants','롯데 ','0',2.13,'2'),(10448866,'2023-04-14 18:30:00',154,154914,1,'KBO','KBO','kbo.png','SSG Landers','SSG ','NC Dinos','NC','0',1.87,'2'),(10448866,'2023-04-14 18:30:00',154,154914,1,'KBO','KBO','kbo.png','SSG Landers','SSG ','NC Dinos','NC','0',1.87,'1'),(10437208,'2023-04-14 18:30:00',154,154914,1,'KBO','KBO','kbo.png','KT Wiz','KT','Hanwha Eagles','한화','0',1.48,'1'),(10437208,'2023-04-14 18:30:00',154,154914,1,'KBO','KBO','kbo.png','KT Wiz','KT','Hanwha Eagles','한화','0',2.54,'2'),(10448865,'2023-04-14 18:30:00',154,154914,1,'KBO','KBO','kbo.png','LG Twins','LG','Doosan Bears','두산','0',1.77,'2'),(10448865,'2023-04-14 18:30:00',154,154914,1,'KBO','KBO','kbo.png','LG Twins','LG','Doosan Bears','두산','0',1.97,'1'),(10443879,'2023-04-14 18:30:00',154,154914,1,'KBO','KBO','kbo.png','Kiwoom Heroes','키움 ','KIA Tigers','KIA','0',1.73,'1'),(10443879,'2023-04-14 18:30:00',154,154914,1,'KBO','KBO','kbo.png','Kiwoom Heroes','키움 ','KIA Tigers','KIA','0',2.04,'2'),(10418084,'2023-04-14 19:00:00',154,48242,1,'KBL ','KBL','kbl.png','Changwon LG Sakers','LG','Seoul SK Knights','SK','0',2.07,'1'),(10418084,'2023-04-14 19:00:00',154,48242,1,'KBL ','KBL','kbl.png','Changwon LG Sakers','LG','Seoul SK Knights','SK','0',1.68,'2'),(10379472,'2023-04-15 01:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Cremonese','크레모네세','Empoli','엠폴리','0',3.28,'X'),(10379472,'2023-04-15 01:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Cremonese','크레모네세','Empoli','엠폴리','0',2.78,'2'),(10379472,'2023-04-15 01:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Cremonese','크레모네세','Empoli','엠폴리','0',2.59,'1'),(10379275,'2023-04-15 03:30:00',161,6046,1,'분데스리가','Bundesliga','bundesliga.png','FC Schalke 04','샬케','Hertha BSC','헤르타','0',2.42,'1'),(10379275,'2023-04-15 03:30:00',161,6046,1,'분데스리가','Bundesliga','bundesliga.png','FC Schalke 04','샬케','Hertha BSC','헤르타','0',3.04,'2'),(10379275,'2023-04-15 03:30:00',161,6046,1,'분데스리가','Bundesliga','bundesliga.png','FC Schalke 04','샬케','Hertha BSC','헤르타','0',3.30,'X');
/*!40000 ALTER TABLE `ppl_bet_game` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'main_chosun_db'
--

--
-- Dumping routines for database 'main_chosun_db'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-04-14 16:54:56
