CREATE DATABASE  IF NOT EXISTS `main_nova_db` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;
USE `main_nova_db`;
-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: localhost    Database: main_nova_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 '',
  `file_type` tinyint(1) DEFAULT NULL,
  `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 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 */;
/*!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 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 (197,'텔레그램 이벤트','2023-03-19 21:15:08'),(196,'페이백 이벤트','2023-03-17 00:26:30'),(195,'지인추천 이벤트','2023-03-17 00:26:03'),(193,'신규가입 이벤트','2023-03-16 15:41:05'),(191,'마켓 이벤트','2023-03-16 14:15:31'),(190,'다폴더 이벤트','2023-03-16 14:12:52'),(189,'생일 이벤트','2023-02-27 14:43:13'),(188,'오류제보 이벤트','2023-02-27 14:41:18');
/*!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 ('kunseock','두폴좆문가',620000,'2023-09-26 07:22:12'),('sdww','우동',1000000,'2023-09-26 05:33:27'),('byung7yun','반석마을',100000,'2023-09-26 03:39:48'),('judokjd1','내반대개꿀',140000,'2023-09-25 21:51:00'),('momdu13','시금치',150000,'2023-09-25 20:42:01'),('space427','파도인가',200000,'2023-09-25 17:42:04'),('dkdkdk1212','커리',150000,'2023-09-25 15:38:43'),('goyeong','앵이',100000,'2023-09-25 15:33: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=18 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 (17,'[★] 충전규정','2023-03-14 15:59:01'),(16,'[★] 환전규정','2023-03-14 15:58:20'),(15,'[★] 등급규정','2023-03-14 15:58:12'),(14,'[★] 롤링규정','2023-03-14 15:57:45'),(13,'[★] 롤링 단폴/다폴더 규정','2023-03-14 15:57:38'),(12,'[★] 배팅취소/악성제재 규정','2023-03-14 15:57:31'),(11,'[★] 스포츠 규정','2023-03-14 15:57:20'),(10,'[★] 미니게임/가상축구 규정','2023-03-14 15:56:43');
/*!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=107 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 (106,'popup/20230314152835_노바악성회원제재팝업.png',1,1,'2023-03-14 15:29:18','2023-03-14 15:29:18','2023-03-14 15:29:18'),(105,'popup/20230314152822_노바페이백팝업.png',1,1,'2023-03-14 15:29:06','2023-03-14 15:29:06','2023-03-14 15:29:06'),(104,'popup/20230314152758_노바아낌없이드립니다팝업.png',1,1,'2023-03-04 11:14:39','2023-03-14 15:28:42','2023-03-04 11:14:39'),(103,'popup/20230314152747_노바신규첫충팝업.png',1,1,'2023-01-27 18:16:36','2023-03-14 15:28:30','2023-01-27 18:16:36');
/*!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 (11435039,'2023-09-26 18:00:00',148,154914,1,'NPB','NPB','npb.png','Nippon-Ham Fighters','니혼햄','Chiba Lotte Marines','지바롯데','0',1.77,'1'),(11435039,'2023-09-26 18:00:00',148,154914,1,'NPB','NPB','npb.png','Nippon-Ham Fighters','니혼햄','Chiba Lotte Marines','지바롯데','0',1.87,'2'),(11435037,'2023-09-26 18:00:00',148,154914,1,'NPB','NPB','npb.png','Hanshin Tigers','한신','Tokyo Yakult Swallows','야쿠르트','0',1.65,'1'),(11435037,'2023-09-26 18:00:00',148,154914,1,'NPB','NPB','npb.png','Hanshin Tigers','한신','Tokyo Yakult Swallows','야쿠르트','0',2.05,'2'),(11435036,'2023-09-26 18:00:00',148,154914,1,'NPB','NPB','npb.png','Orix Buffaloes','오릭스','Saitama Seibu Lions','세이부','0',2.11,'2'),(11435036,'2023-09-26 18:00:00',148,154914,1,'NPB','NPB','npb.png','Orix Buffaloes','오릭스','Saitama Seibu Lions','세이부','0',1.61,'1'),(11435035,'2023-09-26 18:00:00',148,154914,1,'NPB','NPB','npb.png','Hiroshima Toyo Carp','히로시마','Chunichi Dragons','주니치 ','0',2.30,'2'),(11435035,'2023-09-26 18:00:00',148,154914,1,'NPB','NPB','npb.png','Hiroshima Toyo Carp','히로시마','Chunichi Dragons','주니치 ','0',1.53,'1'),(11435038,'2023-09-26 18:00:00',148,154914,1,'NPB','NPB','npb.png','Yokohama Bay Stars','요코하마','Yomiuri Giants','요미우리','0',2.00,'2'),(11435038,'2023-09-26 18:00:00',148,154914,1,'NPB','NPB','npb.png','Yokohama Bay Stars','요코하마','Yomiuri Giants','요미우리','0',1.68,'1'),(11434240,'2023-09-26 18:30:00',154,154914,1,'KBO','KBO','kbo.png','NC Dinos','NC 다이노스','KIA Tigers','KIA 타이거즈','137500',1.25,'1'),(11434240,'2023-09-26 18:30:00',154,154914,1,'KBO','KBO','kbo.png','NC Dinos','NC 다이노스','KIA Tigers','KIA 타이거즈','137500',3.37,'2'),(11434241,'2023-09-26 18:30:00',154,154914,1,'KBO','KBO','kbo.png','SSG Landers','SSG 랜더스','Doosan Bears','두산 베어스','37500',1.58,'1'),(11434241,'2023-09-26 18:30:00',154,154914,1,'KBO','KBO','kbo.png','SSG Landers','SSG 랜더스','Doosan Bears','두산 베어스','37500',2.20,'2'),(11434242,'2023-09-26 18:30:00',154,154914,1,'KBO','KBO','kbo.png','LG Twins','LG 트윈스','KT Wiz','KT 위즈','37500',2.10,'2'),(11434242,'2023-09-26 18:30:00',154,154914,1,'KBO','KBO','kbo.png','LG Twins','LG 트윈스','KT Wiz','KT 위즈','37500',1.63,'1'),(11434243,'2023-09-26 18:30:00',154,154914,1,'KBO','KBO','kbo.png','Hanwha Eagles','한화 이글스','Samsung Lions','삼성 라이온즈','0',1.74,'1'),(11434243,'2023-09-26 18:30:00',154,154914,1,'KBO','KBO','kbo.png','Hanwha Eagles','한화 이글스','Samsung Lions','삼성 라이온즈','0',1.89,'2'),(11428324,'2023-09-27 02:00:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Sevilla','세비야','Almería','알메리아','0',3.83,'X'),(11428324,'2023-09-27 02:00:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Sevilla','세비야','Almería','알메리아','0',1.55,'1'),(11428324,'2023-09-27 02:00:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Sevilla','세비야','Almería','알메리아','0',5.02,'2'),(11382127,'2023-09-27 03:45:00',215,6046,1,'세리에A','Serie A','serie-a.png','Juventus','유벤투스','Lecce','레체','0',6.46,'2'),(11382127,'2023-09-27 03:45:00',215,6046,1,'세리에A','Serie A','serie-a.png','Juventus','유벤투스','Lecce','레체','0',3.97,'X'),(11382127,'2023-09-27 03:45:00',215,6046,1,'세리에A','Serie A','serie-a.png','Juventus','유벤투스','Lecce','레체','0',1.44,'1'),(11309923,'2023-09-27 04:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Lille','릴','Stade Reims','랭스','0',1.84,'1'),(11309923,'2023-09-27 04:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Lille','릴','Stade Reims','랭스','0',3.49,'X'),(11309923,'2023-09-27 04:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Lille','릴','Stade Reims','랭스','0',3.54,'2'),(11381717,'2023-09-27 04:30:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Mallorca','마요르카','Barcelona FC','바르셀로나','0',6.46,'1'),(11381717,'2023-09-27 04:30:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Mallorca','마요르카','Barcelona FC','바르셀로나','0',1.43,'2'),(11381717,'2023-09-27 04:30:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Mallorca','마요르카','Barcelona FC','바르셀로나','0',3.99,'X');
/*!40000 ALTER TABLE `ppl_bet_game` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'main_nova_db'
--

--
-- Dumping routines for database 'main_nova_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-11-06 23:41:09
