Хранилища Subversion ant

-- phpMyAdmin SQL Dump
-- version 3.0.0-alpha
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Окт 14 2009 г., 17:09
-- Версия сервера: 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`
--

DROP TABLE IF EXISTS `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_arch`
--

INSERT INTO `g_arch` (`arch_id`, `arch`) VALUES
(1, 'i386'),
(2, 'amd64');

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

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

DROP TABLE IF EXISTS `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_arch2rep`
--


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

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

DROP TABLE IF EXISTS `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=3 ;

--
-- Дамп данных таблицы `g_distribution`
--

INSERT INTO `g_distribution` (`dist_id`, `distname`, `distua`, `disttype`, `distlogo`) VALUES
(1, 'Debian GNU/Linux', 'debian', 1, '0'),
(2, 'Ubuntu Linux', 'ubuntu', 1, '0');

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

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

DROP TABLE IF EXISTS `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_dtype`
--

INSERT INTO `g_dtype` (`type_id`, `type`) VALUES
(1, 'deb'),
(2, 'rpm');

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

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

DROP TABLE IF EXISTS `g_host2net`;
CREATE TABLE IF NOT EXISTS `g_host2net` (
  `id` INT(5) NOT NULL AUTO_INCREMENT,
  `rhost_id` INT(3) NOT NULL,
  `nb_id` INT(2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rhost_id` (`rhost_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts into network block' AUTO_INCREMENT=3 ;

--
-- Дамп данных таблицы `g_host2net`
--

INSERT INTO `g_host2net` (`id`, `rhost_id`, `nb_id`) VALUES
(1, 1, 1),
(2, 2, 1);

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

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

DROP TABLE IF EXISTS `g_netblock`;
CREATE TABLE IF NOT EXISTS `g_netblock` (
  `nb_id` INT(2) NOT NULL AUTO_INCREMENT,
  `netblock` VARCHAR(25) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`nb_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Network blocks' AUTO_INCREMENT=3 ;

--
-- Дамп данных таблицы `g_netblock`
--

INSERT INTO `g_netblock` (`nb_id`, `netblock`) VALUES
(1, 'AltLUG'),
(2, 'SibNET');

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

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

DROP TABLE IF EXISTS `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_protos`
--

INSERT INTO `g_protos` (`proto_id`, `proto`) VALUES
(1, 'http://');

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

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

DROP TABLE IF EXISTS `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_repfolder`
--


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

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

DROP TABLE IF EXISTS `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=3 ;

--
-- Дамп данных таблицы `g_rephost`
--

INSERT INTO `g_rephost` (`rhost_id`, `rhost`) VALUES
(1, 'apt.nix-files.org.ru'),
(2, 'hyperion.uni-altai.ru');

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

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

DROP TABLE IF EXISTS `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,
  `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=1 ;

--
-- Дамп данных таблицы `g_repository`
--


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

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

DROP TABLE IF EXISTS `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_repscheme`
--

INSERT INTO `g_repscheme` (`scheme_id`, `scheme`) VALUES
(1, '{DIST}'),
(2, '{DIST}-proposed-updates'),
(3, '{DIST}/updates'),
(4, '{DIST}/volatile'),
(5, '{DIST}/volatile-sloppy'),
(6, '{DIST}-backports'),
(7, '{DIST}-updates'),
(8, '{DIST}-security');

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

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

DROP TABLE IF EXISTS `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_rtype`
--

INSERT INTO `g_rtype` (`rtype_id`, `rtype`) VALUES
(1, 'Базовый репозиторий'),
(2, 'Обновления'),
(3, 'Репозитории 3-х лиц'),
(4, 'Репозитории партнеров');

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

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

DROP TABLE IF EXISTS `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=1 ;

--
-- Дамп данных таблицы `g_sect2rep`
--


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

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

DROP TABLE IF EXISTS `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=9 ;

--
-- Дамп данных таблицы `g_section`
--

INSERT INTO `g_section` (`sect_id`, `secname`, `sectinfo`) VALUES
(1, 'main', ''),
(2, 'contrib', ''),
(3, 'non-free', ''),
(4, 'restricted', ''),
(5, 'universe', ''),
(6, 'multiverse', ''),
(7, 'partner', ''),
(8, 'unofficial', '');

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

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

DROP TABLE IF EXISTS `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=5 ;

--
-- Дамп данных таблицы `g_settings`
--

INSERT INTO `g_settings` (`opt_id`, `opt`, `optvalue`) VALUES
(1, 'codename', 'ant-ng'),
(2, 'version', '0.1'),
(3, 'owner', 'admin'),
(4, 'passwd', '1');

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

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

DROP TABLE IF EXISTS `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=9 ;

--
-- Дамп данных таблицы `g_version`
--

INSERT INTO `g_version` (`version_id`, `dist_id`, `vname`, `version`, `vcodename`) VALUES
(1, 1, 'Sarge', '3.1', 'sarge'),
(2, 1, 'Etch', '4.0', 'etch'),
(3, 1, 'Lenny', '5.0', 'lenny'),
(4, 1, 'Squeeze', '6.0', 'squeeze'),
(5, 2, 'Hardy Heron', '8.04', 'hardy'),
(6, 2, 'Intrepid Ibex', '8.10', 'intrepid'),
(7, 2, 'Jaunty Jackalope', '9.04', 'jaunty'),
(8, 2, 'Karmic Koala', '9.10', 'karmic');