diff options
Diffstat (limited to 'pmacct/dbSetupCustom.mysql')
-rw-r--r-- | pmacct/dbSetupCustom.mysql | 20 |
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) -); - |