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

Редакция	Автор	№ строки	Строка
2	diffor	1	-- phpMyAdmin SQL Dump
36	diffor	2	-- version 3.2.1deb1
2	diffor	3	-- http://www.phpmyadmin.net
5	diffor	4	--
2	diffor	5	-- Хост: localhost
37	diffor	6	-- Время создания: Сен 30 2009 г., 21:54
36	diffor	7	-- Версия сервера: 5.1.37
		8	-- Версия PHP: 5.2.10-2ubuntu4
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	CREATE TABLE IF NOT EXISTS `apt_mirrors` (
36	diffor	29	`id` INT(5) NOT NULL AUTO_INCREMENT,
		30	`src_name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		31	`src_url` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		32	`description` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,
		33	PRIMARY KEY (`id`)
11	diffor	34	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ;
10	diffor	35
		36	--
		37	-- Дамп данных таблицы `apt_mirrors`
		38	--
		39
18	diffor	40	INSERT INTO `apt_mirrors` (`id`, `src_name`, `src_url`, `description`) VALUES
		41	(1, 'debian', 'ftp://ftp.us.debian.org/debian', 'Официальный репозиторий Debain'),
		42	(2, 'debian-security', 'ftp://security.debian.org/debian-security', 'Официальный репозиторий обновлений безопасности Debian'),
		43	(3, 'debian-multimedia', 'http://www.debian-multimedia.org', 'Неофициальные репозиторий мультимедийных пакетов Debian'),
		44	(4, 'ubuntu', 'http://archive.ubuntu.com/ubuntu', 'Официальный репозиторий Ubuntu'),
		45	(5, 'ubuntu-security', 'http://security.ubuntu.com/ubuntu', 'Официальный репозиторий обновлений безопасности Ubuntu'),
10	diffor	46	(6, 'ubuntu-canonical', 'http://archive.canonical.com', ''),
11	diffor	47	(7, 'medibuntu', 'http://packages.medibuntu.org/', ''),
		48	(8, 'infralinux', 'http://archive.infralinux.org/infralinux/', ''),
		49	(9, '2gis', 'http://packages.redsolution.ru/2gis', ''),
		50	(10, 'opera', 'http://deb.opera.com/opera/', ''),
		51	(11, 'virtualbox', 'http://download.virtualbox.org/virtualbox/debian', ''),
		52	(12, 'opera-beta', 'http://deb.opera.com/opera-beta/', ''),
		53	(13, 'playonlinux', '', ''),
		54	(14, 'freenx', '', ''),
		55	(15, 'wesnoth', '', ''),
		56	(16, 'xneur', '', '');
10	diffor	57
		58	-- --------------------------------------------------------
		59
		60	--
2	diffor	61	-- Структура таблицы `categories`
5	diffor	62	--
2	diffor	63
		64	CREATE TABLE IF NOT EXISTS `categories` (
36	diffor	65	`id` INT(2) NOT NULL AUTO_INCREMENT,
		66	`category` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
		67	PRIMARY KEY (`id`)
7	diffor	68	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
2	diffor	69
5	diffor	70	--
2	diffor	71	-- Дамп данных таблицы `categories`
5	diffor	72	--
2	diffor	73
5	diffor	74	INSERT INTO `categories` (`id`, `category`) VALUES
2	diffor	75	(1, 'file'),
		76	(2, 'repo'),
7	diffor	77	(3, 'info'),
		78	(4, 'misc');
2	diffor	79
		80	-- --------------------------------------------------------
		81
5	diffor	82	--
31	diffor	83	-- Структура таблицы `details`
		84	--
		85
		86	CREATE TABLE IF NOT EXISTS `details` (
36	diffor	87	`id` INT(2) NOT NULL AUTO_INCREMENT,
		88	`title` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		89	`description` text COLLATE utf8_unicode_ci NOT NULL,
		90	`link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		91	`talklink` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		92	PRIMARY KEY (`id`),
31	diffor	93	KEY `resource_id` (`title`)
		94	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
		95
		96	--
		97	-- Дамп данных таблицы `details`
		98	--
		99
		100	INSERT INTO `details` (`id`, `title`, `description`, `link`, `talklink`) VALUES
		101	(1, 'ftp.niX-FILES', 'Файлопомойко', 'ftp://ftp.nix-files.org.ru', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846');
		102
		103	-- --------------------------------------------------------
		104
		105	--
2	diffor	106	-- Структура таблицы `members`
5	diffor	107	--
2	diffor	108
		109	CREATE TABLE IF NOT EXISTS `members` (
36	diffor	110	`id` INT(2) NOT NULL AUTO_INCREMENT,
		111	`nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		112	`avatar` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		113	`jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
4	diffor	114	`icq` INT(15) NOT NULL,
36	diffor	115	PRIMARY KEY (`id`)
7	diffor	116	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;
2	diffor	117
5	diffor	118	--
2	diffor	119	-- Дамп данных таблицы `members`
5	diffor	120	--
2	diffor	121
5	diffor	122	INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES
4	diffor	123	(1, 'Diffor', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0),
7	diffor	124	(2, 'firstleon', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0),
		125	(3, 'SlipKnoT8', './img/avatar/slipknot8.gif', 'slipknot888@jabber.ru', 0),
25	diffor	126	(4, 'mistiman', './img/avatar/mistiman.png', 'mistiman@jabber.ru', 0),
		127	(5, 'IK', './img/avatar/ik.jpg', 'ik00@jabber.ru', 0),
27	diffor	128	(7, 'SP\|Scream', './img/avatar/spscream.png', 'xelnag@jabber.ru', 0),
		129	(8, 'Yamah', './img/avatar/yamah.png', '—', 0);
2	diffor	130
		131	-- --------------------------------------------------------
		132
5	diffor	133	--
2	diffor	134	-- Структура таблицы `networks`
5	diffor	135	--
2	diffor	136
		137	CREATE TABLE IF NOT EXISTS `networks` (
36	diffor	138	`id` INT(2) NOT NULL AUTO_INCREMENT,
		139	`network` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
		140	`link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		141	PRIMARY KEY (`id`)
14	diffor	142	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
2	diffor	143
5	diffor	144	--
2	diffor	145	-- Дамп данных таблицы `networks`
5	diffor	146	--
2	diffor	147
5	diffor	148	INSERT INTO `networks` (`id`, `network`, `link`) VALUES
2	diffor	149	(1, 'Глоб', ''),
		150	(2, 'Интелби', 'http://www.intelbi.ru/'),
		151	(3, 'Интелека', 'http://www.inteleca.ru/'),
		152	(4, 'АГУ', 'http://www.asu.ru/'),
14	diffor	153	(5, 'АлтГПА', 'http://www.uni-altai.ru/'),
		154	(6, 'АлтГТУ', 'http://www.altstu.ru/'),
		155	(7, 'Webstream', 'http://www.wstream.ru/');
2	diffor	156
		157	-- --------------------------------------------------------
		158
5	diffor	159	--
		160	-- Структура таблицы `resources`
		161	--
		162
		163	CREATE TABLE IF NOT EXISTS `resources` (
36	diffor	164	`id` INT(2) NOT NULL AUTO_INCREMENT,
5	diffor	165	`category_id` INT(2) NOT NULL,
36	diffor	166	`resource` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
		167	`picture` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
25	diffor	168	`member_id` INT(2) NOT NULL,
36	diffor	169	`link_talk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		170	`link_res` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		171	`description` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
		172	`custom` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
		173	PRIMARY KEY (`id`),
25	diffor	174	KEY `category_id` (`category_id`),
		175	KEY `curator` (`member_id`)
7	diffor	176	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
5	diffor	177
		178	--
		179	-- Дамп данных таблицы `resources`
		180	--
		181
25	diffor	182	INSERT INTO `resources` (`id`, `category_id`, `resource`, `picture`, `member_id`, `link_talk`, `link_res`, `description`, `custom`) VALUES
		183	(1, 1, 'ftp', './img/logo/ftp.png', 3, 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846', 'ftp://ftp.nix-files.org.ru', Работает на WebSVN 2.3.3 и Subversion 1.8.10 ✓ XHTML & CSS

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

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