La Paste

2023-11-21 17:36:53

drop table if exists raw_in;

drop table if exists raw_out;

create table raw_in (
    mac_src CHAR(17) DEFAULT NULL,
    mac_dst CHAR(17) DEFAULT NULL,
    ip_src CHAR(45) NOT NULL,
    ip_dst CHAR(45) NOT NULL,
    src_port INT(2) UNSIGNED NOT NULL,
    dst_port INT(2) UNSIGNED NOT NULL,
    ip_proto CHAR(6) NOT NULL, 
    packets INT UNSIGNED NOT NULL,
    bytes BIGINT UNSIGNED NOT NULL,
    stamp_inserted DATETIME NOT NULL,
    PRIMARY KEY (ip_src, ip_dst, src_port, dst_port, ip_proto, stamp_inserted)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

create table raw_out (
    mac_src CHAR(17) DEFAULT NULL,
    mac_dst CHAR(17) DEFAULT NULL,
    ip_src CHAR(45) NOT NULL,
    ip_dst CHAR(45) NOT NULL,
    src_port INT(2) UNSIGNED NOT NULL,
    dst_port INT(2) UNSIGNED NOT NULL,
    ip_proto CHAR(6) NOT NULL, 
    packets INT UNSIGNED NOT NULL,
    bytes BIGINT UNSIGNED NOT NULL,
    stamp_inserted DATETIME NOT NULL,
    PRIMARY KEY (ip_src, ip_dst, src_port, dst_port, ip_proto, stamp_inserted)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;