diff options
| author | doufenghu <[email protected]> | 2019-01-04 11:57:31 +0600 |
|---|---|---|
| committer | doufenghu <[email protected]> | 2019-01-04 11:57:31 +0600 |
| commit | 2a44754632f1f3609433916d1bb7b222ec483faa (patch) | |
| tree | 89f5ac9a11ac1a5da6b54135940fa1022633dec9 | |
| parent | 75578bc44b91f37b975b3a35bdc32763d2e6b125 (diff) | |
增加通联关系ASN统计报表
| -rw-r--r-- | db/20181229/traffic_statistic.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/db/20181229/traffic_statistic.sql b/db/20181229/traffic_statistic.sql new file mode 100644 index 0000000..4e106e3 --- /dev/null +++ b/db/20181229/traffic_statistic.sql @@ -0,0 +1,9 @@ +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=1 DEFAULT CHARSET=utf8mb4;
\ No newline at end of file |