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

