WebSVN - www_nix-files - Авторство - Редакция 166

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

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

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