| 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); |
| |
| -- -------------------------------------------------------- |
| |