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

Редакция	Автор	№ строки	Строка
2	diffor	1	-- phpMyAdmin SQL Dump
12	diffor	2	-- version 2.11.8.1deb5+lenny1
2	diffor	3	-- http://www.phpmyadmin.net
5	diffor	4	--
2	diffor	5	-- Хост: localhost
12	diffor	6	-- Время создания: Сен 08 2009 г., 14:49
		7	-- Версия сервера: 5.0.51
		8	-- Версия PHP: 5.2.6-1+lenny3
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
		28	DROP TABLE IF EXISTS `apt_mirrors`;
		29	CREATE TABLE IF NOT EXISTS `apt_mirrors` (
12	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	`desk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		34	PRIMARY KEY (`id`)
11	diffor	35	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ;
10	diffor	36
		37	--
		38	-- Дамп данных таблицы `apt_mirrors`
		39	--
		40
		41	INSERT INTO `apt_mirrors` (`id`, `src_name`, `src_url`, `desk`) VALUES
		42	(1, 'debian', 'ftp://ftp.us.debian.org/debian', ''),
		43	(2, 'debian-security', 'ftp://security.debian.org/debian-security', ''),
		44	(3, 'debian-multimedia', 'http://www.debian-multimedia.org', ''),
		45	(4, 'ubuntu', 'http://archive.ubuntu.com/ubuntu', ''),
		46	(5, 'ubuntu-security', 'http://security.ubuntu.com/ubuntu', ''),
		47	(6, 'ubuntu-canonical', 'http://archive.canonical.com', ''),
11	diffor	48	(7, 'medibuntu', 'http://packages.medibuntu.org/', ''),
		49	(8, 'infralinux', 'http://archive.infralinux.org/infralinux/', ''),
		50	(9, '2gis', 'http://packages.redsolution.ru/2gis', ''),
		51	(10, 'opera', 'http://deb.opera.com/opera/', ''),
		52	(11, 'virtualbox', 'http://download.virtualbox.org/virtualbox/debian', ''),
		53	(12, 'opera-beta', 'http://deb.opera.com/opera-beta/', ''),
		54	(13, 'playonlinux', '', ''),
		55	(14, 'freenx', '', ''),
		56	(15, 'wesnoth', '', ''),
		57	(16, 'xneur', '', '');
10	diffor	58
		59	-- --------------------------------------------------------
		60
		61	--
2	diffor	62	-- Структура таблицы `categories`
5	diffor	63	--
2	diffor	64
3	diffor	65	DROP TABLE IF EXISTS `categories`;
2	diffor	66	CREATE TABLE IF NOT EXISTS `categories` (
12	diffor	67	`id` INT(2) NOT NULL AUTO_INCREMENT,
		68	`category` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
		69	PRIMARY KEY (`id`)
7	diffor	70	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
2	diffor	71
5	diffor	72	--
2	diffor	73	-- Дамп данных таблицы `categories`
5	diffor	74	--
2	diffor	75
5	diffor	76	INSERT INTO `categories` (`id`, `category`) VALUES
2	diffor	77	(1, 'file'),
		78	(2, 'repo'),
7	diffor	79	(3, 'info'),
		80	(4, 'misc');
2	diffor	81
		82	-- --------------------------------------------------------
		83
5	diffor	84	--
		85	-- Структура таблицы `details`
		86	--
		87
		88	DROP TABLE IF EXISTS `details`;
		89	CREATE TABLE IF NOT EXISTS `details` (
12	diffor	90	`id` INT(2) NOT NULL AUTO_INCREMENT,
		91	`title` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		92	`description` text COLLATE utf8_unicode_ci NOT NULL,
		93	`link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		94	`talklink` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		95	PRIMARY KEY (`id`),
5	diffor	96	KEY `resource_id` (`title`)
		97	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
		98
		99	--
		100	-- Дамп данных таблицы `details`
		101	--
		102
		103	INSERT INTO `details` (`id`, `title`, `description`, `link`, `talklink`) VALUES
		104	(1, 'ftp.niX-FILES', 'Файлопомойко', 'ftp://ftp.nix-files.org.ru', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846');
		105
		106	-- --------------------------------------------------------
		107
		108	--
2	diffor	109	-- Структура таблицы `members`
5	diffor	110	--
2	diffor	111
3	diffor	112	DROP TABLE IF EXISTS `members`;
2	diffor	113	CREATE TABLE IF NOT EXISTS `members` (
12	diffor	114	`id` INT(2) NOT NULL AUTO_INCREMENT,
		115	`nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		116	`avatar` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		117	`jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
4	diffor	118	`icq` INT(15) NOT NULL,
12	diffor	119	PRIMARY KEY (`id`)
7	diffor	120	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;
2	diffor	121
5	diffor	122	--
2	diffor	123	-- Дамп данных таблицы `members`
5	diffor	124	--
2	diffor	125
5	diffor	126	INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES
4	diffor	127	(1, 'Diffor', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0),
7	diffor	128	(2, 'firstleon', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0),
		129	(3, 'SlipKnoT8', './img/avatar/slipknot8.gif', 'slipknot888@jabber.ru', 0),
		130	(4, 'mistiman', './img/avatar/mistiman.png', '', 0),
		131	(5, 'IK', './img/avatar/ik.jpg', '', 0),
		132	(7, 'SP\|Scream', './img/avatar/spscream.png', '', 0),
		133	(8, 'Yamah', './img/avatar/yamah.png', '', 0);
2	diffor	134
		135	-- --------------------------------------------------------
		136
5	diffor	137	--
2	diffor	138	-- Структура таблицы `networks`
5	diffor	139	--
2	diffor	140
3	diffor	141	DROP TABLE IF EXISTS `networks`;
2	diffor	142	CREATE TABLE IF NOT EXISTS `networks` (
12	diffor	143	`id` INT(2) NOT NULL AUTO_INCREMENT,
		144	`network` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
		145	`link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		146	PRIMARY KEY (`id`)
2	diffor	147	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
		148
5	diffor	149	--
2	diffor	150	-- Дамп данных таблицы `networks`
5	diffor	151	--
2	diffor	152
5	diffor	153	INSERT INTO `networks` (`id`, `network`, `link`) VALUES
2	diffor	154	(1, 'Глоб', ''),
		155	(2, 'Интелби', 'http://www.intelbi.ru/'),
		156	(3, 'Интелека', 'http://www.inteleca.ru/'),
		157	(4, 'АГУ', 'http://www.asu.ru/'),
		158	(5, 'АлтГПА', 'http://www.uni-altai.ru/');
		159
		160	-- --------------------------------------------------------
		161
5	diffor	162	--
		163	-- Структура таблицы `resources`
		164	--
		165
		166	DROP TABLE IF EXISTS `resources`;
		167	CREATE TABLE IF NOT EXISTS `resources` (
12	diffor	168	`id` INT(2) NOT NULL AUTO_INCREMENT,
5	diffor	169	`category_id` INT(2) NOT NULL,
12	diffor	170	`resource` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
		171	`picture` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		172	`link_talk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		173	`link_res` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		174	PRIMARY KEY (`id`),
5	diffor	175	KEY `category_id` (`category_id`)
7	diffor	176	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
5	diffor	177
		178	--
		179	-- Дамп данных таблицы `resources`
		180	--
		181
		182	INSERT INTO `resources` (`id`, `category_id`, `resource`, `picture`, `link_talk`, `link_res`) VALUES
		183	(1, 1, 'ftp', './img/logo/ftp.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846', 'ftp://ftp.nix-files.org.ru'),
		184	(2, 2, 'apt', './img/logo/debian.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1370', 'http://apt.nix-files.org.ru'),
		185	(3, 3, 'dicts', './img/logo/kdict.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1432', 'http://dicts.nix-files.org.ru'),
		186	(4, 3, 'mans', './img/logo/khelpcenter.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1449', 'http://mans.nix-files.org.ru'),
		187	(5, 2, 'gentoo', './img/logo/gentoo.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1860', 'http://gentoo.nix-files.org.ru'),
		188	(6, 2, 'mandriva', './img/logo/mandrake.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2005', 'http://mandriva.nix-files.org.ru'),
		189	(7, 2, 'arch', './img/logo/archlinux.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1884', 'http://arch.nix-files.org.ru'),
		190	(8, 2, 'alt', './img/logo/altlinux.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2009', 'http://alt.nix-files.org.ru'),
7	diffor	191	(9, 2, 'freebsd', './img/logo/freebsd.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1990', 'http://freebsd.nix-files.org.ru'),
		192	(10, 4, 'www', './img/logo/www.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1858', 'http://www.nix-files.org.ru'),
		193	(11, 4, 'fail', './img/logo/fail.png', '', 'http://fail.nix-files.org.ru');
5	diffor	194
		195	-- --------------------------------------------------------
		196
		197	--
4	diffor	198	-- Структура таблицы `res_mem_rank`
5	diffor	199	--
4	diffor	200
		201	DROP TABLE IF EXISTS `res_mem_rank`;
		202	CREATE TABLE IF NOT EXISTS `res_mem_rank` (
12	diffor	203	`id` INT(5) NOT NULL AUTO_INCREMENT,
5	diffor	204	`resource_id` INT(2) NOT NULL,
		205	`network_id` INT(2) NOT NULL,
4	diffor	206	`member_id` INT(2) NOT NULL,
		207	`rank_id` INT(2) NOT NULL,
12	diffor	208	PRIMARY KEY (`id`),
5	diffor	209	KEY `resource_id` (`rank_id`),
		210	KEY `member_id` (`member_id`),
		211	KEY `network_id` (`network_id`),
		212	KEY `resource_id_2` (`resource_id`)
7	diffor	213	) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
12	diffor	214
		215	--
		216	-- Дамп данных таблицы `res_mem_rank`
		217	--
		218
		219
		220	-- --------------------------------------------------------
		221
		222	--
		223	-- Структура таблицы `res_net_stat`
		224	--
		225
		226	DROP TABLE IF EXISTS `res_net_stat`;
		227	CREATE TABLE IF NOT EXISTS `res_net_stat` (
		228	`id` INT(5) NOT NULL AUTO_INCREMENT,
		229	`resource_id` INT(2) NOT NULL,
		230	`network_id` INT(2) NOT NULL,
		231	`state_id` INT(2) NOT NULL,
		232	PRIMARY KEY (`id`),
		233	KEY `resource_id` (`resource_id`,`network_id`)
		234	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=37 ;
		235
		236	--
		237	-- Дамп данных таблицы `res_net_stat`
		238	--
		239
		240	INSERT INTO `res_net_stat` (`id`, `resource_id`, `network_id`, `state_id`) VALUES
		241	(1, 1, 2, 1),
		242	(2, 1, 3, 1),
		243	(3, 1, 4, 4),
		244	(4, 1, 5, 3),
		245	(5, 2, 2, 2),
		246	(6, 2, 3, 2),
		247	(7, 2, 4, 4),
		248	(8, 2, 5, 1),
		249	(9, 3, 1, 1),
		250	(10, 3, 2, 1),
		251	(11, 3, 3, 2),
		252	(12, 3, 5, 3),
		253	(13, 4, 1, 1),
		254	(14, 4, 2, 1),
		255	(15, 4, 3, 2),
		256	(16, 4, 5, 3),
		257	(17, 5, 2, 1),
		258	(18, 5, 3, 1),
		259	(19, 5, 5, 2),
		260	(20, 6, 2, 1),
		261	(21, 6, 3, 1),
		262	(22, 6, 5, 3),
		263	(23, 7, 2, 1),
		264	(24, 7, 3, 1),
		265	(25, 7, 5, 3),
		266	(26, 8, 2, 1),
		267	(27, 8, 3, 1),
		268	(28, 8, 5, 3),
		269	(29, 9, 2, 1),
		270	(30, 9, 3, 1),
		271	(31, 9, 5, 2),
		272	(32, 10, 1, 1),
		273	(33, 10, 2, 1),
		274	(34, 10, 3, 2),
		275	(35, 10, 5, 3),
		276	(36, 11, 1, 1);

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

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