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

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

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

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