3,7 → 3,7 |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
-- Время создания: Окт 14 2009 г., 17:09 |
-- Время создания: Окт 16 2009 г., 19:12 |
-- Версия сервера: 5.1.37 |
-- Версия PHP: 5.2.11-1 |
|
111,50 → 111,6 |
-- -------------------------------------------------------- |
|
-- |
-- Структура таблицы `g_host2net` |
-- |
|
DROP TABLE IF EXISTS `g_host2net`; |
CREATE TABLE IF NOT EXISTS `g_host2net` ( |
`id` int(5) NOT NULL AUTO_INCREMENT, |
`rhost_id` int(3) NOT NULL, |
`nb_id` int(2) NOT NULL, |
PRIMARY KEY (`id`), |
KEY `rhost_id` (`rhost_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts into network block' AUTO_INCREMENT=3 ; |
|
-- |
-- Дамп данных таблицы `g_host2net` |
-- |
|
INSERT INTO `g_host2net` (`id`, `rhost_id`, `nb_id`) VALUES |
(1, 1, 1), |
(2, 2, 1); |
|
-- -------------------------------------------------------- |
|
-- |
-- Структура таблицы `g_netblock` |
-- |
|
DROP TABLE IF EXISTS `g_netblock`; |
CREATE TABLE IF NOT EXISTS `g_netblock` ( |
`nb_id` int(2) NOT NULL AUTO_INCREMENT, |
`netblock` varchar(25) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`nb_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Network blocks' AUTO_INCREMENT=3 ; |
|
-- |
-- Дамп данных таблицы `g_netblock` |
-- |
|
INSERT INTO `g_netblock` (`nb_id`, `netblock`) VALUES |
(1, 'AltLUG'), |
(2, 'SibNET'); |
|
-- -------------------------------------------------------- |
|
-- |
-- Структура таблицы `g_protos` |
-- |
|
204,7 → 160,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=3 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ; |
|
-- |
-- Дамп данных таблицы `g_rephost` |
212,7 → 168,8 |
|
INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES |
(1, 'apt.nix-files.org.ru'), |
(2, 'hyperion.uni-altai.ru'); |
(2, 'hyperion.uni-altai.ru'), |
(3, 'apt.nix-files.uni-altai.ru'); |
|
-- -------------------------------------------------------- |
|
229,6 → 186,7 |
`version` int(5) NOT NULL, |
`rtype_id` int(2) NOT NULL, |
`scheme_id` int(2) 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, |
PRIMARY KEY (`rep_id`), |
238,12 → 196,14 |
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=1 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ; |
|
-- |
-- Дамп данных таблицы `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', ''); |
|
-- -------------------------------------------------------- |
|
309,12 → 269,16 |
`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=1 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ; |
|
-- |
-- Дамп данных таблицы `g_sect2rep` |
-- |
|
INSERT INTO `g_sect2rep` (`id`, `sect_id`, `rep_id`) VALUES |
(1, 1, 1), |
(2, 2, 1), |
(3, 3, 1); |
|
-- -------------------------------------------------------- |
|