3,7 → 3,7 |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
-- Время создания: Авг 31 2009 г., 23:35 |
-- Время создания: Авг 31 2009 г., 23:53 |
-- Версия сервера: 5.1.37 |
-- Версия PHP: 5.2.10-2ubuntu2 |
|
32,7 → 32,7 |
`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 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ; |
|
-- |
-- Дамп данных таблицы `apt_mirrors` |
45,7 → 45,16 |
(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/', ''); |
(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', '', ''); |
|
-- -------------------------------------------------------- |
|
202,104 → 211,3 |
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); |