WebSVN - www_nix-files - Различия - Редакция 7 и 10


-- phpMyAdmin SQL Dump
-- version 3.2.1deb1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Авг 31 2009 г., 23:35
-- Версия сервера: 5.1.37
-- Версия PHP: 5.2.10-2ubuntu2

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=8 ;

--
-- Дамп данных таблицы `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/', '');

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

--
-- Структура таблицы `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=6 ;

--
-- Дамп данных таблицы `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/');

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

--
-- Структура таблицы `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`
--

INSERT INTO `res_mem_rank` (`id`, `resource_id`, `network_id`, `member_id`, `rank_id`) VALUES
(1, 1, 2, 3, 1),
(2, 1, 3, 3, 1),
(3, 1, 5, 4, 0),
(4, 2, 2, 2, 0),
(5, 2, 3, 3, 0),
(6, 2, 5, 2, 0),
(7, 3, 1, 5, 0),
(8, 3, 2, 5, 0),
(9, 3, 3, 5, 0),
(15, 5, 2, 4, 0),
(11, 4, 1, 5, 0),
(12, 4, 2, 5, 0),
(13, 4, 3, 5, 0),
(14, 4, 5, 5, 0),
(16, 3, 5, 5, 0),
(17, 5, 3, 4, 0),
(18, 5, 5, 4, 0),
(19, 6, 2, 8, 0),
(20, 6, 3, 8, 0),
(21, 6, 5, 8, 0),
(22, 7, 2, 4, 0),
(23, 7, 3, 4, 0),
(24, 7, 5, 4, 0),
(25, 8, 2, 4, 0),
(26, 8, 3, 4, 0),
(27, 8, 5, 4, 0),
(28, 9, 2, 4, 0),
(29, 9, 3, 4, 0),
(30, 9, 5, 2, 0),
(31, 10, 1, 1, 0),
(32, 10, 2, 1, 0),
(33, 10, 3, 1, 0),
(34, 10, 5, 1, 0),
(35, 11, 1, 1, 0),
(36, 11, 2, 1, 0),
(37, 11, 3, 1, 0),
(38, 11, 5, 1, 0);

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

--
-- Структура таблицы `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=37 ;

--
-- Дамп данных таблицы `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, 3),
(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);
 

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

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

(root)/trunk/db/nix-files.sql @ 36 - Редакция 7 → 10