diff options
| -rwxr-xr-x | www/html/init-bd.sql | 14 |
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 ); |