WebSVN - www_nix-files - Различия - Редакция 12 и 14


-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5+lenny1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Сен 27 2009 г., 10:40
-- Версия сервера: 5.0.51
-- Версия PHP: 5.2.6-1+lenny3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- База данных: `nix-files`
--

-- --------------------------------------------------------

--
-- Структура таблицы `apt_mirrors`
--

DROP TABLE IF EXISTS `apt_mirrors`;
CREATE TABLE IF NOT EXISTS `apt_mirrors` (
  `id` INT(5) NOT NULL AUTO_INCREMENT,
  `src_name` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  `src_url` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  `desk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ;

--
-- Дамп данных таблицы `apt_mirrors`
--

INSERT INTO `apt_mirrors` (`id`, `src_name`, `src_url`, `desk`) VALUES
(1, 'debian', 'ftp://ftp.us.debian.org/debian', ''),
(2, 'debian-security', 'ftp://security.debian.org/debian-security', ''),
(3, 'debian-multimedia', 'http://www.debian-multimedia.org', ''),
(4, 'ubuntu', 'http://archive.ubuntu.com/ubuntu', ''),
(5, 'ubuntu-security', 'http://security.ubuntu.com/ubuntu', ''),
(6, 'ubuntu-canonical', 'http://archive.canonical.com', ''),
(7, 'medibuntu', 'http://packages.medibuntu.org/', ''),
(8, 'infralinux', 'http://archive.infralinux.org/infralinux/', ''),
(9, '2gis', 'http://packages.redsolution.ru/2gis', ''),
(10, 'opera', 'http://deb.opera.com/opera/', ''),
(11, 'virtualbox', 'http://download.virtualbox.org/virtualbox/debian', ''),
(12, 'opera-beta', 'http://deb.opera.com/opera-beta/', ''),
(13, 'playonlinux', '', ''),
(14, 'freenx', '', ''),
(15, 'wesnoth', '', ''),
(16, 'xneur', '', '');

-- --------------------------------------------------------

--
-- Структура таблицы `categories`
--

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `id` INT(2) NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Дамп данных таблицы `categories`
--

INSERT INTO `categories` (`id`, `category`) VALUES
(1, 'file'),
(2, 'repo'),
(3, 'info'),
(4, 'misc');

-- --------------------------------------------------------

--
-- Структура таблицы `details`
--

DROP TABLE IF EXISTS `details`;
CREATE TABLE IF NOT EXISTS `details` (
  `id` INT(2) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  `talklink` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `resource_id` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Дамп данных таблицы `details`
--

INSERT INTO `details` (`id`, `title`, `description`, `link`, `talklink`) VALUES
(1, 'ftp.niX-FILES', 'Файлопомойко', 'ftp://ftp.nix-files.org.ru', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846');

-- --------------------------------------------------------

--
-- Структура таблицы `members`
--

DROP TABLE IF EXISTS `members`;
CREATE TABLE IF NOT EXISTS `members` (
  `id` INT(2) NOT NULL AUTO_INCREMENT,
  `nick` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  `avatar` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  `jabber` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  `icq` INT(15) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

--
-- Дамп данных таблицы `members`
--

INSERT INTO `members` (`id`, `nick`, `avatar`, `jabber`, `icq`) VALUES
(1, 'Diffor', './img/avatar/diffor.jpg', 'diffor@jabber.ru', 0),
(2, 'firstleon', './img/avatar/firstleon.jpg', 'first-leon@jabber.ru', 0),
(3, 'SlipKnoT8', './img/avatar/slipknot8.gif', 'slipknot888@jabber.ru', 0),
(4, 'mistiman', './img/avatar/mistiman.png', '', 0),
(5, 'IK', './img/avatar/ik.jpg', '', 0),
(7, 'SP|Scream', './img/avatar/spscream.png', '', 0),
(8, 'Yamah', './img/avatar/yamah.png', '', 0);

-- --------------------------------------------------------

--
-- Структура таблицы `networks`
--

DROP TABLE IF EXISTS `networks`;
CREATE TABLE IF NOT EXISTS `networks` (
  `id` INT(2) NOT NULL AUTO_INCREMENT,
  `network` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
  `link` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Дамп данных таблицы `networks`
--

INSERT INTO `networks` (`id`, `network`, `link`) VALUES
(1, 'Глоб', ''),
(2, 'Интелби', 'http://www.intelbi.ru/'),
(3, 'Интелека', 'http://www.inteleca.ru/'),
(4, 'АГУ', 'http://www.asu.ru/'),
(5, 'АлтГПА', 'http://www.uni-altai.ru/'),
(6, 'АлтГТУ', 'http://www.altstu.ru/'),
(7, 'Webstream', 'http://www.wstream.ru/');

-- --------------------------------------------------------

--
-- Структура таблицы `resources`
--

DROP TABLE IF EXISTS `resources`;
CREATE TABLE IF NOT EXISTS `resources` (
  `id` INT(2) NOT NULL AUTO_INCREMENT,
  `category_id` INT(2) NOT NULL,
  `resource` VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL,
  `picture` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  `link_talk` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  `link_res` VARCHAR(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

--
-- Дамп данных таблицы `resources`
--

INSERT INTO `resources` (`id`, `category_id`, `resource`, `picture`, `link_talk`, `link_res`) VALUES
(1, 1, 'ftp', './img/logo/ftp.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1846', 'ftp://ftp.nix-files.org.ru'),
(2, 2, 'apt', './img/logo/debian.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1370', 'http://apt.nix-files.org.ru'),
(3, 3, 'dicts', './img/logo/kdict.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1432', 'http://dicts.nix-files.org.ru'),
(4, 3, 'mans', './img/logo/khelpcenter.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1449', 'http://mans.nix-files.org.ru'),
(5, 2, 'gentoo', './img/logo/gentoo.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1860', 'http://gentoo.nix-files.org.ru'),
(6, 2, 'mandriva', './img/logo/mandrake.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2005', 'http://mandriva.nix-files.org.ru'),
(7, 2, 'arch', './img/logo/archlinux.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1884', 'http://arch.nix-files.org.ru'),
(8, 2, 'alt', './img/logo/altlinux.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=2009', 'http://alt.nix-files.org.ru'),
(9, 2, 'freebsd', './img/logo/freebsd.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1990', 'http://freebsd.nix-files.org.ru'),
(10, 4, 'www', './img/logo/www.png', 'http://altlug.ru/phpbb/viewtopic.php?f=37&t=1858', 'http://www.nix-files.org.ru'),
(11, 4, 'fail', './img/logo/fail.png', '', 'http://fail.nix-files.org.ru');

-- --------------------------------------------------------

--
-- Структура таблицы `res_mem_rank`
--

DROP TABLE IF EXISTS `res_mem_rank`;
CREATE TABLE IF NOT EXISTS `res_mem_rank` (
  `id` INT(5) NOT NULL AUTO_INCREMENT,
  `resource_id` INT(2) NOT NULL,
  `network_id` INT(2) NOT NULL,
  `member_id` INT(2) NOT NULL,
  `rank_id` INT(2) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `resource_id` (`rank_id`),
  KEY `member_id` (`member_id`),
  KEY `network_id` (`network_id`),
  KEY `resource_id_2` (`resource_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;

--
-- Дамп данных таблицы `res_mem_rank`
--


-- --------------------------------------------------------

--
-- Структура таблицы `res_net_stat`
--

DROP TABLE IF EXISTS `res_net_stat`;
CREATE TABLE IF NOT EXISTS `res_net_stat` (
  `id` INT(5) NOT NULL AUTO_INCREMENT,
  `resource_id` INT(2) NOT NULL,
  `network_id` INT(2) NOT NULL,
  `state_id` INT(2) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `resource_id` (`resource_id`,`network_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=47 ;

--
-- Дамп данных таблицы `res_net_stat`
--

INSERT INTO `res_net_stat` (`id`, `resource_id`, `network_id`, `state_id`) VALUES
(1, 1, 2, 1),
(2, 1, 3, 1),
(3, 1, 4, 4),
(4, 1, 5, 3),
(5, 2, 2, 2),
(6, 2, 3, 2),
(7, 2, 4, 4),
(8, 2, 5, 1),
(9, 3, 1, 1),
(10, 3, 2, 1),
(11, 3, 3, 2),
(12, 3, 5, 3),
(13, 4, 1, 1),
(14, 4, 2, 1),
(15, 4, 3, 2),
(16, 4, 5, 3),
(17, 5, 2, 1),
(18, 5, 3, 1),
(19, 5, 5, 2),
(20, 6, 2, 1),
(21, 6, 3, 1),
(22, 6, 5, 3),
(23, 7, 2, 1),
(24, 7, 3, 1),
(25, 7, 5, 3),
(26, 8, 2, 1),
(27, 8, 3, 1),
(28, 8, 5, 3),
(29, 9, 2, 1),
(30, 9, 3, 1),
(31, 9, 5, 2),
(32, 10, 1, 1),
(33, 10, 2, 1),
(34, 10, 3, 2),
(35, 10, 5, 3),
(36, 11, 1, 1),
(37, 10, 7, 3),
(38, 3, 7, 3),
(39, 4, 7, 3),
(40, 1, 7, 3),
(41, 2, 7, 3),
(42, 5, 7, 3),
(43, 6, 7, 3),
(44, 7, 7, 3),
(45, 8, 7, 3),
(46, 9, 7, 3);

-- --------------------------------------------------------

--
-- Структура таблицы `states`
--

DROP TABLE IF EXISTS `states`;
CREATE TABLE IF NOT EXISTS `states` (
  `id` INT(3) NOT NULL AUTO_INCREMENT,
  `image` VARCHAR(50) NOT NULL,
  `description` VARCHAR(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Дамп данных таблицы `states`
--

INSERT INTO `states` (`id`, `image`, `description`) VALUES
(1, './img/state/main.png', 'Основной ресурс'),
(2, './img/state/mirror.png', 'Зеркало ресурса'),
(3, './img/state/access.png', 'Свободный высокоскоростной доступ'),
(4, './img/state/freeze.png', 'Временно недоступен');
 

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

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

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