3,7 → 3,7 |
-- http://www.phpmyadmin.net |
-- |
-- Хост: localhost |
-- Время создания: Апр 01 2009 г., 14:40 |
-- Время создания: Апр 16 2009 г., 20:12 |
-- Версия сервера: 5.0.51 |
-- Версия PHP: 5.2.6-1+lenny2 |
|
105,6 → 105,22 |
-- -------------------------------------------------------- |
|
-- |
-- Структура таблицы `origin` |
-- |
|
CREATE TABLE IF NOT EXISTS `origin` ( |
`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`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Структура таблицы `owner` |
-- |
|
128,10 → 144,13 |
`scheme_id` int(2) NOT NULL, |
`rtype_id` int(2) NOT NULL, |
`root_id` int(2) NOT NULL, |
`orig_id` int(5) NOT NULL, |
`default` tinyint(1) NOT NULL, |
PRIMARY KEY (`rep_id`), |
KEY `scheme` (`scheme_id`), |
KEY `rtype_id` (`rtype_id`), |
KEY `root_id` (`root_id`) |
KEY `root_id` (`root_id`), |
KEY `orig_id` (`orig_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ; |
|
-- -------------------------------------------------------- |
196,7 → 215,7 |
`rep_id` int(5) NOT NULL, |
PRIMARY KEY (`id`), |
KEY `sect_id` (`sect_id`,`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=529 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=671 ; |
|
-- -------------------------------------------------------- |
|
237,7 → 256,7 |
PRIMARY KEY (`id`), |
KEY `ver_id` (`ver_id`), |
KEY `rep_id` (`rep_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ; |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=62 ; |
|
-- -------------------------------------------------------- |
|
254,33 → 273,3 |
PRIMARY KEY (`version_id`), |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; |
|
-- |
-- Структура таблицы `origin` |
-- |
|
CREATE TABLE IF NOT EXISTS `origin` ( |
`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`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; |
|
-- -------------------------------------------------------- |
|
-- |
-- Структура таблицы `orig2dist` |
-- |
|
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, |
PRIMARY KEY (`id`), |
KEY `orig_id` (`orig_id`), |
KEY `dist_id` (`dist_id`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; |
|