114,8 → 114,10 |
CREATE TABLE IF NOT EXISTS `ips` ( |
`id` int(5) NOT NULL AUTO_INCREMENT, |
`ip` varchar(16) COLLATE utf8_unicode_ci NOT NULL, |
`network_id` int(5) NOT NULL, |
`server_id` int(5) NOT NULL, |
PRIMARY KEY (`id`) |
PRIMARY KEY (`id`), |
KEY `network_id` (`network_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ; |
|
-- |
122,12 → 124,12 |
-- Дамп данных таблицы `ips` |
-- |
|
INSERT INTO `ips` (`id`, `ip`, `server_id`) VALUES |
(1, '83.246.143.111', 1), |
(2, '83.246.160.195', 2), |
(3, '83.246.159.41', 3), |
(4, '172.16.178.102', 3), |
(5, '78.110.54.204', 4); |
INSERT INTO `ips` (`id`, `ip`, `network_id`, `server_id`) VALUES |
(1, '83.246.143.111', 2, 1), |
(2, '83.246.160.195', 2, 2), |
(3, '83.246.159.41', 2, 3), |
(4, '172.16.178.102', 3, 3), |
(5, '78.110.54.204', 1, 4); |
|
-- -------------------------------------------------------- |
|