515 lines
36 KiB
SQL
515 lines
36 KiB
SQL
-- MySQL dump 10.13 Distrib 5.6.44, for Linux (x86_64)
|
|
--
|
|
-- Host: localhost Database: CCDB
|
|
-- ------------------------------------------------------
|
|
-- Server version 5.6.44
|
|
|
|
/*!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 */;
|
|
/*!40101 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_admin`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_admin`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_admin` (
|
|
`admin_seq` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`admin_id` varchar(16) NOT NULL,
|
|
`admin_name` varchar(16) NOT NULL,
|
|
`admin_password` varchar(32) NOT NULL,
|
|
`admin_type` char(4) NOT NULL,
|
|
`admin_email` varchar(128) NOT NULL,
|
|
`admin_phone` varchar(20) NOT NULL,
|
|
`admin_sms_send` char(1) NOT NULL,
|
|
`admin_etc` text NOT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`update_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`deleted_yn` char(1) NOT NULL DEFAULT 'N',
|
|
`warn_stg_rate` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`admin_seq`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_admin`
|
|
--
|
|
|
|
LOCK TABLES `t_admin` WRITE;
|
|
/*!40000 ALTER TABLE `t_admin` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_admin` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_code_master`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_code_master`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_code_master` (
|
|
`code` char(4) NOT NULL,
|
|
`code_dtl` varchar(64) NOT NULL,
|
|
UNIQUE KEY `code` (`code`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_code_master`
|
|
--
|
|
|
|
LOCK TABLES `t_code_master` WRITE;
|
|
/*!40000 ALTER TABLE `t_code_master` DISABLE KEYS */;
|
|
INSERT INTO `t_code_master` VALUES ('AT01','전체관리자'),('AT02','일반관리자'),('EV01','관리작업'),('EV02','시스템장애'),('EV03','용량경고'),('EV04','RAID Error'),('RA01','DEVICE_OUT'),('RA02','Undefined Error'),('RA03','Writing Error'),('RA04','Reading Error'),('RA05','Start Rebuild'),('RA06','Undefined Error');
|
|
/*!40000 ALTER TABLE `t_code_master` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_fts_log`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_fts_log`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_fts_log` (
|
|
`tid` varchar(20) NOT NULL,
|
|
`mode` int(10) DEFAULT NULL,
|
|
`source_pop` varchar(20) NOT NULL,
|
|
`target_pop` varchar(20) NOT NULL,
|
|
`file_name` varchar(256) DEFAULT NULL,
|
|
`fts_status` varchar(4) NOT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`update_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`deleted_yn` char(1) NOT NULL DEFAULT 'N',
|
|
PRIMARY KEY (`tid`),
|
|
UNIQUE KEY `tid` (`tid`),
|
|
KEY `tid_2` (`tid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_fts_log`
|
|
--
|
|
|
|
LOCK TABLES `t_fts_log` WRITE;
|
|
/*!40000 ALTER TABLE `t_fts_log` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_fts_log` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_fts_log_dtl`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_fts_log_dtl`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_fts_log_dtl` (
|
|
`tid` varchar(20) NOT NULL,
|
|
`file_name_dtl` varchar(256) DEFAULT NULL,
|
|
`fts_status` varchar(4) NOT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`update_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`deleted_yn` char(1) NOT NULL DEFAULT 'N',
|
|
KEY `idx_fhs_log_dtl_tid` (`tid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_fts_log_dtl`
|
|
--
|
|
|
|
LOCK TABLES `t_fts_log_dtl` WRITE;
|
|
/*!40000 ALTER TABLE `t_fts_log_dtl` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_fts_log_dtl` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_neo_server_index`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_neo_server_index`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_neo_server_index` (
|
|
`neo_seq` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
|
|
`neo_type` varchar(10) DEFAULT NULL,
|
|
`name` varchar(10) NOT NULL,
|
|
`ip` varchar(30) NOT NULL,
|
|
`port` tinyint(3) unsigned DEFAULT NULL,
|
|
`domain` varchar(50) DEFAULT NULL,
|
|
`dig_domain` varchar(50) DEFAULT NULL,
|
|
`to_align` varchar(2) DEFAULT NULL,
|
|
`status` tinyint(3) unsigned NOT NULL DEFAULT '1',
|
|
`dead_count` tinyint(3) unsigned DEFAULT '0',
|
|
`type` varchar(50) NOT NULL DEFAULT 'NEOSVR',
|
|
`monitor_yn` char(50) DEFAULT 'Y',
|
|
`deleted_yn` char(50) NOT NULL DEFAULT 'N',
|
|
`update_datetime` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`neo_seq`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_neo_server_index`
|
|
--
|
|
|
|
LOCK TABLES `t_neo_server_index` WRITE;
|
|
/*!40000 ALTER TABLE `t_neo_server_index` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_neo_server_index` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_rms_rc_index`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_rms_rc_index`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_rms_rc_index` (
|
|
`rcid` varchar(32) NOT NULL,
|
|
`rc_name` varchar(255) DEFAULT NULL,
|
|
`svc_rcts_url` varchar(2048) DEFAULT NULL,
|
|
`vol_url_rts` varchar(2048) DEFAULT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`update_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`deleted_yn` char(1) NOT NULL DEFAULT 'N',
|
|
`arrange` int(2) NOT NULL AUTO_INCREMENT,
|
|
`rcacct` varchar(2048) DEFAULT NULL,
|
|
PRIMARY KEY (`arrange`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_rms_rc_index`
|
|
--
|
|
|
|
LOCK TABLES `t_rms_rc_index` WRITE;
|
|
/*!40000 ALTER TABLE `t_rms_rc_index` DISABLE KEYS */;
|
|
INSERT INTO `t_rms_rc_index` VALUES ('NH01','대용량1','nh01-rcts.x-cdn.com','nh01-fhs.x-cdn.com','2014-08-13 08:28:14','2009-12-15 09:53:51','N',1,'nh-01-monitor:solboxmonitor:credeyes39:nh01monitor:/user/service/cert/solboxmonitor501.cert'),('TIME','CC','61.111.52.250','61.111.52.250','2014-11-24 07:30:46','0000-00-00 00:00:00','N',2,'::::'),('NH02','대용량2','nh-02-rcts.x-cdn.com','nh-02-fhs.x-cdn.com','2014-08-13 09:07:38','0000-00-00 00:00:00','N',3,'nh-02-monitor:solboxmonitor:credeyes39:nh02monitor:/user/service/cert/solboxmonitor502.cert'),('GD02','GD-02','gd-02-rcts.x-cdn.com','gd-02-fhs.x-cdn.com','2015-03-19 02:22:27','0000-00-00 00:00:00','N',7,'gd-02-monitor:solboxmonitor:credeyes39:gd02monitor:/user/service/cert/solboxmonitor515.cert'),('PC71','PC-71','pc-71-rcts.x-cdn.com','pc-71-fhs.x-cdn.com','2018-12-20 09:36:43','0000-00-00 00:00:00','N',9,'pc-71-monitor:solboxmonitor:credeyes39:pc71monitor:/user/service/cert/solboxmonitor581.cert'),('GS61','GS-61','gs-61-rcts.x-cdn.com','gs-61-fhs.x-cdn.com','2019-03-30 11:22:29','0000-00-00 00:00:00','N',10,'gs-61-monitor:solboxmonitor:credeyes39:gs61monitor:/user/service/cert/solboxmonitor584.cert');
|
|
/*!40000 ALTER TABLE `t_rms_rc_index` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_rms_rc_server_index`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_rms_rc_server_index`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_rms_rc_server_index` (
|
|
`rc_server_seq` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`rcid` varchar(32) NOT NULL,
|
|
`name` varchar(255) DEFAULT NULL,
|
|
`ip` varchar(255) DEFAULT NULL,
|
|
`port` varchar(10) DEFAULT '80',
|
|
`type` varchar(10) DEFAULT 'RTS',
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`update_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`monitor_yn` char(1) NOT NULL DEFAULT 'Y',
|
|
`deleted_yn` char(1) NOT NULL DEFAULT 'N',
|
|
`etc1` varchar(4000) NOT NULL DEFAULT '0',
|
|
`etc2` varchar(4000) NOT NULL DEFAULT '1',
|
|
`etc3` varchar(4000) NOT NULL DEFAULT '0',
|
|
`raid_stat` tinyint(3) unsigned NOT NULL DEFAULT '2',
|
|
`raid_update_updatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`rc_server_seq`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=287 DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_rms_rc_server_index`
|
|
--
|
|
|
|
LOCK TABLES `t_rms_rc_server_index` WRITE;
|
|
/*!40000 ALTER TABLE `t_rms_rc_server_index` DISABLE KEYS */;
|
|
INSERT INTO `t_rms_rc_server_index` VALUES (6,'nh01','NH01_RCTS02','61.111.53.242','13104','RCTS','2009-12-15 11:27:47','2019-06-27 03:01:49','Y','N','D','1','0',2,'1970-01-01 09:00:00'),(7,'nh01','NH01_FHS001','61.111.52.21','80','RTS','2009-12-15 11:27:47','2019-06-27 03:01:49','Y','N','C','1','0',2,'1970-01-01 09:00:00'),(15,'nh01','NH01_RC','nh-01-monitor','80','RC','2009-12-15 11:27:47','2019-06-27 03:01:49','Y','N','A','1','0',2,'1970-01-01 09:00:00'),(16,'nh01','NH01_STAT','nh01','80','STAT','2009-12-15 11:27:47','2019-06-27 03:01:49','N','N','B','1','0',2,'1970-01-01 09:00:00'),(21,'NH01','NH01_RCDB01','61.111.52.243','6543','RCDB','2010-10-05 08:46:58','2019-06-27 03:01:49','Y','N','E','1','0',2,'0000-00-00 00:00:00'),(22,'NH01','NH01_RCDB02','61.111.53.243','6543','RCDB','2010-10-05 08:46:58','2019-06-27 03:01:49','Y','N','E','1','0',2,'0000-00-00 00:00:00'),(25,'NH01','NH01_FHS007','61.111.52.151','80','RTS','2011-03-31 08:25:48','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(29,'NH01','NH01_FHS008','61.111.52.152','80','RTS','2011-04-29 07:33:15','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(31,'NH01','NH01_FHS012','61.111.52.154','80','RTS','2011-05-30 07:24:20','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(32,'NH01','NH01_FHS013','182.162.11.31','80','RTS','2011-05-30 07:53:35','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(33,'NH01','NH01_FHS014','182.162.11.32','80','RTS','2011-06-09 08:54:31','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(34,'NH01','NH01_FHS015','182.162.11.33','80','RTS','2011-06-10 04:34:49','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(35,'TIME','TIME_gts02','182.162.108.130','80','0','2011-07-25 09:02:51','2019-06-19 11:53:10','N','N','','2','0',2,'0000-00-00 00:00:00'),(37,'NH01','NH01_FHS016','61.111.53.40','80','RTS','2011-08-04 04:31:12','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(38,'NH01','NH01_FHS017','61.111.53.41','8083','RTS','2011-08-04 05:42:39','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(39,'NH01','NH01_FHS018','61.111.53.38','80','RTS','2011-08-04 06:05:01','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(40,'NH01','NH01_FHS019','61.111.53.39','80','RTS','2011-08-04 06:05:21','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(41,'NH01','NH01_FHS020','61.111.53.48','80','RTS','2011-08-04 06:32:39','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(42,'NH01','NH01_FHS021','61.111.53.49','80','RTS','2011-08-04 06:33:04','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(44,'NH01','NH01_FHS023','61.111.53.23','80','RTS','2011-08-04 06:34:29','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(56,'NH01','NH01_FHS035','61.111.52.40','80','RTS','2011-11-22 13:42:41','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(67,'NH02','NH02_FHS001','210.124.122.221','80','RTS','2012-05-31 08:39:51','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(68,'NH02','NH02_FHS002','210.124.122.222','80','RTS','2012-05-31 08:42:24','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(69,'NH02','NH02_FHS003','210.124.122.223','80','RTS','2012-05-31 08:42:24','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(70,'NH02','NH02_FHS004','210.124.122.224','80','RTS','2012-05-31 08:42:24','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(71,'NH02','NH02_FHS005','210.124.122.225','80','RTS','2012-05-31 08:42:24','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(72,'NH02','NH02_FHS006','210.124.122.226','80','RTS','2012-05-31 08:42:24','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(73,'NH02','NH02_FHS007','210.124.122.227','80','RTS','2012-05-31 08:42:24','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(74,'NH02','NH02_FHS008','210.124.122.228','80','RTS','2012-05-31 08:42:24','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(75,'NH02','NH02_FHS009','210.124.122.229','80','RTS','2012-05-31 08:42:24','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(76,'NH02','NH02_FHS010','210.124.122.230','80','RTS','2012-05-31 08:42:24','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(79,'NH02','NH02_RCDB01','210.124.122.253','6543','RCDB','2012-05-31 08:46:12','2019-05-30 05:49:23','Y','N','E','3','0',2,'0000-00-00 00:00:00'),(80,'NH02','NH02_RCDB02','210.124.122.254','6543','RCDB','2012-05-31 08:46:12','2019-05-30 05:49:23','Y','N','E','3','0',2,'0000-00-00 00:00:00'),(81,'NH02','NH02_RCTS01','210.124.122.251','13104','RCTS','2012-05-31 08:46:12','2019-05-30 05:49:23','Y','N','D','3','0',2,'0000-00-00 00:00:00'),(82,'NH02','NH02_RCTS02','210.124.122.252','13104','RCTS','2012-05-31 08:46:12','2019-05-30 05:49:23','N','N','D','3','0',2,'0000-00-00 00:00:00'),(83,'NH02','NH02_RC','nh-02-monitor','80','RC','2012-05-31 08:49:44','2019-05-30 05:49:23','Y','N','A','3','0',2,'0000-00-00 00:00:00'),(84,'NH02','NH02_STAT','nh02','80','STAT','2012-05-31 08:49:44','2019-05-30 05:49:23','N','N','B','3','0',2,'0000-00-00 00:00:00'),(85,'NH01','NH01_RCTS01','61.111.52.242','13104','RCTS','2012-07-03 08:11:53','2019-06-27 03:01:49','N','N','D','1','0',2,'0000-00-00 00:00:00'),(86,'NH02','NH02_FHS011','210.124.122.231','80','RTS','2012-08-08 08:36:17','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(88,'NH02','NH02_FHS013','210.124.122.233','80','RTS','2012-08-08 08:47:24','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(89,'NH02','NH02_FHS014','210.124.122.234','80','RTS','2012-08-08 08:47:42','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(96,'NH01','NH01_FHS025','61.111.53.17','80','RTS','2012-09-11 04:13:32','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(97,'NH01','NH01_FHS026','61.111.53.18','80','RTS','2012-09-11 04:13:32','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(119,'NH01','NH01_FHS036','61.111.53.11','80','RTS','2012-10-25 01:07:39','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(121,'NH01','NH01_FHS038','61.111.53.13','80','RTS','2012-10-25 01:08:18','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(122,'NH01','NH01_FHS039','61.111.53.14','80','RTS','2012-10-25 01:09:29','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(123,'NH01','NH01_FHS040','61.111.53.15','80','RTS','2013-01-07 04:59:41','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(124,'NH01','NH01_FHS041','61.111.53.16','80','RTS','2013-01-07 05:00:17','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(141,'NH01','NH01_FHS042','182.162.11.21','80','RTS','2013-03-26 01:19:22','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(143,'NH01','NH01_FHS044','182.162.11.23','80','RTS','2013-03-26 01:25:53','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(144,'NH01','NH01_FHS045','182.162.11.24','8083','RTS','2013-03-26 01:26:49','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(145,'NH01','NH01_FHS046','182.162.11.25','80','RTS','2013-03-26 01:27:21','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(146,'NH01','NH01_FHS047','182.162.11.26','80','RTS','2013-03-26 01:28:02','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(151,'NH02','NH02_FHS015','210.124.122.235','80','RTS','2013-03-26 07:28:40','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(185,'TIME','TIME_logbackup','210.124.122.211','80','0','2014-11-24 08:24:46','2019-06-19 11:53:10','N','N','','2','0',2,'0000-00-00 00:00:00'),(188,'NH02','NH02_FHS019','210.124.122.239','80','RTS','2014-12-23 10:25:05','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(189,'NH02','NH02_FHS020','210.124.122.240','80','RTS','2014-12-23 10:25:27','2019-05-30 05:49:23','Y','N','C','3','0',2,'0000-00-00 00:00:00'),(191,'GD02','GD02_RCDB01','211.237.7.21','6543','RCDB','2015-03-19 02:25:57','2019-05-30 05:49:12','Y','N','E','7','0',2,'0000-00-00 00:00:00'),(192,'GD02','GD02_RCDB02','211.237.7.22','6543','RCDB','2015-03-19 02:26:23','2019-05-30 05:49:12','Y','N','E','7','0',2,'0000-00-00 00:00:00'),(193,'GD02','GD02_RC','gd-02-monitor','80','RC','2015-03-19 02:26:47','2019-05-30 05:49:12','Y','N','A','7','0',2,'0000-00-00 00:00:00'),(194,'GD02','GD02_RCTS01','211.237.7.23','13104','RCTS','2015-03-19 02:27:17','2019-05-30 05:49:12','N','N','D','7','0',2,'0000-00-00 00:00:00'),(195,'GD02','GD02_RCTS02','211.237.7.24','13104','RCTS','2015-03-19 02:27:40','2019-05-30 05:49:12','Y','N','D','7','0',2,'0000-00-00 00:00:00'),(196,'GD02','GD02_FHS001','211.237.7.31','8083','RTS','2015-03-19 02:28:44','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(197,'GD02','GD02_FHS002','211.237.7.32','8083','RTS','2015-03-19 02:29:02','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(198,'GD02','GD02_FHS003','211.237.7.33','8083','RTS','2015-03-19 02:29:53','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(199,'GD02','GD02_FHS004','211.237.7.34','8083','RTS','2015-03-19 02:30:11','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(200,'GD02','GD02_FHS005','211.237.7.35','8083','RTS','2015-03-19 02:30:30','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(201,'GD02','GD02_FHS006','211.237.7.36','8083','RTS','2015-03-19 02:30:45','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(202,'GD02','GD02_STAT','gd02','80','STAT','2015-03-19 07:29:58','2019-05-30 05:49:12','N','N','B','7','0',2,'0000-00-00 00:00:00'),(216,'NH01','NH01_FHS027','61.111.53.19','80','RTS','2015-04-30 02:24:23','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(217,'NH01','NH01_FHS028','61.111.53.20','80','RTS','2015-04-30 02:24:43','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(219,'NH01','NH01_FHS030','61.111.53.230','80','RTS','2015-05-07 05:20:28','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(220,'NH01','NH01_FHS031','61.111.53.231','80','RTS','2015-05-07 05:20:44','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(221,'NH01','NH01_FHS032','61.111.53.232','80','RTS','2015-05-07 05:20:57','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(224,'NH01','NH01_FHS048','61.111.53.21','80','RTS','2016-01-20 07:35:51','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(225,'NH01','NH01_FHS049','61.111.53.25','80','RTS','2016-01-20 07:36:16','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(226,'NH01','NH01_FHS050','61.111.53.26','80','RTS','2016-01-20 07:36:35','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(227,'NH01','NH01_FHS051','61.111.53.46','80','RTS','2016-01-20 07:36:52','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(228,'GD02','GD02_FHS007','211.237.7.37','8083','RTS','2016-02-05 01:23:53','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(229,'GD02','GD02_FHS008','211.237.7.38','8083','RTS','2016-02-05 01:24:17','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(230,'GD02','GD02_FHS009','211.237.7.39','8083','RTS','2016-02-05 01:24:39','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(231,'GD02','GD02_FHS010','211.237.7.40','8083','RTS','2016-02-05 01:24:57','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(238,'GD02','GD02_FHS012','211.237.7.42','8083','RTS','2017-06-28 09:12:22','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(239,'GD02','GD02_FHS013','211.237.7.43','8083','RTS','2017-06-28 09:12:36','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(240,'GD02','GD02_FHS014','211.237.7.44','8083','RTS','2017-06-28 09:12:49','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(241,'NH01','NH01_FHS052','61.111.53.47','80','RTS','2018-01-24 12:38:56','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(242,'GD02','GD02_FHS015','211.237.7.45','8083','RTS','2018-04-12 06:47:23','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(243,'GD02','GD02_FHS016','211.237.7.46','8083','RTS','2018-04-12 06:47:42','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(244,'GD02','GD02_FHS017','211.237.7.47','8083','RTS','2018-04-12 06:48:12','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(245,'GD02','GD02_FHS018','211.237.7.48','8083','RTS','2018-04-12 06:48:33','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(247,'GD02','GD02_FHS019','211.237.7.49','8083','RTS','2018-10-25 11:07:05','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(248,'GD02','GD02_FHS020','211.237.7.50','8083','RTS','2018-10-25 11:07:44','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(249,'GD02','GD02_FHS021','211.237.7.101','8083','RTS','2018-10-25 11:08:10','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(250,'GD02','GD02_FHS022','211.237.7.102','8083','RTS','2018-10-25 11:08:43','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(251,'GD02','GD02_FHS023','211.237.7.103','8083','RTS','2018-12-11 08:42:54','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(252,'GD02','GD02_FHS024','211.237.7.104','8083','RTS','2018-12-11 08:43:10','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(253,'GD02','GD02_FHS025','211.237.7.105','8083','RTS','2018-12-11 08:43:25','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(254,'GD02','GD02_FHS026','211.237.7.106','8083','RTS','2018-12-11 08:43:42','2019-05-30 05:49:12','Y','N','C','7','0',2,'0000-00-00 00:00:00'),(255,'PC71','PC71_RC','pc-71-monitor','80','RC','2018-12-20 09:40:55','2019-06-12 05:03:35','Y','N','A','9','0',2,'0000-00-00 00:00:00'),(256,'PC71','PC71_RCDB01','117.52.158.101','6543','RCDB','2018-12-20 09:42:50','2019-06-12 05:03:35','Y','N','E','9','0',2,'0000-00-00 00:00:00'),(257,'PC71','PC71_RCDB02','117.52.158.102','6543','RCDB','2018-12-20 09:43:19','2019-06-12 05:03:35','Y','N','E','9','0',2,'0000-00-00 00:00:00'),(258,'PC71','PC71_RCTS01','117.52.158.103','13104','RCTS','2018-12-20 09:43:51','2019-06-12 05:03:35','Y','N','D','9','0',2,'0000-00-00 00:00:00'),(259,'PC71','PC71_RCTS02','117.52.158.104','13104','RCTS','2018-12-20 09:44:17','2019-06-12 05:03:35','N','N','D','9','0',2,'0000-00-00 00:00:00'),(260,'PC71','PC71_FHS001','117.52.158.105','8083','RTS','2018-12-20 09:44:39','2019-06-12 05:03:35','Y','N','C','9','0',2,'0000-00-00 00:00:00'),(261,'PC71','PC71_STAT','pc71','80','STAT','2018-12-20 09:45:00','2019-06-12 05:03:35','N','N','B','9','0',2,'0000-00-00 00:00:00'),(262,'PC71','PC71_FHS002','117.52.158.106','8083','RTS','2018-12-20 13:00:25','2019-06-12 05:03:35','Y','N','C','9','0',2,'0000-00-00 00:00:00'),(263,'PC71','PC71_FHS003','117.52.158.107','8083','RTS','2018-12-20 13:00:50','2019-06-12 05:03:35','Y','N','C','9','0',2,'0000-00-00 00:00:00'),(264,'PC71','PC71_FHS004','117.52.158.108','8083','RTS','2018-12-20 13:01:04','2019-06-12 05:03:35','Y','N','C','9','0',2,'0000-00-00 00:00:00'),(265,'PC71','PC71_FHS005','117.52.158.109','8083','RTS','2018-12-20 13:01:19','2019-06-12 05:03:35','Y','N','C','9','0',2,'0000-00-00 00:00:00'),(266,'PC71','PC71_FHS006','117.52.158.110','8083','RTS','2018-12-20 13:01:36','2019-06-12 05:03:35','Y','N','C','9','0',2,'0000-00-00 00:00:00'),(267,'GS61','GS61_RC','gs-61-monitor','80','RC','2019-03-30 11:23:56','2019-07-16 03:13:35','Y','N','A','10','0',2,'0000-00-00 00:00:00'),(268,'GS61','GS61_RCDB01','182.162.107.19','6543','RCDB','2019-03-30 11:24:36','2019-07-16 03:13:35','Y','N','E','10','0',2,'0000-00-00 00:00:00'),(269,'GS61','GS61_RCDB02','182.162.107.20','6543','RCDB','2019-03-30 11:25:00','2019-07-16 03:13:35','Y','N','E','10','0',2,'0000-00-00 00:00:00'),(270,'GS61','GS61_RCTS01','182.162.108.19','13104','RCTS','2019-03-30 11:25:41','2019-07-16 03:13:35','Y','N','D','10','0',2,'0000-00-00 00:00:00'),(271,'GS61','GS61_RCTS02','182.162.108.20','13104','RCTS','2019-03-30 11:26:13','2019-07-16 03:13:35','N','N','D','10','0',2,'0000-00-00 00:00:00'),(272,'GS61','GS61_FHS001','211.237.7.163','8083','RTS','2019-03-30 11:26:52','2019-07-16 03:13:35','Y','N','C','10','0',2,'0000-00-00 00:00:00'),(273,'GS61','GS61_FHS002','211.237.7.164','8083','RTS','2019-03-30 11:27:13','2019-07-16 03:13:35','Y','N','C','10','0',2,'0000-00-00 00:00:00'),(274,'GS61','GS61_FHS003','211.237.7.165','8083','RTS','2019-03-30 11:27:36','2019-07-16 03:13:35','Y','N','C','10','0',2,'0000-00-00 00:00:00'),(275,'GS61','GS61_FHS004','211.237.7.166','8083','RTS','2019-03-30 11:27:56','2019-07-16 03:13:35','Y','N','C','10','0',2,'0000-00-00 00:00:00'),(278,'NH01','NH01_FHS053','61.111.52.34','80','RTS','2019-04-05 11:38:19','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(279,'NH01','NH01_FHS054','61.111.52.37','80','RTS','2019-04-05 11:48:11','2019-06-27 03:01:49','Y','N','C','1','0',2,'0000-00-00 00:00:00'),(280,'PC71','PC71_FHS007','117.52.158.13','8083','RTS','2019-05-03 01:37:52','2019-06-12 05:03:35','Y','N','C','9','0',2,'0000-00-00 00:00:00'),(281,'PC71','PC71_FHS008','117.52.158.14','8083','RTS','2019-05-03 02:32:21','2019-06-12 05:03:35','Y','N','C','9','0',2,'0000-00-00 00:00:00'),(282,'PC71','PC71_FHS009','117.52.158.15','8083','RTS','2019-05-03 02:52:26','2019-06-12 05:03:35','Y','N','C','9','0',2,'0000-00-00 00:00:00'),(283,'TIME','TIME_gts01','182.162.107.130','80','0','2019-06-19 11:52:55','2019-06-19 11:53:10','N','N','','2','0',2,'0000-00-00 00:00:00'),(284,'GS61','GS61_STAT','gs61','80','STAT','2019-07-04 08:55:31','2019-07-16 03:13:35','N','N','B','10','0',2,'0000-00-00 00:00:00'),(285,'GS61','GS61_FHS005','211.237.6.73','8083','RTS','2019-07-16 03:11:04','2019-07-16 03:13:35','Y','N','C','10','0',2,'0000-00-00 00:00:00'),(286,'GS61','GS61_FHS006','211.237.6.74','8083','RTS','2019-07-16 03:11:17','2019-07-16 03:13:35','Y','N','C','10','0',2,'0000-00-00 00:00:00');
|
|
/*!40000 ALTER TABLE `t_rms_rc_server_index` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_sp_svc_product`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_sp_svc_product`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_sp_svc_product` (
|
|
`sp_svc_tran_id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`sp_user_seq` bigint(20) NOT NULL,
|
|
`sp_svc_id` varchar(32) NOT NULL,
|
|
`sp_svc_begin_date` date NOT NULL,
|
|
`sp_svc_end_date` date NOT NULL,
|
|
`sp_svc_band_width` bigint(20) NOT NULL,
|
|
`sp_svc_max_stg_size` bigint(20) NOT NULL,
|
|
`initial_vector` varchar(32) NOT NULL,
|
|
`private_key` varchar(32) NOT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`update_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`deleted_yn` char(1) NOT NULL DEFAULT 'N',
|
|
PRIMARY KEY (`sp_svc_tran_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_sp_svc_product`
|
|
--
|
|
|
|
LOCK TABLES `t_sp_svc_product` WRITE;
|
|
/*!40000 ALTER TABLE `t_sp_svc_product` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_sp_svc_product` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_sp_svc_product_sp_svc_tran_id_seq`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_sp_svc_product_sp_svc_tran_id_seq`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_sp_svc_product_sp_svc_tran_id_seq` (
|
|
`id` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_sp_svc_product_sp_svc_tran_id_seq`
|
|
--
|
|
|
|
LOCK TABLES `t_sp_svc_product_sp_svc_tran_id_seq` WRITE;
|
|
/*!40000 ALTER TABLE `t_sp_svc_product_sp_svc_tran_id_seq` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_sp_svc_product_sp_svc_tran_id_seq` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_sp_user`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_sp_user`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_sp_user` (
|
|
`sp_user_seq` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`sp_user_id` varchar(32) NOT NULL,
|
|
`sp_user_password` varchar(32) NOT NULL,
|
|
`sp_max_stg_size` bigint(20) NOT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`update_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`deleted_yn` char(1) NOT NULL DEFAULT 'N',
|
|
PRIMARY KEY (`sp_user_seq`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_sp_user`
|
|
--
|
|
|
|
LOCK TABLES `t_sp_user` WRITE;
|
|
/*!40000 ALTER TABLE `t_sp_user` DISABLE KEYS */;
|
|
INSERT INTO `t_sp_user` VALUES (1,'admin','28eb83b5adb2a1bc6f991ed14186bd23',314572800,'2009-12-14 16:01:01','2009-12-14 16:01:01','N');
|
|
/*!40000 ALTER TABLE `t_sp_user` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_stx_netstat`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_stx_netstat`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_stx_netstat` (
|
|
`stx_netstat_seq` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`host_name` varchar(65) NOT NULL,
|
|
`service_name` varchar(65) NOT NULL,
|
|
`rcid` varchar(33) NOT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`stx_traffic_in` bigint(20) DEFAULT NULL,
|
|
`stx_traffic_out` bigint(20) DEFAULT NULL,
|
|
`stx_packet_in` bigint(10) DEFAULT NULL,
|
|
`stx_packet_out` bigint(10) DEFAULT NULL,
|
|
PRIMARY KEY (`stx_netstat_seq`),
|
|
KEY `STX_NETSTAT_SEQ` (`stx_netstat_seq`),
|
|
KEY `REG_DATETIME` (`reg_datetime`),
|
|
KEY `HOST_NAME` (`host_name`),
|
|
KEY `SERVICE_NAME` (`service_name`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_stx_netstat`
|
|
--
|
|
|
|
LOCK TABLES `t_stx_netstat` WRITE;
|
|
/*!40000 ALTER TABLE `t_stx_netstat` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_stx_netstat` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_stx_network`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_stx_network`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_stx_network` (
|
|
`stx_network_seq` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`sp_svc_tran_id` bigint(20) NOT NULL,
|
|
`rcid` varchar(32) NOT NULL,
|
|
`stx_traffic_in` bigint(20) NOT NULL,
|
|
`stx_traffic_out` bigint(20) NOT NULL,
|
|
`stx_content_in` bigint(20) NOT NULL,
|
|
`stx_content_out` bigint(20) NOT NULL,
|
|
`n_cc_in` int(11) NOT NULL,
|
|
`n_cc_out` int(11) NOT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`stx_network_seq`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_stx_network`
|
|
--
|
|
|
|
LOCK TABLES `t_stx_network` WRITE;
|
|
/*!40000 ALTER TABLE `t_stx_network` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_stx_network` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_stx_stgstat`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_stx_stgstat`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_stx_stgstat` (
|
|
`stx_stgstat_seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
`host_name` varchar(65) NOT NULL,
|
|
`service_name` varchar(65) NOT NULL,
|
|
`rcid` varchar(33) NOT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`total` bigint(20) unsigned DEFAULT NULL,
|
|
`free` bigint(20) unsigned DEFAULT NULL,
|
|
PRIMARY KEY (`stx_stgstat_seq`),
|
|
KEY `stx_stgstat_seq` (`stx_stgstat_seq`),
|
|
KEY `reg_datetime` (`reg_datetime`),
|
|
KEY `host_name` (`host_name`),
|
|
KEY `service_name` (`service_name`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_stx_stgstat`
|
|
--
|
|
|
|
LOCK TABLES `t_stx_stgstat` WRITE;
|
|
/*!40000 ALTER TABLE `t_stx_stgstat` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_stx_stgstat` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_stx_storage`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_stx_storage`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_stx_storage` (
|
|
`stx_stg_seq` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`sp_svc_tran_id` bigint(20) NOT NULL,
|
|
`rcid` varchar(32) NOT NULL,
|
|
`vol_quota` bigint(20) NOT NULL,
|
|
`vol_alloc_size` bigint(20) NOT NULL,
|
|
`vol_in_use` bigint(20) NOT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`stx_stg_seq`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_stx_storage`
|
|
--
|
|
|
|
LOCK TABLES `t_stx_storage` WRITE;
|
|
/*!40000 ALTER TABLE `t_stx_storage` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_stx_storage` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_system_event`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_system_event`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_system_event` (
|
|
`sys_evt_seq` int(11) NOT NULL AUTO_INCREMENT,
|
|
`sp_user_seq` bigint(20) NOT NULL,
|
|
`sys_evt_svr_name` varchar(64) NOT NULL,
|
|
`sys_evt_code` char(4) NOT NULL,
|
|
`sys_evt_dtl` text NOT NULL,
|
|
`sys_evt_sendcnt` int(11) NOT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`update_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`deleted_yn` char(1) NOT NULL DEFAULT 'N',
|
|
`sys_evt_adminid` varchar(32) DEFAULT NULL,
|
|
PRIMARY KEY (`sys_evt_seq`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_system_event`
|
|
--
|
|
|
|
LOCK TABLES `t_system_event` WRITE;
|
|
/*!40000 ALTER TABLE `t_system_event` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_system_event` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `t_vms_vol_index`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `t_vms_vol_index`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `t_vms_vol_index` (
|
|
`vol_name` varchar(255) NOT NULL,
|
|
`svc_rc_url` varchar(128) DEFAULT NULL,
|
|
`vol_url_rts` varchar(2048) DEFAULT NULL,
|
|
`reg_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`update_datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`max_bandwidth` bigint(20) NOT NULL,
|
|
`sp_svc_tran_id` varchar(16) NOT NULL,
|
|
`rcid` varchar(32) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=euckr;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `t_vms_vol_index`
|
|
--
|
|
|
|
LOCK TABLES `t_vms_vol_index` WRITE;
|
|
/*!40000 ALTER TABLE `t_vms_vol_index` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `t_vms_vol_index` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!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 2019-07-21 23:30:01
|