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

Редакция

Редакция 200 | Редакция 202 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | 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
171 diffor 6
-- Время создания: Ноя 30 2009 г., 00:30
36 diffor 7
-- Версия сервера: 5.1.37
166 diffor 8
-- Версия PHP: 5.2.10-2ubuntu6.3
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
--
166 diffor 25
-- Структура таблицы `apt_distrs`
10 diffor 26
--
27
 
166 diffor 28
DROP TABLE IF EXISTS `apt_distrs`;
29
CREATE TABLE IF NOT EXISTS `apt_distrs` (
36 diffor 30
  `id` INT(5) NOT NULL AUTO_INCREMENT,
166 diffor 31
  `distr` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
169 diffor 32
  `logo` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL,
166 diffor 33
  PRIMARY KEY (`id`)
34
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
35
 
36
--
37
-- Дамп данных таблицы `apt_distrs`
38
--
39
 
169 diffor 40
INSERT INTO `apt_distrs` (`id`, `distr`, `logo`) VALUES
41
(1, 'Debian', './custom/apt/debian.png'),
42
(2, 'Ubuntu', './custom/apt/ubuntu.png');
166 diffor 43
 
44
-- --------------------------------------------------------
45
 
46
--
47
-- Структура таблицы `apt_reps`
48
--
49
 
50
DROP TABLE IF EXISTS `apt_reps`;
51
CREATE TABLE IF NOT EXISTS `apt_reps` (
52
  `id` INT(5) NOT NULL AUTO_INCREMENT,
36 diffor 53
  `src_name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
54
  `src_url` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
55
  `description` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
170 diffor 56
  `logo` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
36 diffor 57
  PRIMARY KEY (`id`)
167 diffor 58
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;
10 diffor 59
 
60
--
166 diffor 61
-- Дамп данных таблицы `apt_reps`
10 diffor 62
--
63
 
170 diffor 64
INSERT INTO `apt_reps` (`id`, `src_name`, `src_url`, `description`, `logo`) VALUES
65
(1, 'debian', 'ftp://ftp.us.debian.org/debian', 'Основной репозиторий Debain', 'debian.ico'),
66
(2, 'debian-security', 'ftp://security.debian.org/debian-security', 'Обновления безопасности Debian', 'debian.ico'),
67
(3, 'debian-multimedia', 'http://www.debian-multimedia.org', 'Мультимедийные пакеты Debian', 'debian-multimedia.ico'),
68
(4, 'ubuntu', 'http://archive.ubuntu.com/ubuntu', 'Основной репозиторий Ubuntu', 'ubuntu.ico'),
69
(5, 'ubuntu-security', 'http://security.ubuntu.com/ubuntu', 'Обновления безопасности Ubuntu', 'ubuntu.ico'),
70
(6, 'ubuntu-canonical', 'http://archive.canonical.com', 'Коммерческие пакеты Ubuntu', 'canonical.ico'),
171 diffor 71
(7, 'medibuntu', 'http://packages.medibuntu.org/', 'Мультимедийные пакеты Ubuntu', 'medibuntu.ico'),
170 diffor 72
(8, 'infralinux', 'http://archive.infralinux.org/infralinux/', 'Основной репозиторий Infralinux', 'infralinux.ico'),
73
(9, '2gis', 'http://packages.redsolution.ru/2gis', 'ДубльГис', '2gis.ico'),
74
(10, 'opera', 'http://deb.opera.com/opera/', 'Opera', 'opera.ico'),
75
(11, 'virtualbox', 'http://download.virtualbox.org/virtualbox/debian', 'VirtualBox', 'virtualbox.ico'),
76
(12, 'opera-beta', 'http://deb.opera.com/opera-beta/', 'Бэта-версии Opera', 'opera.ico'),
77
(13, 'playonlinux', 'http://deb.playonlinux.com/', 'PlayOnLinux', 'playonlinux.png'),
78
(14, 'freenx', 'http://www.datakeylive.com/ubuntu', 'FreeNX', ''),
79
(16, 'xneur', 'http://gq.net.ru/debian', 'XNeur', ''),
171 diffor 80
(17, 'ubuntu-wine', 'http://wine.budgetdedicated.com/apt', 'Wine для Ubuntu', 'winehq.png'),
81
(18, 'debian-winehq', 'http://www.lamaresh.net/apt', 'Wine для Debian', 'winehq.png'),
82
(19, 'gfoss', 'http://debian.gfoss.it', 'Геософт', 'gfoss.ico');
10 diffor 83
 
84
-- --------------------------------------------------------
85
 
86
--
166 diffor 87
-- Структура таблицы `apt_reps2vers`
88
--
89
 
90
DROP TABLE IF EXISTS `apt_reps2vers`;
91
CREATE TABLE IF NOT EXISTS `apt_reps2vers` (
92
  `id` INT(10) NOT NULL AUTO_INCREMENT,
93
  `rep_id` INT(5) NOT NULL,
94
  `ver_id` INT(5) NOT NULL,
95
  PRIMARY KEY (`id`),
96
  KEY `rep_id` (`rep_id`,`ver_id`)
167 diffor 97
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=70 ;
166 diffor 98
 
99
--
100
-- Дамп данных таблицы `apt_reps2vers`
101
--
102
 
103
INSERT INTO `apt_reps2vers` (`id`, `rep_id`, `ver_id`) VALUES
104
(1, 1, 9),
105
(2, 1, 10),
106
(3, 1, 11),
107
(4, 1, 12),
108
(5, 2, 9),
109
(6, 2, 10),
167 diffor 110
(7, 2, 11),
111
(8, 3, 9),
112
(9, 3, 10),
113
(10, 3, 11),
114
(11, 3, 12),
115
(12, 4, 20),
116
(13, 4, 21),
117
(14, 4, 22),
118
(15, 4, 23),
119
(16, 5, 20),
120
(17, 5, 21),
121
(18, 5, 22),
122
(19, 5, 23),
123
(20, 6, 20),
124
(21, 6, 21),
125
(22, 6, 22),
126
(23, 6, 23),
127
(24, 7, 20),
128
(25, 7, 21),
129
(26, 7, 22),
130
(27, 7, 23),
131
(28, 8, 20),
132
(29, 8, 21),
133
(30, 8, 22),
134
(31, 8, 23),
135
(32, 9, 10),
136
(33, 9, 20),
137
(34, 10, 9),
138
(35, 10, 10),
139
(36, 10, 11),
140
(37, 10, 12),
141
(38, 11, 9),
142
(39, 11, 10),
143
(40, 11, 20),
144
(41, 11, 21),
145
(42, 11, 22),
146
(43, 11, 23),
147
(44, 12, 9),
148
(45, 12, 10),
149
(46, 12, 11),
150
(47, 12, 12),
151
(48, 13, 9),
152
(49, 13, 10),
153
(50, 13, 11),
154
(51, 13, 20),
155
(52, 13, 21),
156
(53, 13, 22),
157
(54, 14, 19),
158
(55, 14, 20),
159
(56, 16, 9),
160
(57, 16, 10),
161
(58, 16, 11),
162
(59, 16, 20),
163
(60, 16, 21),
164
(61, 16, 22),
165
(62, 17, 20),
166
(63, 17, 21),
167
(64, 17, 22),
168
(65, 18, 9),
169
(66, 18, 10),
170
(67, 18, 11),
171
(68, 18, 12),
172
(69, 19, 10);
166 diffor 173
 
174
-- --------------------------------------------------------
175
 
176
--
177
-- Структура таблицы `apt_vers`
178
--
179
 
180
DROP TABLE IF EXISTS `apt_vers`;
181
CREATE TABLE IF NOT EXISTS `apt_vers` (
182
  `id` INT(5) NOT NULL AUTO_INCREMENT,
183
  `distr_id` INT(5) NOT NULL,
184
  `vernum` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,
185
  `codename` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
186
  PRIMARY KEY (`id`),
187
  KEY `distr_id` (`distr_id`)
188
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=24 ;
189
 
190
--
191
-- Дамп данных таблицы `apt_vers`
192
--
193
 
194
INSERT INTO `apt_vers` (`id`, `distr_id`, `vernum`, `codename`) VALUES
195
(1, 1, '1.1', 'buzz'),
196
(2, 1, '1.2', 'rex'),
197
(3, 1, '1.3', 'bo'),
198
(4, 1, '2.0', 'hamm'),
199
(5, 1, '2.1', 'slink'),
200
(6, 1, '2.2', 'potato'),
201
(7, 1, '3.0', 'woody'),
202
(8, 1, '3.1', 'sarge'),
203
(9, 1, '4.0', 'etch'),
204
(10, 1, '5.0', 'lenny'),
205
(11, 1, '6.0', 'squeeze'),
206
(12, 1, '-', 'sid'),
207
(13, 2, '4.10', 'warty'),
208
(14, 2, '5.04', 'hoary'),
209
(15, 2, '5.10', 'breezy'),
210
(16, 2, '6.06', 'dapper'),
211
(17, 2, '6.10', 'edgy'),
212
(18, 2, '7.04', 'feisty'),
213
(19, 2, '7.10', 'gutsy'),
214
(20, 2, '8.04', 'hardy'),
215
(21, 2, '8.10', 'intrepid'),
216
(22, 2, '9.04', 'jaunty'),
217
(23, 2, '9.10', 'karmic');
218
 
219
-- --------------------------------------------------------
220
 
221
--
2 diffor 222
-- Структура таблицы `categories`
5 diffor 223
--
2 diffor 224
 
38 diffor 225
DROP TABLE IF EXISTS `categories`;
2 diffor 226
CREATE TABLE IF NOT EXISTS `categories` (
36 diffor 227
  `id` INT(2) NOT NULL AUTO_INCREMENT,
228
  `category` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
229
  PRIMARY KEY (`id`)
7 diffor 230
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
2 diffor 231
 
5 diffor 232
--
2 diffor 233
-- Дамп данных таблицы `categories`
5 diffor 234
--
2 diffor 235
 
5 diffor 236
INSERT INTO `categories` (`id`, `category`) VALUES
2 diffor 237
(1, 'file'),
238
(2, 'repo'),
7 diffor 239
(3, 'info'),
240
(4, 'misc');
2 diffor 241
 
242
-- --------------------------------------------------------
243
 
5 diffor 244
--
31 diffor 245
-- Структура таблицы `details`
246
--
247
 
38 diffor 248
DROP TABLE IF EXISTS `details`;
31 diffor 249
CREATE TABLE IF NOT EXISTS `details` (
36 diffor 250
  `id` INT(2) NOT NULL AUTO_INCREMENT,
251
  `title` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
252
  `description` text COLLATE utf8_unicode_ci NOT NULL,
253
  `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
254
  `talklink` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
255
  PRIMARY KEY (`id`),
31 diffor 256
  KEY `resource_id` (`title`)
257
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
258
 
259
--
260
-- Дамп данных таблицы `details`
261
--
262
 
263
INSERT INTO `details` (`id`, `title`, `description`, `link`, `talklink`) VALUES
264
(1, 'ftp.niX-FILES', 'Файлопомойко', 'ftp://ftp.nix-files.org.ru', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846');
265
 
266
-- --------------------------------------------------------
267
 
268
--
49 diffor 269
-- Структура таблицы `ips`
270
--
271
 
272
DROP TABLE IF EXISTS `ips`;
273
CREATE TABLE IF NOT EXISTS `ips` (
274
  `id` INT(5) NOT NULL AUTO_INCREMENT,
275
  `ip` VARCHAR(16) COLLATE utf8_unicode_ci NOT NULL,
162 diffor 276
  `network_id` INT(5) NOT NULL,
49 diffor 277
  `server_id` INT(5) NOT NULL,
162 diffor 278
  PRIMARY KEY (`id`),
279
  KEY `network_id` (`network_id`)
49 diffor 280
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
281
 
282
--
283
-- Дамп данных таблицы `ips`
284
--
285
 
162 diffor 286
INSERT INTO `ips` (`id`, `ip`, `network_id`, `server_id`) VALUES
287
(1, '83.246.143.111', 2, 1),
288
(2, '83.246.160.195', 2, 2),
289
(3, '83.246.159.41', 2, 3),
290
(4, '172.16.178.102', 3, 3),
291
(5, '78.110.54.204', 1, 4);
49 diffor 292
 
293
-- --------------------------------------------------------
294
 
295
--
2 diffor 296
-- Структура таблицы `members`
5 diffor 297
--
2 diffor 298
 
38 diffor 299
DROP TABLE IF EXISTS `members`;
2 diffor 300
CREATE TABLE IF NOT EXISTS `members` (
36 diffor 301
  `id` INT(2) NOT NULL AUTO_INCREMENT,
302
  `nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
83 diffor 303
  `fio` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
36 diffor 304
  `avatar` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
305
  `jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
4 diffor 306
  `icq` INT(15) NOT NULL,
36 diffor 307
  PRIMARY KEY (`id`)
7 diffor 308
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;
2 diffor 309
 
5 diffor 310
--
2 diffor 311
-- Дамп данных таблицы `members`
5 diffor 312
--
2 diffor 313
 
84 diffor 314
INSERT INTO `members` (`id`, `nick`, `fio`, `avatar`, `jabber`, `icq`) VALUES
315
(1, 'Diffor', 'Функ Дмитрий', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0),
89 diffor 316
(2, 'firstleon', 'Малютин Владимир', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0),
317
(3, 'SlipKnoT8', 'Кравченко Игорь', './img/avatar/slipknot8.gif', 'slipknot888@jabber.ru', 0),
318
(4, 'mistiman', 'Кем Станислав', './img/avatar/mistiman.png', 'mistiman@jabber.ru', 0),
319
(5, 'IK', 'Климентьев Илья', './img/avatar/ik.jpg', 'ik00@jabber.ru', 0),
201 diffor 320
(8, 'Yamah', '', './img/avatar/yamah.png', 'yamah-byv@jabber.ru', 0),
321
(9, 'razum2um', '', './img/avatar/razum2um.png', 'razum2um@jabber.ru', 0);
2 diffor 322
 
323
-- --------------------------------------------------------
324
 
5 diffor 325
--
41 diffor 326
-- Структура таблицы `netcats`
327
--
328
 
329
DROP TABLE IF EXISTS `netcats`;
330
CREATE TABLE IF NOT EXISTS `netcats` (
331
  `id` INT(2) NOT NULL AUTO_INCREMENT,
332
  `netcat` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
333
  PRIMARY KEY (`id`)
334
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
335
 
336
--
337
-- Дамп данных таблицы `netcats`
338
--
339
 
340
INSERT INTO `netcats` (`id`, `netcat`) VALUES
341
(1, 'Глоб'),
342
(2, 'Основные'),
343
(3, 'Университеты'),
344
(4, 'Пиринг');
345
 
346
-- --------------------------------------------------------
347
 
348
--
2 diffor 349
-- Структура таблицы `networks`
5 diffor 350
--
2 diffor 351
 
38 diffor 352
DROP TABLE IF EXISTS `networks`;
2 diffor 353
CREATE TABLE IF NOT EXISTS `networks` (
36 diffor 354
  `id` INT(2) NOT NULL AUTO_INCREMENT,
41 diffor 355
  `netcat_id` INT(2) NOT NULL,
36 diffor 356
  `network` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
357
  `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
41 diffor 358
  PRIMARY KEY (`id`),
359
  KEY `netcat_id` (`netcat_id`)
172 diffor 360
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;
2 diffor 361
 
5 diffor 362
--
2 diffor 363
-- Дамп данных таблицы `networks`
5 diffor 364
--
2 diffor 365
 
41 diffor 366
INSERT INTO `networks` (`id`, `netcat_id`, `network`, `link`) VALUES
367
(1, 1, 'Глоб', ''),
368
(2, 2, 'Интелби', 'http://www.intelbi.ru/'),
369
(3, 2, 'Интелека', 'http://www.inteleca.ru/'),
370
(4, 3, 'АГУ', 'http://www.asu.ru/'),
371
(5, 3, 'АлтГПА', 'http://www.uni-altai.ru/'),
372
(6, 3, 'АлтГТУ', 'http://www.altstu.ru/'),
373
(7, 4, 'Webstream', 'http://www.wstream.ru/'),
374
(8, 4, 'Дианет', 'http://www.dianet.info/'),
172 diffor 375
(9, 4, 'Диалог', 'http://www.dialog-it.ru/'),
376
(10, 4, 'Нэтком', 'http://www.netcorp.ru/'),
41 diffor 377
(11, 4, 'Рубцовск', 'http://www.rubtsovsk.ru/'),
172 diffor 378
(12, 4, 'Алтайгриф', 'http://www.altaigrif.ru/'),
379
(13, 4, 'ТТК', 'http://www.myttk.ru/');
2 diffor 380
 
381
-- --------------------------------------------------------
382
 
5 diffor 383
--
384
-- Структура таблицы `resources`
385
--
386
 
38 diffor 387
DROP TABLE IF EXISTS `resources`;
5 diffor 388
CREATE TABLE IF NOT EXISTS `resources` (
36 diffor 389
  `id` INT(2) NOT NULL AUTO_INCREMENT,
5 diffor 390
  `category_id` INT(2) NOT NULL,
36 diffor 391
  `resource` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
392
  `picture` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
25 diffor 393
  `member_id` INT(2) NOT NULL,
36 diffor 394
  `link_talk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
395
  `link_res` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
396
  `description` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
397
  `custom` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
398
  PRIMARY KEY (`id`),
25 diffor 399
  KEY `category_id` (`category_id`),
400
  KEY `curator` (`member_id`)
7 diffor 401
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
5 diffor 402
 
403
--
404
-- Дамп данных таблицы `resources`
405
--
406
 
25 diffor 407
INSERT INTO `resources` (`id`, `category_id`, `resource`, `picture`, `member_id`, `link_talk`, `link_res`, `description`, `custom`) VALUES
408
(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 тематики (дистрибутивы, софт, медиафайлы).', ''),
165 diffor 409
(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/apt.php'),
70 diffor 410
(3, 3, 'dicts', './img/logo/dicts.png', 5, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1432', 'http://dicts.nix-files.org.ru', 'Сервер со словарями. Доступен как по протоколу http, так и по протоколу dict (порт 2628).', ''),
411
(4, 3, 'mans', './img/logo/mans.png', 5, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1449', 'http://mans.nix-files.org.ru', 'Онлайн просмотр манов. В основном маны русскоязычные.', ''),
201 diffor 412
(5, 2, 'gentoo', './img/logo/gentoo.png', 9, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1860', 'http://gentoo.nix-files.org.ru', 'Актуальный срез "репозитория" Gentoo.', 'gentoo.php'),
79 diffor 413
(6, 2, 'mandriva', './img/logo/mandriva.png', 8, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2005', 'http://mandriva.nix-files.org.ru', 'Зеркало репозитория Mandriva.', ''),
201 diffor 414
(7, 2, 'arch', './img/logo/archlinux.png', 3, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1884', 'http://arch.nix-files.org.ru', 'Зеркало репозитория ArchLinux,(содержит core, current, extra, community, testing).', 'arch.php'),
25 diffor 415
(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.', ''),
416
(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'),
417
(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.', ''),
196 diffor 418
(11, 4, 'fail', './img/logo/fail.png', 1, '', 'http://fail.nix-files.org.ru', 'Сайт-заглушка, отображаемый при попытке зайти на ресурс, который недоступен для данной сети.', '');
5 diffor 419
 
420
-- --------------------------------------------------------
421
 
422
--
12 diffor 423
-- Структура таблицы `res_net_stat`
424
--
425
 
38 diffor 426
DROP TABLE IF EXISTS `res_net_stat`;
12 diffor 427
CREATE TABLE IF NOT EXISTS `res_net_stat` (
36 diffor 428
  `id` INT(5) NOT NULL AUTO_INCREMENT,
12 diffor 429
  `resource_id` INT(2) NOT NULL,
430
  `network_id` INT(2) NOT NULL,
431
  `state_id` INT(2) NOT NULL,
36 diffor 432
  PRIMARY KEY (`id`),
12 diffor 433
  KEY `resource_id` (`resource_id`,`network_id`)
44 diffor 434
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=105 ;
12 diffor 435
 
436
--
437
-- Дамп данных таблицы `res_net_stat`
438
--
439
 
440
INSERT INTO `res_net_stat` (`id`, `resource_id`, `network_id`, `state_id`) VALUES
441
(1, 1, 2, 1),
442
(2, 1, 3, 1),
443
(3, 1, 4, 4),
444
(4, 1, 5, 3),
44 diffor 445
(5, 2, 2, 1),
446
(6, 2, 3, 1),
12 diffor 447
(7, 2, 4, 4),
48 diffor 448
(8, 2, 5, 3),
12 diffor 449
(9, 3, 1, 1),
450
(10, 3, 2, 1),
199 diffor 451
(11, 3, 3, 1),
12 diffor 452
(12, 3, 5, 3),
453
(13, 4, 1, 1),
454
(14, 4, 2, 1),
199 diffor 455
(15, 4, 3, 1),
12 diffor 456
(16, 4, 5, 3),
457
(17, 5, 2, 1),
458
(18, 5, 3, 1),
459
(19, 5, 5, 2),
460
(20, 6, 2, 1),
461
(21, 6, 3, 1),
462
(22, 6, 5, 3),
463
(23, 7, 2, 1),
464
(24, 7, 3, 1),
465
(25, 7, 5, 3),
466
(26, 8, 2, 1),
467
(27, 8, 3, 1),
468
(28, 8, 5, 3),
44 diffor 469
(29, 9, 2, 5),
470
(30, 9, 3, 5),
471
(31, 9, 5, 5),
12 diffor 472
(32, 10, 1, 1),
473
(33, 10, 2, 1),
199 diffor 474
(34, 10, 3, 1),
12 diffor 475
(35, 10, 5, 3),
14 diffor 476
(36, 11, 1, 1),
477
(37, 10, 7, 3),
478
(38, 3, 7, 3),
479
(39, 4, 7, 3),
480
(40, 1, 7, 3),
481
(41, 2, 7, 3),
482
(42, 5, 7, 3),
483
(43, 6, 7, 3),
484
(44, 7, 7, 3),
485
(45, 8, 7, 3),
44 diffor 486
(46, 9, 7, 5),
40 diffor 487
(47, 3, 8, 3),
488
(48, 4, 8, 3),
489
(49, 1, 8, 3),
490
(50, 2, 8, 3),
491
(51, 5, 8, 3),
492
(52, 6, 8, 3),
493
(53, 7, 8, 3),
494
(54, 8, 8, 3),
44 diffor 495
(55, 9, 8, 5),
496
(56, 10, 8, 3),
497
(57, 1, 9, 4),
498
(58, 2, 9, 4),
499
(59, 3, 9, 4),
500
(60, 4, 9, 4),
501
(61, 5, 9, 4),
502
(62, 6, 9, 4),
503
(63, 7, 9, 4),
504
(64, 8, 9, 4),
505
(65, 9, 9, 5),
506
(66, 10, 9, 4),
507
(67, 1, 10, 4),
508
(68, 2, 10, 4),
509
(69, 3, 10, 4),
510
(70, 4, 10, 4),
511
(71, 5, 10, 4),
512
(72, 6, 10, 4),
513
(73, 7, 10, 4),
514
(74, 8, 10, 4),
515
(75, 9, 10, 5),
516
(76, 10, 10, 4),
517
(77, 1, 11, 4),
518
(78, 2, 11, 4),
519
(79, 3, 11, 4),
520
(80, 4, 11, 4),
521
(81, 5, 11, 4),
522
(82, 6, 11, 4),
523
(83, 7, 11, 4),
524
(84, 8, 11, 4),
525
(85, 9, 11, 5),
526
(86, 10, 11, 4),
527
(87, 1, 12, 4),
528
(88, 2, 12, 4),
529
(89, 3, 12, 4),
530
(90, 4, 12, 4),
531
(91, 5, 12, 4),
532
(92, 6, 12, 4),
533
(93, 7, 12, 4),
534
(94, 8, 12, 4),
535
(95, 9, 12, 5),
536
(96, 10, 12, 4),
537
(97, 3, 4, 4),
538
(98, 4, 4, 4),
539
(99, 5, 4, 4),
540
(100, 6, 4, 4),
541
(101, 7, 4, 4),
542
(102, 8, 4, 4),
543
(103, 9, 4, 5),
173 diffor 544
(104, 10, 4, 4),
545
(105, 3, 13, 3),
546
(106, 4, 13, 3),
547
(107, 1, 13, 3),
548
(108, 2, 13, 3),
549
(109, 5, 13, 3),
550
(110, 6, 13, 3),
551
(111, 7, 13, 3),
552
(112, 8, 13, 3),
553
(113, 9, 13, 5),
197 diffor 554
(114, 10, 13, 3),
555
(115, 11, 2, 1),
556
(116, 11, 3, 1),
557
(117, 11, 4, 4),
558
(118, 11, 5, 3),
559
(119, 11, 7, 3),
560
(120, 11, 8, 3),
198 diffor 561
(121, 11, 9, 4),
562
(122, 11, 10, 4),
563
(123, 11, 11, 4),
564
(124, 11, 12, 4),
565
(125, 11, 13, 3);
14 diffor 566
 
567
-- --------------------------------------------------------
568
 
569
--
49 diffor 570
-- Структура таблицы `servers`
571
--
572
 
573
DROP TABLE IF EXISTS `servers`;
574
CREATE TABLE IF NOT EXISTS `servers` (
575
  `id` INT(5) NOT NULL AUTO_INCREMENT,
576
  `server` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
56 diffor 577
  `cpu` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
578
  `ram` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
161 diffor 579
  `hdd` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
49 diffor 580
  `member_id` INT(2) NOT NULL,
581
  PRIMARY KEY (`id`),
582
  KEY `member_id` (`member_id`)
583
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
584
 
585
--
586
-- Дамп данных таблицы `servers`
587
--
588
 
56 diffor 589
INSERT INTO `servers` (`id`, `server`, `cpu`, `ram`, `hdd`, `member_id`) VALUES
58 diffor 590
(1, 'diffor', 'Intel(R) Celeron(TM) CPU  1200MHz', '512Mb SDRAM', 'RAID1 320Gb (ST3250310NS)', 1),
57 diffor 591
(2, 'leon', 'Intel(R) Pentium(R) III CPU family 1400MHz', '512Mb SDRAM', 'RAID5 551Gb (4 IDE)', 2),
196 diffor 592
(3, 'Frosya', 'Intel(R) Pentium(R) D CPU 2.80GHz', '2Gb DDR2', '500Gb (WD5000AAKS):640Gb (WD6401AALS):750Gb (WD7501AALS)', 3);
49 diffor 593
 
594
-- --------------------------------------------------------
595
 
596
--
14 diffor 597
-- Структура таблицы `states`
598
--
599
 
38 diffor 600
DROP TABLE IF EXISTS `states`;
14 diffor 601
CREATE TABLE IF NOT EXISTS `states` (
36 diffor 602
  `id` INT(3) NOT NULL AUTO_INCREMENT,
14 diffor 603
  `image` VARCHAR(50) NOT NULL,
604
  `description` VARCHAR(50) NOT NULL,
36 diffor 605
  PRIMARY KEY (`id`)
44 diffor 606
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
14 diffor 607
 
608
--
609
-- Дамп данных таблицы `states`
610
--
611
 
612
INSERT INTO `states` (`id`, `image`, `description`) VALUES
44 diffor 613
(1, './img/state/tick_gold.png', 'Основной ресурс'),
614
(2, './img/state/tick_blue.png', 'Зеркало ресурса'),
45 diffor 615
(3, './img/state/tick_green.png', 'Скоростной доступ'),
616
(4, './img/state/tick_gray.png', 'Доступен'),
44 diffor 617
(5, './img/state/snowflake.png', 'Приостановлен');
31 diffor 618
 
619
-- --------------------------------------------------------
620
 
621
--
622
-- Структура таблицы `subnets`
623
--
624
 
38 diffor 625
DROP TABLE IF EXISTS `subnets`;
31 diffor 626
CREATE TABLE IF NOT EXISTS `subnets` (
36 diffor 627
  `id` INT(5) NOT NULL AUTO_INCREMENT,
31 diffor 628
  `subnet` VARCHAR(20) NOT NULL,
629
  `network_id` INT(2) NOT NULL,
36 diffor 630
  PRIMARY KEY (`id`),
31 diffor 631
  KEY `network_id` (`network_id`)
194 diffor 632
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
31 diffor 633
 
634
--
635
-- Дамп данных таблицы `subnets`
636
--
637
 
638
INSERT INTO `subnets` (`id`, `subnet`, `network_id`) VALUES
639
(1, '83.246.128.0/17', 2),
640
(2, '10.246.0.0/16', 2),
641
(3, '80.247.96.0/20', 3),
642
(4, '81.201.240.0/20', 3),
200 diffor 643
(5, '172.0.0.0/8', 3),
31 diffor 644
(7, '82.179.16.0/20', 4),
36 diffor 645
(8, '81.1.237.192/26', 5),
646
(9, '83.246.160.192/28', 5),
40 diffor 647
(11, '93.189.220.0/28', 5),
41 diffor 648
(13, '78.109.128.0/20', 8),
649
(14, '62.33.116.0/23', 9),
650
(15, '80.89.149.0/24', 9),
651
(16, '80.89.153.0/24', 10),
652
(17, '82.200.45.0/24', 10),
653
(18, '84.237.124.0/22', 10),
654
(19, '90.188.0.0/20', 7),
655
(20, '90.188.16.0/20', 7),
656
(21, '92.125.64.0/18', 7),
657
(22, '92.127.64.0/18', 7),
658
(23, '93.189.216.0/21', 8),
659
(24, '94.230.112.0/20', 8),
660
(25, '95.190.128.0/19', 7),
661
(26, '193.27.222.0/23', 11),
662
(27, '194.150.128.0/19', 7),
663
(28, '194.154.85.0/24', 12),
664
(29, '195.239.211.0/24', 12),
665
(30, '212.94.96.0/19', 7),
172 diffor 666
(31, '217.107.47.0/24', 9),
195 diffor 667
(32, '109.171.0.0/17', 13),
180 diffor 668
(33, '94.251.0.0/17', 13),
669
(34, '82.200.47.0/24', 13),
181 diffor 670
(35, '80.89.140.0/24', 13),
182 diffor 671
(36, '178.187.0.0/16', 7),
194 diffor 672
(37, '178.186.128.0/17', 7),
673
(38, '81.1.237.0/24', 13);