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

Редакция

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