From f04705827a8426fdd51f876d0ad8ed9352538c18 Mon Sep 17 00:00:00 2001 From: clyhtsuriva Date: Sun, 19 Apr 2020 22:10:42 +0200 Subject: ajout de ports, centrage tableau, ... --- www/html/init-bd.sql | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'www/html/init-bd.sql') diff --git a/www/html/init-bd.sql b/www/html/init-bd.sql index f824545..4621dfc 100755 --- a/www/html/init-bd.sql +++ b/www/html/init-bd.sql @@ -4,9 +4,11 @@ drop table if exists paquet cascade; create table paquet( id_paquet SERIAL PRIMARY KEY, heure TIME(0) NOT NULL, - protocole VARCHAR(100) NOT NULL, - source VARCHAR(100) NOT NULL, - destination VARCHAR(100) 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 ); -- cgit v1.2.3