X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.16%2F04_ip.sql;h=ba8260fbfe6549eb9a7a83ee35bdeff955b70f63;hb=5f6b1db0226f0ad81e40162c1b4f4e11dcc0394e;hp=4fcd93aa15afc42705eeb3e5acb1ffccf1200194;hpb=9797734d81089ee75f6fa3e855d48b9a9bc5523a;p=platal.git

diff --git a/upgrade/0.9.16/04_ip.sql b/upgrade/0.9.16/04_ip.sql
index 4fcd93a..ba8260f 100644
--- a/upgrade/0.9.16/04_ip.sql
+++ b/upgrade/0.9.16/04_ip.sql
@@ -37,6 +37,8 @@ ALTER TABLE ip_watch
 DROP PRIMARY KEY,
 DROP COLUMN ip,
 CHANGE COLUMN ip2 ip INT(11) UNSIGNED NOT NULL,
-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: