diff options
| author | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-13 13:22:13 +0100 |
|---|---|---|
| committer | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-13 13:22:13 +0100 |
| commit | bad8d2dcd2ee934ba88163af546e1997413a4556 (patch) | |
| tree | cdd2037d32bcbc4dbc34c0d5988f41a0d835a054 /pmacct/dbSetupCustom.mysql | |
| parent | 4b16059c4e7f3735c016d4f47c9f87371bf22d8e (diff) | |
renamed misspelled file
2
Diffstat (limited to 'pmacct/dbSetupCustom.mysql')
| -rw-r--r-- | pmacct/dbSetupCustom.mysql | 16 |
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) +); |
