CREATE DATABASE  IF NOT EXISTS `log_db` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `log_db`;
-- MySQL dump 10.13  Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: 110.45.244.232    Database: log_db
-- ------------------------------------------------------
-- Server version	8.0.29-0ubuntu0.20.04.3

/*!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 `t_ip_block_history`
--

DROP TABLE IF EXISTS `t_ip_block_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `t_ip_block_history` (
  `idx` bigint NOT NULL AUTO_INCREMENT,
  `day` varchar(2) NOT NULL,
  `member_idx` bigint DEFAULT '0',
  `id` varchar(30) DEFAULT NULL,
  `recv_member_idx` bigint DEFAULT NULL,
  `recv_id` varchar(30) DEFAULT NULL,
  `ac_code` tinyint DEFAULT '0',
  `ac_idx` bigint DEFAULT '0',
  `r_money` int DEFAULT '0',
  `be_r_money` int DEFAULT '0',
  `af_r_money` int DEFAULT '0',
  `point` int DEFAULT '0',
  `be_point` int DEFAULT '0',
  `af_point` int DEFAULT '0',
  `coment` varchar(30) DEFAULT '0',
  `u_ip` varchar(100) DEFAULT '0',
  `a_id` varchar(30) DEFAULT '0',
  `reg_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `idx` (`idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='pin 사용이력 로그'
/*!50500 PARTITION BY LIST  COLUMNS(`day`)
(PARTITION t_ip_block_history_01 VALUES IN ('01') ENGINE = InnoDB,
 PARTITION t_ip_block_history_02 VALUES IN ('02') ENGINE = InnoDB,
 PARTITION t_ip_block_history_03 VALUES IN ('03') ENGINE = InnoDB,
 PARTITION t_ip_block_history_04 VALUES IN ('04') ENGINE = InnoDB,
 PARTITION t_ip_block_history_05 VALUES IN ('05') ENGINE = InnoDB,
 PARTITION t_ip_block_history_06 VALUES IN ('06') ENGINE = InnoDB,
 PARTITION t_ip_block_history_07 VALUES IN ('07') ENGINE = InnoDB,
 PARTITION t_ip_block_history_08 VALUES IN ('08') ENGINE = InnoDB,
 PARTITION t_ip_block_history_09 VALUES IN ('09') ENGINE = InnoDB,
 PARTITION t_ip_block_history_10 VALUES IN ('10') ENGINE = InnoDB,
 PARTITION t_ip_block_history_11 VALUES IN ('11') ENGINE = InnoDB,
 PARTITION t_ip_block_history_12 VALUES IN ('12') ENGINE = InnoDB,
 PARTITION t_ip_block_history_13 VALUES IN ('13') ENGINE = InnoDB,
 PARTITION t_ip_block_history_14 VALUES IN ('14') ENGINE = InnoDB,
 PARTITION t_ip_block_history_15 VALUES IN ('15') ENGINE = InnoDB,
 PARTITION t_ip_block_history_16 VALUES IN ('16') ENGINE = InnoDB,
 PARTITION t_ip_block_history_17 VALUES IN ('17') ENGINE = InnoDB,
 PARTITION t_ip_block_history_18 VALUES IN ('18') ENGINE = InnoDB,
 PARTITION t_ip_block_history_19 VALUES IN ('19') ENGINE = InnoDB,
 PARTITION t_ip_block_history_20 VALUES IN ('20') ENGINE = InnoDB,
 PARTITION t_ip_block_history_21 VALUES IN ('21') ENGINE = InnoDB,
 PARTITION t_ip_block_history_22 VALUES IN ('22') ENGINE = InnoDB,
 PARTITION t_ip_block_history_23 VALUES IN ('23') ENGINE = InnoDB,
 PARTITION t_ip_block_history_24 VALUES IN ('24') ENGINE = InnoDB,
 PARTITION t_ip_block_history_25 VALUES IN ('25') ENGINE = InnoDB,
 PARTITION t_ip_block_history_26 VALUES IN ('26') ENGINE = InnoDB,
 PARTITION t_ip_block_history_27 VALUES IN ('27') ENGINE = InnoDB,
 PARTITION t_ip_block_history_28 VALUES IN ('28') ENGINE = InnoDB,
 PARTITION t_ip_block_history_29 VALUES IN ('29') ENGINE = InnoDB,
 PARTITION t_ip_block_history_30 VALUES IN ('30') ENGINE = InnoDB,
 PARTITION t_ip_block_history_31 VALUES IN ('31') ENGINE = InnoDB) */;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_ip_block_history`
--

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

--
-- Table structure for table `t_log_cash`
--

DROP TABLE IF EXISTS `t_log_cash`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `t_log_cash` (
  `idx` bigint NOT NULL AUTO_INCREMENT,
  `day` varchar(2) NOT NULL,
  `member_idx` bigint DEFAULT '0',
  `id` varchar(30) DEFAULT NULL,
  `recv_member_idx` bigint DEFAULT NULL,
  `recv_id` varchar(30) DEFAULT NULL,
  `ac_code` tinyint DEFAULT '0',
  `ac_idx` bigint DEFAULT '0',
  `r_money` int DEFAULT '0',
  `be_r_money` int DEFAULT '0',
  `af_r_money` int DEFAULT '0',
  `point` int DEFAULT '0',
  `be_point` int DEFAULT '0',
  `af_point` int DEFAULT '0',
  `coment` varchar(30) DEFAULT '0',
  `u_ip` varchar(100) DEFAULT '0',
  `a_id` varchar(30) DEFAULT '0',
  `reg_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `idx` (`idx`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COMMENT='pin 사용이력 로그'
/*!50500 PARTITION BY LIST  COLUMNS(`day`)
(PARTITION t_log_cash_01 VALUES IN ('01') ENGINE = InnoDB,
 PARTITION t_log_cash_02 VALUES IN ('02') ENGINE = InnoDB,
 PARTITION t_log_cash_03 VALUES IN ('03') ENGINE = InnoDB,
 PARTITION t_log_cash_04 VALUES IN ('04') ENGINE = InnoDB,
 PARTITION t_log_cash_05 VALUES IN ('05') ENGINE = InnoDB,
 PARTITION t_log_cash_06 VALUES IN ('06') ENGINE = InnoDB,
 PARTITION t_log_cash_07 VALUES IN ('07') ENGINE = InnoDB,
 PARTITION t_log_cash_08 VALUES IN ('08') ENGINE = InnoDB,
 PARTITION t_log_cash_09 VALUES IN ('09') ENGINE = InnoDB,
 PARTITION t_log_cash_10 VALUES IN ('10') ENGINE = InnoDB,
 PARTITION t_log_cash_11 VALUES IN ('11') ENGINE = InnoDB,
 PARTITION t_log_cash_12 VALUES IN ('12') ENGINE = InnoDB,
 PARTITION t_log_cash_13 VALUES IN ('13') ENGINE = InnoDB,
 PARTITION t_log_cash_14 VALUES IN ('14') ENGINE = InnoDB,
 PARTITION t_log_cash_15 VALUES IN ('15') ENGINE = InnoDB,
 PARTITION t_log_cash_16 VALUES IN ('16') ENGINE = InnoDB,
 PARTITION t_log_cash_17 VALUES IN ('17') ENGINE = InnoDB,
 PARTITION t_log_cash_18 VALUES IN ('18') ENGINE = InnoDB,
 PARTITION t_log_cash_19 VALUES IN ('19') ENGINE = InnoDB,
 PARTITION t_log_cash_20 VALUES IN ('20') ENGINE = InnoDB,
 PARTITION t_log_cash_21 VALUES IN ('21') ENGINE = InnoDB,
 PARTITION t_log_cash_22 VALUES IN ('22') ENGINE = InnoDB,
 PARTITION t_log_cash_23 VALUES IN ('23') ENGINE = InnoDB,
 PARTITION t_log_cash_24 VALUES IN ('24') ENGINE = InnoDB,
 PARTITION t_log_cash_25 VALUES IN ('25') ENGINE = InnoDB,
 PARTITION t_log_cash_26 VALUES IN ('26') ENGINE = InnoDB,
 PARTITION t_log_cash_27 VALUES IN ('27') ENGINE = InnoDB,
 PARTITION t_log_cash_28 VALUES IN ('28') ENGINE = InnoDB,
 PARTITION t_log_cash_29 VALUES IN ('29') ENGINE = InnoDB,
 PARTITION t_log_cash_30 VALUES IN ('30') ENGINE = InnoDB,
 PARTITION t_log_cash_31 VALUES IN ('31') ENGINE = InnoDB) */;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_log_cash`
--

LOCK TABLES `t_log_cash` WRITE;
/*!40000 ALTER TABLE `t_log_cash` DISABLE KEYS */;
INSERT INTO `t_log_cash` VALUES (1,'01',10,NULL,NULL,NULL,0,0,0,0,0,0,0,0,'0','0','0','2022-06-14 20:29:30'),(2,'31',10,NULL,NULL,NULL,0,0,0,0,0,0,0,0,'0','0','0','2022-06-14 20:29:38');
/*!40000 ALTER TABLE `t_log_cash` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_login_history`
--

DROP TABLE IF EXISTS `t_login_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `t_login_history` (
  `idx` bigint NOT NULL AUTO_INCREMENT,
  `day` varchar(2) NOT NULL,
  `member_idx` bigint DEFAULT '0',
  `id` varchar(30) DEFAULT NULL,
  `recv_member_idx` bigint DEFAULT NULL,
  `recv_id` varchar(30) DEFAULT NULL,
  `ac_code` tinyint DEFAULT '0',
  `ac_idx` bigint DEFAULT '0',
  `r_money` int DEFAULT '0',
  `be_r_money` int DEFAULT '0',
  `af_r_money` int DEFAULT '0',
  `point` int DEFAULT '0',
  `be_point` int DEFAULT '0',
  `af_point` int DEFAULT '0',
  `coment` varchar(30) DEFAULT '0',
  `u_ip` varchar(100) DEFAULT '0',
  `a_id` varchar(30) DEFAULT '0',
  `reg_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `idx` (`idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='pin 사용이력 로그'
/*!50500 PARTITION BY LIST  COLUMNS(`day`)
(PARTITION t_login_history_01 VALUES IN ('01') ENGINE = InnoDB,
 PARTITION t_login_history_02 VALUES IN ('02') ENGINE = InnoDB,
 PARTITION t_login_history_03 VALUES IN ('03') ENGINE = InnoDB,
 PARTITION t_login_history_04 VALUES IN ('04') ENGINE = InnoDB,
 PARTITION t_login_history_05 VALUES IN ('05') ENGINE = InnoDB,
 PARTITION t_login_history_06 VALUES IN ('06') ENGINE = InnoDB,
 PARTITION t_login_history_07 VALUES IN ('07') ENGINE = InnoDB,
 PARTITION t_login_history_08 VALUES IN ('08') ENGINE = InnoDB,
 PARTITION t_login_history_09 VALUES IN ('09') ENGINE = InnoDB,
 PARTITION t_login_history_10 VALUES IN ('10') ENGINE = InnoDB,
 PARTITION t_login_history_11 VALUES IN ('11') ENGINE = InnoDB,
 PARTITION t_login_history_12 VALUES IN ('12') ENGINE = InnoDB,
 PARTITION t_login_history_13 VALUES IN ('13') ENGINE = InnoDB,
 PARTITION t_login_history_14 VALUES IN ('14') ENGINE = InnoDB,
 PARTITION t_login_history_15 VALUES IN ('15') ENGINE = InnoDB,
 PARTITION t_login_history_16 VALUES IN ('16') ENGINE = InnoDB,
 PARTITION t_login_history_17 VALUES IN ('17') ENGINE = InnoDB,
 PARTITION t_login_history_18 VALUES IN ('18') ENGINE = InnoDB,
 PARTITION t_login_history_19 VALUES IN ('19') ENGINE = InnoDB,
 PARTITION t_login_history_20 VALUES IN ('20') ENGINE = InnoDB,
 PARTITION t_login_history_21 VALUES IN ('21') ENGINE = InnoDB,
 PARTITION t_login_history_22 VALUES IN ('22') ENGINE = InnoDB,
 PARTITION t_login_history_23 VALUES IN ('23') ENGINE = InnoDB,
 PARTITION t_login_history_24 VALUES IN ('24') ENGINE = InnoDB,
 PARTITION t_login_history_25 VALUES IN ('25') ENGINE = InnoDB,
 PARTITION t_login_history_26 VALUES IN ('26') ENGINE = InnoDB,
 PARTITION t_login_history_27 VALUES IN ('27') ENGINE = InnoDB,
 PARTITION t_login_history_28 VALUES IN ('28') ENGINE = InnoDB,
 PARTITION t_login_history_29 VALUES IN ('29') ENGINE = InnoDB,
 PARTITION t_login_history_30 VALUES IN ('30') ENGINE = InnoDB,
 PARTITION t_login_history_31 VALUES IN ('31') ENGINE = InnoDB) */;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_login_history`
--

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

--
-- Dumping events for database 'log_db'
--

--
-- Dumping routines for database 'log_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 2022-06-21 14:26:59
