CREATE DATABASE  IF NOT EXISTS `main_balvenie_db` /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci */;
USE `main_balvenie_db`;
-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: localhost    Database: main_balvenie_db
-- ------------------------------------------------------
-- Server version	5.5.5-10.6.16-MariaDB-0ubuntu0.22.04.1-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(),
  `file_type` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`idx`),
  KEY `thumbnail` (`thumbnail`) USING BTREE
) ENGINE=MEMORY AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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 (46,'banner/1693019143_main_balvenie_M.mp4',2,1,1,'2023-07-14 15:32:25','2024-01-18 01:23:41','2023-07-14 15:32:25',NULL),(45,'banner/1692694896_1692440309_main_balvenie_PC.mp4',1,1,1,'2023-07-14 15:31:54','2023-08-22 18:01:39','2023-07-14 15:31:54',NULL);
/*!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=280 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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 (279,'frtertert','2023-08-30 18:41:51'),(278,'sdweerwer','2023-08-30 18:41:33'),(277,'eqwrtwetr','2023-08-30 18:40:56'),(276,'asdqwjeqmweqweq','2023-08-30 18:40:40'),(275,'asdjkahksdjasjdhaksjd','2023-08-30 18:40:15'),(274,'qweqweqwe','2023-08-30 18:39:56'),(270,'FFFQWER','2023-08-29 17:24:08'),(268,'ASDASD','2023-08-29 17:19:59');
/*!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=utf8mb3 COLLATE=utf8mb3_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 ('dev14','개발자  14',10000,'2024-01-04 11:48:35'),('seemon1','시몬하위',500000,'2024-01-02 21:38:51'),('seemon','시몬',1000000,'2024-01-02 18:39:13'),('seemon1','시몬하위',500000,'2024-01-02 18:32:59'),('seemon1','시몬하위',1000000,'2024-01-02 18:32:40'),('dev14','개발자  14',5000,'2024-01-02 18:17:38'),('dev14','개발자  14',50000,'2024-01-02 18:11:58'),('dev14','개발자  14',50000,'2024-01-02 18:09:49');
/*!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=51 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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 (50,'announcement test','2023-10-12 16:28:07'),(49,'Sample','2023-08-23 16:25:25');
/*!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=65 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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 (64,'popup/20230821185758_amin_pop3.png',1,1,'2023-08-21 18:58:01','2023-08-21 18:58:01','2023-08-21 18:58:01'),(63,'popup/20230821185747_amin_pop4.png',1,1,'2023-08-21 18:57:50','2023-08-21 18:57:50','2023-08-21 18:57:50');
/*!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=utf8mb3 COLLATE=utf8mb3_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 (12154371,'2024-02-04 20:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Torino','토리노','Salernitana','살레르니타나','0',3.63,'X'),(12154371,'2024-02-04 20:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Torino','토리노','Salernitana','살레르니타나','0',6.69,'2'),(12154371,'2024-02-04 20:30:00',215,6046,1,'세리에A','Serie A','serie-a.png','Torino','토리노','Salernitana','살레르니타나','0',1.48,'1'),(12152589,'2024-02-04 21:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','AS Monaco FC','모나코','Le Havre','하브르','0',1.54,'1'),(12152589,'2024-02-04 21:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','AS Monaco FC','모나코','Le Havre','하브르','0',5.26,'2'),(12152589,'2024-02-04 21:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','AS Monaco FC','모나코','Le Havre','하브르','0',3.82,'X'),(12152624,'2024-02-04 22:00:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Villarreal','비야레알','Cádiz','싸디즈','0',3.93,'X'),(12152624,'2024-02-04 22:00:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Villarreal','비야레알','Cádiz','싸디즈','0',5.51,'2'),(12152624,'2024-02-04 22:00:00',142,6046,1,'프리메라리가','LaLiga','laliga.png','Villarreal','비야레알','Cádiz','싸디즈','0',1.51,'1'),(12154369,'2024-02-04 23:00:00',215,6046,1,'세리에A','Serie A','serie-a.png','Napoli','나폴리','Hellas Verona','베로나','0',4.33,'X'),(12154369,'2024-02-04 23:00:00',215,6046,1,'세리에A','Serie A','serie-a.png','Napoli','나폴리','Hellas Verona','베로나','0',1.39,'1'),(12154369,'2024-02-04 23:00:00',215,6046,1,'세리에A','Serie A','serie-a.png','Napoli','나폴리','Hellas Verona','베로나','0',6.73,'2'),(12153828,'2024-02-04 23:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','AFC Bournemouth','본머스','Nottingham Forest','노팅엄 포레스트','0',4.00,'X'),(12153828,'2024-02-04 23:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','AFC Bournemouth','본머스','Nottingham Forest','노팅엄 포레스트','0',1.62,'1'),(12153828,'2024-02-04 23:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','AFC Bournemouth','본머스','Nottingham Forest','노팅엄 포레스트','0',4.29,'2'),(12153824,'2024-02-04 23:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','Manchester United','맨체스터 유나이티드','West Ham United','웨스트햄','0',5.03,'2'),(12153824,'2024-02-04 23:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','Manchester United','맨체스터 유나이티드','West Ham United','웨스트햄','0',1.53,'1'),(12153824,'2024-02-04 23:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','Manchester United','맨체스터 유나이티드','West Ham United','웨스트햄','0',4.02,'X'),(12153823,'2024-02-04 23:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','Chelsea','첼시','Wolverhampton Wanderers','울버햄튼','0',4.03,'X'),(12153823,'2024-02-04 23:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','Chelsea','첼시','Wolverhampton Wanderers','울버햄튼','0',5.28,'2'),(12153823,'2024-02-04 23:00:00',243,6046,1,'프리미어리그','Premier League','epl.png','Chelsea','첼시','Wolverhampton Wanderers','울버햄튼','0',1.51,'1'),(12152595,'2024-02-04 23:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Stade Reims','랭스','Toulouse','툴루즈','0',1.72,'1'),(12152595,'2024-02-04 23:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Stade Reims','랭스','Toulouse','툴루즈','0',3.35,'X'),(12152595,'2024-02-04 23:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Stade Reims','랭스','Toulouse','툴루즈','0',4.54,'2'),(12152590,'2024-02-04 23:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Metz','메츠','Lorient','로리앙','0',2.94,'X'),(12152590,'2024-02-04 23:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Metz','메츠','Lorient','로리앙','0',3.42,'2'),(12152590,'2024-02-04 23:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Metz','메츠','Lorient','로리앙','0',2.14,'1'),(12152588,'2024-02-04 23:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Lille','릴','Clermont','클레르몬트','0',4.29,'X'),(12152588,'2024-02-04 23:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Lille','릴','Clermont','클레르몬트','0',1.38,'1'),(12152588,'2024-02-04 23:00:00',147,6046,1,'리그앙','Ligue 1','ligue1.png','Lille','릴','Clermont','클레르몬트','0',7.15,'2');
/*!40000 ALTER TABLE `ppl_bet_game` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_dist_sts_info`
--

DROP TABLE IF EXISTS `tb_dist_sts_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `tb_dist_sts_info` (
  `dist_idx` int(11) NOT NULL DEFAULT 0,
  `day_join` int(11) NOT NULL DEFAULT 0,
  `day_charge` int(11) NOT NULL DEFAULT 0,
  `day_exchange` int(11) NOT NULL DEFAULT 0,
  `day_charge_count` int(11) NOT NULL DEFAULT 0,
  `day_exchange_count` int(11) NOT NULL DEFAULT 0,
  `month_join` int(11) NOT NULL DEFAULT 0,
  `month_charge` int(11) NOT NULL DEFAULT 0,
  `month_exchange` int(11) NOT NULL DEFAULT 0,
  `month_charge_count` int(11) NOT NULL DEFAULT 0,
  `month_exchange_count` int(11) NOT NULL DEFAULT 0,
  `update_dt` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `create_dt` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`dist_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='총판 정산정보저장';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_dist_sts_info`
--

LOCK TABLES `tb_dist_sts_info` WRITE;
/*!40000 ALTER TABLE `tb_dist_sts_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `tb_dist_sts_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_user_site_call_static`
--

DROP TABLE IF EXISTS `tb_user_site_call_static`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `tb_user_site_call_static` (
  `member_idx` int(11) NOT NULL DEFAULT 0,
  `bet_type` int(11) NOT NULL DEFAULT 0 COMMENT '1 : 스포츠 , 2 : 실시간 ',
  `create_dt` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`member_idx`,`bet_type`,`create_dt`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_user_site_call_static`
--

LOCK TABLES `tb_user_site_call_static` WRITE;
/*!40000 ALTER TABLE `tb_user_site_call_static` DISABLE KEYS */;
INSERT INTO `tb_user_site_call_static` VALUES (283,1,'2024-01-27 21:16:58'),(283,1,'2024-01-27 21:17:17'),(283,1,'2024-01-27 21:17:44'),(283,1,'2024-01-27 21:19:43'),(283,1,'2024-01-27 21:34:10'),(283,1,'2024-01-27 21:37:21'),(283,1,'2024-01-27 21:37:26'),(3399,1,'2024-01-27 22:06:28'),(3399,1,'2024-01-27 22:55:52'),(3399,1,'2024-01-27 22:56:05'),(293,1,'2024-02-02 20:16:51'),(293,1,'2024-02-02 20:17:00'),(3400,1,'2024-02-04 20:16:01'),(3400,1,'2024-02-04 20:16:31'),(3400,1,'2024-02-04 20:18:03'),(3400,1,'2024-02-04 20:33:49'),(3400,1,'2024-02-04 20:35:26'),(292,1,'2024-02-21 19:39:01'),(292,1,'2024-02-21 19:39:06'),(292,1,'2024-02-21 19:39:12'),(292,1,'2024-02-21 19:39:29'),(292,1,'2024-02-21 19:39:40'),(283,1,'2024-02-21 19:46:03'),(283,1,'2024-02-21 19:46:11'),(283,1,'2024-02-21 19:46:22'),(283,1,'2024-02-21 19:46:41'),(283,1,'2024-02-21 19:47:25'),(283,1,'2024-02-21 19:55:44'),(283,1,'2024-02-21 19:56:23'),(283,1,'2024-02-21 19:56:30'),(283,1,'2024-02-21 19:56:35'),(283,1,'2024-02-21 20:00:18'),(283,1,'2024-02-21 20:00:25'),(3399,1,'2024-02-22 12:44:37'),(3399,1,'2024-02-22 12:44:43'),(3399,1,'2024-02-22 12:45:29'),(3399,1,'2024-02-23 22:55:23'),(3399,1,'2024-02-23 22:55:48'),(3399,1,'2024-02-23 22:56:11'),(3399,1,'2024-02-23 22:57:17'),(292,1,'2024-02-27 17:09:08'),(292,1,'2024-02-27 17:09:11'),(292,1,'2024-02-27 17:11:11'),(292,1,'2024-02-27 17:12:40'),(292,1,'2024-02-27 17:13:08'),(292,1,'2024-02-27 17:15:05'),(292,1,'2024-02-27 17:15:18'),(292,1,'2024-02-27 20:07:15'),(292,1,'2024-02-27 20:07:26'),(292,1,'2024-02-27 20:07:36'),(292,1,'2024-02-27 20:08:27'),(292,1,'2024-02-27 20:10:04'),(292,1,'2024-02-27 20:22:44'),(292,1,'2024-02-27 20:22:45'),(292,1,'2024-02-27 20:23:24');
/*!40000 ALTER TABLE `tb_user_site_call_static` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'main_balvenie_db'
--

--
-- Dumping routines for database 'main_balvenie_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 2024-02-29  1:02:18
