3,7 → 3,7 |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
-- Время создания: Окт 14 2009 г., 17:08 |
-- Время создания: Окт 16 2009 г., 19:12 |
-- Версия сервера: 5.1.37 |
-- Версия PHP: 5.2.11-1 |
|
82,34 → 82,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_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_protos` |
-- |
|
147,7 → 119,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 ; |
|
-- -------------------------------------------------------- |
|
164,6 → 136,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`), |
173,7 → 146,7 |
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 ; |
|
-- -------------------------------------------------------- |
|
215,7 → 188,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=1 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ; |
|
-- -------------------------------------------------------- |
|