CREATE DATABASE  IF NOT EXISTS `main_gm_db` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;
USE `main_gm_db`;
-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: 210.175.73.186    Database: main_gm_db
-- ------------------------------------------------------
-- Server version	5.5.5-10.4.28-MariaDB-1:10.4.28+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=79 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci 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/m_slideshow.jpg',2,1,1,'2022-05-12 14:33:46','2022-05-21 23:14:10','2022-05-12 14:33:46'),(62,'banner/slideshow.jpg',1,1,1,'2022-05-12 14:33:09','2022-11-16 15:21:12','2022-05-12 14:33:09'),(78,'banner/20230403182738_tessssst1.JPG',1,1,5,'2023-04-03 19:27:37','2023-04-03 19:27:37','2023-04-03 19:27:37');
/*!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=68 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!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 (67,'그래 이벤트','2022-05-26 10:10:31'),(66,'test2','2022-05-25 18:10:44'),(65,'명탐정 이벤트','2022-05-24 20:28:08'),(64,'롤링100%안내','2022-05-24 20:26:21');
/*!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 COLLATE=utf8_general_ci 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 ('gmdev2','지엠데브이',100000,'2023-02-23 15:54:22'),('gmdev7','지엠데브칠',300000,'2023-01-31 13:19:17'),('gmdev3','지엠데브삼',10000,'2022-08-17 00:48:08'),('seemon','시몬',3000000,'2022-07-15 12:58:31'),('seemon','시몬',3000000,'2022-07-14 20:48:12'),('seemon','시몬',3000000,'2022-07-13 16:52:09'),('seemon','시몬',3000000,'2022-07-12 21:43:20'),('seemon','시몬',3000000,'2022-07-12 16:05:07');
/*!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=558 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci 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 (557,'공지 작성','2022-05-26 10:46:42'),(556,'test6','2022-05-26 10:44:44'),(555,'공지사항','2022-05-26 10:12:17'),(554,'test4','2022-05-25 18:13:59'),(553,'test3','2022-05-25 18:11:16'),(552,'test2','2022-05-24 20:50:22'),(551,'test','2022-05-24 20:47:34');
/*!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=22 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci 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 (21,'popup/20221122183950_m_004.png',1,4,'2022-11-22 18:39:50','2022-11-22 18:39:50','2022-11-22 18:39:50'),(20,'popup/20221122183937_m_003.png',1,3,'2022-11-22 18:39:37','2022-11-22 18:39:37','2022-11-22 18:39:37'),(19,'popup/20221122182034_m_002.png',1,2,'2022-11-22 18:20:34','2022-11-22 18:20:34','2022-11-22 18:20:34'),(18,'popup/20221122182024_m_001.png',1,1,'2022-11-22 18:20:24','2022-11-22 18:20:24','2022-11-22 18:20:24');
/*!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 COLLATE=utf8_general_ci 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 (10444845,'2023-04-14 02:05:00',4,154914,1,'MLB','MLB','mlb.png','Baltimore Orioles','볼티모어','Oakland Athletics','오클랜드','0',2.91,'2'),(10444845,'2023-04-14 02:05:00',4,154914,1,'MLB','MLB','mlb.png','Baltimore Orioles','볼티모어','Oakland Athletics','오클랜드','0',1.30,'1'),(10443086,'2023-04-14 02:10:00',4,154914,1,'MLB','MLB','mlb.png','Tampa Bay Rays','탬파베이','Boston Red Sox','보스턴','0',1.32,'1'),(10443086,'2023-04-14 02:10:00',4,154914,1,'MLB','MLB','mlb.png','Tampa Bay Rays','탬파베이','Boston Red Sox','보스턴','0',2.84,'2'),(10443906,'2023-04-14 07:40:00',4,154914,1,'MLB','MLB','mlb.png','Cincinnati Reds','신시내티','Philadelphia Phillies','필라델피아','0',2.04,'2'),(10443906,'2023-04-14 07:40:00',4,154914,1,'MLB','MLB','mlb.png','Cincinnati Reds','신시내티','Philadelphia Phillies','필라델피아','0',1.61,'1'),(10401703,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Montreal Canadiens','몬트리얼 캐내디언스','Boston Bruins','보스턴 브루인즈','0',4.95,'X'),(10401703,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Montreal Canadiens','몬트리얼 캐내디언스','Boston Bruins','보스턴 브루인즈','0',1.55,'2'),(10401703,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Montreal Canadiens','몬트리얼 캐내디언스','Boston Bruins','보스턴 브루인즈','0',4.62,'1'),(10440299,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Florida Panthers','플로리다 팬서스','Carolina Hurricanes','캐롤라이나 허리케인즈','0',4.27,'X'),(10440299,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Florida Panthers','플로리다 팬서스','Carolina Hurricanes','캐롤라이나 허리케인즈','0',2.37,'1'),(10440299,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Florida Panthers','플로리다 팬서스','Carolina Hurricanes','캐롤라이나 허리케인즈','0',2.45,'2'),(10440291,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Columbus Blue Jackets','콜럼버스 블루 재킷스','Pittsburgh Penguins','피츠버그 펭귄즈','0',4.57,'X'),(10440291,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Columbus Blue Jackets','콜럼버스 블루 재킷스','Pittsburgh Penguins','피츠버그 펭귄즈','0',3.50,'1'),(10440291,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Columbus Blue Jackets','콜럼버스 블루 재킷스','Pittsburgh Penguins','피츠버그 펭귄즈','0',1.78,'2'),(10440311,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Washington Capitals','워싱턴 캐피털스','New Jersey Devils','뉴저지 데블스','0',4.42,'X'),(10440311,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Washington Capitals','워싱턴 캐피털스','New Jersey Devils','뉴저지 데블스','0',1.88,'2'),(10440311,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Washington Capitals','워싱턴 캐피털스','New Jersey Devils','뉴저지 데블스','0',3.25,'1'),(10440283,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Buffalo Sabres','버팔로 사브레즈','Ottawa Senators','오타와 세너터스','0',2.11,'1'),(10440283,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Buffalo Sabres','버팔로 사브레즈','Ottawa Senators','오타와 세너터스','0',4.53,'X'),(10440283,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Buffalo Sabres','버팔로 사브레즈','Ottawa Senators','오타와 세너터스','0',2.73,'2'),(10428727,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','New York Rangers','뉴욕 레인저스','Toronto Maple Leafs','토론토 메이플 리프스','0',4.27,'X'),(10428727,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','New York Rangers','뉴욕 레인저스','Toronto Maple Leafs','토론토 메이플 리프스','0',2.60,'2'),(10428727,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','New York Rangers','뉴욕 레인저스','Toronto Maple Leafs','토론토 메이플 리프스','0',2.23,'1'),(10440307,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Tampa Bay Lightning','탬파베이 라이트닝','Detroit Red Wings','디트로이트 레드 윙스','0',4.60,'X'),(10440307,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Tampa Bay Lightning','탬파베이 라이트닝','Detroit Red Wings','디트로이트 레드 윙스','0',3.93,'2'),(10440307,'2023-04-14 08:00:00',4,35232,1,'NHL','NHL','NHL.png','Tampa Bay Lightning','탬파베이 라이트닝','Detroit Red Wings','디트로이트 레드 윙스','0',1.69,'1'),(10443913,'2023-04-14 08:05:00',4,154914,1,'MLB','MLB','mlb.png','New York Yankees','뉴욕양키즈','Minnesota Twins','미네소타','0',2.18,'2'),(10443913,'2023-04-14 08:05:00',4,154914,1,'MLB','MLB','mlb.png','New York Yankees','뉴욕양키즈','Minnesota Twins','미네소타','0',1.55,'1'),(10443090,'2023-04-14 08:07:00',4,154914,1,'MLB','MLB','mlb.png','Toronto Blue Jays','토론토','Detroit Tigers','디트로이트','0',2.84,'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-14  0:15:36
