/trunk/sql/ant.sql |
---|
725,37 → 725,50 |
(9, 1, 'Squeeze', '6.0', 'squeeze'), |
(10, 2, 'Jaunty Jackalope', '9.04', 'jaunty'); |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `origin` |
-- |
CREATE TABLE IF NOT EXISTS `origin` ( |
`id` int(5) NOT NULL auto_increment, |
`origin` varchar(25) 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 (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; |
PRIMARY KEY (`orig_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; |
-- |
-- Дамп данных таблицы `origin` |
-- |
INSERT INTO `origin` (`orig_id`, `origin`, `desk`, `basedir`, `homeurl`, `keyurl`) VALUES |
(1, 'Debian', 'Официальный репозиторий Debian', 'debian', 'http://archive.debian.org/', ''), |
(2, 'Unofficial Multimedia Packages', 'Неофициальные мультимедийные пакеты ', 'debian-multimedia', 'http://www.debian-multimedia.org', ''), |
(3, 'Opera Software ASA', 'Web-браузер Opera', 'opera', 'http://deb.opera.com/', 'http://deb.opera.com/archive.key'), |
(4, 'Ubuntu', 'Официальный репозиторий Ubuntu', 'ubuntu', 'http://archive.ubuntu.com/', ''), |
(5, 'LP-PPA-kubuntu-experimental', 'Экспериментальные пакеты для Kubuntu', 'kubuntu-experimental', 'https://launchpad.net/~kubuntu-experimental', ''), |
(6, 'PlayOnLinux', 'PlayOnLinux vous permetra installer des jeux windows sous un environnement linux', 'playonlinux', 'http://www.playonlinux.com', ''); |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `orig2rep` |
-- Структура таблицы `orig2dist` |
-- |
CREATE TABLE IF NOT EXISTS `orig2reps` ( |
CREATE TABLE IF NOT EXISTS `orig2dist` ( |
`id` int(11) NOT NULL auto_increment, |
`orig_id` int(5) default NULL, |
`dist_id` int(5) default NULL, |
`ver_id` int(5) default NULL, |
`rep_id` int(5) default NULL, |
PRIMARY KEY (`id`), |
KEY `orig_id` (`orig_id`), |
KEY `dist_id` (`dist_id`), |
KEY `ver_id` (`ver_id`), |
KEY `rep_id` (`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; |
-- |
-- Дамп данных таблицы `orig2dist` |
-- |
INSERT INTO `orig2dist` (`id`, `orig_id`, `dist_id`) VALUES |
(1, 1, 1); |
/trunk/sql/ant-scheme.sql |
---|
255,37 → 255,32 |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `origin` |
-- |
CREATE TABLE IF NOT EXISTS `origin` ( |
`id` int(5) NOT NULL auto_increment, |
`origin` varchar(25) 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 (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; |
PRIMARY KEY (`orig_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `orig2rep` |
-- Структура таблицы `orig2dist` |
-- |
CREATE TABLE IF NOT EXISTS `orig2reps` ( |
CREATE TABLE IF NOT EXISTS `orig2dist` ( |
`id` int(11) NOT NULL auto_increment, |
`orig_id` int(5) default NULL, |
`dist_id` int(5) default NULL, |
`ver_id` int(5) default NULL, |
`rep_id` int(5) default NULL, |
PRIMARY KEY (`id`), |
KEY `orig_id` (`orig_id`), |
KEY `dist_id` (`dist_id`), |
KEY `ver_id` (`ver_id`), |
KEY `rep_id` (`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; |
/trunk/sql/install.sql |
---|
348,37 → 348,31 |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `origin` |
-- |
CREATE TABLE IF NOT EXISTS `origin` ( |
`id` int(5) NOT NULL auto_increment, |
`origin` varchar(25) 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 (`id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; |
PRIMARY KEY (`orig_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
-- -------------------------------------------------------- |
-- |
-- Структура таблицы `orig2rep` |
-- Структура таблицы `orig2dist` |
-- |
CREATE TABLE IF NOT EXISTS `orig2reps` ( |
CREATE TABLE IF NOT EXISTS `orig2dist` ( |
`id` int(11) NOT NULL auto_increment, |
`orig_id` int(5) default NULL, |
`dist_id` int(5) default NULL, |
`ver_id` int(5) default NULL, |
`rep_id` int(5) default NULL, |
PRIMARY KEY (`id`), |
KEY `orig_id` (`orig_id`), |
KEY `dist_id` (`dist_id`), |
KEY `ver_id` (`ver_id`), |
KEY `rep_id` (`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |