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 ; |
|