diff options
Diffstat (limited to 'dbsetup.sql')
| -rw-r--r-- | dbsetup.sql | 18 |
1 files changed, 0 insertions, 18 deletions
diff --git a/dbsetup.sql b/dbsetup.sql deleted file mode 100644 index 91ac8ee..0000000 --- a/dbsetup.sql +++ /dev/null @@ -1,18 +0,0 @@ -USE pmacct; - -DROP TABLE IF EXISTS clean_data; - -CREATE TABLE clean_data ( - ipb_src CHAR(39) NOT NULL, - ipb_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, - occurences INT UNSIGNED NOT NULL, - volume CHAR(10) NOT NULL, - time DATETIME NOT NULL, - UNIQUE idx (ipb_src, ipb_dst, as_src, as_dst, port_src, port_dst, volume, time) -); - -grant all privileges on pmacct.* to flowcleaner@localhost identified by 'nil' with grant option; |