summaryrefslogtreecommitdiff
path: root/pmacct/dbSetupCustom.mysql
diff options
context:
space:
mode:
authorDaniel Langesten <daniel.langest@gmail.com>2015-03-13 13:22:13 +0100
committerDaniel Langesten <daniel.langest@gmail.com>2015-03-13 13:22:13 +0100
commitbad8d2dcd2ee934ba88163af546e1997413a4556 (patch)
treecdd2037d32bcbc4dbc34c0d5988f41a0d835a054 /pmacct/dbSetupCustom.mysql
parent4b16059c4e7f3735c016d4f47c9f87371bf22d8e (diff)
renamed misspelled file
2
Diffstat (limited to 'pmacct/dbSetupCustom.mysql')
-rw-r--r--pmacct/dbSetupCustom.mysql16
1 files changed, 16 insertions, 0 deletions
diff --git a/pmacct/dbSetupCustom.mysql b/pmacct/dbSetupCustom.mysql
new file mode 100644
index 0000000..dafc638
--- /dev/null
+++ b/pmacct/dbSetupCustom.mysql
@@ -0,0 +1,16 @@
+drop database if exists pmacct;
+create database pmacct;
+use pmacct;
+
+drop table is exists acct;
+create table acct (
+ ip_src CHAR(15) NOT NULL,
+ ip_dst CHAR(15) NOT NULL,
+ src_port INT(2) UNSIGNED NOT NULL,
+ dst_port INT(2) UNSIGNED NOT NULL,
+ packets INT UNSIGNED NOT NULL,
+ bytes BIGINT UNSIGNED NOT NULL,
+ stamp_inserted DATETIME NOT NULL,
+ stamp_updated DATETIME,
+ PRIMARY KEY (ip_src, ip_dst, src_port, dst_port, stamp_inserted)
+);