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

Редакция

Редакция 199 | Редакция 201 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | 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),
163 diffor 320
(8, 'Yamah', '', './img/avatar/yamah.png', 'yamah-byv@jabber.ru', 0);
2 diffor 321
 
322
-- --------------------------------------------------------
323
 
5 diffor 324
--
41 diffor 325
-- Структура таблицы `netcats`
326
--
327
 
328
DROP TABLE IF EXISTS `netcats`;
329
CREATE TABLE IF NOT EXISTS `netcats` (
330
  `id` INT(2) NOT NULL AUTO_INCREMENT,
331
  `netcat` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
332
  PRIMARY KEY (`id`)
333
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
334
 
335
--
336
-- Дамп данных таблицы `netcats`
337
--
338
 
339
INSERT INTO `netcats` (`id`, `netcat`) VALUES
340
(1, 'Глоб'),
341
(2, 'Основные'),
342
(3, 'Университеты'),
343
(4, 'Пиринг');
344
 
345
-- --------------------------------------------------------
346
 
347
--
2 diffor 348
-- Структура таблицы `networks`
5 diffor 349
--
2 diffor 350
 
38 diffor 351
DROP TABLE IF EXISTS `networks`;
2 diffor 352
CREATE TABLE IF NOT EXISTS `networks` (
36 diffor 353
  `id` INT(2) NOT NULL AUTO_INCREMENT,
41 diffor 354
  `netcat_id` INT(2) NOT NULL,
36 diffor 355
  `network` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
356
  `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
41 diffor 357
  PRIMARY KEY (`id`),
358
  KEY `netcat_id` (`netcat_id`)
172 diffor 359
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;
2 diffor 360
 
5 diffor 361
--
2 diffor 362
-- Дамп данных таблицы `networks`
5 diffor 363
--
2 diffor 364
 
41 diffor 365
INSERT INTO `networks` (`id`, `netcat_id`, `network`, `link`) VALUES
366
(1, 1, 'Глоб', ''),
367
(2, 2, 'Интелби', 'http://www.intelbi.ru/'),
368
(3, 2, 'Интелека', 'http://www.inteleca.ru/'),
369
(4, 3, 'АГУ', 'http://www.asu.ru/'),
370
(5, 3, 'АлтГПА', 'http://www.uni-altai.ru/'),
371
(6, 3, 'АлтГТУ', 'http://www.altstu.ru/'),
372
(7, 4, 'Webstream', 'http://www.wstream.ru/'),
373
(8, 4, 'Дианет', 'http://www.dianet.info/'),
172 diffor 374
(9, 4, 'Диалог', 'http://www.dialog-it.ru/'),
375
(10, 4, 'Нэтком', 'http://www.netcorp.ru/'),
41 diffor 376
(11, 4, 'Рубцовск', 'http://www.rubtsovsk.ru/'),
172 diffor 377
(12, 4, 'Алтайгриф', 'http://www.altaigrif.ru/'),
378
(13, 4, 'ТТК', 'http://www.myttk.ru/');
2 diffor 379
 
380
-- --------------------------------------------------------
381
 
5 diffor 382
--
383
-- Структура таблицы `resources`
384
--
385
 
38 diffor 386
DROP TABLE IF EXISTS `resources`;
5 diffor 387
CREATE TABLE IF NOT EXISTS `resources` (
36 diffor 388
  `id` INT(2) NOT NULL AUTO_INCREMENT,
5 diffor 389
  `category_id` INT(2) NOT NULL,
36 diffor 390
  `resource` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
391
  `picture` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
25 diffor 392
  `member_id` INT(2) NOT NULL,
36 diffor 393
  `link_talk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
394
  `link_res` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
395
  `description` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
396
  `custom` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
397
  PRIMARY KEY (`id`),
25 diffor 398
  KEY `category_id` (`category_id`),
399
  KEY `curator` (`member_id`)
7 diffor 400
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
5 diffor 401
 
402
--
403
-- Дамп данных таблицы `resources`
404
--
405
 
25 diffor 406
INSERT INTO `resources` (`id`, `category_id`, `resource`, `picture`, `member_id`, `link_talk`, `link_res`, `description`, `custom`) VALUES
407
(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 408
(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 409
(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).', ''),
410
(4, 3, 'mans', './img/logo/mans.png', 5, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1449', 'http://mans.nix-files.org.ru', 'Онлайн просмотр манов. В основном маны русскоязычные.', ''),
25 diffor 411
(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'),
79 diffor 412
(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.', ''),
25 diffor 413
(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'),
414
(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.', ''),
415
(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'),
416
(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 417
(11, 4, 'fail', './img/logo/fail.png', 1, '', 'http://fail.nix-files.org.ru', 'Сайт-заглушка, отображаемый при попытке зайти на ресурс, который недоступен для данной сети.', '');
5 diffor 418
 
419
-- --------------------------------------------------------
420
 
421
--
12 diffor 422
-- Структура таблицы `res_net_stat`
423
--
424
 
38 diffor 425
DROP TABLE IF EXISTS `res_net_stat`;
12 diffor 426
CREATE TABLE IF NOT EXISTS `res_net_stat` (
36 diffor 427
  `id` INT(5) NOT NULL AUTO_INCREMENT,
12 diffor 428
  `resource_id` INT(2) NOT NULL,
429
  `network_id` INT(2) NOT NULL,
430
  `state_id` INT(2) NOT NULL,
36 diffor 431
  PRIMARY KEY (`id`),
12 diffor 432
  KEY `resource_id` (`resource_id`,`network_id`)
44 diffor 433
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=105 ;
12 diffor 434
 
435
--
436
-- Дамп данных таблицы `res_net_stat`
437
--
438
 
439
INSERT INTO `res_net_stat` (`id`, `resource_id`, `network_id`, `state_id`) VALUES
440
(1, 1, 2, 1),
441
(2, 1, 3, 1),
442
(3, 1, 4, 4),
443
(4, 1, 5, 3),
44 diffor 444
(5, 2, 2, 1),
445
(6, 2, 3, 1),
12 diffor 446
(7, 2, 4, 4),
48 diffor 447
(8, 2, 5, 3),
12 diffor 448
(9, 3, 1, 1),
449
(10, 3, 2, 1),
199 diffor 450
(11, 3, 3, 1),
12 diffor 451
(12, 3, 5, 3),
452
(13, 4, 1, 1),
453
(14, 4, 2, 1),
199 diffor 454
(15, 4, 3, 1),
12 diffor 455
(16, 4, 5, 3),
456
(17, 5, 2, 1),
457
(18, 5, 3, 1),
458
(19, 5, 5, 2),
459
(20, 6, 2, 1),
460
(21, 6, 3, 1),
461
(22, 6, 5, 3),
462
(23, 7, 2, 1),
463
(24, 7, 3, 1),
464
(25, 7, 5, 3),
465
(26, 8, 2, 1),
466
(27, 8, 3, 1),
467
(28, 8, 5, 3),
44 diffor 468
(29, 9, 2, 5),
469
(30, 9, 3, 5),
470
(31, 9, 5, 5),
12 diffor 471
(32, 10, 1, 1),
472
(33, 10, 2, 1),
199 diffor 473
(34, 10, 3, 1),
12 diffor 474
(35, 10, 5, 3),
14 diffor 475
(36, 11, 1, 1),
476
(37, 10, 7, 3),
477
(38, 3, 7, 3),
478
(39, 4, 7, 3),
479
(40, 1, 7, 3),
480
(41, 2, 7, 3),
481
(42, 5, 7, 3),
482
(43, 6, 7, 3),
483
(44, 7, 7, 3),
484
(45, 8, 7, 3),
44 diffor 485
(46, 9, 7, 5),
40 diffor 486
(47, 3, 8, 3),
487
(48, 4, 8, 3),
488
(49, 1, 8, 3),
489
(50, 2, 8, 3),
490
(51, 5, 8, 3),
491
(52, 6, 8, 3),
492
(53, 7, 8, 3),
493
(54, 8, 8, 3),
44 diffor 494
(55, 9, 8, 5),
495
(56, 10, 8, 3),
496
(57, 1, 9, 4),
497
(58, 2, 9, 4),
498
(59, 3, 9, 4),
499
(60, 4, 9, 4),
500
(61, 5, 9, 4),
501
(62, 6, 9, 4),
502
(63, 7, 9, 4),
503
(64, 8, 9, 4),
504
(65, 9, 9, 5),
505
(66, 10, 9, 4),
506
(67, 1, 10, 4),
507
(68, 2, 10, 4),
508
(69, 3, 10, 4),
509
(70, 4, 10, 4),
510
(71, 5, 10, 4),
511
(72, 6, 10, 4),
512
(73, 7, 10, 4),
513
(74, 8, 10, 4),
514
(75, 9, 10, 5),
515
(76, 10, 10, 4),
516
(77, 1, 11, 4),
517
(78, 2, 11, 4),
518
(79, 3, 11, 4),
519
(80, 4, 11, 4),
520
(81, 5, 11, 4),
521
(82, 6, 11, 4),
522
(83, 7, 11, 4),
523
(84, 8, 11, 4),
524
(85, 9, 11, 5),
525
(86, 10, 11, 4),
526
(87, 1, 12, 4),
527
(88, 2, 12, 4),
528
(89, 3, 12, 4),
529
(90, 4, 12, 4),
530
(91, 5, 12, 4),
531
(92, 6, 12, 4),
532
(93, 7, 12, 4),
533
(94, 8, 12, 4),
534
(95, 9, 12, 5),
535
(96, 10, 12, 4),
536
(97, 3, 4, 4),
537
(98, 4, 4, 4),
538
(99, 5, 4, 4),
539
(100, 6, 4, 4),
540
(101, 7, 4, 4),
541
(102, 8, 4, 4),
542
(103, 9, 4, 5),
173 diffor 543
(104, 10, 4, 4),
544
(105, 3, 13, 3),
545
(106, 4, 13, 3),
546
(107, 1, 13, 3),
547
(108, 2, 13, 3),
548
(109, 5, 13, 3),
549
(110, 6, 13, 3),
550
(111, 7, 13, 3),
551
(112, 8, 13, 3),
552
(113, 9, 13, 5),
197 diffor 553
(114, 10, 13, 3),
554
(115, 11, 2, 1),
555
(116, 11, 3, 1),
556
(117, 11, 4, 4),
557
(118, 11, 5, 3),
558
(119, 11, 7, 3),
559
(120, 11, 8, 3),
198 diffor 560
(121, 11, 9, 4),
561
(122, 11, 10, 4),
562
(123, 11, 11, 4),
563
(124, 11, 12, 4),
564
(125, 11, 13, 3);
14 diffor 565
 
566
-- --------------------------------------------------------
567
 
568
--
49 diffor 569
-- Структура таблицы `servers`
570
--
571
 
572
DROP TABLE IF EXISTS `servers`;
573
CREATE TABLE IF NOT EXISTS `servers` (
574
  `id` INT(5) NOT NULL AUTO_INCREMENT,
575
  `server` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
56 diffor 576
  `cpu` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
577
  `ram` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
161 diffor 578
  `hdd` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
49 diffor 579
  `member_id` INT(2) NOT NULL,
580
  PRIMARY KEY (`id`),
581
  KEY `member_id` (`member_id`)
582
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
583
 
584
--
585
-- Дамп данных таблицы `servers`
586
--
587
 
56 diffor 588
INSERT INTO `servers` (`id`, `server`, `cpu`, `ram`, `hdd`, `member_id`) VALUES
58 diffor 589
(1, 'diffor', 'Intel(R) Celeron(TM) CPU  1200MHz', '512Mb SDRAM', 'RAID1 320Gb (ST3250310NS)', 1),
57 diffor 590
(2, 'leon', 'Intel(R) Pentium(R) III CPU family 1400MHz', '512Mb SDRAM', 'RAID5 551Gb (4 IDE)', 2),
196 diffor 591
(3, 'Frosya', 'Intel(R) Pentium(R) D CPU 2.80GHz', '2Gb DDR2', '500Gb (WD5000AAKS):640Gb (WD6401AALS):750Gb (WD7501AALS)', 3);
49 diffor 592
 
593
-- --------------------------------------------------------
594
 
595
--
14 diffor 596
-- Структура таблицы `states`
597
--
598
 
38 diffor 599
DROP TABLE IF EXISTS `states`;
14 diffor 600
CREATE TABLE IF NOT EXISTS `states` (
36 diffor 601
  `id` INT(3) NOT NULL AUTO_INCREMENT,
14 diffor 602
  `image` VARCHAR(50) NOT NULL,
603
  `description` VARCHAR(50) NOT NULL,
36 diffor 604
  PRIMARY KEY (`id`)
44 diffor 605
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
14 diffor 606
 
607
--
608
-- Дамп данных таблицы `states`
609
--
610
 
611
INSERT INTO `states` (`id`, `image`, `description`) VALUES
44 diffor 612
(1, './img/state/tick_gold.png', 'Основной ресурс'),
613
(2, './img/state/tick_blue.png', 'Зеркало ресурса'),
45 diffor 614
(3, './img/state/tick_green.png', 'Скоростной доступ'),
615
(4, './img/state/tick_gray.png', 'Доступен'),
44 diffor 616
(5, './img/state/snowflake.png', 'Приостановлен');
31 diffor 617
 
618
-- --------------------------------------------------------
619
 
620
--
621
-- Структура таблицы `subnets`
622
--
623
 
38 diffor 624
DROP TABLE IF EXISTS `subnets`;
31 diffor 625
CREATE TABLE IF NOT EXISTS `subnets` (
36 diffor 626
  `id` INT(5) NOT NULL AUTO_INCREMENT,
31 diffor 627
  `subnet` VARCHAR(20) NOT NULL,
628
  `network_id` INT(2) NOT NULL,
36 diffor 629
  PRIMARY KEY (`id`),
31 diffor 630
  KEY `network_id` (`network_id`)
194 diffor 631
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
31 diffor 632
 
633
--
634
-- Дамп данных таблицы `subnets`
635
--
636
 
637
INSERT INTO `subnets` (`id`, `subnet`, `network_id`) VALUES
638
(1, '83.246.128.0/17', 2),
639
(2, '10.246.0.0/16', 2),
640
(3, '80.247.96.0/20', 3),
641
(4, '81.201.240.0/20', 3),
200 diffor 642
(5, '172.0.0.0/8', 3),
31 diffor 643
(7, '82.179.16.0/20', 4),
36 diffor 644
(8, '81.1.237.192/26', 5),
645
(9, '83.246.160.192/28', 5),
40 diffor 646
(11, '93.189.220.0/28', 5),
41 diffor 647
(13, '78.109.128.0/20', 8),
648
(14, '62.33.116.0/23', 9),
649
(15, '80.89.149.0/24', 9),
650
(16, '80.89.153.0/24', 10),
651
(17, '82.200.45.0/24', 10),
652
(18, '84.237.124.0/22', 10),
653
(19, '90.188.0.0/20', 7),
654
(20, '90.188.16.0/20', 7),
655
(21, '92.125.64.0/18', 7),
656
(22, '92.127.64.0/18', 7),
657
(23, '93.189.216.0/21', 8),
658
(24, '94.230.112.0/20', 8),
659
(25, '95.190.128.0/19', 7),
660
(26, '193.27.222.0/23', 11),
661
(27, '194.150.128.0/19', 7),
662
(28, '194.154.85.0/24', 12),
663
(29, '195.239.211.0/24', 12),
664
(30, '212.94.96.0/19', 7),
172 diffor 665
(31, '217.107.47.0/24', 9),
195 diffor 666
(32, '109.171.0.0/17', 13),
180 diffor 667
(33, '94.251.0.0/17', 13),
668
(34, '82.200.47.0/24', 13),
181 diffor 669
(35, '80.89.140.0/24', 13),
182 diffor 670
(36, '178.187.0.0/16', 7),
194 diffor 671
(37, '178.186.128.0/17', 7),
672
(38, '81.1.237.0/24', 13);