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

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

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

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