3,7 → 3,7 |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
-- Время создания: Ноя 26 2009 г., 13:47 |
-- Время создания: Ноя 30 2009 г., 14:09 |
-- Версия сервера: 5.1.37 |
-- Версия PHP: 5.2.11-1 |
|
54,12 → 54,67 |
`rep_id` int(5) NOT NULL, |
PRIMARY KEY (`id`), |
KEY `arch_id` (`arch_id`,`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=1 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=103 ; |
|
-- |
-- Дамп данных таблицы `g_arch2rep` |
-- |
|
INSERT INTO `g_arch2rep` (`id`, `arch_id`, `rep_id`) VALUES |
(82, 2, 8), |
(81, 1, 8), |
(30, 2, 7), |
(29, 1, 7), |
(28, 2, 6), |
(27, 1, 6), |
(62, 2, 5), |
(61, 1, 5), |
(9, 1, 2), |
(10, 2, 2), |
(11, 1, 3), |
(12, 2, 3), |
(13, 1, 4), |
(14, 2, 4), |
(84, 2, 9), |
(83, 1, 9), |
(92, 2, 10), |
(91, 1, 10), |
(86, 2, 11), |
(85, 1, 11), |
(43, 1, 12), |
(44, 2, 12), |
(45, 1, 13), |
(46, 2, 13), |
(88, 2, 14), |
(87, 1, 14), |
(49, 1, 15), |
(50, 2, 15), |
(90, 2, 16), |
(89, 1, 16), |
(53, 1, 17), |
(54, 2, 17), |
(94, 2, 18), |
(93, 1, 18), |
(96, 2, 19), |
(95, 1, 19), |
(59, 1, 20), |
(60, 2, 20), |
(63, 1, 21), |
(64, 2, 21), |
(69, 1, 22), |
(70, 2, 22), |
(78, 2, 23), |
(77, 1, 23), |
(73, 1, 24), |
(74, 2, 24), |
(75, 1, 25), |
(76, 2, 25), |
(79, 1, 26), |
(80, 2, 26), |
(97, 1, 27), |
(98, 2, 27), |
(102, 2, 28), |
(101, 1, 28); |
|
-- -------------------------------------------------------- |
|
76,7 → 131,7 |
`distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`dist_id`), |
KEY `disttype` (`disttype`,`distlogo`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=6 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=7 ; |
|
-- |
-- Дамп данных таблицы `g_distribution` |
85,7 → 140,8 |
INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES |
(1, 'Debian GNU/Linux', 'debian', 1, '1'), |
(2, 'Ubuntu Linux', 'ubuntu', 1, '0'), |
(5, 'ALTLinux', 'altlinux', 2, '0'); |
(5, 'ALTLinux', 'altlinux', 2, '0'), |
(6, 'InfraLinux', 'infralinux', 1, '0'); |
|
-- -------------------------------------------------------- |
|
142,12 → 198,35 |
`rfolder` varchar(100) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`rfolder_id`), |
KEY `rhost_id` (`rfolder`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=1 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=23 ; |
|
-- |
-- Дамп данных таблицы `g_repfolder` |
-- |
|
INSERT INTO `g_repfolder` (`rfolder_id`, `rfolder`) VALUES |
(1, '/debian'), |
(2, '/debian-backports'), |
(3, '/debian-multimedia'), |
(4, '/opera-beta'), |
(5, '/opera'), |
(6, '/debian-security'), |
(7, '/debian-volatile'), |
(8, '/debian-winehq'), |
(9, '/gfoss'), |
(10, '/2gis'), |
(11, '/freenx'), |
(12, '/virtualbox'), |
(13, '/ubuntu'), |
(14, '/playonlinux'), |
(15, '/xneur'), |
(16, '/ubuntu-winehq'), |
(17, '/ubuntu-commercial'), |
(18, '/infralinux'), |
(19, '/sarge-backports'), |
(20, '/sarge-proposed-updates'), |
(21, '/sarge'), |
(22, '/p5/branch'); |
|
-- -------------------------------------------------------- |
|
161,7 → 240,7 |
`rhost` varchar(150) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`rhost_id`), |
KEY `proto_id` (`rhost`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=8 ; |
|
-- |
-- Дамп данных таблицы `g_rephost` |
170,7 → 249,8 |
INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES |
(1, 'apt.nix-files.org.ru'), |
(2, 'hyperion.uni-altai.ru'), |
(3, 'apt.nix-files.uni-altai.ru'); |
(3, 'apt.nix-files.uni-altai.ru'), |
(7, 'alt.nix-files.org.ru'); |
|
-- -------------------------------------------------------- |
|
187,9 → 267,10 |
`version` int(5) NOT NULL, |
`rtype_id` int(2) NOT NULL, |
`scheme_id` int(2) NOT NULL, |
`sign_id` int(3) NOT NULL, |
`repname` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
`repinfo` text COLLATE utf8_unicode_ci NOT NULL, |
`repkey` varchar(20) COLLATE utf8_unicode_ci NOT NULL, |
`repkey` varchar(200) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`rep_id`), |
KEY `proto_id` (`proto_id`), |
KEY `rhost_id` (`rhost_id`), |
196,15 → 277,42 |
KEY `rfolder_id` (`rfolder_id`), |
KEY `version` (`version`), |
KEY `rtype_id` (`rtype_id`), |
KEY `scheme_id` (`scheme_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ; |
KEY `scheme_id` (`scheme_id`), |
KEY `sign_id` (`sign_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=29 ; |
|
-- |
-- Дамп данных таблицы `g_repository` |
-- |
|
INSERT INTO `g_repository` (`rep_id`, `proto_id`, `rhost_id`, `rfolder_id`, `version`, `rtype_id`, `scheme_id`, `repname`, `repinfo`, `repkey`) VALUES |
(1, 1, 1, 1, 1, 1, 1, 'Sarge Base', 'eeee', ''); |
INSERT INTO `g_repository` (`rep_id`, `proto_id`, `rhost_id`, `rfolder_id`, `version`, `rtype_id`, `scheme_id`, `sign_id`, `repname`, `repinfo`, `repkey`) VALUES |
(5, 1, 1, 21, 1, 1, 1, 0, 'Sarge Base', 'Базовый репозиторий для sarge', ''), |
(2, 1, 1, 1, 2, 1, 1, 0, 'Etch Base', 'Основной репозиторий для etch', ''), |
(3, 1, 1, 2, 2, 2, 6, 0, 'Etch Backports', 'Бэкпортированный софт для etch', ''), |
(4, 1, 1, 12, 2, 3, 1, 0, 'VirtualBox', 'Sun VirtualBox', ''), |
(6, 1, 2, 1, 3, 3, 1, 0, 'Hyperion', 'Неофициальный репозиторий АлтГПА и AltLUG\\''а', 'wget -O - http://hyperion.uni-altai.ru/hyperion.key | apt-key add -'), |
(7, 1, 2, 1, 4, 3, 1, 0, 'Hyperion', 'Неофициальный репозиторий АлтГПА и AltLUG\\''а', 'wget -O - http://hyperion.uni-altai.ru/hyperion.key | apt-key add -'), |
(8, 1, 1, 1, 3, 1, 1, 0, 'Lenny Base', 'Базовый репозиторий Lenny', 'apt-get install debian-keyring'), |
(9, 1, 1, 6, 3, 2, 3, 0, 'Security', 'Обновления безопасности', 'apt-get install debian-keyring'), |
(10, 1, 1, 2, 3, 2, 6, 0, 'Backports', 'Бэкпортированное ПО для Lenny', 'apt-get install debian-backports-keyring'), |
(11, 1, 1, 7, 3, 2, 4, 0, 'Volatile', 'Непостоянные обновления для Lenny', 'apt-get install debian-keyring'), |
(12, 1, 1, 13, 7, 1, 1, 0, 'Jaunty Base', 'Базовый репозиторий Jaunty Jackalope', ''), |
(13, 1, 1, 1, 13, 1, 1, 0, 'Sid Base', 'Базовый репозиторий', ''), |
(14, 1, 1, 1, 3, 2, 2, 0, 'Updates', 'Предлагаемые обновления', 'apt-get install debian-keyring'), |
(15, 1, 1, 3, 3, 3, 1, 0, 'Multimedia', 'Мультимедийное ПО и набор кодеков', ''), |
(16, 1, 1, 7, 3, 2, 5, 0, 'Volatile-sloppy', 'Непостоянные обновления для Lenny', 'apt-get install debian-keyring'), |
(17, 1, 1, 8, 3, 3, 1, 0, 'WineHQ', 'Репозиторий с WineHQ', ''), |
(18, 1, 1, 5, 3, 3, 1, 0, 'Opera', 'Репозиторий с браузером Opera', 'wget -O - http://deb.opera.com/archive.key | apt-key add -'), |
(19, 1, 1, 4, 3, 3, 1, 0, 'Opera Beta', 'Репозиторий с бета-версиями браузера Opera', 'wget -O - http://deb.opera.com/archive.key | apt-key add -'), |
(20, 1, 1, 9, 3, 3, 1, 0, 'gfoss', 'Репозиторий с ГИС', ''), |
(21, 1, 1, 10, 3, 3, 1, 0, '2GIS', 'Репозиторий с 2GIS', ''), |
(22, 1, 1, 18, 14, 1, 1, 0, 'InfraLinux 8.10 Base', 'базовый репозиторий', ''), |
(23, 1, 1, 18, 14, 2, 8, 0, 'Security', 'Обновления безопасности', ''), |
(24, 1, 1, 18, 14, 2, 7, 0, 'Updates', 'Предлагаемые обновления', ''), |
(25, 1, 1, 18, 14, 2, 6, 0, 'Backports', 'Официально неподдерживаемые обновления', ''), |
(26, 1, 1, 12, 3, 3, 1, 0, 'VirtualBox', 'Репозиторий с Sun Microsystems VirtualBox', ''), |
(27, 1, 7, 22, 12, 1, 11, 2, 'Master Base', 'Базовый репозиторий', ''), |
(28, 1, 7, 22, 12, 2, 11, 3, 'Security', 'Обновления безопасности', ''); |
|
-- -------------------------------------------------------- |
|
218,7 → 326,7 |
`scheme` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`scheme_id`), |
KEY `scheme` (`scheme`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=9 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=13 ; |
|
-- |
-- Дамп данных таблицы `g_repscheme` |
232,7 → 340,11 |
(5, '{DIST}/volatile-sloppy'), |
(6, '{DIST}-backports'), |
(7, '{DIST}-updates'), |
(8, '{DIST}-security'); |
(8, '{DIST}-security'), |
(9, 'noarch'), |
(10, 'x86_64'), |
(11, 'i586'), |
(12, 'x86_32'); |
|
-- -------------------------------------------------------- |
|
270,7 → 382,7 |
`rep_id` int(5) NOT NULL, |
PRIMARY KEY (`id`), |
KEY `sect_id` (`sect_id`,`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=137 ; |
|
-- |
-- Дамп данных таблицы `g_sect2rep` |
277,9 → 389,72 |
-- |
|
INSERT INTO `g_sect2rep` (`id`, `sect_id`, `rep_id`) VALUES |
(1, 1, 1), |
(2, 2, 1), |
(3, 3, 1); |
(119, 3, 9), |
(118, 2, 9), |
(117, 1, 9), |
(116, 3, 8), |
(115, 2, 8), |
(114, 1, 8), |
(46, 10, 7), |
(45, 9, 7), |
(44, 8, 7), |
(43, 8, 6), |
(42, 9, 6), |
(41, 10, 6), |
(85, 3, 5), |
(84, 2, 5), |
(83, 1, 5), |
(16, 1, 2), |
(17, 2, 2), |
(18, 3, 2), |
(19, 1, 3), |
(20, 2, 3), |
(21, 3, 3), |
(22, 3, 4), |
(131, 3, 10), |
(130, 2, 10), |
(129, 1, 10), |
(122, 3, 11), |
(121, 2, 11), |
(120, 1, 11), |
(65, 1, 12), |
(66, 4, 12), |
(67, 5, 12), |
(68, 6, 12), |
(69, 1, 13), |
(70, 2, 13), |
(71, 3, 13), |
(125, 3, 14), |
(124, 2, 14), |
(123, 1, 14), |
(75, 1, 15), |
(128, 3, 16), |
(127, 2, 16), |
(126, 1, 16), |
(79, 1, 17), |
(132, 3, 18), |
(133, 3, 19), |
(82, 1, 20), |
(86, 3, 21), |
(93, 1, 22), |
(94, 4, 22), |
(95, 5, 22), |
(96, 6, 22), |
(112, 6, 23), |
(111, 5, 23), |
(110, 4, 23), |
(109, 1, 23), |
(101, 1, 24), |
(102, 4, 24), |
(103, 5, 24), |
(104, 6, 24), |
(105, 1, 25), |
(106, 4, 25), |
(107, 5, 25), |
(108, 6, 25), |
(113, 1, 26), |
(134, 11, 27), |
(136, 13, 28); |
|
-- -------------------------------------------------------- |
|
304,9 → 479,9 |
(1, 'main', 'раздел со свободными пакетами'), |
(2, 'contrib', 'раздел со свободными пакетами, зависимыми от несвободных'), |
(3, 'non-free', 'раздел с несвободными пакетами'), |
(4, 'restricted', ''), |
(5, 'universe', ''), |
(6, 'multiverse', ''), |
(4, 'restricted', 'поддерживаемое ПО доступное под не полностью свободными лицензиями'), |
(5, 'universe', 'поддерживемое сообществом ПО'), |
(6, 'multiverse', 'несвободное ПО'), |
(7, 'partner', ''), |
(8, 'unofficial', 'раздел с неофициальными пакетами'), |
(9, 'astro', 'раздел с пакетами астрономических программ'), |
381,7 → 556,7 |
`vcodename` varchar(10) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`version_id`), |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=13 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=17 ; |
|
-- |
-- Дамп данных таблицы `g_version` |
397,4 → 572,8 |
(7, 2, 'Jaunty Jackalope', '9.04', 'jaunty'), |
(8, 2, 'Karmic Koala', '9.10', 'karmic'), |
(12, 5, 'Школьный Мастер', '5.0', 'master'), |
(11, 5, 'Ark', '5.0', 'ark'); |
(11, 5, 'Ark', '5.0', 'ark'), |
(13, 1, 'Sid', '', 'sid'), |
(14, 6, 'Intrepid Ibex', '8.10', 'intrepid'), |
(15, 6, 'Jaunty Jackalope', '9.04', 'jaunty'), |
(16, 6, 'Karmic Koala', '9.10', 'karmic'); |