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

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

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

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