Хранилища Subversion www_nix-files

Редакция

Редакция 48 | Редакция 56 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS

Редакция Автор № строки Строка
2 diffor 1
-- phpMyAdmin SQL Dump
49 diffor 2
-- version 3.2.2.1deb1
2 diffor 3
-- http://www.phpmyadmin.net
5 diffor 4
--
2 diffor 5
-- Хост: localhost
49 diffor 6
-- Время создания: Окт 23 2009 г., 23:48
36 diffor 7
-- Версия сервера: 5.1.37
41 diffor 8
-- Версия PHP: 5.2.10-2ubuntu5
5 diffor 9
 
10
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
 
12
 
13
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16
/*!40101 SET NAMES utf8 */;
17
 
18
--
2 diffor 19
-- База данных: `nix-files`
5 diffor 20
--
2 diffor 21
 
22
-- --------------------------------------------------------
23
 
5 diffor 24
--
10 diffor 25
-- Структура таблицы `apt_mirrors`
26
--
27
 
38 diffor 28
DROP TABLE IF EXISTS `apt_mirrors`;
10 diffor 29
CREATE TABLE IF NOT EXISTS `apt_mirrors` (
36 diffor 30
  `id` INT(5) NOT NULL AUTO_INCREMENT,
31
  `src_name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
32
  `src_url` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
33
  `description` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
34
  PRIMARY KEY (`id`)
40 diffor 35
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;
10 diffor 36
 
37
--
38
-- Дамп данных таблицы `apt_mirrors`
39
--
40
 
18 diffor 41
INSERT INTO `apt_mirrors` (`id`, `src_name`, `src_url`, `description`) VALUES
39 diffor 42
(1, 'debian', 'ftp://ftp.us.debian.org/debian', 'Основной репозиторий Debain'),
43
(2, 'debian-security', 'ftp://security.debian.org/debian-security', 'Обновления безопасности Debian'),
44
(3, 'debian-multimedia', 'http://www.debian-multimedia.org', 'Мультимедийные пакеты Debian'),
45
(4, 'ubuntu', 'http://archive.ubuntu.com/ubuntu', 'Основной репозиторий Ubuntu'),
46
(5, 'ubuntu-security', 'http://security.ubuntu.com/ubuntu', 'Обновления безопасности Ubuntu'),
47
(6, 'ubuntu-canonical', 'http://archive.canonical.com', 'Коммерческие пакеты Ubuntu'),
48
(7, 'medibuntu', 'http://packages.medibuntu.org/', 'Мультимедийные пакеты Ubuntu'),
49
(8, 'infralinux', 'http://archive.infralinux.org/infralinux/', 'Основной репозиторий Infralinux'),
50
(9, '2gis', 'http://packages.redsolution.ru/2gis', 'ДубльГис'),
51
(10, 'opera', 'http://deb.opera.com/opera/', 'Opera'),
52
(11, 'virtualbox', 'http://download.virtualbox.org/virtualbox/debian', 'VirtualBox'),
53
(12, 'opera-beta', 'http://deb.opera.com/opera-beta/', 'Бэта-версии Opera'),
54
(13, 'playonlinux', 'http://deb.playonlinux.com/', 'PlayOnLinux'),
40 diffor 55
(14, 'freenx', 'http://www.datakeylive.com/ubuntu', 'FreeNX'),
56
(16, 'xneur', 'http://gq.net.ru/debian', 'XNeur'),
57
(17, 'ubuntu-wine', 'http://wine.budgetdedicated.com/apt', 'Wine для Ubuntu'),
58
(18, 'debian-winehq', 'http://www.lamaresh.net/apt', 'Wine для Debian');
10 diffor 59
 
60
-- --------------------------------------------------------
61
 
62
--
2 diffor 63
-- Структура таблицы `categories`
5 diffor 64
--
2 diffor 65
 
38 diffor 66
DROP TABLE IF EXISTS `categories`;
2 diffor 67
CREATE TABLE IF NOT EXISTS `categories` (
36 diffor 68
  `id` INT(2) NOT NULL AUTO_INCREMENT,
69
  `category` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
70
  PRIMARY KEY (`id`)
7 diffor 71
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
2 diffor 72
 
5 diffor 73
--
2 diffor 74
-- Дамп данных таблицы `categories`
5 diffor 75
--
2 diffor 76
 
5 diffor 77
INSERT INTO `categories` (`id`, `category`) VALUES
2 diffor 78
(1, 'file'),
79
(2, 'repo'),
7 diffor 80
(3, 'info'),
81
(4, 'misc');
2 diffor 82
 
83
-- --------------------------------------------------------
84
 
5 diffor 85
--
31 diffor 86
-- Структура таблицы `details`
87
--
88
 
38 diffor 89
DROP TABLE IF EXISTS `details`;
31 diffor 90
CREATE TABLE IF NOT EXISTS `details` (
36 diffor 91
  `id` INT(2) NOT NULL AUTO_INCREMENT,
92
  `title` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
93
  `description` text COLLATE utf8_unicode_ci NOT NULL,
94
  `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
95
  `talklink` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
96
  PRIMARY KEY (`id`),
31 diffor 97
  KEY `resource_id` (`title`)
98
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
99
 
100
--
101
-- Дамп данных таблицы `details`
102
--
103
 
104
INSERT INTO `details` (`id`, `title`, `description`, `link`, `talklink`) VALUES
105
(1, 'ftp.niX-FILES', 'Файлопомойко', 'ftp://ftp.nix-files.org.ru', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846');
106
 
107
-- --------------------------------------------------------
108
 
109
--
49 diffor 110
-- Структура таблицы `ips`
111
--
112
 
113
DROP TABLE IF EXISTS `ips`;
114
CREATE TABLE IF NOT EXISTS `ips` (
115
  `id` INT(5) NOT NULL AUTO_INCREMENT,
116
  `ip` VARCHAR(16) COLLATE utf8_unicode_ci NOT NULL,
117
  `server_id` INT(5) NOT NULL,
118
  PRIMARY KEY (`id`)
119
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
120
 
121
--
122
-- Дамп данных таблицы `ips`
123
--
124
 
125
INSERT INTO `ips` (`id`, `ip`, `server_id`) VALUES
126
(1, '83.246.143.111', 1),
127
(2, '83.246.160.195', 2),
128
(3, '83.246.159.41', 3),
129
(4, '172.16.178.102', 3),
130
(5, '78.110.54.204', 4);
131
 
132
-- --------------------------------------------------------
133
 
134
--
2 diffor 135
-- Структура таблицы `members`
5 diffor 136
--
2 diffor 137
 
38 diffor 138
DROP TABLE IF EXISTS `members`;
2 diffor 139
CREATE TABLE IF NOT EXISTS `members` (
36 diffor 140
  `id` INT(2) NOT NULL AUTO_INCREMENT,
141
  `nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
142
  `avatar` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
143
  `jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
4 diffor 144
  `icq` INT(15) NOT NULL,
36 diffor 145
  PRIMARY KEY (`id`)
7 diffor 146
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;
2 diffor 147
 
5 diffor 148
--
2 diffor 149
-- Дамп данных таблицы `members`
5 diffor 150
--
2 diffor 151
 
5 diffor 152
INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES
4 diffor 153
(1, 'Diffor', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0),
7 diffor 154
(2, 'firstleon', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0),
155
(3, 'SlipKnoT8', './img/avatar/slipknot8.gif', 'slipknot888@jabber.ru', 0),
25 diffor 156
(4, 'mistiman', './img/avatar/mistiman.png', 'mistiman@jabber.ru', 0),
157
(5, 'IK', './img/avatar/ik.jpg', 'ik00@jabber.ru', 0),
27 diffor 158
(7, 'SP|Scream', './img/avatar/spscream.png', 'xelnag@jabber.ru', 0),
159
(8, 'Yamah', './img/avatar/yamah.png', '—', 0);
2 diffor 160
 
161
-- --------------------------------------------------------
162
 
5 diffor 163
--
41 diffor 164
-- Структура таблицы `netcats`
165
--
166
 
167
DROP TABLE IF EXISTS `netcats`;
168
CREATE TABLE IF NOT EXISTS `netcats` (
169
  `id` INT(2) NOT NULL AUTO_INCREMENT,
170
  `netcat` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
171
  PRIMARY KEY (`id`)
172
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
173
 
174
--
175
-- Дамп данных таблицы `netcats`
176
--
177
 
178
INSERT INTO `netcats` (`id`, `netcat`) VALUES
179
(1, 'Глоб'),
180
(2, 'Основные'),
181
(3, 'Университеты'),
182
(4, 'Пиринг');
183
 
184
-- --------------------------------------------------------
185
 
186
--
2 diffor 187
-- Структура таблицы `networks`
5 diffor 188
--
2 diffor 189
 
38 diffor 190
DROP TABLE IF EXISTS `networks`;
2 diffor 191
CREATE TABLE IF NOT EXISTS `networks` (
36 diffor 192
  `id` INT(2) NOT NULL AUTO_INCREMENT,
41 diffor 193
  `netcat_id` INT(2) NOT NULL,
36 diffor 194
  `network` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
195
  `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
41 diffor 196
  PRIMARY KEY (`id`),
197
  KEY `netcat_id` (`netcat_id`)
198
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;
2 diffor 199
 
5 diffor 200
--
2 diffor 201
-- Дамп данных таблицы `networks`
5 diffor 202
--
2 diffor 203
 
41 diffor 204
INSERT INTO `networks` (`id`, `netcat_id`, `network`, `link`) VALUES
205
(1, 1, 'Глоб', ''),
206
(2, 2, 'Интелби', 'http://www.intelbi.ru/'),
207
(3, 2, 'Интелека', 'http://www.inteleca.ru/'),
208
(4, 3, 'АГУ', 'http://www.asu.ru/'),
209
(5, 3, 'АлтГПА', 'http://www.uni-altai.ru/'),
210
(6, 3, 'АлтГТУ', 'http://www.altstu.ru/'),
211
(7, 4, 'Webstream', 'http://www.wstream.ru/'),
212
(8, 4, 'Дианет', 'http://www.dianet.info/'),
213
(9, 4, 'Диалог', 'http://www.dialog-it.ru'),
214
(10, 4, 'Нэтком', 'http://www.netcorp.ru'),
215
(11, 4, 'Рубцовск', 'http://www.rubtsovsk.ru/'),
216
(12, 4, 'Алтайгриф', 'http://www.altaigrif.ru');
2 diffor 217
 
218
-- --------------------------------------------------------
219
 
5 diffor 220
--
221
-- Структура таблицы `resources`
222
--
223
 
38 diffor 224
DROP TABLE IF EXISTS `resources`;
5 diffor 225
CREATE TABLE IF NOT EXISTS `resources` (
36 diffor 226
  `id` INT(2) NOT NULL AUTO_INCREMENT,
5 diffor 227
  `category_id` INT(2) NOT NULL,
36 diffor 228
  `resource` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
229
  `picture` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
25 diffor 230
  `member_id` INT(2) NOT NULL,
36 diffor 231
  `link_talk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
232
  `link_res` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
233
  `description` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
234
  `custom` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
235
  PRIMARY KEY (`id`),
25 diffor 236
  KEY `category_id` (`category_id`),
237
  KEY `curator` (`member_id`)
7 diffor 238
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
5 diffor 239
 
240
--
241
-- Дамп данных таблицы `resources`
242
--
243
 
25 diffor 244
INSERT INTO `resources` (`id`, `category_id`, `resource`, `picture`, `member_id`, `link_talk`, `link_res`, `description`, `custom`) VALUES
245
(1, 1, 'ftp', './img/logo/ftp.png', 3, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846', 'ftp://ftp.nix-files.org.ru', 'Файлообменник *nix тематики (дистрибутивы, софт, медиафайлы).', ''),
246
(2, 2, 'apt', './img/logo/debian.png', 2, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1370', 'http://apt.nix-files.org.ru', 'Зеркала apt-репозиториев (Debain, Ubuntu и др.)', 'apt.php'),
247
(3, 3, 'dicts', './img/logo/kdict.png', 5, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1432', 'http://dicts.nix-files.org.ru', 'Сервер со словарями. Доступен как по протоколу http, так и по протоколу dict (порт 2628).', ''),
248
(4, 3, 'mans', './img/logo/khelpcenter.png', 5, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1449', 'http://mans.nix-files.org.ru', 'Онлайн просмотр манов. В основном маны русскоязычные.', ''),
249
(5, 2, 'gentoo', './img/logo/gentoo.png', 4, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1860', 'http://gentoo.nix-files.org.ru', 'Актуальный срез "репозитория" Gentoo.', 'gentoo.php'),
250
(6, 2, 'mandriva', './img/logo/mandrake.png', 8, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2005', 'http://mandriva.nix-files.org.ru', 'Зеркало репозитория Mandriva.', ''),
251
(7, 2, 'arch', './img/logo/archlinux.png', 4, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1884', 'http://arch.nix-files.org.ru', 'Зеркало репозитория ArchLinux,(содержит core, current, extra, community, testing).', 'arch.php'),
252
(8, 2, 'alt', './img/logo/altlinux.png', 4, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2009', 'http://alt.nix-files.org.ru', 'Зеркало репозитория AltLinux.', ''),
253
(9, 2, 'freebsd', './img/logo/freebsd.png', 4, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1990', 'http://freebsd.nix-files.org.ru', 'Актуальный срез "репозитория" FreeBSD.', 'freebsd.php'),
254
(10, 4, 'www', './img/logo/www.png', 1, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1858', 'http://www.nix-files.org.ru', 'Индексная страница со ссылками на ресурсы nix-files.', ''),
255
(11, 4, 'fail', './img/logo/fail.png', 7, '', 'http://fail.nix-files.org.ru', 'Сайт-заглушка, отображаемый при попытке зайти на ресурс, который недоступен для данной сети.', '');
5 diffor 256
 
257
-- --------------------------------------------------------
258
 
259
--
12 diffor 260
-- Структура таблицы `res_net_stat`
261
--
262
 
38 diffor 263
DROP TABLE IF EXISTS `res_net_stat`;
12 diffor 264
CREATE TABLE IF NOT EXISTS `res_net_stat` (
36 diffor 265
  `id` INT(5) NOT NULL AUTO_INCREMENT,
12 diffor 266
  `resource_id` INT(2) NOT NULL,
267
  `network_id` INT(2) NOT NULL,
268
  `state_id` INT(2) NOT NULL,
36 diffor 269
  PRIMARY KEY (`id`),
12 diffor 270
  KEY `resource_id` (`resource_id`,`network_id`)
44 diffor 271
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=105 ;
12 diffor 272
 
273
--
274
-- Дамп данных таблицы `res_net_stat`
275
--
276
 
277
INSERT INTO `res_net_stat` (`id`, `resource_id`, `network_id`, `state_id`) VALUES
278
(1, 1, 2, 1),
279
(2, 1, 3, 1),
280
(3, 1, 4, 4),
281
(4, 1, 5, 3),
44 diffor 282
(5, 2, 2, 1),
283
(6, 2, 3, 1),
12 diffor 284
(7, 2, 4, 4),
48 diffor 285
(8, 2, 5, 3),
12 diffor 286
(9, 3, 1, 1),
287
(10, 3, 2, 1),
288
(11, 3, 3, 2),
289
(12, 3, 5, 3),
290
(13, 4, 1, 1),
291
(14, 4, 2, 1),
292
(15, 4, 3, 2),
293
(16, 4, 5, 3),
294
(17, 5, 2, 1),
295
(18, 5, 3, 1),
296
(19, 5, 5, 2),
297
(20, 6, 2, 1),
298
(21, 6, 3, 1),
299
(22, 6, 5, 3),
300
(23, 7, 2, 1),
301
(24, 7, 3, 1),
302
(25, 7, 5, 3),
303
(26, 8, 2, 1),
304
(27, 8, 3, 1),
305
(28, 8, 5, 3),
44 diffor 306
(29, 9, 2, 5),
307
(30, 9, 3, 5),
308
(31, 9, 5, 5),
12 diffor 309
(32, 10, 1, 1),
310
(33, 10, 2, 1),
311
(34, 10, 3, 2),
312
(35, 10, 5, 3),
14 diffor 313
(36, 11, 1, 1),
314
(37, 10, 7, 3),
315
(38, 3, 7, 3),
316
(39, 4, 7, 3),
317
(40, 1, 7, 3),
318
(41, 2, 7, 3),
319
(42, 5, 7, 3),
320
(43, 6, 7, 3),
321
(44, 7, 7, 3),
322
(45, 8, 7, 3),
44 diffor 323
(46, 9, 7, 5),
40 diffor 324
(47, 3, 8, 3),
325
(48, 4, 8, 3),
326
(49, 1, 8, 3),
327
(50, 2, 8, 3),
328
(51, 5, 8, 3),
329
(52, 6, 8, 3),
330
(53, 7, 8, 3),
331
(54, 8, 8, 3),
44 diffor 332
(55, 9, 8, 5),
333
(56, 10, 8, 3),
334
(57, 1, 9, 4),
335
(58, 2, 9, 4),
336
(59, 3, 9, 4),
337
(60, 4, 9, 4),
338
(61, 5, 9, 4),
339
(62, 6, 9, 4),
340
(63, 7, 9, 4),
341
(64, 8, 9, 4),
342
(65, 9, 9, 5),
343
(66, 10, 9, 4),
344
(67, 1, 10, 4),
345
(68, 2, 10, 4),
346
(69, 3, 10, 4),
347
(70, 4, 10, 4),
348
(71, 5, 10, 4),
349
(72, 6, 10, 4),
350
(73, 7, 10, 4),
351
(74, 8, 10, 4),
352
(75, 9, 10, 5),
353
(76, 10, 10, 4),
354
(77, 1, 11, 4),
355
(78, 2, 11, 4),
356
(79, 3, 11, 4),
357
(80, 4, 11, 4),
358
(81, 5, 11, 4),
359
(82, 6, 11, 4),
360
(83, 7, 11, 4),
361
(84, 8, 11, 4),
362
(85, 9, 11, 5),
363
(86, 10, 11, 4),
364
(87, 1, 12, 4),
365
(88, 2, 12, 4),
366
(89, 3, 12, 4),
367
(90, 4, 12, 4),
368
(91, 5, 12, 4),
369
(92, 6, 12, 4),
370
(93, 7, 12, 4),
371
(94, 8, 12, 4),
372
(95, 9, 12, 5),
373
(96, 10, 12, 4),
374
(97, 3, 4, 4),
375
(98, 4, 4, 4),
376
(99, 5, 4, 4),
377
(100, 6, 4, 4),
378
(101, 7, 4, 4),
379
(102, 8, 4, 4),
380
(103, 9, 4, 5),
381
(104, 10, 4, 4);
14 diffor 382
 
383
-- --------------------------------------------------------
384
 
385
--
49 diffor 386
-- Структура таблицы `servers`
387
--
388
 
389
DROP TABLE IF EXISTS `servers`;
390
CREATE TABLE IF NOT EXISTS `servers` (
391
  `id` INT(5) NOT NULL AUTO_INCREMENT,
392
  `server` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
393
  `member_id` INT(2) NOT NULL,
394
  PRIMARY KEY (`id`),
395
  KEY `member_id` (`member_id`)
396
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
397
 
398
--
399
-- Дамп данных таблицы `servers`
400
--
401
 
402
INSERT INTO `servers` (`id`, `server`, `member_id`) VALUES
403
(1, 'diffor', 1),
404
(2, 'leon', 2),
405
(3, 'Frosia', 3),
406
(4, 'fail', 7);
407
 
408
-- --------------------------------------------------------
409
 
410
--
14 diffor 411
-- Структура таблицы `states`
412
--
413
 
38 diffor 414
DROP TABLE IF EXISTS `states`;
14 diffor 415
CREATE TABLE IF NOT EXISTS `states` (
36 diffor 416
  `id` INT(3) NOT NULL AUTO_INCREMENT,
14 diffor 417
  `image` VARCHAR(50) NOT NULL,
418
  `description` VARCHAR(50) NOT NULL,
36 diffor 419
  PRIMARY KEY (`id`)
44 diffor 420
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
14 diffor 421
 
422
--
423
-- Дамп данных таблицы `states`
424
--
425
 
426
INSERT INTO `states` (`id`, `image`, `description`) VALUES
44 diffor 427
(1, './img/state/tick_gold.png', 'Основной ресурс'),
428
(2, './img/state/tick_blue.png', 'Зеркало ресурса'),
45 diffor 429
(3, './img/state/tick_green.png', 'Скоростной доступ'),
430
(4, './img/state/tick_gray.png', 'Доступен'),
44 diffor 431
(5, './img/state/snowflake.png', 'Приостановлен');
31 diffor 432
 
433
-- --------------------------------------------------------
434
 
435
--
436
-- Структура таблицы `subnets`
437
--
438
 
38 diffor 439
DROP TABLE IF EXISTS `subnets`;
31 diffor 440
CREATE TABLE IF NOT EXISTS `subnets` (
36 diffor 441
  `id` INT(5) NOT NULL AUTO_INCREMENT,
31 diffor 442
  `subnet` VARCHAR(20) NOT NULL,
443
  `network_id` INT(2) NOT NULL,
36 diffor 444
  PRIMARY KEY (`id`),
31 diffor 445
  KEY `network_id` (`network_id`)
41 diffor 446
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;
31 diffor 447
 
448
--
449
-- Дамп данных таблицы `subnets`
450
--
451
 
452
INSERT INTO `subnets` (`id`, `subnet`, `network_id`) VALUES
453
(1, '83.246.128.0/17', 2),
454
(2, '10.246.0.0/16', 2),
455
(3, '80.247.96.0/20', 3),
456
(4, '81.201.240.0/20', 3),
457
(5, '172.16.64.0/18', 3),
458
(6, '172.16.128.0/18', 3),
459
(7, '82.179.16.0/20', 4),
36 diffor 460
(8, '81.1.237.192/26', 5),
461
(9, '83.246.160.192/28', 5),
40 diffor 462
(11, '93.189.220.0/28', 5),
41 diffor 463
(13, '78.109.128.0/20', 8),
464
(14, '62.33.116.0/23', 9),
465
(15, '80.89.149.0/24', 9),
466
(16, '80.89.153.0/24', 10),
467
(17, '82.200.45.0/24', 10),
468
(18, '84.237.124.0/22', 10),
469
(19, '90.188.0.0/20', 7),
470
(20, '90.188.16.0/20', 7),
471
(21, '92.125.64.0/18', 7),
472
(22, '92.127.64.0/18', 7),
473
(23, '93.189.216.0/21', 8),
474
(24, '94.230.112.0/20', 8),
475
(25, '95.190.128.0/19', 7),
476
(26, '193.27.222.0/23', 11),
477
(27, '194.150.128.0/19', 7),
478
(28, '194.154.85.0/24', 12),
479
(29, '195.239.211.0/24', 12),
480
(30, '212.94.96.0/19', 7),
481
(31, '217.107.47.0/24', 9);