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=25 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 (24,'출석체크 이벤트','2023-01-05 15:17:56'),(23,'카지노 페이백 이벤트','2023-01-05 12:38:03'),(22,'카지노 롤링규정','2023-01-05 12:37:19'),(18,'첫충/매충 이벤트','2022-10-13 11:18:56'),(16,'신규 가입 이벤트','2022-10-04 20:25:33'),(15,'보너스 폴더 이벤트','2022-10-04 20:24:32'),(14,'지인 추천 이벤트','2022-10-04 20:23:48'),(13,'스포츠 한폴더 이벤트','2022-10-04 20:23:06');
/*!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 ('akenflen','부자',3000000,'2023-01-27 04:35:20'),('rytjq','상영중',630000,'2023-01-27 04:34:41'),('ksw7622','망동',110000,'2023-01-27 01:00:42'),('wldn12','빅딜러',340000,'2023-01-27 00:34:33'),('dlwodn7788','돌건이',1500000,'2023-01-26 22:15:27'),('gug0413 ','히르',190000,'2023-01-26 21:50:41'),('ehdus12','고고고링',4760000,'2023-01-26 21:39:12'),('syranos','시라노스',270000,'2023-01-26 20:58:16');
/*!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=16 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 (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'),(8,'※ 배팅취소 안내문','2022-09-23 20:22:22'),(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 AUTO_INCREMENT=25 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 */;
INSERT INTO `main_popups` VALUES (24,'popup/20230109203312_사칭주의-팝업.png',1,1,'2023-01-09 20:33:13','2023-01-09 20:34:09','2023-01-09 20:33:13'),(17,'popup/20221011120918_조선 배너 1.jpg',1,1,'2022-10-11 12:09:21','2023-01-09 20:24:49','2022-10-11 12:09:21'),(15,'popup/20221011120901_조선배너.jpg',1,1,'2022-10-11 12:09:04','2022-10-11 12:09:04','2022-10-11 12:09:04');
/*!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 (9975460,'2023-01-27 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Tampa Bay Lightning','탬파베이 라이트닝','Boston Bruins','보스턴 브루인즈','132310',2.44,'1'),(9975460,'2023-01-27 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Tampa Bay Lightning','탬파베이 라이트닝','Boston Bruins','보스턴 브루인즈','132310',2.35,'2'),(9975460,'2023-01-27 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Tampa Bay Lightning','탬파베이 라이트닝','Boston Bruins','보스턴 브루인즈','132310',4.10,'X'),(9970894,'2023-01-27 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Washington Capitals','워싱턴 캐피털스','Pittsburgh Penguins','피츠버그 펭귄즈','10000',2.21,'1'),(9970894,'2023-01-27 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Washington Capitals','워싱턴 캐피털스','Pittsburgh Penguins','피츠버그 펭귄즈','10000',2.57,'2'),(9970894,'2023-01-27 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Washington Capitals','워싱턴 캐피털스','Pittsburgh Penguins','피츠버그 펭귄즈','10000',4.20,'X'),(9975458,'2023-01-27 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Montreal Canadiens','몬트리얼 캐내디언스','Detroit Red Wings','디트로이트 레드 윙스','0',3.04,'1'),(9975458,'2023-01-27 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Montreal Canadiens','몬트리얼 캐내디언스','Detroit Red Wings','디트로이트 레드 윙스','0',1.95,'2'),(9975458,'2023-01-27 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Montreal Canadiens','몬트리얼 캐내디언스','Detroit Red Wings','디트로이트 레드 윙스','0',4.24,'X'),(9978314,'2023-01-27 09:30:00',4,48242,1,'NBA','NBA','nba.png','Boston Celtics','보스턴','New York Knicks','뉴욕닉스','393921',1.25,'1'),(9978314,'2023-01-27 09:30:00',4,48242,1,'NBA','NBA','nba.png','Boston Celtics','보스턴','New York Knicks','뉴욕닉스','393921',3.76,'2'),(9978316,'2023-01-27 09:40:00',4,48242,1,'NBA','NBA','nba.png','Brooklyn Nets','브루클린','Detroit Pistons','디트로이트 피스톤스','954382',1.24,'1'),(9978316,'2023-01-27 09:40:00',4,48242,1,'NBA','NBA','nba.png','Brooklyn Nets','브루클린','Detroit Pistons','디트로이트 피스톤스','954382',3.82,'2'),(9978315,'2023-01-27 09:40:00',4,48242,1,'NBA','NBA','nba.png','Charlotte Hornets','샬럿','Chicago Bulls','시카고','833341',2.87,'1'),(9978315,'2023-01-27 09:40:00',4,48242,1,'NBA','NBA','nba.png','Charlotte Hornets','샬럿','Chicago Bulls','시카고','833341',1.40,'2'),(9975464,'2023-01-27 10:00:00',4,35232,1,'NHL','NHL','NHL.png','Winnipeg Jets','위니펙 제츠','Buffalo Sabres','버팔로 사브레즈','47000',1.86,'1'),(9975464,'2023-01-27 10:00:00',4,35232,1,'NHL','NHL','NHL.png','Winnipeg Jets','위니펙 제츠','Buffalo Sabres','버팔로 사브레즈','47000',3.22,'2'),(9975464,'2023-01-27 10:00:00',4,35232,1,'NHL','NHL','NHL.png','Winnipeg Jets','위니펙 제츠','Buffalo Sabres','버팔로 사브레즈','47000',4.34,'X'),(9975463,'2023-01-27 10:00:00',4,35232,1,'NHL','NHL','NHL.png','Minnesota Wild','미네소타 와일드','Philadelphia Flyers','필라델피아 플라이어스','37000',1.69,'1'),(9975463,'2023-01-27 10:00:00',4,35232,1,'NHL','NHL','NHL.png','Minnesota Wild','미네소타 와일드','Philadelphia Flyers','필라델피아 플라이어스','37000',3.75,'2'),(9975463,'2023-01-27 10:00:00',4,35232,1,'NHL','NHL','NHL.png','Minnesota Wild','미네소타 와일드','Philadelphia Flyers','필라델피아 플라이어스','37000',4.48,'X'),(9975467,'2023-01-27 10:00:00',4,35232,1,'NHL','NHL','NHL.png','Nashville Predators','내슈빌 프레더터스','New Jersey Devils','뉴저지 데블스','0',2.61,'1'),(9975467,'2023-01-27 10:00:00',4,35232,1,'NHL','NHL','NHL.png','Nashville Predators','내슈빌 프레더터스','New Jersey Devils','뉴저지 데블스','0',2.22,'2'),(9975467,'2023-01-27 10:00:00',4,35232,1,'NHL','NHL','NHL.png','Nashville Predators','내슈빌 프레더터스','New Jersey Devils','뉴저지 데블스','0',4.13,'X'),(9978416,'2023-01-27 10:10:00',4,48242,1,'NBA','NBA','nba.png','Houston Rockets','휴스턴','Cleveland Cavaliers','클리블랜드','303332',3.91,'1'),(9978416,'2023-01-27 10:10:00',4,48242,1,'NBA','NBA','nba.png','Houston Rockets','휴스턴','Cleveland Cavaliers','클리블랜드','303332',1.23,'2'),(9975457,'2023-01-27 11:00:00',4,35232,1,'NHL','NHL','NHL.png','Colorado Avalanche','콜로라도 아발란치','Anaheim Ducks','애너하임 덕스','10000',1.41,'1'),(9975457,'2023-01-27 11:00:00',4,35232,1,'NHL','NHL','NHL.png','Colorado Avalanche','콜로라도 아발란치','Anaheim Ducks','애너하임 덕스','10000',5.71,'2'),(9975457,'2023-01-27 11:00:00',4,35232,1,'NHL','NHL','NHL.png','Colorado Avalanche','콜로라도 아발란치','Anaheim Ducks','애너하임 덕스','10000',5.29,'X'),(9975462,'2023-01-27 11:00:00',4,35232,1,'NHL','NHL','NHL.png','Arizona Coyotes','애리조나 코요테즈','St. Louis Blues','세인트 루이스 블루즈','10000',2.94,'1');
/*!40000 ALTER TABLE `ppl_bet_game` ENABLE KEYS */;
UNLOCK TABLES;
/*!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-01-27  4:58:16
