diff options
author | clyhtsuriva <clyhtsuriva@gmail.com> | 2020-04-19 21:41:26 +0200 |
---|---|---|
committer | clyhtsuriva <clyhtsuriva@gmail.com> | 2020-04-19 21:41:26 +0200 |
commit | e62f449b02a91585d3cb06bf54b09b94094a28e7 (patch) | |
tree | 6f715309e5dfd4e2c8219edac2e2475128976250 | |
parent | dc48cf7cbca435becc481c80214b320e78825eeb (diff) |
data type en time pour init bdd
-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 ); |