WebSVN - www_nix-files - Различия - Редакция 167 и 169

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

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

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