CREATE DATABASE  IF NOT EXISTS `BETGO_ADMIN_DEV` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `BETGO_ADMIN_DEV`;
--
-- Host: 210.175.73.152    Database: BETGO_ADMIN_DEV
-- ------------------------------------------------------

 SET NAMES utf8 ;

--
-- Table structure for table `t_adm_config`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `t_adm_config` (
  `idx` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `a_id` varchar(50) NOT NULL,
  `alarm_name` varchar(50) DEFAULT NULL,
  `alarm_use` enum('Y','N') NOT NULL DEFAULT 'Y',
  `alarm_kind` varchar(50) DEFAULT NULL,
  `alarm_file` varchar(300) DEFAULT NULL,
  `reg_time` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `t_adm_config`
--


--
-- Table structure for table `t_adm_ip`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `t_adm_ip` (
  `idx` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `a_ip` varchar(30) DEFAULT NULL,
  `a_memo` text DEFAULT NULL,
  `isuse` enum('Y','N') DEFAULT 'Y',
  `reg_time` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`idx`),
  UNIQUE KEY `UQ_t_adm_ip_01` (`a_ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `t_adm_ip`
--


--
-- Table structure for table `t_adm_log`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `t_adm_log` (
  `idx` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `a_id` varchar(50) NOT NULL,
  `a_ip` varchar(30) DEFAULT NULL,
  `a_country` varchar(50) DEFAULT NULL,
  `is_login` enum('Y','N','') DEFAULT NULL,
  `u_id` varchar(50) DEFAULT NULL,
  `u_nick` varchar(50) DEFAULT NULL,
  `log_data` text DEFAULT NULL,
  `log_type` tinyint(3) unsigned DEFAULT 99 COMMENT '1 운영툴 로그인\r\n2. 관리자 ip관리, 개별 ip 차단관리\r\n3. 도메인 코드 관리\r\n4. 레벨별 계좌설정\r\n5. 가입첫충\r\n6. 등급별 베팅금액 설정\r\n7. 사이트 설정\r\n11. 관리자 아이디 관리',
  `reg_time` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`idx`),
  KEY `idx_log_type` (`log_type`)
) ENGINE=InnoDB AUTO_INCREMENT=478 DEFAULT CHARSET=utf8 COMMENT='관리자 로그';

--
-- Dumping data for table `t_adm_log`
--

INSERT INTO `t_adm_log` VALUES (1,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-18 11:56:17'),(2,'testadmin','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-18 11:56:38'),(3,'testadmin','156.146.35.167','local','Y',NULL,NULL,NULL,1,'2021-12-18 12:53:23'),(4,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-19 04:23:01'),(5,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-19 04:28:56'),(6,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-19 04:30:02'),(7,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 01:14:00'),(8,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 01:14:28'),(9,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 01:35:09'),(10,'hong221','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-20 01:35:24'),(11,'hong221','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-20 01:35:29'),(12,'hong221','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-20 01:35:32'),(13,'hong221','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-20 01:35:36'),(14,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 01:35:58'),(15,'tiger2','127.0.0.1','local','N',NULL,NULL,NULL,1,'2021-12-20 02:28:54'),(16,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-20 02:30:26'),(17,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-20 02:40:11'),(18,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 02:51:16'),(19,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-20 03:07:15'),(20,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 03:09:55'),(21,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 03:32:43'),(22,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 03:36:27'),(23,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 03:39:52'),(24,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 04:08:27'),(25,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 05:08:38'),(26,'tiger10','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-20 05:21:30'),(27,'tiger10','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-20 05:21:39'),(28,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 05:37:20'),(29,'testadmin','156.146.35.167','local','Y',NULL,NULL,NULL,1,'2021-12-20 06:17:08'),(30,'tiger2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 06:40:06'),(31,'testadmin','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-20 07:37:50'),(32,'testadmin','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-20 07:38:17'),(33,'testadmin','210.151.37.199','local','Y',NULL,NULL,NULL,1,'2021-12-20 07:38:22'),(34,'testadmin','212.102.51.228','local','Y',NULL,NULL,NULL,1,'2021-12-20 07:39:53'),(35,'testadmin','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-20 08:02:01'),(36,'testadmin','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-20 08:02:05'),(37,'testadmin','210.151.37.199','local','Y',NULL,NULL,NULL,1,'2021-12-20 08:02:20'),(38,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-20 08:06:28'),(39,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-20 08:52:56'),(40,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-20 09:45:49'),(41,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-20 12:13:31'),(42,'testadmin','210.151.37.199','local','Y',NULL,NULL,NULL,1,'2021-12-20 20:24:51'),(43,'testadmin','156.146.35.91','local','Y',NULL,NULL,NULL,1,'2021-12-20 20:35:44'),(44,'tombow','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-20 20:36:23'),(45,'testadmin1','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-20 20:36:32'),(46,'testadmin2','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-20 20:36:36'),(47,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-21 01:02:04'),(48,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-21 02:02:44'),(49,'testadmin','212.102.51.228','local','Y',NULL,NULL,NULL,1,'2021-12-21 02:21:21'),(50,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-21 03:02:36'),(51,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-21 05:15:56'),(52,'betgo5','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-21 05:43:36'),(53,'betgo5','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-21 05:43:45'),(54,'betgo5','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-21 05:44:00'),(55,'betgo5','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-21 05:44:12'),(56,'betgo4','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-21 06:46:16'),(57,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-21 06:47:00'),(58,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-21 06:48:03'),(59,'tiger3','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-21 06:48:51'),(60,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-21 06:54:14'),(61,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-21 07:05:23'),(62,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-21 07:07:40'),(63,'tiger3','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-21 07:08:32'),(64,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-21 08:39:55'),(65,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-21 11:01:17'),(66,'testadmin','124.33.132.195','local','Y',NULL,NULL,NULL,1,'2021-12-21 12:25:30'),(67,'testadmin','124.33.132.195','local','N',NULL,NULL,NULL,1,'2021-12-21 13:58:11'),(68,'testadmin','124.33.132.195','local','Y',NULL,NULL,NULL,1,'2021-12-21 13:58:17'),(69,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-21 14:05:25'),(70,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-22 00:29:23'),(71,'tiger3','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-22 02:22:28'),(72,'testadmin','212.102.51.228','local','Y',NULL,NULL,NULL,1,'2021-12-22 02:40:51'),(73,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-22 04:18:21'),(74,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-22 07:26:07'),(75,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-23 00:27:04'),(76,'admin','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-23 02:03:40'),(77,'admin','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-23 02:03:43'),(78,'testadmin','210.151.37.199','local','Y',NULL,NULL,NULL,1,'2021-12-23 02:03:55'),(79,'testadmin','212.102.51.228','local','N',NULL,NULL,NULL,1,'2021-12-23 02:15:09'),(80,'testadmin','212.102.51.228','local','Y',NULL,NULL,NULL,1,'2021-12-23 02:15:16'),(81,'tombow','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-23 02:46:48'),(82,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-23 02:48:40'),(83,'tombow','210.151.37.199','local','Y',NULL,NULL,NULL,1,'2021-12-23 05:34:18'),(84,'tombow','91.234.192.115','local','Y',NULL,NULL,NULL,1,'2021-12-23 06:02:02'),(85,'testadmin','212.102.51.234','local','Y',NULL,NULL,NULL,1,'2021-12-23 10:40:18'),(86,'tiger4',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [1 level 업데이트]',4,'2021-12-23 11:51:48'),(87,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-23 12:10:21'),(88,'testadmin','212.102.51.234','local','Y',NULL,NULL,NULL,1,'2021-12-24 01:51:17'),(89,'betgo1','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-24 02:18:13'),(90,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-24 02:18:19'),(91,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-24 02:46:12'),(92,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-24 06:35:18'),(93,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-24 07:58:14'),(94,'testadmin','212.102.51.231','local','Y',NULL,NULL,NULL,1,'2021-12-24 07:58:26'),(95,'tombow','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-26 13:37:45'),(96,'tombow','210.151.37.199','local','Y',NULL,NULL,NULL,1,'2021-12-26 13:37:49'),(97,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-27 01:38:08'),(98,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-27 01:52:44'),(99,'testadmin','212.102.51.231','local','Y',NULL,NULL,NULL,1,'2021-12-27 02:00:22'),(100,'testadmin','212.102.51.231','local','N',NULL,NULL,NULL,1,'2021-12-27 06:42:32'),(101,'testadmin','212.102.51.231','local','Y',NULL,NULL,NULL,1,'2021-12-27 06:42:36'),(102,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-27 07:23:53'),(103,'tiger1',NULL,NULL,NULL,NULL,NULL,'[test] [test] 등록',3,'2021-12-27 08:10:36'),(104,'tiger1',NULL,NULL,NULL,NULL,NULL,'[test]  삭제',3,'2021-12-27 08:10:53'),(105,'tiger2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-27 08:27:18'),(106,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-28 00:39:12'),(107,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-28 05:48:52'),(108,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-28 06:21:13'),(109,'tiger4','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-28 08:20:38'),(110,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-28 08:20:42'),(111,'tiger','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-28 09:01:02'),(112,'tiger','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-28 09:01:06'),(113,'tiger','54.250.249.165','local','N',NULL,NULL,NULL,1,'2021-12-28 09:01:11'),(114,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-28 09:01:16'),(115,'admintest','138.199.21.51','local','N',NULL,NULL,NULL,1,'2021-12-28 19:18:38'),(116,'testadmin','212.102.51.226','local','Y',NULL,NULL,NULL,1,'2021-12-29 00:44:32'),(117,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-29 00:45:29'),(118,'testadmin','212.102.51.231','local','Y',NULL,NULL,NULL,1,'2021-12-29 02:34:12'),(119,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-29 06:17:17'),(120,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2021-12-29 06:19:03'),(121,'tiger4',NULL,NULL,NULL,NULL,NULL,'사이트 점검  [N] [Y]',7,'2021-12-29 08:43:49'),(122,'tiger4',NULL,NULL,NULL,NULL,NULL,'사이트 점검  [Y] [N]',7,'2021-12-29 08:46:23'),(123,'tiger4',NULL,NULL,NULL,NULL,NULL,'충전 점검  [N] [Y]',7,'2021-12-29 08:46:30'),(124,'tiger4',NULL,NULL,NULL,NULL,NULL,'환전 점검  [N] [Y]',7,'2021-12-29 08:46:30'),(125,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-29 09:36:26'),(126,'tombow','210.151.37.199','local','N',NULL,NULL,NULL,1,'2021-12-30 07:17:41'),(127,'tombow','210.151.37.199','local','Y',NULL,NULL,NULL,1,'2021-12-30 07:17:45'),(128,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2021-12-30 07:39:58'),(129,'testadmin2','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-01-03 00:50:53'),(130,'testadmin2','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-01-03 00:50:57'),(131,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-01-03 00:51:04'),(132,'tiger1','127.0.0.1','local','N',NULL,NULL,NULL,1,'2022-01-03 02:01:31'),(133,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-03 02:01:33'),(134,'testadmin','212.102.51.233','local','Y',NULL,NULL,NULL,1,'2022-01-03 02:23:19'),(135,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-01-03 02:28:32'),(136,'tiger3','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-03 02:28:46'),(137,'tc01','212.102.51.233','local','N',NULL,NULL,NULL,1,'2022-01-03 02:49:11'),(138,'testadmin','212.102.51.233','local','Y',NULL,NULL,NULL,1,'2022-01-03 02:49:20'),(139,'testadmin','212.102.51.227','local','Y',NULL,NULL,NULL,1,'2022-01-03 07:58:12'),(140,'tombow','210.151.37.199','local','N',NULL,NULL,NULL,1,'2022-01-03 08:26:52'),(141,'tombow','210.151.37.199','local','Y',NULL,NULL,NULL,1,'2022-01-03 08:26:55'),(142,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-01-03 08:46:28'),(143,'tiger3',NULL,NULL,NULL,NULL,NULL,'[test][test7] 등록',3,'2022-01-03 13:21:28'),(144,'tiger3',NULL,NULL,NULL,NULL,NULL,'[]  삭제',3,'2022-01-03 13:21:58'),(145,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-04 01:00:55'),(146,'tiger4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-01-04 01:00:56'),(147,'testadmin','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-01-04 01:54:01'),(148,'testadmin','212.102.51.227','local','Y',NULL,NULL,NULL,1,'2022-01-04 02:39:38'),(149,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-04 03:15:43'),(150,'tiger2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-01-04 05:48:26'),(151,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-04 05:50:09'),(152,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-01-04 06:13:58'),(153,'tiger1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-01-04 08:14:07'),(154,'tiger3',NULL,NULL,NULL,NULL,NULL,'충전 점검  [Y] [N]',7,'2022-01-04 08:47:53'),(155,'tiger3',NULL,NULL,NULL,NULL,NULL,'환전 점검  [Y] [Y]',7,'2022-01-04 08:47:53'),(156,'tiger3',NULL,NULL,NULL,NULL,NULL,'충전 점검  [N] [Y]',7,'2022-01-04 08:48:01'),(157,'tombow','210.151.37.154','local','N',NULL,NULL,NULL,1,'2022-01-04 09:06:28'),(158,'tombow','210.151.37.154','local','Y',NULL,NULL,NULL,1,'2022-01-04 09:06:32'),(159,'tiger2','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-04 10:11:56'),(160,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-04 15:56:51'),(161,'tombow','172.107.194.149','미국','Y',NULL,NULL,NULL,1,'2022-01-04 15:59:04'),(162,'hong119','210.151.37.199','일본','N',NULL,NULL,NULL,1,'2022-01-04 15:59:15'),(163,'testadmin','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-04 15:59:24'),(164,'testadmin',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [1 level 업데이트]',4,'2022-01-04 16:41:07'),(165,'testadmin',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [1 level 업데이트]',4,'2022-01-04 16:41:52'),(166,'tiger2','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-05 03:09:27'),(167,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-05 03:16:22'),(168,'testadmin2','::1','local','N',NULL,NULL,NULL,1,'2022-01-05 06:47:25'),(169,'testadmin2','::1','local','N',NULL,NULL,NULL,1,'2022-01-05 06:47:31'),(170,'admin','::1','local','N',NULL,NULL,NULL,1,'2022-01-05 06:48:12'),(171,'testadmin','::1','local','Y',NULL,NULL,NULL,1,'2022-01-05 06:53:32'),(172,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-05 08:11:17'),(173,'tiger2','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-05 08:51:10'),(174,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-05 09:14:26'),(175,'tiger4',NULL,NULL,NULL,NULL,NULL,'사이트 점검  [N] [Y]',7,'2022-01-05 10:36:39'),(176,'tiger4',NULL,NULL,NULL,NULL,NULL,'사이트 점검  [Y] [N]',7,'2022-01-05 10:36:47'),(177,'tiger4',NULL,NULL,NULL,NULL,NULL,'충전 점검  [N] [Y]',7,'2022-01-05 10:37:22'),(178,'tiger4',NULL,NULL,NULL,NULL,NULL,'환전 점검  [N] [Y]',7,'2022-01-05 10:37:22'),(179,'tiger4',NULL,NULL,NULL,NULL,NULL,'충전 점검  [Y] [N]',7,'2022-01-05 10:37:59'),(180,'tiger4',NULL,NULL,NULL,NULL,NULL,'환전 점검  [Y] [N]',7,'2022-01-05 10:37:59'),(181,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-05 10:39:31'),(182,'betgo1','54.250.249.165','미국','N',NULL,NULL,NULL,1,'2022-01-05 10:40:21'),(183,'tiger1','127.0.0.1','local','N',NULL,NULL,NULL,1,'2022-01-05 10:40:26'),(184,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-05 10:40:30'),(185,'tiger1',NULL,NULL,NULL,NULL,NULL,'사이트 점검  [N] [Y]',7,'2022-01-05 10:40:44'),(186,'tiger1',NULL,NULL,NULL,NULL,NULL,'충전 점검  [N] [Y]',7,'2022-01-05 10:41:00'),(187,'tiger1',NULL,NULL,NULL,NULL,NULL,'환전 점검  [N] [Y]',7,'2022-01-05 10:41:00'),(188,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-05 10:42:25'),(189,'tiger4',NULL,NULL,NULL,NULL,NULL,'충전 점검  [Y] [N]',7,'2022-01-05 10:56:42'),(190,'tiger4',NULL,NULL,NULL,NULL,NULL,'환전 점검  [Y] [N]',7,'2022-01-05 10:56:42'),(191,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-05 13:01:50'),(192,'tiger4','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-06 00:30:51'),(193,'tiger2','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-06 02:18:41'),(194,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-06 02:20:51'),(195,'tiger4',NULL,NULL,NULL,NULL,NULL,'충전 점검  [N] [Y]',7,'2022-01-06 02:52:05'),(196,'tiger4',NULL,NULL,NULL,NULL,NULL,'환전 점검  [N] [Y]',7,'2022-01-06 02:52:05'),(197,'tiger4',NULL,NULL,NULL,NULL,NULL,'충전 점검  [Y] [N]',7,'2022-01-06 02:52:29'),(198,'tiger4',NULL,NULL,NULL,NULL,NULL,'환전 점검  [Y] [N]',7,'2022-01-06 02:52:29'),(199,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-06 05:05:33'),(200,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-06 05:53:54'),(201,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-06 06:21:37'),(202,'tiger2','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-06 06:29:12'),(203,'tiger2','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-06 06:32:34'),(204,'wkfk1313','210.151.37.154','일본','N',NULL,NULL,NULL,1,'2022-01-06 07:50:27'),(205,'wkfk1313','210.151.37.154','일본','N',NULL,NULL,NULL,1,'2022-01-06 07:50:31'),(206,'wkfk1313','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-06 07:57:33'),(207,'wkfk1313','210.151.37.154','일본','Y',NULL,NULL,NULL,1,'2022-01-06 08:00:15'),(208,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-06 08:01:24'),(209,'testadmin','::1','local','Y',NULL,NULL,NULL,1,'2022-01-06 08:48:52'),(210,'tiger2','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-06 09:52:01'),(211,'tiger2','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-06 10:21:30'),(212,'tiger4','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-06 10:31:38'),(213,'tiger4','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-07 00:59:34'),(214,'betgo2','54.250.249.165','미국','N',NULL,NULL,NULL,1,'2022-01-07 04:57:32'),(215,'tiger2','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-07 04:57:39'),(216,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-07 05:11:37'),(217,'tiger4','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-07 07:15:55'),(218,'testadmin','::1','local','Y',NULL,NULL,NULL,1,'2022-01-07 10:12:02'),(219,'testadmin','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-07 10:12:49'),(220,'testadmin','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 05:49:27'),(221,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-08 07:12:30'),(222,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-08 07:51:34'),(223,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 07:53:02'),(224,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-08 08:20:33'),(225,'testadmin','54.250.249.165','미국','N',NULL,NULL,NULL,1,'2022-01-08 08:21:01'),(226,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 08:21:02'),(227,'testadmin','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 08:21:05'),(228,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-08 08:26:38'),(229,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-08 08:44:16'),(230,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 08:48:33'),(231,'testadmin','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 08:56:05'),(232,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-08 08:58:34'),(233,'testadmin','223.38.33.169','대한민국','Y',NULL,NULL,NULL,1,'2022-01-08 09:17:13'),(234,'testadmin','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 09:47:11'),(235,'wkfk1313','91.234.192.161','스웨덴','Y',NULL,NULL,NULL,1,'2022-01-08 09:56:08'),(236,'tombow',NULL,NULL,NULL,NULL,NULL,'[cabar01.com][budy] 등록',3,'2022-01-08 09:59:36'),(237,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 10:06:14'),(238,'wkfk1313','210.151.37.154','일본','Y',NULL,NULL,NULL,1,'2022-01-08 10:09:54'),(239,'testadmin','218.54.183.226','대한민국','Y',NULL,NULL,NULL,1,'2022-01-08 10:20:57'),(240,'testadmin','91.234.192.161','스웨덴','N',NULL,NULL,NULL,1,'2022-01-08 10:28:19'),(241,'testadmin','91.234.192.161','스웨덴','Y',NULL,NULL,NULL,1,'2022-01-08 10:28:40'),(242,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-08 10:50:05'),(243,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 10:58:27'),(244,'tiger3','127.0.0.1','local','N',NULL,NULL,NULL,1,'2022-01-08 10:58:36'),(245,'tiger3','127.0.0.1','local','N',NULL,NULL,NULL,1,'2022-01-08 10:58:42'),(246,'tiger2','127.0.0.1','local','N',NULL,NULL,NULL,1,'2022-01-08 10:58:46'),(247,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-08 10:59:16'),(248,'testadmin','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 11:02:43'),(249,'tiger3','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-08 11:14:33'),(250,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-09 07:07:47'),(251,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-09 07:07:47'),(252,'testadmin','167.179.84.101','뉴질랜드','Y',NULL,NULL,NULL,1,'2022-01-09 15:27:59'),(253,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-10 02:01:55'),(254,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-10 03:46:48'),(255,'tiger4','::1','local','Y',NULL,NULL,NULL,1,'2022-01-10 05:45:33'),(256,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-10 06:52:03'),(257,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-10 08:48:54'),(258,'testadmin','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-10 09:09:41'),(259,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-10 10:18:53'),(260,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-10 10:37:17'),(261,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-10 13:57:47'),(262,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-10 14:08:00'),(263,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-10 14:20:42'),(264,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-10 14:20:42'),(265,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-11 04:59:54'),(266,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-11 05:11:49'),(267,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-11 06:12:30'),(268,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-11 08:39:38'),(269,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-11 09:10:45'),(270,'testadmin','::1','local','Y',NULL,NULL,NULL,1,'2022-01-11 10:35:25'),(271,'tiger1','127.0.0.1','local','N',NULL,NULL,NULL,1,'2022-01-12 01:32:35'),(272,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-12 01:32:38'),(273,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-12 02:04:40'),(274,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-12 02:04:40'),(275,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-12 03:51:09'),(276,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-12 04:49:18'),(277,'testadmin','::1','local','Y',NULL,NULL,NULL,1,'2022-01-12 09:07:05'),(278,'wkfk1313','210.151.37.154','일본','Y',NULL,NULL,NULL,1,'2022-01-12 10:44:09'),(279,'testadmin','212.102.51.227','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-13 02:15:02'),(280,'testadmin','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-13 02:21:48'),(281,'testadmin','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-13 02:41:47'),(282,'testadmin','212.102.51.230','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-13 05:55:00'),(283,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-13 06:42:19'),(284,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-13 06:50:10'),(285,'tiger1','210.175.73.195','일본','Y',NULL,NULL,NULL,1,'2022-01-13 07:04:35'),(286,'testadmin','210.175.73.195','일본','Y',NULL,NULL,NULL,1,'2022-01-13 07:05:25'),(287,'testadmin','212.102.51.230','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-13 07:05:47'),(288,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-13 08:45:18'),(289,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-13 09:17:00'),(290,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-13 09:29:20'),(291,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-13 09:32:59'),(292,'tiger1','54.250.249.165','미국','N',NULL,NULL,NULL,1,'2022-01-13 10:16:43'),(293,'tiger1','54.250.249.165','미국','N',NULL,NULL,NULL,1,'2022-01-13 10:16:50'),(294,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-13 10:16:53'),(295,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-13 10:18:00'),(296,'testadmin','156.146.35.170','미국','Y',NULL,NULL,NULL,1,'2022-01-14 02:55:34'),(297,'testadmin','156.146.35.170','미국','Y',NULL,NULL,NULL,1,'2022-01-14 02:56:39'),(298,'tiger3','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-14 04:24:55'),(299,'tiger4','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-14 05:00:21'),(300,'tiger4','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-14 05:14:59'),(301,'tiger4','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-14 05:47:18'),(302,'testadmin','156.146.35.170','미국','Y',NULL,NULL,NULL,1,'2022-01-14 08:42:59'),(303,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-14 09:15:22'),(304,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-14 09:16:04'),(305,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-14 09:17:23'),(306,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-14 12:05:58'),(307,'tiger3','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-14 12:20:57'),(308,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-14 12:23:01'),(309,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-14 13:06:46'),(310,'testadmin','156.146.35.170','미국','Y',NULL,NULL,NULL,1,'2022-01-14 13:15:24'),(311,'tiger2','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-14 13:29:54'),(312,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-14 14:01:30'),(313,'testadmin','156.146.35.170','미국','Y',NULL,NULL,NULL,1,'2022-01-14 14:59:24'),(314,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-14 15:01:04'),(315,'testadmin','156.146.35.170','미국','Y',NULL,NULL,NULL,1,'2022-01-14 15:11:29'),(316,'tombow','210.151.37.199','일본','N',NULL,NULL,NULL,1,'2022-01-14 15:14:35'),(317,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-14 15:14:39'),(318,'testadmin','156.146.35.170','미국','Y',NULL,NULL,NULL,1,'2022-01-14 15:15:24'),(319,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-14 15:17:38'),(320,'testadmin','156.146.35.170','미국','Y',NULL,NULL,NULL,1,'2022-01-14 15:23:00'),(321,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-14 15:37:36'),(322,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-14 16:55:32'),(323,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-14 17:30:44'),(324,'tiger1','128.134.178.249','대한민국','N',NULL,NULL,NULL,1,'2022-01-15 01:06:30'),(325,'tiger1','128.134.178.249','대한민국','Y',NULL,NULL,NULL,1,'2022-01-15 01:06:37'),(326,'tombow','210.151.37.199','일본','N',NULL,NULL,NULL,1,'2022-01-15 05:06:02'),(327,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-15 05:06:07'),(328,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-15 05:09:50'),(329,'wkfk1313','210.151.37.154','일본','Y',NULL,NULL,NULL,1,'2022-01-15 06:08:58'),(330,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-15 06:11:00'),(331,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-15 06:11:01'),(332,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-15 06:32:54'),(333,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-15 06:41:05'),(334,'tombow','210.151.37.199','일본','Y',NULL,NULL,NULL,1,'2022-01-15 06:42:02'),(335,'wkfk1313','210.151.37.154','일본','Y',NULL,NULL,NULL,1,'2022-01-15 07:07:50'),(336,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-15 09:00:55'),(337,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-15 09:02:16'),(338,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-15 09:07:54'),(339,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-15 09:14:15'),(340,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-15 12:10:00'),(341,'testadmin','156.146.35.170','미국','Y',NULL,NULL,NULL,1,'2022-01-15 12:13:49'),(342,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-15 12:44:11'),(343,'wkfk1313','210.151.37.154','일본','Y',NULL,NULL,NULL,1,'2022-01-15 15:18:03'),(344,'tiger4','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-17 01:49:19'),(345,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-17 05:51:42'),(346,'wkfk1313','210.151.37.154','일본','Y',NULL,NULL,NULL,1,'2022-01-17 19:41:20'),(347,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-18 01:22:00'),(348,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-18 02:14:53'),(349,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-18 02:28:25'),(350,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-18 02:57:38'),(351,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-18 04:54:24'),(352,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-18 05:30:58'),(353,'tiger4','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-18 06:56:25'),(354,'tiger2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-18 06:58:48'),(355,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-18 06:59:52'),(356,'testadmin','212.102.51.234','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-18 08:29:20'),(357,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-18 10:11:38'),(358,'tiger1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-01-18 10:25:33'),(359,'testadmin','124.33.132.195','일본','Y',NULL,NULL,NULL,1,'2022-01-18 11:34:52'),(360,'testadmin','212.102.51.234','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-20 05:11:15'),(361,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-21 01:45:17'),(362,'tiger1','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-01-21 09:54:28'),(363,'wkfk1313','210.151.37.154','일본','Y',NULL,NULL,NULL,1,'2022-01-21 23:00:55'),(364,'testadmin','212.102.51.233','이탈리아','Y',NULL,NULL,NULL,1,'2022-01-25 06:59:16'),(365,'wkfk1313','210.151.37.154','일본','Y',NULL,NULL,NULL,1,'2022-01-28 00:52:48'),(366,'testadmin','212.102.51.229','이탈리아','Y',NULL,NULL,NULL,1,'2022-02-03 01:53:22'),(367,'testadmin','212.102.51.229','이탈리아','Y',NULL,NULL,NULL,1,'2022-02-03 08:58:29'),(368,'testadmin','210.151.37.37','일본','Y',NULL,NULL,NULL,1,'2022-02-03 09:01:59'),(369,'testadmin','210.151.37.37','일본','Y',NULL,NULL,NULL,1,'2022-02-03 09:04:15'),(370,'testadmin','54.250.249.165','미국','Y',NULL,NULL,NULL,1,'2022-02-04 05:33:15'),(371,'tiger1','156.146.35.167','미국','Y',NULL,NULL,NULL,1,'2022-02-07 01:31:31'),(372,'testadmin','156.146.35.167','미국','Y',NULL,NULL,NULL,1,'2022-02-07 02:03:02'),(373,'onoff1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-07 11:59:09'),(374,'onoff2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-08 03:04:04'),(375,'onoff1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-08 09:49:11'),(376,'onoff3','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-08 09:52:49'),(377,'onoff1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-09 06:20:44'),(378,'betgo1','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-09 07:37:09'),(379,'onoff1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-09 07:37:15'),(380,'onoff1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-10 06:19:55'),(381,'onoff2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-10 06:20:35'),(382,'onoff2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-10 06:33:35'),(383,'onoff1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-10 06:35:04'),(384,'onoff2','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-10 06:37:52'),(385,'onoff1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-10 06:39:36'),(386,'onoff1','127.0.0.1','local',NULL,NULL,NULL,'이벤트 충전 설정 : start_dt=>14:02 end_dt=>17:00',51,'2022-02-11 04:50:15'),(387,'onoff1',NULL,NULL,NULL,NULL,NULL,'사이트 점검  [N] [Y]',7,'2022-02-11 05:46:02'),(388,'onoff1',NULL,NULL,NULL,NULL,NULL,'충전 점검  [N] [Y]',7,'2022-02-11 05:46:02'),(389,'onoff1',NULL,NULL,NULL,NULL,NULL,'환전 점검  [N] [Y]',7,'2022-02-11 05:46:02'),(390,'onoff1',NULL,NULL,NULL,NULL,NULL,'게시판 점검  [N] [Y]',7,'2022-02-11 05:46:03'),(391,'onoff1',NULL,NULL,NULL,NULL,NULL,'사이트 점검  [Y] [N]',7,'2022-02-11 05:48:35'),(392,'onoff1',NULL,NULL,NULL,NULL,NULL,'충전 점검  [Y] [N]',7,'2022-02-11 05:48:35'),(393,'onoff1',NULL,NULL,NULL,NULL,NULL,'환전 점검  [Y] [N]',7,'2022-02-11 05:48:35'),(394,'onoff1',NULL,NULL,NULL,NULL,NULL,'게시판 점검  [Y] [N]',7,'2022-02-11 05:48:35'),(395,'onoff1',NULL,NULL,NULL,NULL,NULL,'가입 첫충  [20.0] 업데이트',5,'2022-02-11 05:50:17'),(396,'onoff1',NULL,NULL,NULL,NULL,NULL,'가입 첫충  [10.0] 업데이트',5,'2022-02-11 05:50:26'),(397,'onoff1',NULL,NULL,NULL,NULL,NULL,'사이트 점검  [N] [Y]',7,'2022-02-11 06:36:52'),(398,'onoff1',NULL,NULL,NULL,NULL,NULL,'충전 점검  [N] [Y]',7,'2022-02-11 06:36:53'),(399,'onoff1',NULL,NULL,NULL,NULL,NULL,'환전 점검  [N] [Y]',7,'2022-02-11 06:36:53'),(400,'onoff1',NULL,NULL,NULL,NULL,NULL,'게시판 점검  [N] [Y]',7,'2022-02-11 06:36:53'),(401,'onoff1',NULL,NULL,NULL,NULL,NULL,'사이트 점검  [Y] [N]',7,'2022-02-11 06:37:02'),(402,'onoff1',NULL,NULL,NULL,NULL,NULL,'충전 점검  [Y] [N]',7,'2022-02-11 06:37:02'),(403,'onoff1',NULL,NULL,NULL,NULL,NULL,'환전 점검  [Y] [N]',7,'2022-02-11 06:37:02'),(404,'onoff1',NULL,NULL,NULL,NULL,NULL,'게시판 점검  [Y] [N]',7,'2022-02-11 06:37:02'),(405,'onoff1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-11 09:34:37'),(406,'onoff2','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-11 10:08:58'),(407,'testadmin','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-12 03:18:34'),(408,'testadmin','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-12 03:18:38'),(409,'testadmin','212.102.51.230','local','Y',NULL,NULL,NULL,1,'2022-02-12 05:46:19'),(410,'onoff1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-12 05:57:31'),(411,'test7','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-12 09:19:31'),(412,'onoff2','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-12 10:20:31'),(413,'onoff2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-12 10:20:35'),(414,'testadmin','138.199.22.231','local','Y',NULL,NULL,NULL,1,'2022-02-12 11:23:31'),(415,'onoff3','138.199.22.230','local','Y',NULL,NULL,NULL,1,'2022-02-14 01:18:39'),(416,'onoff3','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-14 01:53:45'),(417,'onoff3','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-14 01:53:47'),(418,'onoff3','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-14 01:56:06'),(419,'onoff2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-14 01:56:20'),(420,'onoff2','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-14 02:10:18'),(421,'onoff2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-14 02:10:20'),(422,'testadmin','212.102.51.234','local','Y',NULL,NULL,NULL,1,'2022-02-14 02:25:53'),(423,'onoff2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-14 03:39:15'),(424,'tombow','124.33.132.244','local','N',NULL,NULL,NULL,1,'2022-02-14 06:41:48'),(425,'testadmin','124.33.132.244','local','Y',NULL,NULL,NULL,1,'2022-02-14 06:42:02'),(426,'onoff3','212.102.51.234','local','Y',NULL,NULL,NULL,1,'2022-02-14 06:54:34'),(427,'testadmin',NULL,NULL,NULL,NULL,NULL,'가입 첫충  [5.0] 업데이트',5,'2022-02-14 07:20:10'),(428,'onoff2','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-14 07:40:16'),(429,'onoff2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-14 07:40:21'),(430,'testadmin','210.151.37.154','local','Y',NULL,NULL,NULL,1,'2022-02-14 07:57:45'),(431,'onoff2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-14 08:32:12'),(432,'test1','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-14 08:37:21'),(433,'onoff3','138.199.22.235','local','Y',NULL,NULL,NULL,1,'2022-02-14 09:30:56'),(434,'onoff3','212.102.51.234','local','Y',NULL,NULL,NULL,1,'2022-02-14 09:45:52'),(435,'tombow','124.33.132.244','local','N',NULL,NULL,NULL,1,'2022-02-14 15:26:43'),(436,'testadmin','124.33.132.244','local','Y',NULL,NULL,NULL,1,'2022-02-14 15:26:48'),(437,'testadmin','210.151.37.154','local','Y',NULL,NULL,NULL,1,'2022-02-14 15:30:31'),(438,'testadmin','203.10.99.101','local','Y',NULL,NULL,NULL,1,'2022-02-14 15:55:00'),(439,'onoff2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-15 01:33:36'),(440,'onoff3','212.102.51.234','local','Y',NULL,NULL,NULL,1,'2022-02-15 01:33:41'),(441,'onoff1','54.250.249.165','local','N',NULL,NULL,NULL,1,'2022-02-15 01:34:58'),(442,'onoff4','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-15 01:35:28'),(443,'onoff2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-15 02:56:41'),(444,'arachang','91.234.192.40','local','N',NULL,NULL,NULL,1,'2022-02-15 05:11:55'),(445,'wkfk1313','210.151.37.154','local','N',NULL,NULL,NULL,1,'2022-02-15 06:37:52'),(446,'Testadmin','210.151.37.154','local','Y',NULL,NULL,NULL,1,'2022-02-15 06:40:19'),(447,'Easy','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-15 06:43:15'),(448,'onoff1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-15 06:47:26'),(449,'arachang','182.221.206.154','local','Y',NULL,NULL,NULL,1,'2022-02-15 06:50:48'),(450,'onoff2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-15 06:57:46'),(451,'tombow','124.33.132.244','local','Y',NULL,NULL,NULL,1,'2022-02-15 08:46:38'),(452,'onoff2','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-15 09:03:55'),(453,'Tombow',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [1 level 업데이트]',4,'2022-02-15 09:41:02'),(454,'Tombow',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [2 level 업데이트]',4,'2022-02-15 09:41:02'),(455,'Tombow',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [3 level 업데이트]',4,'2022-02-15 09:41:02'),(456,'Tombow',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [4 level 업데이트]',4,'2022-02-15 09:41:02'),(457,'Tombow',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [5 level 업데이트]',4,'2022-02-15 09:41:02'),(458,'Tombow',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [6 level 업데이트]',4,'2022-02-15 09:41:02'),(459,'Tombow',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [7 level 업데이트]',4,'2022-02-15 09:41:02'),(460,'Tombow',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [8 level 업데이트]',4,'2022-02-15 09:41:02'),(461,'Tombow',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [9 level 업데이트]',4,'2022-02-15 09:41:02'),(462,'Tombow',NULL,NULL,NULL,NULL,NULL,'[레벨별 계좌 설정] [10 level 업데이트]',4,'2022-02-15 09:41:02'),(463,'onoff1',NULL,NULL,NULL,NULL,NULL,'카지노 점검  [N] [Y]',7,'2022-02-15 11:35:36'),(464,'onoff1',NULL,NULL,NULL,NULL,NULL,'슬롯 점검  [N] [Y]',7,'2022-02-15 11:35:36'),(465,'onoff1',NULL,NULL,NULL,NULL,NULL,'카지노 점검  [Y] [N]',7,'2022-02-15 11:35:49'),(466,'onoff1',NULL,NULL,NULL,NULL,NULL,'슬롯 점검  [Y] [N]',7,'2022-02-15 11:35:50'),(467,'onoff3','156.146.35.166','local','Y',NULL,NULL,NULL,1,'2022-02-16 01:29:48'),(468,'onoff3','156.146.35.166','local','Y',NULL,NULL,NULL,1,'2022-02-16 05:52:53'),(469,'onoff1',NULL,NULL,NULL,NULL,NULL,'가입 첫충  [6.0] 업데이트',5,'2022-02-16 07:37:50'),(470,'onoff1',NULL,NULL,NULL,NULL,NULL,'가입 첫충  [5.0] 업데이트',5,'2022-02-16 07:37:59'),(471,'onoff1','54.250.249.165','local','Y',NULL,NULL,NULL,1,'2022-02-16 07:51:40'),(472,'testadmin','210.151.37.199','local','Y',NULL,NULL,NULL,1,'2022-02-16 09:06:39'),(473,'testadmin','210.151.36.197','local','Y',NULL,NULL,NULL,1,'2022-02-16 09:07:38'),(474,'onoff3','212.102.51.233','local','Y',NULL,NULL,NULL,1,'2022-02-16 10:01:23'),(475,'onoff1','127.0.0.1','local','Y',NULL,NULL,NULL,1,'2022-02-16 10:25:07'),(476,'tombow','210.151.37.199','local','Y',NULL,NULL,NULL,1,'2022-02-16 12:39:30'),(477,'wkfk1313','210.151.37.154','local','Y',NULL,NULL,NULL,1,'2022-02-16 23:19:45');
 SET character_set_client = utf8mb4 ;

--
-- Table structure for table `t_ip_country`
--

 SET character_set_client = utf8mb4 ;
CREATE TABLE `t_ip_country` (
  `idx` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `country_code` varchar(10) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `ip_start` int(10) unsigned NOT NULL,
  `ip_end` int(10) unsigned NOT NULL,
  PRIMARY KEY (`idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `t_ip_country`
--


--
-- Dumping events for database 'BETGO_ADMIN_DEV'
--

--
-- Dumping routines for database 'BETGO_ADMIN_DEV'
--
/*!50003 DROP FUNCTION IF EXISTS `FN_GET_IP_COUNTRY` */;
DELIMITER ;;
CREATE DEFINER=`admin`@`%` FUNCTION `FN_GET_IP_COUNTRY`($p_ip VARCHAR(50)) RETURNS varchar(50) CHARSET utf8
BEGIN

	DECLARE $ret 			VARCHAR(50);
	DECLARE $v_ip 			INT UNSIGNED DEFAULT 0;
	SET $ret = 'local';

	SELECT INET_ATON($p_ip) INTO $v_ip;
	SELECT country INTO $ret FROM t_ip_country WHERE $v_ip >= ip_start and $v_ip <= ip_end LIMIT 1;

	RETURN $ret;
END ;;
DELIMITER ;


