CREATE DATABASE  IF NOT EXISTS `main_bets_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `main_bets_db`;
-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: 3.113.11.142    Database: main_bets_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=82 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 (81,'banner/20230211152057_slideshow1_m.jpg',2,1,1,'2022-12-29 15:15:45','2023-02-11 15:20:32','2022-12-29 15:15:45'),(80,'banner/20230211152020_slideshow.jpg',1,1,1,'2022-12-29 15:15:28','2023-02-11 15:19:55','2022-12-29 15:15:28');
/*!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=77 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 (76,'보너스 배당 이벤트','2023-01-05 14:10:46'),(75,'무한지급 돌발 충전 이벤트','2023-01-05 14:10:22'),(74,'첫충전 이벤트','2023-01-03 14:38:24'),(72,'신규가입 첫충 이벤트','2023-01-02 07:03:02'),(71,'구원 이벤트','2022-12-27 19:05: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 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 ('sthan76','에피소드',140000,'2023-04-08 11:33:39'),('twezm71513','제로',810000,'2023-04-08 11:31:05'),('dhoswl1915','해봐',310000,'2023-04-08 11:30:39'),('bsg981','피쿠옹',1090000,'2023-04-08 10:04:54'),('back2back','백투백백백',5630000,'2023-04-08 08:12:31'),('jjagachunsa','천년이',330000,'2023-04-08 07:26:49'),('kyj502711','김둘리',840000,'2023-04-08 07:15:53'),('twezm71513','제로',320000,'2023-04-08 06:56:26');
/*!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=14 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 (13,'라이트닝 게임 베팅 금지안내(카지노)','2023-04-03 23:54:05'),(12,'가입 첫충30% 추가 지급 이벤트 안내','2023-02-25 18:12:37'),(10,'클래식스포츠 이용안내','2023-01-07 06:58:03'),(9,'경기별 베팅 금액 안내','2023-01-03 15:43:55'),(8,'양방,시간차 등 악성 베팅 규제 안내','2023-01-02 15:00:14'),(7,'베팅 관련안내','2023-01-02 14:49:01'),(6,'보너스 포인트 롤링안내','2023-01-02 14:42:36'),(5,'공식 텔레그램 상담센터','2023-01-02 13:12:12');
/*!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=23 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 (22,'popup/20230318132150_500_600_08.jpg',1,3,'2023-03-18 13:22:01','2023-03-18 13:22:01','2023-03-18 13:22:01'),(17,'popup/20230109050956_500_600_02.jpg',1,2,'2023-01-04 15:31:59','2023-01-15 23:51:33','2023-01-04 15:31:59'),(20,'popup/20230227142540_500_600_01.jpg',1,1,'2023-01-06 10:38:24','2023-02-27 14:25:31','2023-01-06 10:38: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 (10411733,'2023-04-08 13:00:00',148,154914,1,'NPB','NPB','npb.png','Fukuoka Softbank Hawks','소프트뱅크','Saitama Seibu Lions','세이부','45000',2.14,'2'),(10411733,'2023-04-08 13:00:00',148,154914,1,'NPB','NPB','npb.png','Fukuoka Softbank Hawks','소프트뱅크','Saitama Seibu Lions','세이부','45000',1.68,'1'),(10396508,'2023-04-08 14:00:00',154,48242,1,'KBL ','KBL','kbl.png','Goyang Carrot Jumpers','캐롯','Ulsan Mobis Phoebus','모비스','1454000',1.63,'2'),(10396508,'2023-04-08 14:00:00',154,48242,1,'KBL ','KBL','kbl.png','Goyang Carrot Jumpers','캐롯','Ulsan Mobis Phoebus','모비스','1454000',2.20,'1'),(10411737,'2023-04-08 14:00:00',148,154914,1,'NPB','NPB','npb.png','Hiroshima Toyo Carp','히로시마','Yomiuri Giants','요미우리','425000',1.87,'2'),(10411737,'2023-04-08 14:00:00',148,154914,1,'NPB','NPB','npb.png','Hiroshima Toyo Carp','히로시마','Yomiuri Giants','요미우리','425000',1.86,'1'),(10411891,'2023-04-08 14:00:00',148,154914,1,'NPB','NPB','npb.png','Orix Buffaloes','오릭스','Nippon-Ham Fighters','니혼햄','335000',1.85,'1'),(10411891,'2023-04-08 14:00:00',148,154914,1,'NPB','NPB','npb.png','Orix Buffaloes','오릭스','Nippon-Ham Fighters','니혼햄','335000',1.90,'2'),(10411792,'2023-04-08 14:00:00',148,154914,1,'NPB','NPB','npb.png','Hanshin Tigers','한신','Tokyo Yakult Swallows','야쿠르트','282000',2.20,'1'),(10411792,'2023-04-08 14:00:00',148,154914,1,'NPB','NPB','npb.png','Hanshin Tigers','한신','Tokyo Yakult Swallows','야쿠르트','282000',1.63,'2'),(10411734,'2023-04-08 14:00:00',148,154914,1,'NPB','NPB','npb.png','Yokohama Bay Stars','요코하마','Chunichi Dragons','주니치 ','115000',1.93,'2'),(10411734,'2023-04-08 14:00:00',148,154914,1,'NPB','NPB','npb.png','Yokohama Bay Stars','요코하마','Chunichi Dragons','주니치 ','115000',1.82,'1'),(10411707,'2023-04-08 14:00:00',148,154914,1,'NPB','NPB','npb.png','Chiba Lotte Marines','지바롯데','Rakuten Golden Eagles','라쿠텐','20000',1.84,'2'),(10411707,'2023-04-08 14:00:00',148,154914,1,'NPB','NPB','npb.png','Chiba Lotte Marines','지바롯데','Rakuten Golden Eagles','라쿠텐','20000',1.89,'1'),(10411853,'2023-04-08 17:00:00',154,154914,1,'KBO','KBO','kbo.png','NC Dinos','NC','Kiwoom Heroes','키움 ','3294712',1.69,'2'),(10411853,'2023-04-08 17:00:00',154,154914,1,'KBO','KBO','kbo.png','NC Dinos','NC','Kiwoom Heroes','키움 ','3294712',2.11,'1'),(10411854,'2023-04-08 17:00:00',154,154914,1,'KBO','KBO','kbo.png','KIA Tigers','KIA','Doosan Bears','두산','622112',2.15,'1'),(10411854,'2023-04-08 17:00:00',154,154914,1,'KBO','KBO','kbo.png','KIA Tigers','KIA','Doosan Bears','두산','622112',1.68,'2'),(10411852,'2023-04-08 17:00:00',154,154914,1,'KBO','KBO','kbo.png','LG Twins','LG','Samsung Lions','삼성 ','335000',2.00,'2'),(10411852,'2023-04-08 17:00:00',154,154914,1,'KBO','KBO','kbo.png','LG Twins','LG','Samsung Lions','삼성 ','335000',1.77,'1'),(10411855,'2023-04-08 17:00:00',154,154914,1,'KBO','KBO','kbo.png','Lotte Giants','롯데 ','KT Wiz','KT','89500',2.18,'1'),(10411855,'2023-04-08 17:00:00',154,154914,1,'KBO','KBO','kbo.png','Lotte Giants','롯데 ','KT Wiz','KT','89500',1.66,'2'),(10412165,'2023-04-08 17:00:00',154,154914,1,'KBO','KBO','kbo.png','Hanwha Eagles','한화','SSG Landers','SSG ','77000',2.48,'1'),(10412165,'2023-04-08 17:00:00',154,154914,1,'KBO','KBO','kbo.png','Hanwha Eagles','한화','SSG Landers','SSG ','77000',1.52,'2'),(10297984,'2023-04-08 19:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Udinese','우디네세','AC Monza Brianza','몬차','0',2.08,'1'),(10297984,'2023-04-08 19:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Udinese','우디네세','AC Monza Brianza','몬차','0',3.65,'2'),(10297984,'2023-04-08 19:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Udinese','우디네세','AC Monza Brianza','몬차','0',3.38,'X'),(10299921,'2023-04-08 20:30:00',243,6046,1,'프리미어리그','Premier League','epl.png','Manchester United','맨체스터 유나이티드','Everton','에버튼','90000',4.40,'X'),(10299921,'2023-04-08 20:30:00',243,6046,1,'프리미어리그','Premier League','epl.png','Manchester United','맨체스터 유나이티드','Everton','에버튼','90000',1.47,'1'),(10299921,'2023-04-08 20:30:00',243,6046,1,'프리미어리그','Premier League','epl.png','Manchester United','맨체스터 유나이티드','Everton','에버튼','90000',7.14,'2');
/*!40000 ALTER TABLE `ppl_bet_game` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'main_bets_db'
--

--
-- Dumping routines for database 'main_bets_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-08 12:35:15
