aboutsummaryrefslogtreecommitdiff
path: root/www/html/init-bd.sql
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
);