WebSVN - www_nix-files - Различия - Редакция 206 и 207

Редакция 206		Редакция 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

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

(root)/trunk/db/nix-files.sql - Редакция 206 → 207