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

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

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

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