aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xwww/html/init-bd.sql14
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
);