3,7 → 3,7 |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
-- Время создания: Ноя 26 2009 г., 13:46 |
-- Время создания: Ноя 30 2009 г., 14:09 |
-- Версия сервера: 5.1.37 |
-- Версия PHP: 5.2.11-1 |
|
25,6 → 25,7 |
-- Структура таблицы `g_arch` |
-- |
|
DROP TABLE IF EXISTS `g_arch`; |
CREATE TABLE IF NOT EXISTS `g_arch` ( |
`arch_id` int(2) NOT NULL AUTO_INCREMENT, |
`arch` varchar(10) COLLATE utf8_unicode_ci NOT NULL, |
38,6 → 39,7 |
-- Структура таблицы `g_arch2rep` |
-- |
|
DROP TABLE IF EXISTS `g_arch2rep`; |
CREATE TABLE IF NOT EXISTS `g_arch2rep` ( |
`id` int(5) NOT NULL AUTO_INCREMENT, |
`arch_id` int(2) NOT NULL, |
44,7 → 46,7 |
`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 ; |
|
-- -------------------------------------------------------- |
|
52,6 → 54,7 |
-- Структура таблицы `g_distribution` |
-- |
|
DROP TABLE IF EXISTS `g_distribution`; |
CREATE TABLE IF NOT EXISTS `g_distribution` ( |
`dist_id` int(5) NOT NULL AUTO_INCREMENT, |
`distname` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
60,7 → 63,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 ; |
|
-- -------------------------------------------------------- |
|
68,6 → 71,7 |
-- Структура таблицы `g_dtype` |
-- |
|
DROP TABLE IF EXISTS `g_dtype`; |
CREATE TABLE IF NOT EXISTS `g_dtype` ( |
`type_id` int(1) NOT NULL AUTO_INCREMENT, |
`type` varchar(3) COLLATE utf8_unicode_ci NOT NULL, |
81,6 → 85,7 |
-- Структура таблицы `g_protos` |
-- |
|
DROP TABLE IF EXISTS `g_protos`; |
CREATE TABLE IF NOT EXISTS `g_protos` ( |
`proto_id` int(1) NOT NULL AUTO_INCREMENT, |
`proto` varchar(10) COLLATE utf8_unicode_ci NOT NULL, |
94,12 → 99,13 |
-- Структура таблицы `g_repfolder` |
-- |
|
DROP TABLE IF EXISTS `g_repfolder`; |
CREATE TABLE IF NOT EXISTS `g_repfolder` ( |
`rfolder_id` int(5) NOT NULL AUTO_INCREMENT, |
`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 ; |
|
-- -------------------------------------------------------- |
|
107,12 → 113,13 |
-- Структура таблицы `g_rephost` |
-- |
|
DROP TABLE IF EXISTS `g_rephost`; |
CREATE TABLE IF NOT EXISTS `g_rephost` ( |
`rhost_id` int(3) NOT NULL AUTO_INCREMENT, |
`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 ; |
|
-- -------------------------------------------------------- |
|
120,6 → 127,7 |
-- Структура таблицы `g_repository` |
-- |
|
DROP TABLE IF EXISTS `g_repository`; |
CREATE TABLE IF NOT EXISTS `g_repository` ( |
`rep_id` int(5) NOT NULL AUTO_INCREMENT, |
`proto_id` int(1) NOT NULL, |
128,9 → 136,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`), |
137,8 → 146,9 |
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 ; |
|
-- -------------------------------------------------------- |
|
146,12 → 156,13 |
-- Структура таблицы `g_repscheme` |
-- |
|
DROP TABLE IF EXISTS `g_repscheme`; |
CREATE TABLE IF NOT EXISTS `g_repscheme` ( |
`scheme_id` int(2) NOT NULL AUTO_INCREMENT, |
`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 ; |
|
-- -------------------------------------------------------- |
|
159,6 → 170,7 |
-- Структура таблицы `g_rtype` |
-- |
|
DROP TABLE IF EXISTS `g_rtype`; |
CREATE TABLE IF NOT EXISTS `g_rtype` ( |
`rtype_id` int(2) NOT NULL AUTO_INCREMENT, |
`rtype` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
171,6 → 183,7 |
-- Структура таблицы `g_sect2rep` |
-- |
|
DROP TABLE IF EXISTS `g_sect2rep`; |
CREATE TABLE IF NOT EXISTS `g_sect2rep` ( |
`id` int(5) NOT NULL AUTO_INCREMENT, |
`sect_id` int(2) NOT NULL, |
177,7 → 190,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 ; |
|
-- -------------------------------------------------------- |
|
185,6 → 198,7 |
-- Структура таблицы `g_section` |
-- |
|
DROP TABLE IF EXISTS `g_section`; |
CREATE TABLE IF NOT EXISTS `g_section` ( |
`sect_id` int(2) NOT NULL AUTO_INCREMENT, |
`secname` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
199,6 → 213,7 |
-- Структура таблицы `g_settings` |
-- |
|
DROP TABLE IF EXISTS `g_settings`; |
CREATE TABLE IF NOT EXISTS `g_settings` ( |
`opt_id` int(2) NOT NULL AUTO_INCREMENT, |
`opt` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
213,6 → 228,7 |
-- Структура таблицы `g_signs` |
-- |
|
DROP TABLE IF EXISTS `g_signs`; |
CREATE TABLE IF NOT EXISTS `g_signs` ( |
`sign_id` int(3) NOT NULL AUTO_INCREMENT, |
`sname` varchar(25) NOT NULL, |
226,6 → 242,7 |
-- Структура таблицы `g_version` |
-- |
|
DROP TABLE IF EXISTS `g_version`; |
CREATE TABLE IF NOT EXISTS `g_version` ( |
`version_id` int(5) NOT NULL AUTO_INCREMENT, |
`dist_id` int(5) NOT NULL, |
234,4 → 251,4 |
`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 ; |