diff options
author | clyhtsuriva <clyhtsuriva@gmail.com> | 2020-04-19 22:10:42 +0200 |
---|---|---|
committer | clyhtsuriva <clyhtsuriva@gmail.com> | 2020-04-19 22:10:42 +0200 |
commit | f04705827a8426fdd51f876d0ad8ed9352538c18 (patch) | |
tree | b7c4aab28a00ac0925bd0f665c7d650cbb57de01 /www/html/init-bd.sql | |
parent | e62f449b02a91585d3cb06bf54b09b94094a28e7 (diff) |
ajout de ports, centrage tableau, ...
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 ); |