summaryrefslogtreecommitdiff
path: root/pmacct/dbSetupCustom.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'pmacct/dbSetupCustom.mysql')
-rw-r--r--pmacct/dbSetupCustom.mysql20
1 files changed, 0 insertions, 20 deletions
diff --git a/pmacct/dbSetupCustom.mysql b/pmacct/dbSetupCustom.mysql
deleted file mode 100644
index 167ffb1..0000000
--- a/pmacct/dbSetupCustom.mysql
+++ /dev/null
@@ -1,20 +0,0 @@
-drop database if exists pmacct;
-create database pmacct;
-use pmacct;
-
-drop table if exists acct;
- create table acct (
- ip_src CHAR(39) NOT NULL,
- ip_dst CHAR(39) NOT NULL,
- as_src INT(4) UNSIGNED NOT NULL,
- as_dst INT(4) UNSIGNED NOT NULL,
- port_src INT(2) UNSIGNED NOT NULL,
- port_dst INT(2) UNSIGNED NOT NULL,
- packets INT UNSIGNED NOT NULL,
- bytes INT UNSIGNED NOT NULL,
- pkt_len_distrib CHAR(10) NOT NULL,
- stamp_inserted DATETIME NOT NULL,
- stamp_updated DATETIME,
- PRIMARY KEY (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, pkt_len_distrib, stamp_inserted)
-);
-