CREATE DATABASE  IF NOT EXISTS `main_ddakbet_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `main_ddakbet_db`;
-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: 210.175.73.133    Database: main_ddakbet_db
-- ------------------------------------------------------
-- Server version	5.5.5-10.1.48-MariaDB-0ubuntu0.18.04.1

/*!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=133 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 (132,'banner/20230225190141_slideshow1_m.jpg',2,1,1,'2023-02-25 19:01:12','2023-02-25 19:01:53','2023-02-25 19:01:12'),(131,'banner/20230225190157_slideshow1_pc.jpg',1,1,1,'2023-02-25 19:00:07','2023-02-25 19:02:09','2023-02-25 19:00:07');
/*!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=198 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 (197,'지인추천 이벤트','2023-02-25 15:26:44'),(196,'보너스 배당 이벤트','2023-02-25 15:26:08'),(194,'신규가입 이벤트','2023-02-25 15:24:51'),(193,'추가보너스 이벤트','2023-02-25 15:24:17'),(192,'일일 이벤트','2023-02-25 15:19:05');
/*!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 ('aszx009','김으뜸',50000,'2023-02-27 22:16:55'),('ink77','잉크',300000,'2023-02-27 22:12:43'),('ddaksample1','닥 샘플',50000,'2023-02-27 15:49:02'),('ddak5','닥오',10000,'2023-02-25 18:07:14'),('ddak8','닥팔',10000,'2023-02-25 16:24:17'),('ddak7','닥칠',10000,'2023-02-25 12:53:46'),('ddak9','닥구',40000,'2023-02-24 11:48:31'),('dist_a_u2','dist_a_u2',5000000,'2022-09-22 18:09:47');
/*!40000 ALTER TABLE `main_meh` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `main_meh_top`
--

DROP TABLE IF EXISTS `main_meh_top`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `main_meh_top` (
  `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_top`
--

LOCK TABLES `main_meh_top` WRITE;
/*!40000 ALTER TABLE `main_meh_top` DISABLE KEYS */;
INSERT INTO `main_meh_top` VALUES ('ink77','잉크',300000,'2023-02-27 22:12:43'),('ddaksample1','닥 샘플',50000,'2023-02-27 15:49:02'),('aszx009','김으뜸',50000,'2023-02-27 22:16:55'),('ddak9','닥구',40000,'2023-02-24 11:48:31'),('ddak7','닥칠',10000,'2023-02-25 12:53:46'),('ddak8','닥팔',10000,'2023-02-25 16:24:17'),('ddak5','닥오',10000,'2023-02-25 18:07:14');
/*!40000 ALTER TABLE `main_meh_top` 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=19 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 (18,'텔레그램 고객센터 안내','2023-02-25 15:28:05'),(17,'양방,악성 베팅관련 안내','2023-02-25 15:27:36');
/*!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 (10174216,'2023-03-01 03:05:00',4,154914,1,'MLB','MLB','mlb.png','Pittsburgh Pirates','피츠버그','Baltimore Orioles','볼티모어','0',1.92,'1'),(10174216,'2023-03-01 03:05:00',4,154914,1,'MLB','MLB','mlb.png','Pittsburgh Pirates','피츠버그','Baltimore Orioles','볼티모어','0',1.83,'2'),(10174212,'2023-03-01 03:05:00',4,154914,1,'MLB','MLB','mlb.png','Minnesota Twins','미네소타','Atlanta Braves','애틀란타','0',1.88,'1'),(10174201,'2023-03-01 03:05:00',4,154914,1,'MLB','MLB','mlb.png','Tampa Bay Rays','탬파베이','New York Yankees','뉴욕양키즈','0',1.88,'2'),(10174212,'2023-03-01 03:05:00',4,154914,1,'MLB','MLB','mlb.png','Minnesota Twins','미네소타','Atlanta Braves','애틀란타','0',1.88,'2'),(10174201,'2023-03-01 03:05:00',4,154914,1,'MLB','MLB','mlb.png','Tampa Bay Rays','탬파베이','New York Yankees','뉴욕양키즈','0',1.88,'1'),(10174202,'2023-03-01 03:05:00',4,154914,1,'MLB','MLB','mlb.png','Washington Nationals','워싱턴','St. Louis Cardinals','세인트루이스','0',1.73,'2'),(10174202,'2023-03-01 03:05:00',4,154914,1,'MLB','MLB','mlb.png','Washington Nationals','워싱턴','St. Louis Cardinals','세인트루이스','0',2.06,'1'),(10174279,'2023-03-01 03:10:00',4,154914,1,'MLB','MLB','mlb.png','New York Mets','뉴욕메츠','Houston Astros','휴스턴','0',1.70,'1'),(10174279,'2023-03-01 03:10:00',4,154914,1,'MLB','MLB','mlb.png','New York Mets','뉴욕메츠','Houston Astros','휴스턴','0',2.10,'2'),(10174293,'2023-03-01 05:05:00',4,154914,1,'MLB','MLB','mlb.png','Texas Rangers','텍사스','Colorado Rockies','콜로라도','0',1.70,'1'),(10174293,'2023-03-01 05:05:00',4,154914,1,'MLB','MLB','mlb.png','Texas Rangers','텍사스','Colorado Rockies','콜로라도','0',2.10,'2'),(10174289,'2023-03-01 05:05:00',4,154914,1,'MLB','MLB','mlb.png','Oakland Athletics','오클랜드','Los Angeles Angels','LA에인절스','0',1.97,'1'),(10174289,'2023-03-01 05:05:00',4,154914,1,'MLB','MLB','mlb.png','Oakland Athletics','오클랜드','Los Angeles Angels','LA에인절스','0',1.80,'2'),(10174285,'2023-03-01 05:05:00',4,154914,1,'MLB','MLB','mlb.png','Los Angeles Dodgers','LA다저스','Cincinnati Reds','신시내티','0',1.52,'1'),(10174290,'2023-03-01 05:05:00',4,154914,1,'MLB','MLB','mlb.png','San Francisco Giants','샌프란시스코','San Diego Padres','샌디에이고','0',1.70,'1'),(10174285,'2023-03-01 05:05:00',4,154914,1,'MLB','MLB','mlb.png','Los Angeles Dodgers','LA다저스','Cincinnati Reds','신시내티','0',2.46,'2'),(10174290,'2023-03-01 05:05:00',4,154914,1,'MLB','MLB','mlb.png','San Francisco Giants','샌프란시스코','San Diego Padres','샌디에이고','0',2.10,'2'),(10174294,'2023-03-01 05:10:00',4,154914,1,'MLB','MLB','mlb.png','Arizona Diamondbacks','애리조나','Chicago White Sox','화이트삭스','0',2.01,'2'),(10174294,'2023-03-01 05:10:00',4,154914,1,'MLB','MLB','mlb.png','Arizona Diamondbacks','애리조나','Chicago White Sox','화이트삭스','0',1.76,'1'),(10174296,'2023-03-01 05:10:00',4,154914,1,'MLB','MLB','mlb.png','Milwaukee Brewers','밀워키','Chicago Cubs','시카고컵스','0',2.06,'2'),(10174296,'2023-03-01 05:10:00',4,154914,1,'MLB','MLB','mlb.png','Milwaukee Brewers','밀워키','Chicago Cubs','시카고컵스','0',1.73,'1'),(10174341,'2023-03-01 08:40:00',4,154914,1,'MLB','MLB','mlb.png','Miami Marlins','마이애미','Boston Red Sox','보스턴','0',1.97,'2'),(10174341,'2023-03-01 08:40:00',4,154914,1,'MLB','MLB','mlb.png','Miami Marlins','마이애미','Boston Red Sox','보스턴','0',1.80,'1'),(10169366,'2023-03-01 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Ottawa Senators','오타와 세너터스','Detroit Red Wings','디트로이트 레드 윙스','5000',2.20,'1'),(10169366,'2023-03-01 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Ottawa Senators','오타와 세너터스','Detroit Red Wings','디트로이트 레드 윙스','5000',4.22,'X'),(10169366,'2023-03-01 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Ottawa Senators','오타와 세너터스','Detroit Red Wings','디트로이트 레드 윙스','5000',2.59,'2'),(10169369,'2023-03-01 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Tampa Bay Lightning','탬파베이 라이트닝','Florida Panthers','플로리다 팬서스','0',3.04,'2'),(10169369,'2023-03-01 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Tampa Bay Lightning','탬파베이 라이트닝','Florida Panthers','플로리다 팬서스','0',4.49,'X'),(10169369,'2023-03-01 09:00:00',4,35232,1,'NHL','NHL','NHL.png','Tampa Bay Lightning','탬파베이 라이트닝','Florida Panthers','플로리다 팬서스','0',1.90,'1');
/*!40000 ALTER TABLE `ppl_bet_game` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'main_ddakbet_db'
--

--
-- Dumping routines for database 'main_ddakbet_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-02-28 21:29:09
