Subversion Repositories www_nix-files

Rev

Rev 206 | Details | Compare with Previous | Last modification | View Log | RSS feed

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