diff options
Diffstat (limited to 'www/html/init-bd.sql')
| -rwxr-xr-x | www/html/init-bd.sql | 8 |
1 files changed, 5 insertions, 3 deletions
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 ); |