Merge branch 'platal-0.9.16'

[platal.git] / upgrade / 0.9.16 / 04_ip.sql

diff --git a/upgrade/0.9.16/04_ip.sql b/upgrade/0.9.16/04_ip.sql
index 4fcd93a..ba8260f 100644 (file)
--- 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: