-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: localhost    Database: main_betgo_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=85 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 (84,'banner/20220825174656_m_main_visual.jpg',2,1,1,'2022-08-23 18:02:24','2022-08-25 17:46:58','2022-08-23 18:02:24'),(83,'banner/20220825174645_main_visual.jpg',1,1,1,'2022-08-23 18:02:09','2022-08-25 17:46:47','2022-08-23 18:02: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=74 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 (73,'신규가입 첫충 이벤트','2022-09-08 17:46:29'),(72,'지인추천 이벤트','2022-08-21 15:52:42'),(71,'무한 돌발충전 이벤트','2022-08-21 15:43:38'),(70,'폴더수 비례 추가 배당 이벤트','2022-08-21 06:52:23'),(66,'999이벤트','2022-05-25 18:10:44'),(65,'오류신고 이벤트','2022-05-24 20:28:08'),(64,'첫충전, 매충전 이벤트','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 ('yhc8271','으뇽이',150000,'2023-06-15 21:07:42'),('apple486','유애퀴',70000,'2023-06-15 14:35:50'),('danmin','휘미',170000,'2023-06-15 07:55:02'),('qqq6','푸우푸우',2300000,'2023-06-15 06:29:32'),('qqq5','두꺼빙',120000,'2023-06-15 06:00:33'),('qqq4','럭키칠떙',630000,'2023-06-15 04:44:46'),('qqq3','아쿠아붐',1000000,'2023-06-15 02:59:13'),('qqq2','브레이커',270000,'2023-06-15 01:49:47');
/*!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=9 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 (8,'카지노, 라이트닝 게임 베팅 금지안내','2023-04-03 23:49:53'),(7,'카지노 이용안내','2023-04-01 20:45:34'),(6,'정기 점검 안내','2022-08-21 14:17:18'),(5,'텔레그램 고객센터 안내','2022-08-21 13:55:01'),(4,'양방베팅 관련 안내','2022-08-21 06:22:22'),(3,'롤링 규정안내','2022-08-21 04:49:53'),(2,'마틴,루틴 허용','2022-08-21 04:46:45'),(1,'경기별 최대 베팅 금액 안내','2022-08-21 04:43:09');
/*!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 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 */;
/*!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 (10827400,'2023-06-16 02:05:00',4,154914,1,'MLB','MLB','mlb.png','Baltimore Orioles','볼티모어','Toronto Blue Jays','토론토','0',2.09,'2'),(10827400,'2023-06-16 02:05:00',4,154914,1,'MLB','MLB','mlb.png','Baltimore Orioles','볼티모어','Toronto Blue Jays','토론토','0',1.75,'1'),(10827420,'2023-06-16 04:37:00',4,154914,1,'MLB','MLB','mlb.png','Oakland Athletics','오클랜드','Tampa Bay Rays','탬파베이','0',1.47,'2'),(10827420,'2023-06-16 04:37:00',4,154914,1,'MLB','MLB','mlb.png','Oakland Athletics','오클랜드','Tampa Bay Rays','탬파베이','0',2.72,'1'),(10818139,'2023-06-16 04:40:00',4,154914,1,'MLB','MLB','mlb.png','Arizona Diamondbacks','애리조나','Philadelphia Phillies','필라델피아','0',2.12,'1'),(10818139,'2023-06-16 04:40:00',4,154914,1,'MLB','MLB','mlb.png','Arizona Diamondbacks','애리조나','Philadelphia Phillies','필라델피아','0',1.74,'2'),(10827415,'2023-06-16 08:10:00',4,154914,1,'MLB','MLB','mlb.png','Minnesota Twins','미네소타','Detroit Tigers','디트로이트','5000',1.47,'1'),(10827415,'2023-06-16 08:10:00',4,154914,1,'MLB','MLB','mlb.png','Minnesota Twins','미네소타','Detroit Tigers','디트로이트','5000',2.72,'2'),(10827472,'2023-06-16 08:20:00',4,154914,1,'MLB','MLB','mlb.png','Atlanta Braves','애틀란타','Colorado Rockies','콜로라도','0',3.04,'2'),(10827472,'2023-06-16 08:20:00',4,154914,1,'MLB','MLB','mlb.png','Atlanta Braves','애틀란타','Colorado Rockies','콜로라도','0',1.39,'1'),(10818141,'2023-06-16 09:05:00',4,154914,1,'MLB','MLB','mlb.png','Texas Rangers','텍사스','Los Angeles Angels','LA에인절스','0',2.19,'2'),(10818141,'2023-06-16 09:05:00',4,154914,1,'MLB','MLB','mlb.png','Texas Rangers','텍사스','Los Angeles Angels','LA에인절스','0',1.70,'1'),(10818142,'2023-06-16 09:05:00',4,154914,1,'MLB','MLB','mlb.png','Chicago Cubs','시카고컵스','Pittsburgh Pirates','피츠버그','0',1.59,'1'),(10818142,'2023-06-16 09:05:00',4,154914,1,'MLB','MLB','mlb.png','Chicago Cubs','시카고컵스','Pittsburgh Pirates','피츠버그','0',2.41,'2'),(10818140,'2023-06-16 09:10:00',4,154914,1,'MLB','MLB','mlb.png','Houston Astros','휴스턴','Washington Nationals','워싱턴','5000',2.59,'2'),(10818140,'2023-06-16 09:10:00',4,154914,1,'MLB','MLB','mlb.png','Houston Astros','휴스턴','Washington Nationals','워싱턴','5000',1.53,'1'),(10818138,'2023-06-16 09:40:00',4,154914,1,'MLB','MLB','mlb.png','San Diego Padres','샌디에이고','Cleveland Guardians','클리블랜드','0',2.09,'2'),(10818138,'2023-06-16 09:40:00',4,154914,1,'MLB','MLB','mlb.png','San Diego Padres','샌디에이고','Cleveland Guardians','클리블랜드','0',1.75,'1'),(10818137,'2023-06-16 11:10:00',4,154914,1,'MLB','MLB','mlb.png','Los Angeles Dodgers','LA다저스','Chicago White Sox','화이트삭스','5000',2.24,'2'),(10818137,'2023-06-16 11:10:00',4,154914,1,'MLB','MLB','mlb.png','Los Angeles Dodgers','LA다저스','Chicago White Sox','화이트삭스','5000',1.67,'1');
/*!40000 ALTER TABLE `ppl_bet_game` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'main_betgo_db'
--

--
-- Dumping routines for database 'main_betgo_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-06-15 22:52:42
