增加初始化脚本

1 files changed, 1454 insertions, 0 deletions

diff --git a/NTC/galaxy-structure.sql b/NTC/galaxy-structure.sql
new file mode 100644
index 0000000..3e64659
--- /dev/null
+++ b/NTC/galaxy-structure.sql
@@ -0,0 +1,1454 @@
+/*

+SQLyog 企业版 - MySQL GUI v8.14 

+MySQL - 5.5.5-10.2.14-MariaDB-log : Database - galaxy-dev

+*********************************************************************

+*/


+

+/*!40101 SET NAMES utf8 */;

+

+/*!40101 SET SQL_MODE=''*/;

+

+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_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 `area` */

+

+DROP TABLE IF EXISTS `area`;

+

+CREATE TABLE `area` (

+  `area_id` bigint(20) NOT NULL COMMENT '序号',

+  `area_name` varchar(128) NOT NULL COMMENT '地区名称',

+  `parent_id` bigint(20) unsigned NOT NULL COMMENT '所属上级地区ID，一级目录（洲）为0',

+  `area_level` int(2) NOT NULL COMMENT '地域级别,1:大洲; 2:国家; 3:省',

+  `yl1` int(11) DEFAULT 0 COMMENT '预留1',

+  `yl2` varchar(80) DEFAULT NULL COMMENT '预留2',

+  PRIMARY KEY (`area_id`)

+) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+

+/*Table structure for table `image_url` */

+

+DROP TABLE IF EXISTS `image_url`;

+

+CREATE TABLE `image_url` (

+  `id` int(11) NOT NULL AUTO_INCREMENT,

+  `module` varchar(255) DEFAULT NULL COMMENT '模块名称',

+  `type` varchar(255) DEFAULT NULL COMMENT '类型',

+  `url` varchar(255) DEFAULT NULL COMMENT '图片地址',

+  `datetime` datetime DEFAULT NULL COMMENT '上传时间',

+  PRIMARY KEY (`id`) USING BTREE

+) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

+

+/*Table structure for table `isp` */

+

+DROP TABLE IF EXISTS `isp`;

+

+CREATE TABLE `isp` (

+  `isp_name` varchar(32) NOT NULL COMMENT '运营商名称',

+  `isp_id` bigint(20) NOT NULL COMMENT '运营商值',

+  `yl1` int(11) DEFAULT NULL COMMENT '预留1',

+  `yl2` varchar(64) DEFAULT NULL COMMENT '预留2',

+  PRIMARY KEY (`isp_id`)

+) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+

+/*Table structure for table `menu_service` */

+

+DROP TABLE IF EXISTS `menu_service`;

+

+CREATE TABLE `menu_service` (

+  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',

+  `service` int(255) NOT NULL COMMENT '业务类型',

+  `service_desc` varchar(255) DEFAULT NULL COMMENT '业务类型名称',

+  `is_maat` int(255) NOT NULL COMMENT '0不是maat业务,1是maat业务',

+  PRIMARY KEY (`id`),

+  KEY `service` (`service`)

+) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

+

+/*Table structure for table `mm_audio_report` */

+

+DROP TABLE IF EXISTS `mm_audio_report`;

+

+CREATE TABLE `mm_audio_report` (

+  `STAT_ID` int(11) NOT NULL AUTO_INCREMENT,

+  `PID` varchar(128) NOT NULL,

+  `SERVICE` int(11) NOT NULL,

+  `NUM` bigint(11) NOT NULL,

+  `LOG_URI` varchar(256) NOT NULL,

+  `REPORT_TIME` datetime NOT NULL,

+  PRIMARY KEY (`STAT_ID`)

+) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `mm_pic_report` */

+

+DROP TABLE IF EXISTS `mm_pic_report`;

+

+CREATE TABLE `mm_pic_report` (

+  `STAT_ID` int(11) NOT NULL AUTO_INCREMENT,

+  `PID` varchar(128) NOT NULL,

+  `SERVICE` int(11) NOT NULL,

+  `NUM` bigint(11) NOT NULL,

+  `LOG_URI` varchar(256) NOT NULL,

+  `REPORT_TIME` datetime NOT NULL,

+  PRIMARY KEY (`STAT_ID`)

+) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `mm_video_report` */

+

+DROP TABLE IF EXISTS `mm_video_report`;

+

+CREATE TABLE `mm_video_report` (

+  `STAT_ID` int(11) NOT NULL AUTO_INCREMENT,

+  `PID` varchar(128) NOT NULL,

+  `SERVICE` int(11) NOT NULL,

+  `NUM` bigint(11) NOT NULL,

+  `LOG_URI` varchar(256) NOT NULL,

+  `REPORT_TIME` datetime NOT NULL,

+  PRIMARY KEY (`STAT_ID`)

+) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `mm_voip_report` */

+

+DROP TABLE IF EXISTS `mm_voip_report`;

+

+CREATE TABLE `mm_voip_report` (

+  `STAT_ID` int(11) NOT NULL AUTO_INCREMENT,

+  `ACCOUNT` varchar(128) NOT NULL,

+  `SERVICE` int(11) NOT NULL,

+  `NUM` bigint(11) NOT NULL,

+  `LOG_URI` varchar(256) NOT NULL,

+  `REPORT_TIME` datetime NOT NULL,

+  PRIMARY KEY (`STAT_ID`)

+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `nms_di_rule` */

+

+DROP TABLE IF EXISTS `nms_di_rule`;

+

+CREATE TABLE `nms_di_rule` (

+  `ID` bigint(20) NOT NULL AUTO_INCREMENT,

+  `detection_info_id` bigint(20) NOT NULL,

+  `ServiceIndex` bigint(20) DEFAULT NULL,

+  `ServiceCode` bigint(20) DEFAULT NULL,

+  `ServiceDesc` varchar(32) DEFAULT NULL,

+  `agedTime` bigint(20) DEFAULT NULL,

+  `ClientNum` varchar(64) DEFAULT NULL,

+  `RefluxPort` varchar(64) DEFAULT NULL,

+  `RuleNumber` varchar(1024) DEFAULT NULL,

+  `usedRuleNum` varchar(1024) DEFAULT NULL,

+  `leftRuleNum` varchar(1024) DEFAULT NULL,

+  `HitTotalNum` bigint(20) DEFAULT NULL,

+  `DETECTIONED_STATE` varchar(2) DEFAULT NULL,

+  `SEQ_ID` int(11) DEFAULT NULL,

+  `DETECTION_SET_INFO_ID` bigint(20) DEFAULT NULL,

+  `data_check_time` datetime DEFAULT NULL,

+  `data_arrive_time` datetime DEFAULT NULL,

+  `data_check_time_digital` bigint(20) DEFAULT NULL,

+  `data_arrive_time_digital` bigint(20) DEFAULT NULL,

+  PRIMARY KEY (`ID`),

+  KEY `DI_SUGON_RULE_1` (`data_check_time`),

+  KEY `DI_SUGON_RULE_2` (`SEQ_ID`),

+  KEY `DI_SUGON_RULE_3` (`DETECTION_SET_INFO_ID`)

+) ENGINE=InnoDB AUTO_INCREMENT=9740 DEFAULT CHARSET=utf8;

+

+/*Table structure for table `ntc_attr_type_report` */

+

+DROP TABLE IF EXISTS `ntc_attr_type_report`;

+

+CREATE TABLE `ntc_attr_type_report` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `service` int(11) NOT NULL,

+  `attr_type` int(11) NOT NULL,

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `report_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_ATTR_TYPE_REPORT_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=11603 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `ntc_attr_type_stat_daily` */

+

+DROP TABLE IF EXISTS `ntc_attr_type_stat_daily`;

+

+CREATE TABLE `ntc_attr_type_stat_daily` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `attr_type` int(11) NOT NULL COMMENT '性质',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_ATTR_TYPE_STAT_DAILY_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=358 DEFAULT CHARSET=utf8mb4 COMMENT='9.13.	ntc性质日报表';

+

+/*Table structure for table `ntc_attr_type_stat_hour` */

+

+DROP TABLE IF EXISTS `ntc_attr_type_stat_hour`;

+

+CREATE TABLE `ntc_attr_type_stat_hour` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `attr_type` int(11) NOT NULL COMMENT '性质',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_ATTR_TYPE_STAT_HOUR_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1651 DEFAULT CHARSET=utf8mb4 COMMENT='9.12.	ntc性质小时报表';

+

+/*Table structure for table `ntc_attr_type_stat_month` */

+

+DROP TABLE IF EXISTS `ntc_attr_type_stat_month`;

+

+CREATE TABLE `ntc_attr_type_stat_month` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `attr_type` int(11) NOT NULL COMMENT '性质',

+  `sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_ATTR_TYPE_STAT_MONTH_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=utf8mb4 COMMENT='ntc性质月报表';

+

+/*Table structure for table `ntc_destip_country_report` */

+

+DROP TABLE IF EXISTS `ntc_destip_country_report`;

+

+CREATE TABLE `ntc_destip_country_report` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `service` int(11) NOT NULL,

+  `dest_country` varchar(255) NOT NULL,

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `report_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_DESTIP_COUNTRY_REPORT_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=26556 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `ntc_destip_country_stat_daily` */

+

+DROP TABLE IF EXISTS `ntc_destip_country_stat_daily`;

+

+CREATE TABLE `ntc_destip_country_stat_daily` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `dest_country` varchar(255) NOT NULL COMMENT '目的ip所属国家',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_DESTIP_COUNTRY_STAT_DAILY_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1084 DEFAULT CHARSET=utf8mb4 COMMENT='9.11.	ntc国家日报表';

+

+/*Table structure for table `ntc_destip_country_stat_hour` */

+

+DROP TABLE IF EXISTS `ntc_destip_country_stat_hour`;

+

+CREATE TABLE `ntc_destip_country_stat_hour` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `dest_country` varchar(255) NOT NULL COMMENT '目的ip所属国家',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_DESTIP_COUNTRY_STAT_HOUR_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=4595 DEFAULT CHARSET=utf8mb4 COMMENT='9.10.	ntc国家小时报表';

+

+/*Table structure for table `ntc_destip_country_stat_month` */

+

+DROP TABLE IF EXISTS `ntc_destip_country_stat_month`;

+

+CREATE TABLE `ntc_destip_country_stat_month` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `dest_country` varchar(255) NOT NULL COMMENT '目的ip所属国家',

+  `sum` bigint(20) NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_DESTIP_COUNTRY_STAT_MONTH_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COMMENT='ntc国家月报表';

+

+/*Table structure for table `ntc_device_info` */

+

+DROP TABLE IF EXISTS `ntc_device_info`;

+

+CREATE TABLE `ntc_device_info` (

+  `id` int(11) NOT NULL AUTO_INCREMENT,

+  `entrance_id` int(11) NOT NULL,

+  `link_id` int(11) NOT NULL,

+  `manager_ip` varchar(128) NOT NULL,

+  `create_time` datetime DEFAULT NULL,

+  PRIMARY KEY (`id`) USING BTREE

+) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `ntc_entrance_report` */

+

+DROP TABLE IF EXISTS `ntc_entrance_report`;

+

+CREATE TABLE `ntc_entrance_report` (

+  `stat_id` bigint(20) NOT NULL AUTO_INCREMENT,

+  `service` int(11) NOT NULL,

+  `entrance_id` int(11) NOT NULL,

+  `sum` bigint(20) NOT NULL,

+  `report_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`,`report_time`) USING BTREE,

+  KEY `IDX_NTC_ENTRANCE_REPORT_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=13906 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC

+ PARTITION BY RANGE (to_days(`report_time`))

+(PARTITION `NTC_PARTITION_20190515` VALUES LESS THAN (737559) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190516` VALUES LESS THAN (737560) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190517` VALUES LESS THAN (737561) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190518` VALUES LESS THAN (737562) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190519` VALUES LESS THAN (737563) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190520` VALUES LESS THAN (737564) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190521` VALUES LESS THAN (737565) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190522` VALUES LESS THAN (737566) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190523` VALUES LESS THAN (737567) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190524` VALUES LESS THAN (737568) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190525` VALUES LESS THAN (737569) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190526` VALUES LESS THAN (737570) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190527` VALUES LESS THAN (737571) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190528` VALUES LESS THAN (737572) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190529` VALUES LESS THAN (737573) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190530` VALUES LESS THAN (737574) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190531` VALUES LESS THAN (737575) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190601` VALUES LESS THAN (737576) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190602` VALUES LESS THAN (737577) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190603` VALUES LESS THAN (737578) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190604` VALUES LESS THAN (737579) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190605` VALUES LESS THAN (737580) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190606` VALUES LESS THAN (737581) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190607` VALUES LESS THAN (737582) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190608` VALUES LESS THAN (737583) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190609` VALUES LESS THAN (737584) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190610` VALUES LESS THAN (737585) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190611` VALUES LESS THAN (737586) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190612` VALUES LESS THAN (737587) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190613` VALUES LESS THAN (737588) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190614` VALUES LESS THAN (737589) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190615` VALUES LESS THAN (737590) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190616` VALUES LESS THAN (737591) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190617` VALUES LESS THAN (737592) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190618` VALUES LESS THAN (737593) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190619` VALUES LESS THAN (737594) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190620` VALUES LESS THAN (737595) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190621` VALUES LESS THAN (737596) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190622` VALUES LESS THAN (737597) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190623` VALUES LESS THAN (737598) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190624` VALUES LESS THAN (737599) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190625` VALUES LESS THAN (737600) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190626` VALUES LESS THAN (737601) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190627` VALUES LESS THAN (737602) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190628` VALUES LESS THAN (737603) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190629` VALUES LESS THAN (737604) ENGINE = InnoDB,

+ PARTITION `NTC_PARTITION_20190630` VALUES LESS THAN (737605) ENGINE = InnoDB);

+

+/*Table structure for table `ntc_entrance_stat_daily` */

+

+DROP TABLE IF EXISTS `ntc_entrance_stat_daily`;

+

+CREATE TABLE `ntc_entrance_stat_daily` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `entrance_id` int(11) NOT NULL COMMENT '局点（出入口）',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_ENTRANCE_STAT_DAILY_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=749 DEFAULT CHARSET=utf8mb4 COMMENT='9.15.	ntc局点日报表';

+

+/*Table structure for table `ntc_entrance_stat_hour` */

+

+DROP TABLE IF EXISTS `ntc_entrance_stat_hour`;

+

+CREATE TABLE `ntc_entrance_stat_hour` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `entrance_id` int(11) NOT NULL COMMENT '局点（出入口）',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_ENTRANCE_STAT_HOUR_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=2463 DEFAULT CHARSET=utf8mb4 COMMENT='9.14.	ntc局点小时报表';

+

+/*Table structure for table `ntc_entrance_stat_month` */

+

+DROP TABLE IF EXISTS `ntc_entrance_stat_month`;

+

+CREATE TABLE `ntc_entrance_stat_month` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `entrance_id` int(11) NOT NULL COMMENT '局点（出入口）',

+  `sum` bigint(11) NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_ENTRANCE_STAT_MONTH_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=utf8mb4 COMMENT='ntc局点月报表';

+

+/*Table structure for table `ntc_lwhh_report` */

+

+DROP TABLE IF EXISTS `ntc_lwhh_report`;

+

+CREATE TABLE `ntc_lwhh_report` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `service` int(11) NOT NULL,

+  `lwhh` int(11) NOT NULL,

+  `sum` bigint(11) unsigned NOT NULL,

+  `report_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_LWHH_REPORT_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=11622 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `ntc_lwhh_stat_daily` */

+

+DROP TABLE IF EXISTS `ntc_lwhh_stat_daily`;

+

+CREATE TABLE `ntc_lwhh_stat_daily` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `lwhh` int(11) NOT NULL COMMENT '来文函号',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_LWHH_STAT_DAILY_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=380 DEFAULT CHARSET=utf8mb4 COMMENT='9.17.	ntc来文函号日报表';

+

+/*Table structure for table `ntc_lwhh_stat_hour` */

+

+DROP TABLE IF EXISTS `ntc_lwhh_stat_hour`;

+

+CREATE TABLE `ntc_lwhh_stat_hour` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `lwhh` int(11) NOT NULL COMMENT '来文函号',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_LWHH_STAT_HOUR_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1668 DEFAULT CHARSET=utf8mb4 COMMENT='9.16.	ntc来文函号小时报表';

+

+/*Table structure for table `ntc_lwhh_stat_month` */

+

+DROP TABLE IF EXISTS `ntc_lwhh_stat_month`;

+

+CREATE TABLE `ntc_lwhh_stat_month` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `lwhh` int(11) NOT NULL COMMENT '来文函号',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_LWHH_STAT_MONTH_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=195 DEFAULT CHARSET=utf8mb4 COMMENT='ntc来文函号月报表';

+

+/*Table structure for table `ntc_major_task_report` */

+

+DROP TABLE IF EXISTS `ntc_major_task_report`;

+

+CREATE TABLE `ntc_major_task_report` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `task_id` int(20) NOT NULL,

+  `letter_num` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `config_num` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `monitor_num` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `control_num` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `report_time` datetime NOT NULL,

+  `task_time` datetime NOT NULL,

+  `task_name` varchar(50) NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_MAJOR_TASK_REPORT_TIME` (`report_time`) USING BTREE

+) ENGINE=InnoDB AUTO_INCREMENT=1671 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

+

+/*Table structure for table `ntc_pz_report` */

+

+DROP TABLE IF EXISTS `ntc_pz_report`;

+

+CREATE TABLE `ntc_pz_report` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `cfg_id` int(20) NOT NULL,

+  `service` int(11) NOT NULL,

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `report_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_PZ_REPORT_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=679273 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `ntc_pz_stat_daily` */

+

+DROP TABLE IF EXISTS `ntc_pz_stat_daily`;

+

+CREATE TABLE `ntc_pz_stat_daily` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `cfg_id` int(11) NOT NULL COMMENT '配置id',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_PZ_STAT_DAILY_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1029981 DEFAULT CHARSET=utf8mb4 COMMENT='9.3.	ntc配置统计日报表';

+

+/*Table structure for table `ntc_pz_stat_hour` */

+

+DROP TABLE IF EXISTS `ntc_pz_stat_hour`;

+

+CREATE TABLE `ntc_pz_stat_hour` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `cfg_id` int(11) NOT NULL COMMENT '配置id',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_REPORT_TIME` (`report_time`),

+  KEY `IDX_PZ_STAT_HOUR_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1214966 DEFAULT CHARSET=utf8mb4 COMMENT='9.2.	ntc配置统计小时报表';

+

+/*Table structure for table `ntc_pz_stat_month` */

+

+DROP TABLE IF EXISTS `ntc_pz_stat_month`;

+

+CREATE TABLE `ntc_pz_stat_month` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `cfg_id` int(11) NOT NULL COMMENT '配置id',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_PZ_STAT_MONTH_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1213249 DEFAULT CHARSET=utf8mb4 COMMENT='ntc配置统计月报表';

+

+/*Table structure for table `ntc_radius_report` */

+

+DROP TABLE IF EXISTS `ntc_radius_report`;

+

+CREATE TABLE `ntc_radius_report` (

+  `STAT_ID` int(11) NOT NULL AUTO_INCREMENT,

+  `NAS_IP` varchar(128) NOT NULL,

+  `ACCOUNT` varchar(128) NOT NULL,

+  `NUM` bigint(11) NOT NULL,

+  `REPORT_TIME` datetime DEFAULT NULL,

+  PRIMARY KEY (`STAT_ID`) USING BTREE,

+  KEY `IDX_NTC_RADIUS_REPORT_TIME` (`REPORT_TIME`) USING BTREE

+) ENGINE=InnoDB AUTO_INCREMENT=150874 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

+

+/*Table structure for table `ntc_reject_url_statistic` */

+

+DROP TABLE IF EXISTS `ntc_reject_url_statistic`;

+

+CREATE TABLE `ntc_reject_url_statistic` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '�ֵ�ID',

+  `ip_addr` varchar(255) NOT NULL COMMENT 'IPַ��',

+  `url` varchar(2048) NOT NULL COMMENT 'URL',

+  `sum` bigint(255) NOT NULL COMMENT '����',

+  `stat_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp() COMMENT 'ͳ��ʱ��',

+  PRIMARY KEY (`stat_id`) USING BTREE

+) ENGINE=InnoDB AUTO_INCREMENT=5910 DEFAULT CHARSET=utf8;

+

+/*Table structure for table `ntc_reject_website_statistic` */

+

+DROP TABLE IF EXISTS `ntc_reject_website_statistic`;

+

+CREATE TABLE `ntc_reject_website_statistic` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '�ֵ�ID',

+  `ip_addr` varchar(255) NOT NULL COMMENT 'IPַ��',

+  `website` varchar(255) NOT NULL COMMENT '��վ',

+  `sum` bigint(255) NOT NULL COMMENT '����',

+  `stat_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp() COMMENT 'ͳ��ʱ��',

+  PRIMARY KEY (`stat_id`) USING BTREE

+) ENGINE=InnoDB AUTO_INCREMENT=564 DEFAULT CHARSET=utf8;

+

+/*Table structure for table `ntc_service_behav_statistic` */

+

+DROP TABLE IF EXISTS `ntc_service_behav_statistic`;

+

+CREATE TABLE `ntc_service_behav_statistic` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `service` int(11) NOT NULL,

+  `entrance_id` int(11) NOT NULL,

+  `s_ip` varchar(128) NOT NULL,

+  `d_ip` varchar(128) NOT NULL,

+  `sum` int(11) NOT NULL,

+  `report_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`)

+) ENGINE=InnoDB AUTO_INCREMENT=134531 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `ntc_service_dic` */

+

+DROP TABLE IF EXISTS `ntc_service_dic`;

+

+CREATE TABLE `ntc_service_dic` (

+  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号',

+  `service_code` int(11) NOT NULL,

+  `action` int(11) NOT NULL,

+  `service_name_zh` varchar(255) DEFAULT '' COMMENT '业务-中文',

+  `service_name_en` varchar(255) DEFAULT '' COMMENT '业务-英文',

+  `service_name_ru` varchar(255) DEFAULT '' COMMENT '业务-俄语',

+  `desc` varchar(255) DEFAULT '' COMMENT '描述',

+  `is_valid` int(2) NOT NULL,

+  PRIMARY KEY (`id`)

+) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;

+

+/*Table structure for table `ntc_service_report` */

+

+DROP TABLE IF EXISTS `ntc_service_report`;

+

+CREATE TABLE `ntc_service_report` (

+  `stat_id` int(20) NOT NULL AUTO_INCREMENT,

+  `service` int(11) NOT NULL,

+  `sum` bigint(11) unsigned NOT NULL,

+  `report_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_SERVICE_REPORT_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=17985 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `ntc_service_stat_daily` */

+

+DROP TABLE IF EXISTS `ntc_service_stat_daily`;

+

+CREATE TABLE `ntc_service_stat_daily` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_SERVICE_STAT_DAILY_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=331 DEFAULT CHARSET=utf8mb4 COMMENT='9.5.	ntc业务类型日报表';

+

+/*Table structure for table `ntc_service_stat_hour` */

+

+DROP TABLE IF EXISTS `ntc_service_stat_hour`;

+

+CREATE TABLE `ntc_service_stat_hour` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_SERVICE_STAT_HOUR_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=2281 DEFAULT CHARSET=utf8mb4 COMMENT='9.4.	ntc业务类型小时报表';

+

+/*Table structure for table `ntc_service_stat_month` */

+

+DROP TABLE IF EXISTS `ntc_service_stat_month`;

+

+CREATE TABLE `ntc_service_stat_month` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_SERVICE_STAT_MONTH_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COMMENT='ntc业务类型月报表';

+

+/*Table structure for table `ntc_srcip_domestic_report` */

+

+DROP TABLE IF EXISTS `ntc_srcip_domestic_report`;

+

+CREATE TABLE `ntc_srcip_domestic_report` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `service` int(11) NOT NULL,

+  `src_province` varchar(255) NOT NULL,

+  `src_city` varchar(255) DEFAULT NULL,

+  `sum` bigint(11) unsigned NOT NULL,

+  `report_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_SRCIP_REPORT_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=9909 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `ntc_srcip_domestic_stat_daily` */

+

+DROP TABLE IF EXISTS `ntc_srcip_domestic_stat_daily`;

+

+CREATE TABLE `ntc_srcip_domestic_stat_daily` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `src_province` varchar(255) NOT NULL COMMENT '源ip所属省',

+  `src_city` varchar(255) DEFAULT NULL COMMENT '源ip所属市',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_SRCIP_STAT_DAILY_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8mb4 COMMENT='9.9.	ntc境内日报表';

+

+/*Table structure for table `ntc_srcip_domestic_stat_hour` */

+

+DROP TABLE IF EXISTS `ntc_srcip_domestic_stat_hour`;

+

+CREATE TABLE `ntc_srcip_domestic_stat_hour` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `src_province` varchar(255) NOT NULL COMMENT '源ip所属省',

+  `src_city` varchar(255) DEFAULT NULL COMMENT '源ip所属市',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_SRCIP_STAT_HOUR_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1318 DEFAULT CHARSET=utf8mb4 COMMENT='9.8.	ntc境内小时报表';

+

+/*Table structure for table `ntc_srcip_domestic_stat_month` */

+

+DROP TABLE IF EXISTS `ntc_srcip_domestic_stat_month`;

+

+CREATE TABLE `ntc_srcip_domestic_stat_month` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `src_province` varchar(255) NOT NULL COMMENT '源ip所属省',

+  `src_city` varchar(255) DEFAULT '0' COMMENT '源ip所属市',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_SRCIP_STAT_MONTH_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COMMENT='ntc境内月报表';

+

+/*Table structure for table `ntc_tag_report` */

+

+DROP TABLE IF EXISTS `ntc_tag_report`;

+

+CREATE TABLE `ntc_tag_report` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `service` int(11) NOT NULL,

+  `tag` int(11) NOT NULL,

+  `sum` bigint(11) unsigned NOT NULL,

+  `report_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TAG_REPORT_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=11605 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `ntc_tag_stat_daily` */

+

+DROP TABLE IF EXISTS `ntc_tag_stat_daily`;

+

+CREATE TABLE `ntc_tag_stat_daily` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `tag` int(11) NOT NULL COMMENT '标签',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TAG_STAT_DAILY_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=370 DEFAULT CHARSET=utf8mb4 COMMENT='9.7.	ntc标签统计日报表';

+

+/*Table structure for table `ntc_tag_stat_hour` */

+

+DROP TABLE IF EXISTS `ntc_tag_stat_hour`;

+

+CREATE TABLE `ntc_tag_stat_hour` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `tag` int(11) NOT NULL COMMENT '标签',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TAG_STAT_HOUR_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1659 DEFAULT CHARSET=utf8mb4 COMMENT='9.6.	ntc标签统计小时报表';

+

+/*Table structure for table `ntc_tag_stat_month` */

+

+DROP TABLE IF EXISTS `ntc_tag_stat_month`;

+

+CREATE TABLE `ntc_tag_stat_month` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `service` int(11) NOT NULL COMMENT '业务类型',

+  `tag` int(11) NOT NULL COMMENT '标签',

+  `sum` bigint(11) unsigned NOT NULL DEFAULT 0 COMMENT '日志数量',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TAG_STAT_MONTH_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8mb4 COMMENT='ntc标签统计月报表';

+

+/*Table structure for table `ntc_task_report` */

+

+DROP TABLE IF EXISTS `ntc_task_report`;

+

+CREATE TABLE `ntc_task_report` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `task_id` int(20) NOT NULL,

+  `report_type` int(11) NOT NULL,

+  `ip_num` bigint(20) unsigned NOT NULL DEFAULT 0,

+  `http_num` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `mail_num` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `vedio_num` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `agent_num` bigint(11) unsigned NOT NULL DEFAULT 0,

+  `report_time` datetime NOT NULL,

+  `task_time` datetime NOT NULL,

+  `task_name` varchar(50) NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TASK_REPORT_TIME` (`report_time`) USING BTREE

+) ENGINE=InnoDB AUTO_INCREMENT=3458 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

+

+/*Table structure for table `ntc_total_report` */

+

+DROP TABLE IF EXISTS `ntc_total_report`;

+

+CREATE TABLE `ntc_total_report` (

+  `stat_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id自增',

+  `reject_num` bigint(20) NOT NULL DEFAULT 0 COMMENT '封堵数量',

+  `monitor_num` bigint(20) NOT NULL DEFAULT 0 COMMENT '监测数量',

+  `c2s_pkt_num` bigint(20) DEFAULT 0 COMMENT 'c2s包数',

+  `s2c_pkt_num` bigint(20) DEFAULT 0 COMMENT 's2c包数',

+  `c2s_byte_len` bigint(20) NOT NULL DEFAULT 0 COMMENT 'c2s字节数',

+  `s2c_byte_len` bigint(20) NOT NULL DEFAULT 0 COMMENT 's2c字节数',

+  `new_uni_conn_num` bigint(20) DEFAULT 0 COMMENT '新建链接数',

+  `close_conn_num` bigint(20) DEFAULT 0 COMMENT '活跃链接数',

+  `drop_conn_num` bigint(20) DEFAULT 0 COMMENT '丢弃链接数',

+  `loop_conn_num` bigint(20) DEFAULT 0 COMMENT '回流链接数',

+  `report_time` datetime NOT NULL COMMENT '统计时间',

+  `bps` bigint(20) unsigned DEFAULT NULL COMMENT '负载流量bps',

+  `pps` bigint(20) unsigned DEFAULT NULL COMMENT '负载包数pps',

+  PRIMARY KEY (`stat_id`,`report_time`),

+  KEY `IDX_NTC_TOTAL_TIME` (`report_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=59457 DEFAULT CHARSET=utf8mb4 COMMENT='9.1.	业务总量汇聚报表';

+

+/*Table structure for table `pxy_total_report` */

+

+DROP TABLE IF EXISTS `pxy_total_report`;

+

+CREATE TABLE `pxy_total_report` (

+  `STAT_ID` int(11) NOT NULL AUTO_INCREMENT,

+  `MONITOR_NUM` bigint(11) NOT NULL,

+  `REJECT_NUM` bigint(11) NOT NULL,

+  `REPLACE_NUM` bigint(11) NOT NULL,

+  `REDIRECT_NUM` bigint(11) NOT NULL,

+  `REPORT_TIME` datetime NOT NULL,

+  PRIMARY KEY (`STAT_ID`)

+) ENGINE=InnoDB AUTO_INCREMENT=340 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `pz_control_report` */

+

+DROP TABLE IF EXISTS `pz_control_report`;

+

+CREATE TABLE `pz_control_report` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `cfg_id` int(20) NOT NULL,

+  `service` int(11) NOT NULL,

+  `sum` int(11) NOT NULL,

+  `report_time` datetime DEFAULT NULL,

+  PRIMARY KEY (`stat_id`) USING BTREE

+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `remote_nms_di_rule` */

+

+DROP TABLE IF EXISTS `remote_nms_di_rule`;

+

+CREATE TABLE `remote_nms_di_rule` (

+  `ID` bigint(20) NOT NULL AUTO_INCREMENT,

+  `detection_info_id` bigint(20) NOT NULL,

+  `ServiceIndex` bigint(20) DEFAULT NULL,

+  `ServiceCode` bigint(20) DEFAULT NULL,

+  `ServiceDesc` varchar(32) DEFAULT NULL,

+  `agedTime` bigint(20) DEFAULT NULL,

+  `ClientNum` bigint(20) DEFAULT NULL,

+  `RefluxPort` varchar(64) DEFAULT NULL,

+  `RuleNumber` varchar(1024) DEFAULT NULL,

+  `usedRuleNum` varchar(1024) DEFAULT NULL,

+  `leftRuleNum` varchar(1024) DEFAULT NULL,

+  `HitTotalNum` varchar(64) DEFAULT NULL,

+  `DETECTIONED_STATE` varchar(2) DEFAULT NULL,

+  `SEQ_ID` int(11) DEFAULT NULL,

+  `DETECTION_SET_INFO_ID` bigint(20) DEFAULT NULL,

+  `data_check_time` datetime NOT NULL,

+  `data_arrive_time` datetime DEFAULT NULL,

+  `data_check_time_digital` bigint(20) DEFAULT NULL,

+  `data_arrive_time_digital` bigint(20) DEFAULT NULL,

+  PRIMARY KEY (`ID`,`data_check_time`),

+  KEY `DI_SUGON_RULE_1` (`data_check_time`),

+  KEY `DI_SUGON_RULE_2` (`SEQ_ID`),

+  KEY `DI_SUGON_RULE_3` (`DETECTION_SET_INFO_ID`),

+  KEY `index_DI_RULE_DETECTION_INFO_ID` (`detection_info_id`) USING BTREE

+) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://root:[email protected]:3306/nms/di_rule';

+

+/*Table structure for table `services_config_request_log` */

+

+DROP TABLE IF EXISTS `services_config_request_log`;

+

+CREATE TABLE `services_config_request_log` (

+  `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',

+  `OPERATOR` varchar(200) DEFAULT NULL COMMENT '操作人',

+  `VERSION` varchar(100) NOT NULL COMMENT '版本号',

+  `OPACTION` int(11) NOT NULL COMMENT '操作行为',

+  `OPTIME` datetime DEFAULT NULL COMMENT '操作时间',

+  `REQUEST_CONTENT` longtext DEFAULT NULL COMMENT '操作内容',

+  `REQUEST_TIME` datetime DEFAULT NULL COMMENT '请求时间',

+  `CONSUMER_TIME` bigint(20) NOT NULL COMMENT '处理时间',

+  `REQUEST_IP` varchar(200) DEFAULT NULL COMMENT '请求ip',

+  `BUSINESS_CODE` int(11) DEFAULT NULL COMMENT '业务码(用来异常处理的)',

+  `EXCEPTION_INFO` text DEFAULT NULL COMMENT '错误信息',

+  `SERVER_IP` varchar(200) DEFAULT NULL COMMENT '服务端ip',

+  `TRACE_CODE` varchar(32) DEFAULT NULL COMMENT '追踪码(用来查请求日志)',

+  `REQUEST_URI` varchar(200) DEFAULT NULL COMMENT '请求地址',

+  PRIMARY KEY (`ID`) USING BTREE

+) ENGINE=InnoDB AUTO_INCREMENT=1345752 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

+

+/*Table structure for table `services_log_request_log` */

+

+DROP TABLE IF EXISTS `services_log_request_log`;

+

+CREATE TABLE `services_log_request_log` (

+  `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',

+  `OPERATOR` varchar(200) DEFAULT NULL COMMENT '操作人',

+  `VERSION` varchar(100) NOT NULL COMMENT '版本号',

+  `OPACTION` int(11) NOT NULL COMMENT '操作行为',

+  `OPTIME` datetime DEFAULT NULL COMMENT '操作时间',

+  `REQUEST_CONTENT` longtext DEFAULT NULL COMMENT '操作内容',

+  `REQUEST_TIME` datetime DEFAULT NULL COMMENT '请求时间',

+  `CONSUMER_TIME` bigint(20) NOT NULL COMMENT '处理时间',

+  `REQUEST_IP` varchar(200) DEFAULT NULL COMMENT '请求ip',

+  `BUSINESS_CODE` int(11) DEFAULT NULL COMMENT '业务码(用来异常处理的)',

+  `EXCEPTION_INFO` text DEFAULT NULL COMMENT '错误信息',

+  `SERVER_IP` varchar(200) DEFAULT NULL COMMENT '服务端ip',

+  `TRACE_CODE` varchar(32) DEFAULT NULL COMMENT '追踪码(用来查请求日志)',

+  `REQUEST_URI` varchar(200) DEFAULT NULL COMMENT '请求地址',

+  PRIMARY KEY (`ID`) USING BTREE,

+  KEY `IDX_SERVICE_REQ_LOG_TIME` (`OPTIME`)

+) ENGINE=InnoDB AUTO_INCREMENT=437529 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

+

+/*Table structure for table `services_request_log` */

+

+DROP TABLE IF EXISTS `services_request_log`;

+

+CREATE TABLE `services_request_log` (

+  `ID` bigint(20) NOT NULL AUTO_INCREMENT,

+  `OPERATOR` varchar(200) DEFAULT NULL,

+  `VERSION` varchar(100) NOT NULL,

+  `OPACTION` int(11) NOT NULL,

+  `OPTIME` datetime DEFAULT NULL,

+  `REQUEST_CONTENT` longtext DEFAULT NULL,

+  `REQUEST_TIME` datetime NOT NULL,

+  `CONSUMER_TIME` bigint(20) NOT NULL,

+  `REQUEST_IP` varchar(200) DEFAULT NULL,

+  `BUSINESS_CODE` int(11) DEFAULT NULL,

+  `EXCEPTION_INFO` text DEFAULT NULL,

+  `SERVER_IP` varchar(200) DEFAULT NULL,

+  `TRACE_CODE` varchar(32) DEFAULT NULL,

+  `REQUEST_URI` varchar(200) DEFAULT NULL,

+  PRIMARY KEY (`ID`),

+  KEY `IDX_SYSTEM_BEHAV_LOG_REQ_TIME` (`REQUEST_TIME`)

+) ENGINE=InnoDB AUTO_INCREMENT=168948 DEFAULT CHARSET=utf8;

+

+/*Table structure for table `shedlock` */

+

+DROP TABLE IF EXISTS `shedlock`;

+

+CREATE TABLE `shedlock` (

+  `name` varchar(64) NOT NULL,

+  `lock_until` timestamp(3) NULL DEFAULT NULL,

+  `locked_at` timestamp(3) NULL DEFAULT NULL,

+  `locked_by` varchar(255) DEFAULT NULL,

+  PRIMARY KEY (`name`)

+) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+

+/*Table structure for table `shijianlog` */

+

+DROP TABLE IF EXISTS `shijianlog`;

+

+CREATE TABLE `shijianlog` (

+  `proc_name` varchar(255) DEFAULT NULL,

+  `op_time` datetime DEFAULT NULL,

+  `status` varchar(255) DEFAULT NULL

+) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+

+/*Table structure for table `src_ip` */

+

+DROP TABLE IF EXISTS `src_ip`;

+

+CREATE TABLE `src_ip` (

+  `seq_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '序号',

+  `ip_start_addr` int(11) unsigned NOT NULL DEFAULT 0 COMMENT 'IP起始地址,主机序',

+  `ip_end_addr` int(11) unsigned NOT NULL DEFAULT 0 COMMENT 'IP结束地址,主机序',

+  `ip_addr_range` int(11) unsigned NOT NULL DEFAULT 1 COMMENT 'IP地址范围(数量)',

+  `ip_start_string` varchar(20) DEFAULT NULL COMMENT 'IP起始地址字符串描述',

+  `ip_end_string` varchar(20) DEFAULT NULL COMMENT 'IP终止地址字符串描述',

+  `port` int(2) unsigned NOT NULL DEFAULT 0 COMMENT '端口,主机序',

+  `isp_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '运营商ID',

+  `area_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '地区ID',

+  `flag` int(11) DEFAULT 3 COMMENT '标志位， 0:可用于DDOS系统做源IP; 1:只做为通用IP库做查询;2:保留地址;3:未知或无法详细分类地址',

+  `description` varchar(256) DEFAULT NULL COMMENT '纯真IP库里的原始描述信息',

+  `yl1` int(11) DEFAULT NULL COMMENT '预留1',

+  `yl2` varchar(100) DEFAULT NULL COMMENT '预留2',

+  `yl3` varchar(100) DEFAULT NULL,

+  PRIMARY KEY (`seq_id`),

+  KEY `idx_src_ip_addr` (`ip_start_addr`),

+  KEY `idx_src_ip_dst_addr` (`ip_end_addr`) USING BTREE

+) ENGINE=InnoDB AUTO_INCREMENT=440889 DEFAULT CHARSET=utf8;

+

+/*Table structure for table `sys_app_log_stat_status` */

+

+DROP TABLE IF EXISTS `sys_app_log_stat_status`;

+

+CREATE TABLE `sys_app_log_stat_status` (

+  `log_id` int(32) NOT NULL AUTO_INCREMENT,

+  `log_service` int(20) NOT NULL COMMENT '业务类型：\r\n1.配置pz\r\n2.类型service\r\n3.标签tag\r\n4.境内srcipdomestic\r\n5.国家destipcountry\r\n6.性质attrtype\r\n7.局点entrance\r\n8.来文函号lwhh',

+  `log_time` datetime NOT NULL COMMENT '该统计时间',

+  `log_type` int(20) NOT NULL COMMENT '统计类型：\r\n1.小时报\r\n2.日报\r\n3.月报',

+  PRIMARY KEY (`log_id`)

+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `sys_area` */

+

+DROP TABLE IF EXISTS `sys_area`;

+

+CREATE TABLE `sys_area` (

+  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',

+  `parent_id` int(11) NOT NULL COMMENT '父级编号',

+  `parent_ids` varchar(2000) NOT NULL COMMENT '所有父级编号',

+  `name` varchar(100) NOT NULL COMMENT '名称',

+  `sort` int(2) NOT NULL COMMENT '排序',

+  `code` varchar(100) DEFAULT NULL COMMENT '区域编码',

+  `type` char(1) DEFAULT NULL COMMENT '区域类型',

+  `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',

+  `longitude` float DEFAULT NULL COMMENT '经度',

+  `latitude` float DEFAULT NULL COMMENT '纬度',

+  `del_flag` int(2) NOT NULL DEFAULT 1 COMMENT '删除标记',

+  PRIMARY KEY (`id`),

+  KEY `sys_area_parent_id` (`parent_id`),

+  KEY `sys_area_del_flag` (`del_flag`)

+) ENGINE=MyISAM AUTO_INCREMENT=46467 DEFAULT CHARSET=utf8 COMMENT='区域表';

+

+/*Table structure for table `sys_data_dictionary_item` */

+

+DROP TABLE IF EXISTS `sys_data_dictionary_item`;

+

+CREATE TABLE `sys_data_dictionary_item` (

+  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',

+  `item_code` varchar(128) NOT NULL COMMENT '编码（数据表中存储的值如：0、1、2、3）',

+  `item_value` varchar(256) NOT NULL COMMENT '编码对应的值（页面上展现的具体意义）',

+  `item_desc` varchar(256) DEFAULT NULL COMMENT '编码描述信息',

+  `item_sort` int(2) NOT NULL COMMENT '排序序号',

+  `status` int(11) DEFAULT 1 COMMENT '该条数据是否可用（1：可用 0：禁用）',

+  `type` int(11) DEFAULT 1 COMMENT '该条记录页面是否可维护（1：可维护 0：不可维护）',

+  `dictionary_id` int(11) DEFAULT NULL COMMENT '关联数据字典外键',

+  PRIMARY KEY (`id`)

+) ENGINE=InnoDB AUTO_INCREMENT=303 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='词典选项列表';

+

+/*Table structure for table `sys_data_dictionary_name` */

+

+DROP TABLE IF EXISTS `sys_data_dictionary_name`;

+

+CREATE TABLE `sys_data_dictionary_name` (

+  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',

+  `module_name` varchar(50) NOT NULL COMMENT '模块名称',

+  `mark` varchar(50) NOT NULL COMMENT '词典标识',

+  `remark` varchar(255) DEFAULT NULL COMMENT '描述信息',

+  `revision` varchar(500) DEFAULT NULL COMMENT '历史记录',

+  `create_time` datetime NOT NULL COMMENT '创建时间',

+  `modify_time` datetime NOT NULL COMMENT '修改时间',

+  `status` int(2) NOT NULL DEFAULT 1 COMMENT '词典状态',

+  PRIMARY KEY (`id`)

+) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='系统词典标识表';

+

+/*Table structure for table `sys_inter_user_role` */

+

+DROP TABLE IF EXISTS `sys_inter_user_role`;

+

+CREATE TABLE `sys_inter_user_role` (

+  `ID` int(11) NOT NULL AUTO_INCREMENT,

+  `ROLE_ID` int(11) NOT NULL,

+  `USER_ID` int(11) NOT NULL,

+  PRIMARY KEY (`ID`)

+) ENGINE=InnoDB AUTO_INCREMENT=1124 DEFAULT CHARSET=utf8 COMMENT='系统权限用户角色关联表';

+

+/*Table structure for table `sys_log` */

+

+DROP TABLE IF EXISTS `sys_log`;

+

+CREATE TABLE `sys_log` (

+  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',

+  `type` int(2) NOT NULL DEFAULT 1 COMMENT '日志类型',

+  `title` varchar(255) NOT NULL COMMENT '日志标题',

+  `create_by` varchar(64) NOT NULL COMMENT '创建者',

+  `create_date` datetime NOT NULL COMMENT '创建时间',

+  `remote_addr` varchar(255) NOT NULL COMMENT '操作IP地址',

+  `user_agent` varchar(255) DEFAULT NULL COMMENT '用户代理',

+  `request_uri` varchar(255) NOT NULL COMMENT '请求URI',

+  `method` varchar(5) NOT NULL COMMENT '操作方式',

+  `state` int(2) NOT NULL DEFAULT 1 COMMENT '行为状态：1-成功 2-失败',

+  `consumer_time` int(11) DEFAULT 0 COMMENT '消费时间',

+  `params` text DEFAULT NULL COMMENT '操作提交的数据',

+  `exception` text DEFAULT NULL COMMENT '异常信息',

+  PRIMARY KEY (`id`),

+  KEY `sys_log_create_by` (`create_by`),

+  KEY `sys_log_request_uri` (`request_uri`),

+  KEY `sys_log_type` (`type`),

+  KEY `sys_log_create_date` (`create_date`)

+) ENGINE=InnoDB AUTO_INCREMENT=2286 DEFAULT CHARSET=utf8 COMMENT='用户行为日志';

+

+/*Table structure for table `sys_menu` */

+

+DROP TABLE IF EXISTS `sys_menu`;

+

+CREATE TABLE `sys_menu` (

+  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',

+  `parent_id` int(11) NOT NULL COMMENT '父级编号',

+  `parent_ids` varchar(1024) NOT NULL COMMENT '所有父级编号',

+  `name` varchar(100) NOT NULL COMMENT '名称',

+  `sort` int(2) NOT NULL COMMENT '排序',

+  `href` varchar(2000) DEFAULT NULL COMMENT '链接',

+  `target` varchar(20) DEFAULT NULL COMMENT '目标',

+  `icon` varchar(100) DEFAULT NULL COMMENT '图标',

+  `is_show` int(2) NOT NULL COMMENT '是否在菜单中显示',

+  `permission` varchar(200) DEFAULT NULL COMMENT '权限标识',

+  `create_by` varchar(64) NOT NULL COMMENT '创建者',

+  `create_date` datetime NOT NULL COMMENT '创建时间',

+  `update_by` varchar(64) NOT NULL COMMENT '更新者',

+  `update_date` datetime NOT NULL COMMENT '更新时间',

+  `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',

+  `del_flag` int(1) NOT NULL DEFAULT 1 COMMENT '删除标记',

+  `menu_bg` varchar(16) DEFAULT NULL COMMENT '背景颜色，用于快捷菜单',

+  `quick_action` int(2) NOT NULL DEFAULT 0 COMMENT '是否为快捷菜单：0-否 1-普通 2-是且为宽屏',

+  PRIMARY KEY (`id`),

+  KEY `sys_menu_parent_id` (`parent_id`)

+) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='系统权限功能菜单表';

+

+/*Table structure for table `sys_office` */

+

+DROP TABLE IF EXISTS `sys_office`;

+

+CREATE TABLE `sys_office` (

+  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',

+  `parent_id` int(11) NOT NULL COMMENT '父级编号',

+  `parent_ids` varchar(2000) NOT NULL COMMENT '所有父级编号',

+  `name` varchar(100) NOT NULL COMMENT '名称',

+  `en_name` varchar(100) DEFAULT NULL COMMENT '英文名称',

+  `sort` int(11) NOT NULL COMMENT '排序',

+  `area_id` int(11) NOT NULL COMMENT '归属区域',

+  `code` varchar(100) DEFAULT NULL COMMENT '区域编码',

+  `type` int(2) NOT NULL COMMENT '机构类型（1：分公司；2：单位；3：部门 4：信访办）',

+  `grade` int(2) NOT NULL COMMENT '机构等级（1：一级；2：二级；3：三级；4：四级）',

+  `job_type` int(2) DEFAULT NULL COMMENT '职责分类',

+  `address` varchar(255) DEFAULT NULL COMMENT '联系地址',

+  `zip_code` varchar(100) DEFAULT NULL COMMENT '邮政编码',

+  `master` varchar(100) DEFAULT NULL COMMENT '负责人',

+  `phone` varchar(200) DEFAULT NULL COMMENT '电话',

+  `fax` varchar(200) DEFAULT NULL COMMENT '传真',

+  `email` varchar(200) DEFAULT NULL COMMENT '邮箱',

+  `useable` int(2) DEFAULT 1 COMMENT '是否启用',

+  `primary_person` int(11) DEFAULT NULL COMMENT '主负责人',

+  `deputy_person` int(11) DEFAULT NULL COMMENT '副负责人',

+  `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',

+  `del_flag` int(2) NOT NULL DEFAULT 1 COMMENT '删除标记',

+  `create_time` datetime NOT NULL COMMENT '创建时间',

+  PRIMARY KEY (`id`),

+  KEY `sys_office_parent_id` (`parent_id`),

+  KEY `sys_office_del_flag` (`del_flag`),

+  KEY `sys_office_type` (`type`)

+) ENGINE=MyISAM AUTO_INCREMENT=3849 DEFAULT CHARSET=utf8 COMMENT='机构表';

+

+/*Table structure for table `sys_privilege` */

+

+DROP TABLE IF EXISTS `sys_privilege`;

+

+CREATE TABLE `sys_privilege` (

+  `ID` int(11) NOT NULL AUTO_INCREMENT,

+  `PRIVILEGE_MASTER` varchar(10) NOT NULL COMMENT '权限归属：用户-USER，角色-ROLE；',

+  `PRIVILEGE_MASTER_VALUE` int(11) NOT NULL COMMENT '权限归属关联：用户-USERID，角色-ROLEID;',

+  `PRIVILEGE_ACCESS` varchar(10) NOT NULL COMMENT '权限访问类型：菜单-1000，按钮-1001；',

+  `PRIVILEGE_ACCESS_VALUE` int(11) NOT NULL COMMENT '权限访问值关联：菜单-MENUID，按钮-BTNID;',

+  `PRIVILEGE_OPERATION` int(2) NOT NULL DEFAULT 1 COMMENT '访问操作：enable-1，disabled-0；',

+  PRIMARY KEY (`ID`)

+) ENGINE=InnoDB AUTO_INCREMENT=4811 DEFAULT CHARSET=utf8 COMMENT='权限分配表';

+

+/*Table structure for table `sys_role` */

+

+DROP TABLE IF EXISTS `sys_role`;

+

+CREATE TABLE `sys_role` (

+  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',

+  `NAME` varchar(64) NOT NULL COMMENT '角色名称',

+  `DATA_SCOPE` int(2) NOT NULL COMMENT '数据范围',

+  `REMARK` varchar(128) DEFAULT NULL,

+  `STATUS` int(2) NOT NULL DEFAULT 1,

+  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',

+  `ROLE_TYPE` varchar(128) NOT NULL COMMENT '角色类型：assignment（任务分配）、security-role（管理角色）、user（普通用户）',

+  PRIMARY KEY (`ID`),

+  UNIQUE KEY `UK_SYS_ROLE_NAME` (`NAME`)

+) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='系统权限角色表';

+

+/*Table structure for table `sys_user` */

+

+DROP TABLE IF EXISTS `sys_user`;

+

+CREATE TABLE `sys_user` (

+  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '自然主键',

+  `photo` varchar(512) DEFAULT NULL COMMENT '头像',

+  `LOGIN_ID` varchar(64) NOT NULL COMMENT '登录账户ID，用于权限验证的标识。',

+  `NAME` varchar(64) NOT NULL COMMENT '用户名称，用于显示',

+  `EMAIL` varchar(64) NOT NULL,

+  `IDENTITY` int(1) NOT NULL DEFAULT 0 COMMENT '1-信访办 0-办理信访人员',

+  `PASSWORD` varchar(128) NOT NULL,

+  `CREATE_TIME` datetime NOT NULL COMMENT '创建时间',

+  `STATUS` int(2) NOT NULL DEFAULT 1,

+  `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司',

+  `ENTITY_ID` int(11) DEFAULT NULL COMMENT '所属单位',

+  `OFFICE_ID` int(11) DEFAULT NULL COMMENT '所属部门',

+  PRIMARY KEY (`ID`),

+  UNIQUE KEY `AK_email_unqiue` (`EMAIL`),

+  UNIQUE KEY `AK_loginid_unique` (`LOGIN_ID`)

+) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8 COMMENT='系统用户表-用于系统相关权限认证方面';

+

+/*Table structure for table `traffic_abnormal_machine` */

+

+DROP TABLE IF EXISTS `traffic_abnormal_machine`;

+

+CREATE TABLE `traffic_abnormal_machine` (

+  `nmsServer_Id` int(11) NOT NULL,

+  `hostname` varchar(255) DEFAULT NULL,

+  `ip` varchar(255) DEFAULT NULL,

+  KEY `fk_traffic_abnormal_machine` (`nmsServer_Id`),

+  CONSTRAINT `fk_traffic_abnormal_machine` FOREIGN KEY (`nmsServer_Id`) REFERENCES `traffic_nmsserver_statistic` (`id`)

+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_app_statistic` */

+

+DROP TABLE IF EXISTS `traffic_app_statistic`;

+

+CREATE TABLE `traffic_app_statistic` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `app_type` int(11) NOT NULL,

+  `entrance_id` int(11) DEFAULT NULL,

+  `link_num` bigint(11) NOT NULL,

+  `c2s_pkt_num` bigint(11) NOT NULL,

+  `s2c_pkt_num` bigint(11) NOT NULL,

+  `c2s_byte_len` bigint(11) NOT NULL,

+  `s2c_byte_len` bigint(11) NOT NULL,

+  `stat_time` datetime NOT NULL,

+  `direction` int(11) DEFAULT NULL COMMENT '0-out 1-in',

+  `addr_type` varchar(32) DEFAULT NULL,

+  `trans_type` int(11) DEFAULT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TRAFFIC_APP_STAT_TIME` (`stat_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1311001002 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_asn_statistic` */

+

+DROP TABLE IF EXISTS `traffic_asn_statistic`;

+

+CREATE TABLE `traffic_asn_statistic` (

+  `stat_id` bigint(20) NOT NULL AUTO_INCREMENT,

+  `asn_type` int(11) NOT NULL COMMENT '1-src_asn 2-dst_asn',

+  `asn` varchar(64) NOT NULL,

+  `packets` bigint(20) NOT NULL,

+  `bytes` bigint(20) NOT NULL,

+  `stat_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`)

+) ENGINE=InnoDB AUTO_INCREMENT=39648 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_http_focus_statistic` */

+

+DROP TABLE IF EXISTS `traffic_http_focus_statistic`;

+

+CREATE TABLE `traffic_http_focus_statistic` (

+  `stat_id` bigint(20) NOT NULL AUTO_INCREMENT,

+  `web_id` int(11) NOT NULL,

+  `unique_num` bigint(20) NOT NULL,

+  `link_num` bigint(20) NOT NULL,

+  `c2s_pkt_num` bigint(20) NOT NULL,

+  `s2c_pkt_num` bigint(20) NOT NULL,

+  `c2s_byte_len` bigint(20) NOT NULL,

+  `s2c_byte_len` bigint(20) NOT NULL,

+  `entrance_id` int(11) NOT NULL,

+  `stat_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_HTTP_FOCUS_STATISTIC_TIME` (`stat_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1311001002 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_http_statistic` */

+

+DROP TABLE IF EXISTS `traffic_http_statistic`;

+

+CREATE TABLE `traffic_http_statistic` (

+  `stat_id` bigint(20) NOT NULL AUTO_INCREMENT,

+  `web_id` int(11) NOT NULL,

+  `link_num` bigint(20) NOT NULL,

+  `c2s_pkt_num` bigint(20) NOT NULL,

+  `s2c_pkt_num` bigint(20) NOT NULL,

+  `c2s_byte_len` bigint(20) NOT NULL,

+  `s2c_byte_len` bigint(20) NOT NULL,

+  `stat_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`,`stat_time`),

+  KEY `IDX_TRAFFIC_HTTP_STAT_TIME` (`stat_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=6666666672 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_ip_active_statistic` */

+

+DROP TABLE IF EXISTS `traffic_ip_active_statistic`;

+

+CREATE TABLE `traffic_ip_active_statistic` (

+  `stat_id` bigint(20) NOT NULL AUTO_INCREMENT,

+  `ip_addr` varchar(255) NOT NULL,

+  `area_id` int(11) DEFAULT NULL,

+  `link_num` bigint(20) NOT NULL,

+  `c2s_pkt_num` bigint(20) NOT NULL,

+  `s2c_pkt_num` bigint(20) NOT NULL,

+  `c2s_byte_len` bigint(20) NOT NULL,

+  `s2c_byte_len` bigint(20) NOT NULL,

+  `stat_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TRAFFIC_IP_ACTIVE_STAT_TIME` (`stat_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=9522154 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_ip_identify` */

+

+DROP TABLE IF EXISTS `traffic_ip_identify`;

+

+CREATE TABLE `traffic_ip_identify` (

+  `stat_id` bigint(20) NOT NULL AUTO_INCREMENT,

+  `ip_start` varchar(64) NOT NULL,

+  `ip_end` varchar(64) NOT NULL,

+  `ip_start_num` int(11) NOT NULL,

+  `ip_end_num` int(11) NOT NULL,

+  `ip_sub` varchar(64) NOT NULL,

+  `country` varchar(64) NOT NULL,

+  `area_type` int(11) NOT NULL,

+  `desc_detail` varchar(1024) DEFAULT '',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_ip_identify_num` (`ip_start_num`,`ip_end_num`)

+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_netflow_port_info` */

+

+DROP TABLE IF EXISTS `traffic_netflow_port_info`;

+

+CREATE TABLE `traffic_netflow_port_info` (

+  `ENTRANCE_ID` int(11) DEFAULT NULL,

+  `STAT_ID` bigint(20) NOT NULL AUTO_INCREMENT,

+  `PORT` int(2) NOT NULL,

+  `NODE_NAME` varchar(64) NOT NULL,

+  `NODE_IP` varchar(128) NOT NULL,

+  `PORT_DESC` varchar(128) DEFAULT NULL,

+  `BANDWIDTH` bigint(20) unsigned DEFAULT NULL,

+  `INOCTETS` bigint(20) unsigned NOT NULL,

+  `OUTOCTETS` bigint(20) unsigned NOT NULL,

+  `INOCTETS_SPEED` bigint(20) unsigned NOT NULL,

+  `OUTOCTETS_SPEED` bigint(20) unsigned NOT NULL,

+  `INPKTS_SPEED` bigint(20) unsigned NOT NULL,

+  `OUTPKTS_SPEED` bigint(20) unsigned NOT NULL,

+  `RECV_TIME` datetime DEFAULT NULL,

+  PRIMARY KEY (`STAT_ID`) USING BTREE,

+  KEY `IDX_NETFLOW_RECV_TIME` (`RECV_TIME`)

+) ENGINE=InnoDB AUTO_INCREMENT=233478 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

+

+/*Table structure for table `traffic_nmsserver_statistic` */

+

+DROP TABLE IF EXISTS `traffic_nmsserver_statistic`;

+

+CREATE TABLE `traffic_nmsserver_statistic` (

+  `id` int(11) NOT NULL AUTO_INCREMENT,

+  `commit_time` datetime DEFAULT NULL,

+  `area` varchar(255) DEFAULT NULL,

+  `total` int(11) DEFAULT NULL,

+  `normal` int(11) DEFAULT NULL,

+  `abnormal` int(11) DEFAULT NULL,

+  PRIMARY KEY (`id`)

+) ENGINE=InnoDB AUTO_INCREMENT=127945 DEFAULT CHARSET=utf8mb4 COMMENT='记录nms上报的服务器状态信息';

+

+/*Table structure for table `traffic_port_active_statistic` */

+

+DROP TABLE IF EXISTS `traffic_port_active_statistic`;

+

+CREATE TABLE `traffic_port_active_statistic` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `port` int(11) NOT NULL,

+  `sum` bigint(11) NOT NULL,

+  `stat_time` datetime NOT NULL,

+  `trans_proto` int(11) DEFAULT 0 COMMENT '6-tcp 17 -udp',

+  PRIMARY KEY (`stat_id`)

+) ENGINE=InnoDB AUTO_INCREMENT=72758 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_protocol_statistic` */

+

+DROP TABLE IF EXISTS `traffic_protocol_statistic`;

+

+CREATE TABLE `traffic_protocol_statistic` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `proto_type` int(11) NOT NULL,

+  `entrance_id` int(11) DEFAULT NULL,

+  `link_num` bigint(11) NOT NULL,

+  `c2s_pkt_num` bigint(11) NOT NULL,

+  `s2c_pkt_num` bigint(11) NOT NULL,

+  `c2s_byte_len` bigint(11) NOT NULL,

+  `s2c_byte_len` bigint(11) NOT NULL,

+  `stat_time` datetime NOT NULL,

+  `direction` int(11) DEFAULT NULL COMMENT '0-out 1-in',

+  `addr_type` varchar(32) DEFAULT NULL,

+  `trans_type` int(11) DEFAULT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TRAFFIC_PROTOCOL_STAT_TIME` (`stat_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=2147483648 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_seriesdevice_port_info` */

+

+DROP TABLE IF EXISTS `traffic_seriesdevice_port_info`;

+

+CREATE TABLE `traffic_seriesdevice_port_info` (

+  `id` int(11) NOT NULL AUTO_INCREMENT,

+  `commit_time` datetime DEFAULT NULL COMMENT '时间',

+  `area` varchar(255) DEFAULT '' COMMENT '区域',

+  `port` varchar(255) DEFAULT '' COMMENT '端口',

+  `status` varchar(10) DEFAULT '' COMMENT 'down, up, bypass, pass',

+  PRIMARY KEY (`id`)

+) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

+

+/*Table structure for table `traffic_service_statistic` */

+

+DROP TABLE IF EXISTS `traffic_service_statistic`;

+

+CREATE TABLE `traffic_service_statistic` (

+  `stat_id` int(11) NOT NULL AUTO_INCREMENT,

+  `service_type` int(11) NOT NULL,

+  `entrance_id` int(11) DEFAULT NULL,

+  `link_num` bigint(11) NOT NULL,

+  `c2s_pkt_num` bigint(11) NOT NULL,

+  `s2c_pkt_num` bigint(11) NOT NULL,

+  `c2s_byte_len` bigint(11) NOT NULL,

+  `s2c_byte_len` bigint(11) NOT NULL,

+  `stat_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TRAFFIC_SERVICE_STAT_TIME` (`stat_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_total_statistic` */

+

+DROP TABLE IF EXISTS `traffic_total_statistic`;

+

+CREATE TABLE `traffic_total_statistic` (

+  `STAT_ID` int(11) NOT NULL AUTO_INCREMENT,

+  `MATCH_TYPE` int(2) NOT NULL,

+  `SUM` bigint(11) unsigned NOT NULL,

+  `STAT_TIME` datetime NOT NULL,

+  PRIMARY KEY (`STAT_ID`)

+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_trans_statistic` */

+

+DROP TABLE IF EXISTS `traffic_trans_statistic`;

+

+CREATE TABLE `traffic_trans_statistic` (

+  `stat_id` bigint(20) NOT NULL AUTO_INCREMENT,

+  `addr_type` varchar(32) NOT NULL,

+  `trans_type` int(11) NOT NULL,

+  `entrance_id` int(11) DEFAULT NULL,

+  `link_num` bigint(11) NOT NULL,

+  `c2s_pkt_num` bigint(20) NOT NULL,

+  `s2c_pkt_num` bigint(20) NOT NULL,

+  `c2s_byte_len` bigint(20) NOT NULL,

+  `s2c_byte_len` bigint(20) NOT NULL,

+  `stat_time` datetime NOT NULL,

+  `direction` int(11) DEFAULT NULL COMMENT '0-out 1-in',

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TRAFFIC_TRANS_STAT_TIME` (`stat_time`,`addr_type`,`trans_type`) USING BTREE

+) ENGINE=InnoDB AUTO_INCREMENT=274001486 DEFAULT CHARSET=utf8mb4;

+

+/*Table structure for table `traffic_ua_statistic` */

+

+DROP TABLE IF EXISTS `traffic_ua_statistic`;

+

+CREATE TABLE `traffic_ua_statistic` (

+  `stat_id` bigint(20) NOT NULL AUTO_INCREMENT,

+  `bs_type` int(11) NOT NULL,

+  `os_type` int(11) NOT NULL COMMENT 'os type',

+  `entrance_id` int(11) DEFAULT NULL,

+  `link_num` bigint(20) NOT NULL,

+  `c2s_pkt_num` bigint(20) NOT NULL,

+  `s2c_pkt_num` bigint(20) NOT NULL,

+  `c2s_byte_len` bigint(20) NOT NULL,

+  `s2c_byte_len` bigint(20) NOT NULL,

+  `stat_time` datetime NOT NULL,

+  PRIMARY KEY (`stat_id`),

+  KEY `IDX_TRAFFIC_UA_STAT_TIME` (`stat_time`)

+) ENGINE=InnoDB AUTO_INCREMENT=1311001002 DEFAULT CHARSET=utf8mb4;

+

+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;