| /trunk/sql/ant.sql |
|---|
| 724,3 → 724,34 |
| (6, 3, 'Intrepid Ibex', '8.10', 'intrepid'), |
| (9, 1, 'Squeeze', '6.0', 'squeeze'), |
| (10, 2, 'Jaunty Jackalope', '9.04', 'jaunty'); |
| -- -------------------------------------------------------- |
| -- |
| -- Структура таблицы `origin` |
| -- |
| CREATE TABLE IF NOT EXISTS `origin` ( |
| `origin_id` int(5) NOT NULL auto_increment, |
| `origin` varchar(25) default NULL, |
| PRIMARY KEY (`origin_id`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11; |
| -- -------------------------------------------------------- |
| -- |
| -- Структура таблицы `orig2rep` |
| -- |
| CREATE TABLE IF NOT EXISTS `orig2reps` ( |
| `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 ; |
| /trunk/sql/ant-scheme.sql |
|---|
| 254,3 → 254,34 |
| PRIMARY KEY (`version_id`), |
| KEY `dist_id` (`dist_id`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; |
| -- -------------------------------------------------------- |
| -- |
| -- Структура таблицы `origin` |
| -- |
| CREATE TABLE IF NOT EXISTS `origin` ( |
| `origin_id` int(5) NOT NULL auto_increment, |
| `origin` varchar(25) default NULL, |
| PRIMARY KEY (`origin_id`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| -- -------------------------------------------------------- |
| -- |
| -- Структура таблицы `orig2rep` |
| -- |
| CREATE TABLE IF NOT EXISTS `orig2reps` ( |
| `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 ; |
| /trunk/sql/install.sql |
|---|
| 348,3 → 348,33 |
| KEY `dist_id` (`dist_id`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
| -- -------------------------------------------------------- |
| -- |
| -- Структура таблицы `origin` |
| -- |
| CREATE TABLE IF NOT EXISTS `origin` ( |
| `origin_id` int(5) NOT NULL auto_increment, |
| `origin` varchar(25) default NULL, |
| PRIMARY KEY (`origin_id`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11; |
| -- -------------------------------------------------------- |
| -- |
| -- Структура таблицы `orig2rep` |
| -- |
| CREATE TABLE IF NOT EXISTS `orig2reps` ( |
| `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 ; |