From e62f449b02a91585d3cb06bf54b09b94094a28e7 Mon Sep 17 00:00:00 2001 From: clyhtsuriva Date: Sun, 19 Apr 2020 21:41:26 +0200 Subject: data type en time pour init bdd --- www/html/init-bd.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/www/html/init-bd.sql b/www/html/init-bd.sql index f1a4f2b..f824545 100755 --- a/www/html/init-bd.sql +++ b/www/html/init-bd.sql @@ -1,12 +1,12 @@ --Creation of the main table -drop table if exists trame cascade; +drop table if exists paquet cascade; -create table trame( - id_trame serial primary key, - heure varchar(100), - protocole varchar(100), - source varchar(100), - destination varchar(100) +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 ); -- cgit v1.2.3