Редакция 327 |
К новейшей редакции |
Авторство |
Сравнить с предыдущей |
Последнее изменение |
Открыть журнал
| Скачать
| RSS
-- phpMyAdmin SQL Dump
-- version 3.0.0-alpha
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Окт 14 2009 г., 17:08
-- Версия сервера: 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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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 ;