WebSVN - www_nix-files - Различия - Редакция 200 и 201

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

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

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