CREATE DATABASE  IF NOT EXISTS `main_gm_db` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `main_gm_db`;
-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: 210.175.72.147    Database: main_gm_db
-- ------------------------------------------------------
-- Server version	5.5.5-10.4.26-MariaDB-1:10.4.26+maria~ubu1804-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=87 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 (86,'banner/20230220150006_1676864427235.png',1,1,1,'2023-01-16 19:04:23','2023-02-20 15:00:42','2023-01-16 19:04:23'),(84,'banner/20230219175240_1676793460054.png',2,1,1,'2023-01-16 18:22:14','2023-02-19 17:53:13','2023-01-16 18:22:14');
/*!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,'[텔레그램 친구추가] 이벤트','2022-10-03 23:09:30'),(23,'[겜블 신규가입 첫 충전] 이벤트','2022-09-21 16:59:41'),(22,'[겜블 골드템] 이벤트','2022-05-13 15:10:32'),(20,'[겜블 명탐정] 이벤트','2022-05-13 15:06:30'),(19,'[겜블 다폴더] 이벤트','2022-05-13 15:05:29'),(17,'[겜블 지원] 이벤트','2022-05-13 15:00:55'),(16,'[겜블 지인추천] 이벤트','2022-05-13 14:57:53'),(15,'[겜블 생일] 이벤트','2022-05-13 14:56:31');
/*!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 ('gkrtod132','누가가라',2270000,'2023-04-03 20:57:44'),('Kim2922','식껍',250000,'2023-04-03 20:54:27'),('qweas654','쥬립',3230000,'2023-04-03 20:48:31'),('twosip','시흥토토',1000000,'2023-04-03 20:47:08'),('lars0627','라스',500000,'2023-04-03 20:46:08'),('cjstk','딸기우유',1250000,'2023-04-03 20:44:03'),('raxz','며언',4600000,'2023-04-03 20:41:07'),('dyd1996','일호',120000,'2023-04-03 20:40:38');
/*!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=12 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 (11,'▶ 롤링규정 안내 [단폴/다폴더]','2023-02-15 08:55:43'),(10,'▶ 롤링규정 안내','2022-11-12 03:28:29'),(9,'▶ e-Sports 안내','2022-07-26 03:13:16'),(7,'▶ 슬롯/해쉬/카지노 안내','2022-05-19 21:06:42'),(6,'▶ 미니게임/가상축구 안내','2022-05-19 21:06:21'),(5,'▶ 배팅취소 및 악성제재 안내','2022-05-19 21:06:01'),(4,'▶ 등급별 이용 안내','2022-05-19 21:05:45'),(3,'▶ 스포츠 종목별 규정 안내','2022-05-19 21:05:30');
/*!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=37 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 (36,'popup/20230131003753_1652430451515.png',1,4,'2023-01-31 00:43:00','2023-01-31 00:43:00','2023-01-31 00:43:00'),(24,'popup/20230131003731_양방-배팅-회원-이용제한-안내.png',1,3,'2022-05-24 14:23:00','2023-01-31 00:42:47','2022-05-24 14:23:00'),(30,'popup/20230131003535_팝업수정건.png',1,2,'2022-06-01 08:43:51','2023-01-31 00:40:49','2022-06-01 08:43:51'),(34,'popup/20230131003501_신규가입-첫충전-팝업.png',1,1,'2023-01-29 01:05:02','2023-01-31 00:40:07','2023-01-29 01:05:02');
/*!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 (10250343,'2023-04-04 01:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Empoli','엠폴리','Lecce','레체','1774244',2.87,'X'),(10250343,'2023-04-04 01:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Empoli','엠폴리','Lecce','레체','1774244',2.55,'1'),(10250343,'2023-04-04 01:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Empoli','엠폴리','Lecce','레체','1774244',2.93,'2'),(10382417,'2023-04-04 03:10:00',4,154914,1,'MLB','MLB','mlb.png','Milwaukee Brewers','밀워키','New York Mets','뉴욕메츠','166200',1.97,'2'),(10382417,'2023-04-04 03:10:00',4,154914,1,'MLB','MLB','mlb.png','Milwaukee Brewers','밀워키','New York Mets','뉴욕메츠','166200',1.77,'1'),(10250344,'2023-04-04 03:45:00',215,6046,1,'세리에A','Serie A','serie-a.png','Sassuolo','사수올로','Torino','토리노','1695410',2.39,'1'),(10250344,'2023-04-04 03:45:00',215,6046,1,'세리에A','Serie A','serie-a.png','Sassuolo','사수올로','Torino','토리노','1695410',2.94,'2'),(10250344,'2023-04-04 03:45:00',215,6046,1,'세리에A','Serie A','serie-a.png','Sassuolo','사수올로','Torino','토리노','1695410',3.14,'X'),(10250376,'2023-04-04 04:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','Everton','에버튼','Tottenham Hotspur','토트넘 홋스퍼','7343864',2.12,'2'),(10250376,'2023-04-04 04:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','Everton','에버튼','Tottenham Hotspur','토트넘 홋스퍼','7343864',3.42,'1'),(10250376,'2023-04-04 04:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','Everton','에버튼','Tottenham Hotspur','토트넘 홋스퍼','7343864',3.26,'X'),(10250367,'2023-04-04 04:00:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Valencia','발렌시아','Rayo Vallecano','바예카노','1761944',3.13,'X'),(10250367,'2023-04-04 04:00:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Valencia','발렌시아','Rayo Vallecano','바예카노','1761944',3.71,'2'),(10250367,'2023-04-04 04:00:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Valencia','발렌시아','Rayo Vallecano','바예카노','1761944',2.06,'1'),(10382530,'2023-04-04 04:10:00',4,154914,1,'MLB','MLB','mlb.png','Chicago White Sox','화이트삭스','San Francisco Giants','샌프란시스코','142173',2.09,'2'),(10382530,'2023-04-04 04:10:00',4,154914,1,'MLB','MLB','mlb.png','Chicago White Sox','화이트삭스','San Francisco Giants','샌프란시스코','142173',1.68,'1'),(10382533,'2023-04-04 07:40:00',4,154914,1,'MLB','MLB','mlb.png','Miami Marlins','마이애미','Minnesota Twins','미네소타','930000',1.99,'1'),(10382533,'2023-04-04 07:40:00',4,154914,1,'MLB','MLB','mlb.png','Miami Marlins','마이애미','Minnesota Twins','미네소타','930000',1.75,'2'),(10382728,'2023-04-04 07:40:00',4,154914,1,'MLB','MLB','mlb.png','Cincinnati Reds','신시내티','Chicago Cubs','시카고컵스','260673',1.76,'2'),(10382728,'2023-04-04 07:40:00',4,154914,1,'MLB','MLB','mlb.png','Cincinnati Reds','신시내티','Chicago Cubs','시카고컵스','260673',1.98,'1'),(10382540,'2023-04-04 08:05:00',4,154914,1,'MLB','MLB','mlb.png','New York Yankees','뉴욕양키스','Philadelphia Phillies','필라델피아','944122',2.41,'2'),(10382540,'2023-04-04 08:05:00',4,154914,1,'MLB','MLB','mlb.png','New York Yankees','뉴욕양키스','Philadelphia Phillies','필라델피아','944122',1.53,'1'),(10382539,'2023-04-04 08:05:00',4,154914,1,'MLB','MLB','mlb.png','Washington Nationals','워싱턴','Tampa Bay Rays','탬파베이','757553',2.37,'1'),(10382539,'2023-04-04 08:05:00',4,154914,1,'MLB','MLB','mlb.png','Washington Nationals','워싱턴','Tampa Bay Rays','탬파베이','757553',1.54,'2'),(10382541,'2023-04-04 08:10:00',4,154914,1,'MLB','MLB','mlb.png','Boston Red Sox','보스턴','Pittsburgh Pirates','피츠버그','822053',1.58,'1'),(10382541,'2023-04-04 08:10:00',4,154914,1,'MLB','MLB','mlb.png','Boston Red Sox','보스턴','Pittsburgh Pirates','피츠버그','822053',2.30,'2'),(10382508,'2023-04-04 08:40:00',4,154914,1,'MLB','MLB','mlb.png','Kansas City Royals','캔자스시티','Toronto Blue Jays','토론토','199200',2.07,'1'),(10382508,'2023-04-04 08:40:00',4,154914,1,'MLB','MLB','mlb.png','Kansas City Royals','캔자스시티','Toronto Blue Jays','토론토','199200',1.71,'2'),(10382505,'2023-04-04 08:45:00',4,154914,1,'MLB','MLB','mlb.png','St. Louis Cardinals','세인트루이스','Atlanta Braves','애틀란타','1952180',2.04,'1'),(10382505,'2023-04-04 08:45:00',4,154914,1,'MLB','MLB','mlb.png','St. Louis Cardinals','세인트루이스','Atlanta Braves','애틀란타','1952180',1.71,'2');
/*!40000 ALTER TABLE `ppl_bet_game` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'main_gm_db'
--

--
-- Dumping routines for database 'main_gm_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-03 21:02:36
