From e62f449b02a91585d3cb06bf54b09b94094a28e7 Mon Sep 17 00:00:00 2001
From: clyhtsuriva <clyhtsuriva@gmail.com>
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(-)

(limited to 'www/html/init-bd.sql')

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

