blob: 4621dfc2ebeb855685ec74c07b0b52dd814da23f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
--Creation of the main table
drop table if exists paquet cascade;
create table paquet(
id_paquet SERIAL PRIMARY KEY,
heure TIME(0) NOT NULL,
protocole VARCHAR NOT NULL,
ip_source VARCHAR NOT NULL,
ip_destination VARCHAR NOT NULL,
port_source INT NOT NULL,
port_destination INT NOT NULL
);
|
