diff options
| author | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-17 12:01:38 +0100 |
|---|---|---|
| committer | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-17 12:01:38 +0100 |
| commit | 38eb46bad4062e04f1db1b93bf5d0d1a935c4d96 (patch) | |
| tree | a9c64eae94da4f54478c6cd6f00e31b9df38bc19 /pmacct/dbSetupCustom.mysql | |
| parent | 22ee0829d5ce9508d74d20abae3e06583e3d1820 (diff) | |
merged db setups into one file
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) -); - |