Subversion Repositories www_nix-files

Rev

Rev 206 | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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