data type en time pour init bdd

1 files 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
 );