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

Редакция

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