4 ADD COLUMN ip2
INT(11) UNSIGNED
NOT NULL,
5 ADD COLUMN forward_ip2
INT(11) UNSIGNED
DEFAULT NULL;
8 SET ip2
= SUBSTRING_INDEX(ip
, ".", 1) * 256 * 256 * 256
9 + SUBSTRING_INDEX(SUBSTRING_INDEX(ip
, ".", 2), ".", -1) * 256 * 256
10 + SUBSTRING_INDEX(SUBSTRING_INDEX(ip
, ".", 3), ".", -1) * 256
11 + SUBSTRING_INDEX(ip
, ".", -1),
12 forward_ip2
= SUBSTRING_INDEX(forward_ip
, ".", 1) * 256 * 256 * 256
13 + SUBSTRING_INDEX(SUBSTRING_INDEX(forward_ip
, ".", 2), ".", -1) * 256 * 256
14 + SUBSTRING_INDEX(SUBSTRING_INDEX(forward_ip
, ".", 3), ".", -1) * 256
15 + SUBSTRING_INDEX(forward_ip
, ".", -1);
19 DROP COLUMN forward_ip
,
20 CHANGE
COLUMN ip2 ip
INT(11) UNSIGNED
NOT NULL,
21 CHANGE
COLUMN forward_ip2 forward_ip
INT(11) UNSIGNED
DEFAULT NULL,
23 ADD INDEX forward_ip (forward_ip
);
28 ADD COLUMN ip2
INT(11) UNSIGNED
NOT NULL;
31 SET ip2
= SUBSTRING_INDEX(ip
, ".", 1) * 256 * 256 * 256
32 + SUBSTRING_INDEX(SUBSTRING_INDEX(ip
, ".", 2), ".", -1) * 256 * 256
33 + SUBSTRING_INDEX(SUBSTRING_INDEX(ip
, ".", 3), ".", -1) * 256
34 + SUBSTRING_INDEX(ip
, ".", -1);
39 CHANGE
COLUMN ip2 ip
INT(11) UNSIGNED
NOT NULL,
40 ADD COLUMN mask
uint(11) NOT NULL DEFAULT 4294967295,
41 ADD PRIMARY KEY ip (ip
),
42 ADD INDEX network (ip
, mask
);
44 # vim
:set syntax
=mysql
: