diff options
| author | dongxiaoyan <[email protected]> | 2018-12-25 19:57:00 +0800 |
|---|---|---|
| committer | dongxiaoyan <[email protected]> | 2018-12-25 19:57:00 +0800 |
| commit | 85437071cb0f73ca4f4e4abce36ef10c6fd6ab95 (patch) | |
| tree | c2627caba6215052a45dbf26b0c77ade0a5fb94c /db | |
| parent | 4446b8c1b050516a15ee245f0359e343fabf84fd (diff) | |
事件封堵、事件监测(时间粒度小时)、 重点保障事件(时间粒度天)，离线报表表结构，离线统计由galaxy-stat-service完成，写入数据
Diffstat (limited to 'db')
| -rw-r--r-- | db/20181225/add_event_report_table.sql | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/db/20181225/add_event_report_table.sql b/db/20181225/add_event_report_table.sql new file mode 100644 index 0000000..71f2e0a --- /dev/null +++ b/db/20181225/add_event_report_table.sql @@ -0,0 +1,39 @@ +##新增统计表：
+##重点保障事件(时间粒度天)： ntc_major_task_report
+CREATE TABLE `ntc_major_task_report` (
+`stat_id` int(11) NOT NULL AUTO_INCREMENT ,
+`task_id` int(20) NOT NULL ,
+`task_name` varchar(64) 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 ,
+PRIMARY KEY (`stat_id`),
+INDEX `IDX_MAJOR_TASK_REPORT_TIME` (`report_time`) USING BTREE
+)
+ENGINE=InnoDB
+DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
+AUTO_INCREMENT=1
+ROW_FORMAT=DYNAMIC;
+##事件封堵、事件监测(时间粒度小时)：ntc_task_report
+CREATE TABLE `ntc_task_report` (
+`stat_id` int(11) NOT NULL AUTO_INCREMENT ,
+`task_id` int(20) NOT NULL ,
+`task_name` varchar(64) NOT NULL ,
+`report_type` int(11) NOT NULL ,#1：事件封堵；2事件监测；
+`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 ,
+PRIMARY KEY (`stat_id`),
+INDEX `IDX_TASK_REPORT_TIME` (`report_time`) USING BTREE
+)
+ENGINE=InnoDB
+DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
+AUTO_INCREMENT=1
+ROW_FORMAT=DYNAMIC;
\ No newline at end of file |