Хранилища Subversion ant

-- phpMyAdmin SQL Dump

-- version 3.0.0-alpha

-- http://www.phpmyadmin.net

--

-- Хост: localhost

-- Время создания: Ноя 26 2009 г., 13:46

-- Версия сервера: 5.1.37

-- Версия PHP: 5.2.11-1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--

-- База данных: `generator`

--

-- --------------------------------------------------------

--

-- Структура таблицы `g_arch`

--

CREATE TABLE IF NOT EXISTS `g_arch` (

  `arch_id` INT(2) NOT NULL AUTO_INCREMENT,

  `arch` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`arch_id`),

  KEY `arch` (`arch`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures' AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_arch2rep`

--

CREATE TABLE IF NOT EXISTS `g_arch2rep` (

  `id` INT(5) NOT NULL AUTO_INCREMENT,

  `arch_id` INT(2) NOT NULL,

  `rep_id` INT(5) NOT NULL,

  PRIMARY KEY (`id`),

  KEY `arch_id` (`arch_id`,`rep_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Architectures of repositories' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_distribution`

--

CREATE TABLE IF NOT EXISTS `g_distribution` (

  `dist_id` INT(5) NOT NULL AUTO_INCREMENT,

  `distname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,

  `distua` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,

  `disttype` INT(1) NOT NULL,

  `distlogo` enum('0','1') COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`dist_id`),

  KEY `disttype` (`disttype`,`distlogo`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives' AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_dtype`

--

CREATE TABLE IF NOT EXISTS `g_dtype` (

  `type_id` INT(1) NOT NULL AUTO_INCREMENT,

  `type` VARCHAR(3) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`type_id`),

  KEY `type` (`type`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Distributives types (deb or rpm)' AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_protos`

--

CREATE TABLE IF NOT EXISTS `g_protos` (

  `proto_id` INT(1) NOT NULL AUTO_INCREMENT,

  `proto` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`proto_id`),

  KEY `proto` (`proto`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Protocoles for access for repository' AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_repfolder`

--

CREATE TABLE IF NOT EXISTS `g_repfolder` (

  `rfolder_id` INT(5) NOT NULL AUTO_INCREMENT,

  `rfolder` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`rfolder_id`),

  KEY `rhost_id` (`rfolder`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository folders' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_rephost`

--

CREATE TABLE IF NOT EXISTS `g_rephost` (

  `rhost_id` INT(3) NOT NULL AUTO_INCREMENT,

  `rhost` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`rhost_id`),

  KEY `proto_id` (`rhost`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_repository`

--

CREATE TABLE IF NOT EXISTS `g_repository` (

  `rep_id` INT(5) NOT NULL AUTO_INCREMENT,

  `proto_id` INT(1) NOT NULL,

  `rhost_id` INT(3) NOT NULL,

  `rfolder_id` INT(5) NOT NULL,

  `version` INT(5) NOT NULL,

  `rtype_id` INT(2) NOT NULL,

  `scheme_id` INT(2) NOT NULL,

  `repname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,

  `repinfo` text COLLATE utf8_unicode_ci NOT NULL,

  `repkey` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`rep_id`),

  KEY `proto_id` (`proto_id`),

  KEY `rhost_id` (`rhost_id`),

  KEY `rfolder_id` (`rfolder_id`),

  KEY `version` (`version`),

  KEY `rtype_id` (`rtype_id`),

  KEY `scheme_id` (`scheme_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_repscheme`

--

CREATE TABLE IF NOT EXISTS `g_repscheme` (

  `scheme_id` INT(2) NOT NULL AUTO_INCREMENT,

  `scheme` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`scheme_id`),

  KEY `scheme` (`scheme`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository schemes' AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_rtype`

--

CREATE TABLE IF NOT EXISTS `g_rtype` (

  `rtype_id` INT(2) NOT NULL AUTO_INCREMENT,

  `rtype` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`rtype_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Types of repositories (official, updates, 3rd party, etc.)' AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_sect2rep`

--

CREATE TABLE IF NOT EXISTS `g_sect2rep` (

  `id` INT(5) NOT NULL AUTO_INCREMENT,

  `sect_id` INT(2) NOT NULL,

  `rep_id` INT(5) NOT NULL,

  PRIMARY KEY (`id`),

  KEY `sect_id` (`sect_id`,`rep_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_section`

--

CREATE TABLE IF NOT EXISTS `g_section` (

  `sect_id` INT(2) NOT NULL AUTO_INCREMENT,

  `secname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,

  `sectinfo` VARCHAR(250) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`sect_id`),

  KEY `secname` (`secname`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Information about sections' AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_settings`

--

CREATE TABLE IF NOT EXISTS `g_settings` (

  `opt_id` INT(2) NOT NULL AUTO_INCREMENT,

  `opt` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,

  `optvalue` VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`opt_id`),

  KEY `opt` (`opt`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings' AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_signs`

--

CREATE TABLE IF NOT EXISTS `g_signs` (

  `sign_id` INT(3) NOT NULL AUTO_INCREMENT,

  `sname` VARCHAR(25) NOT NULL,

  `sinfo` VARCHAR(150) NOT NULL,

  PRIMARY KEY (`sign_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Подписи для репозиториев AltLinux' AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--

-- Структура таблицы `g_version`

--

CREATE TABLE IF NOT EXISTS `g_version` (

  `version_id` INT(5) NOT NULL AUTO_INCREMENT,

  `dist_id` INT(5) NOT NULL,

  `vname` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,

  `version` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,

  `vcodename` VARCHAR(10) COLLATE utf8_unicode_ci NOT NULL,

  PRIMARY KEY (`version_id`),

  KEY `dist_id` (`dist_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Version of distributives' AUTO_INCREMENT=13 ;