3,9 → 3,9 |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
-- Время создания: Июн 02 2009 г., 15:57 |
-- Версия сервера: 5.0.51 |
-- Версия PHP: 5.2.6-1+lenny3 |
-- Время создания: Окт 13 2009 г., 21:41 |
-- Версия сервера: 5.1.37 |
-- Версия PHP: 5.2.11-1 |
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
|
25,10 → 25,11 |
-- Структура таблицы `arch` |
-- |
|
DROP TABLE IF EXISTS `arch`; |
CREATE TABLE IF NOT EXISTS `arch` ( |
`arch_id` int(2) NOT NULL auto_increment, |
`arch` varchar(10) default NULL, |
PRIMARY KEY (`arch_id`) |
`arch_id` int(2) NOT NULL AUTO_INCREMENT, |
`arch` varchar(10) DEFAULT NULL, |
PRIMARY KEY (`arch_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; |
|
-- |
45,11 → 46,12 |
-- Структура таблицы `arch2rep` |
-- |
|
DROP TABLE IF EXISTS `arch2rep`; |
CREATE TABLE IF NOT EXISTS `arch2rep` ( |
`id` int(11) NOT NULL auto_increment, |
`arch_id` int(2) default NULL, |
`rep_id` int(5) default NULL, |
PRIMARY KEY (`id`), |
`id` int(11) NOT NULL AUTO_INCREMENT, |
`arch_id` int(2) DEFAULT NULL, |
`rep_id` int(5) DEFAULT NULL, |
PRIMARY KEY (`id`), |
KEY `arch_id` (`arch_id`), |
KEY `rep_id` (`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
69,12 → 71,13 |
-- Структура таблицы `changelog` |
-- |
|
DROP TABLE IF EXISTS `changelog`; |
CREATE TABLE IF NOT EXISTS `changelog` ( |
`log_id` int(5) NOT NULL auto_increment, |
`log_id` int(5) NOT NULL AUTO_INCREMENT, |
`log_record` datetime NOT NULL, |
`log_title` varchar(35) NOT NULL, |
`log_desc` text NOT NULL, |
PRIMARY KEY (`log_id`) |
PRIMARY KEY (`log_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; |
|
-- |
93,13 → 96,14 |
-- Структура таблицы `distribution` |
-- |
|
DROP TABLE IF EXISTS `distribution`; |
CREATE TABLE IF NOT EXISTS `distribution` ( |
`dist_id` int(5) NOT NULL auto_increment, |
`distname` varchar(25) default NULL, |
`dist_id` int(5) NOT NULL AUTO_INCREMENT, |
`distname` varchar(25) DEFAULT NULL, |
`distua` varchar(50) NOT NULL, |
`disttype` int(1) NOT NULL, |
`distlogo` enum('0','1') NOT NULL, |
PRIMARY KEY (`dist_id`), |
PRIMARY KEY (`dist_id`), |
KEY `disttype` (`disttype`), |
KEY `distlogo` (`distlogo`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; |
119,10 → 123,11 |
-- Структура таблицы `dtype` |
-- |
|
DROP TABLE IF EXISTS `dtype`; |
CREATE TABLE IF NOT EXISTS `dtype` ( |
`type_id` int(1) NOT NULL auto_increment, |
`type` char(3) character set utf8 NOT NULL, |
PRIMARY KEY (`type_id`) |
`type_id` int(1) NOT NULL AUTO_INCREMENT, |
`type` char(3) CHARACTER SET utf8 NOT NULL, |
PRIMARY KEY (`type_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; |
|
-- |
139,11 → 144,12 |
-- Структура таблицы `interfaces` |
-- |
|
DROP TABLE IF EXISTS `interfaces`; |
CREATE TABLE IF NOT EXISTS `interfaces` ( |
`if_id` int(2) NOT NULL auto_increment, |
`if_id` int(2) NOT NULL AUTO_INCREMENT, |
`interface` varchar(25) NOT NULL, |
`interfaceinfo` varchar(100) NOT NULL, |
PRIMARY KEY (`if_id`) |
PRIMARY KEY (`if_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
|
-- |
161,12 → 167,13 |
-- Структура таблицы `mirror` |
-- |
|
DROP TABLE IF EXISTS `mirror`; |
CREATE TABLE IF NOT EXISTS `mirror` ( |
`mirror_id` int(5) NOT NULL auto_increment, |
`mname` varchar(50) default NULL, |
`mirror_id` int(5) NOT NULL AUTO_INCREMENT, |
`mname` varchar(50) DEFAULT NULL, |
`mproto` varchar(10) NOT NULL, |
`murl` varchar(50) default NULL, |
PRIMARY KEY (`mirror_id`) |
`murl` varchar(50) DEFAULT NULL, |
PRIMARY KEY (`mirror_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; |
|
-- |
183,14 → 190,15 |
-- Структура таблицы `origin` |
-- |
|
DROP TABLE IF EXISTS `origin`; |
CREATE TABLE IF NOT EXISTS `origin` ( |
`orig_id` int(5) NOT NULL auto_increment, |
`origin` varchar(30) default NULL, |
`orig_id` int(5) NOT NULL AUTO_INCREMENT, |
`origin` varchar(30) DEFAULT NULL, |
`desk` text NOT NULL, |
`basedir` varchar(50) NOT NULL, |
`homeurl` varchar(50) NOT NULL, |
`keyurl` varchar(50) NOT NULL, |
PRIMARY KEY (`orig_id`) |
PRIMARY KEY (`orig_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; |
|
-- |
216,11 → 224,12 |
-- Структура таблицы `owner` |
-- |
|
DROP TABLE IF EXISTS `owner`; |
CREATE TABLE IF NOT EXISTS `owner` ( |
`id` int(11) NOT NULL auto_increment, |
`login` char(32) default NULL, |
`passwd` char(32) default NULL, |
PRIMARY KEY (`id`) |
`id` int(11) NOT NULL AUTO_INCREMENT, |
`login` char(32) DEFAULT NULL, |
`passwd` char(32) DEFAULT NULL, |
PRIMARY KEY (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
|
-- |
236,9 → 245,10 |
-- Структура таблицы `repository` |
-- |
|
DROP TABLE IF EXISTS `repository`; |
CREATE TABLE IF NOT EXISTS `repository` ( |
`rep_id` int(5) NOT NULL auto_increment, |
`repname` varchar(20) default NULL, |
`rep_id` int(5) NOT NULL AUTO_INCREMENT, |
`repname` varchar(20) DEFAULT NULL, |
`repdescribe` text, |
`scheme_id` int(2) NOT NULL, |
`rtype_id` int(2) NOT NULL, |
245,7 → 255,7 |
`root_id` int(2) NOT NULL, |
`orig_id` int(5) NOT NULL, |
`defaultrep` tinyint(1) NOT NULL, |
PRIMARY KEY (`rep_id`), |
PRIMARY KEY (`rep_id`), |
KEY `scheme` (`scheme_id`), |
KEY `rtype_id` (`rtype_id`), |
KEY `root_id` (`root_id`), |
313,10 → 323,11 |
-- Структура таблицы `root` |
-- |
|
DROP TABLE IF EXISTS `root`; |
CREATE TABLE IF NOT EXISTS `root` ( |
`root_id` int(2) NOT NULL auto_increment, |
`root_id` int(2) NOT NULL AUTO_INCREMENT, |
`root_folder` varchar(50) NOT NULL, |
PRIMARY KEY (`root_id`) |
PRIMARY KEY (`root_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
|
-- |
332,10 → 343,11 |
-- Структура таблицы `rtype` |
-- |
|
DROP TABLE IF EXISTS `rtype`; |
CREATE TABLE IF NOT EXISTS `rtype` ( |
`rtype_id` int(2) NOT NULL auto_increment, |
`rtype_id` int(2) NOT NULL AUTO_INCREMENT, |
`rtype` varchar(25) NOT NULL, |
PRIMARY KEY (`rtype_id`) |
PRIMARY KEY (`rtype_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; |
|
-- |
353,10 → 365,11 |
-- Структура таблицы `scheme` |
-- |
|
DROP TABLE IF EXISTS `scheme`; |
CREATE TABLE IF NOT EXISTS `scheme` ( |
`scheme_id` int(2) NOT NULL auto_increment, |
`scheme_id` int(2) NOT NULL AUTO_INCREMENT, |
`scheme` varchar(200) NOT NULL, |
PRIMARY KEY (`scheme_id`) |
PRIMARY KEY (`scheme_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; |
|
-- |
379,11 → 392,12 |
-- Структура таблицы `sect2dist` |
-- |
|
DROP TABLE IF EXISTS `sect2dist`; |
CREATE TABLE IF NOT EXISTS `sect2dist` ( |
`id` int(10) NOT NULL auto_increment, |
`id` int(10) NOT NULL AUTO_INCREMENT, |
`sect_id` int(3) NOT NULL, |
`dist_id` int(5) NOT NULL, |
PRIMARY KEY (`id`), |
PRIMARY KEY (`id`), |
KEY `sect_id` (`sect_id`,`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ; |
|
417,11 → 431,12 |
-- Структура таблицы `sect2rep` |
-- |
|
DROP TABLE IF EXISTS `sect2rep`; |
CREATE TABLE IF NOT EXISTS `sect2rep` ( |
`id` int(10) NOT NULL auto_increment, |
`id` int(10) NOT NULL AUTO_INCREMENT, |
`sect_id` int(3) NOT NULL, |
`rep_id` int(5) NOT NULL, |
PRIMARY KEY (`id`), |
PRIMARY KEY (`id`), |
KEY `sect_id` (`sect_id`,`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=757 ; |
|
639,11 → 654,12 |
-- Структура таблицы `section` |
-- |
|
DROP TABLE IF EXISTS `section`; |
CREATE TABLE IF NOT EXISTS `section` ( |
`sect_id` int(3) NOT NULL auto_increment, |
`sect_id` int(3) NOT NULL AUTO_INCREMENT, |
`sectname` varchar(25) NOT NULL, |
`sectinfo` text NOT NULL, |
PRIMARY KEY (`sect_id`) |
PRIMARY KEY (`sect_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; |
|
-- |
665,11 → 681,12 |
-- Структура таблицы `settings` |
-- |
|
DROP TABLE IF EXISTS `settings`; |
CREATE TABLE IF NOT EXISTS `settings` ( |
`opt_id` int(2) NOT NULL auto_increment, |
`opt_id` int(2) NOT NULL AUTO_INCREMENT, |
`opt` varchar(50) NOT NULL, |
`optvalue` varchar(200) NOT NULL, |
PRIMARY KEY (`opt_id`) |
PRIMARY KEY (`opt_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; |
|
-- |
679,7 → 696,7 |
INSERT INTO `settings` (`opt_id`, `opt`, `optvalue`) VALUES |
(1, 'proto', 'http://'), |
(2, 'url', 'apt.nix-files.org.ru'), |
(3, 'version', '0.2.92-SVN-r285'), |
(3, 'version', '0.2.91-SVN-r296'), |
(4, 'interface', 'telepathy'), |
(5, 'codename', 'Ant'), |
(6, 'style', 'default'), |
691,11 → 708,12 |
-- Структура таблицы `ver2rep` |
-- |
|
DROP TABLE IF EXISTS `ver2rep`; |
CREATE TABLE IF NOT EXISTS `ver2rep` ( |
`id` int(11) NOT NULL auto_increment, |
`ver_id` int(5) default NULL, |
`rep_id` int(5) default NULL, |
PRIMARY KEY (`id`), |
`id` int(11) NOT NULL AUTO_INCREMENT, |
`ver_id` int(5) DEFAULT NULL, |
`rep_id` int(5) DEFAULT NULL, |
PRIMARY KEY (`id`), |
KEY `ver_id` (`ver_id`), |
KEY `rep_id` (`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=62 ; |
764,13 → 782,14 |
-- Структура таблицы `version` |
-- |
|
DROP TABLE IF EXISTS `version`; |
CREATE TABLE IF NOT EXISTS `version` ( |
`version_id` int(5) NOT NULL auto_increment, |
`dist_id` int(5) default NULL, |
`vname` varchar(25) default NULL, |
`version_id` int(5) NOT NULL AUTO_INCREMENT, |
`dist_id` int(5) DEFAULT NULL, |
`vname` varchar(25) DEFAULT NULL, |
`version` varchar(10) NOT NULL, |
`vcodename` varchar(10) default NULL, |
PRIMARY KEY (`version_id`), |
`vcodename` varchar(10) DEFAULT NULL, |
PRIMARY KEY (`version_id`), |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; |
|