X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.16%2F04_ip.sql;h=ba8260fbfe6549eb9a7a83ee35bdeff955b70f63;hb=a0c034efcf0777541e087500e94853f515cda1ca;hp=6d708ed7e77b8618979629b511200cb22fee4305;hpb=ea8c1dcc1901ca922b591cb9b56befef15d2ba17;p=platal.git diff --git a/upgrade/0.9.16/04_ip.sql b/upgrade/0.9.16/04_ip.sql index 6d708ed..ba8260f 100644 --- a/upgrade/0.9.16/04_ip.sql +++ b/upgrade/0.9.16/04_ip.sql @@ -37,8 +37,8 @@ ALTER TABLE ip_watch DROP PRIMARY KEY, DROP COLUMN ip, CHANGE COLUMN ip2 ip INT(11) UNSIGNED NOT NULL, -ADD COLUMN mask uint(11) NOT NULL DEFAULT 4294967295, -ADD PRIMARY KEY ip (ip) +ADD COLUMN mask int(11) unsigned NOT NULL DEFAULT 4294967295, +ADD PRIMARY KEY ip (ip), ADD INDEX network (ip, mask); # vim:set syntax=mysql: