[gentoo-commits] dev/zorry:master commit in: gobs/sql/

["Magnus Granberg" <zorry@gentoo.org>]

commit:     837c39fb561cbf670afc0453b2b8f7f0bc3988bf
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Fri Dec 21 01:05:25 2012 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Fri Dec 21 01:05:25 2012 +0000
URL:        http://git.overlays.gentoo.org/gitweb/?p=dev/zorry.git;a=commit;h=837c39fb

Add the structur of the mysql db

---
 gobs/sql/pgdump.sql.gz |  Bin 10547 -> 0 bytes
 gobs/sql/zobcs.sql     |  412 ++++++++++++++++++++++++++++++++++++++++++++++++
 2 files changed, 412 insertions(+), 0 deletions(-)

diff --git a/gobs/sql/pgdump.sql.gz b/gobs/sql/pgdump.sql.gz
deleted file mode 100644
index d259808..0000000
Binary files a/gobs/sql/pgdump.sql.gz and /dev/null differ

diff --git a/gobs/sql/zobcs.sql b/gobs/sql/zobcs.sql
new file mode 100644
index 0000000..eb9f32d
--- /dev/null
+++ b/gobs/sql/zobcs.sql
@@ -0,0 +1,412 @@
+-- phpMyAdmin SQL Dump
+-- version 3.5.2.2
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Dec 21, 2012 at 01:02 AM
+-- Server version: 5.5.28-MariaDB-log
+-- PHP Version: 5.4.6--pl0-gentoo
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+SET time_zone = "+00:00";
+
+
+/*!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 */;
+
+--
+-- Database: `zobcs`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_jobs`
+--
+
+DROP TABLE IF EXISTS `build_jobs`;
+CREATE TABLE IF NOT EXISTS `build_jobs` (
+  `build_job_id` int(11) NOT NULL AUTO_INCREMENT,
+  `ebuild_id` int(11) NOT NULL,
+  `config_id` int(11) NOT NULL,
+  `status` enum('Waiting','Now') NOT NULL DEFAULT 'Waiting',
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`build_job_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15222 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_jobs_emerge_options`
+--
+
+DROP TABLE IF EXISTS `build_jobs_emerge_options`;
+CREATE TABLE IF NOT EXISTS `build_jobs_emerge_options` (
+  `build_job_id` int(11) NOT NULL,
+  `eoption_id` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_jobs_redo`
+--
+
+DROP TABLE IF EXISTS `build_jobs_redo`;
+CREATE TABLE IF NOT EXISTS `build_jobs_redo` (
+  `build_job_id` int(11) NOT NULL COMMENT 'build job id',
+  `fail_times` int(1) NOT NULL COMMENT 'Fail times max 5',
+  `fail_type` varchar(15) NOT NULL COMMENT 'Type of fail',
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Time'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Build jobs that need to be redone';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_jobs_use`
+--
+
+DROP TABLE IF EXISTS `build_jobs_use`;
+CREATE TABLE IF NOT EXISTS `build_jobs_use` (
+  `build_job_id` int(11) NOT NULL,
+  `use_id` int(11) NOT NULL,
+  `status` enum('True','False') NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs`
+--
+
+DROP TABLE IF EXISTS `build_logs`;
+CREATE TABLE IF NOT EXISTS `build_logs` (
+  `build_log_id` int(11) NOT NULL,
+  `ebuild_id` int(11) NOT NULL,
+  `fail` enum('True','False') NOT NULL DEFAULT 'False',
+  `summery_text` text NOT NULL,
+  `log_hash` varchar(100) NOT NULL,
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Main log info for the builds';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_config`
+--
+
+DROP TABLE IF EXISTS `build_logs_config`;
+CREATE TABLE IF NOT EXISTS `build_logs_config` (
+  `build_log_id` int(11) NOT NULL,
+  `config_id` int(11) NOT NULL,
+  `logname` varchar(150) NOT NULL COMMENT 'filename of the log'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_emerge_options`
+--
+
+DROP TABLE IF EXISTS `build_logs_emerge_options`;
+CREATE TABLE IF NOT EXISTS `build_logs_emerge_options` (
+  `build_job_id` int(11) NOT NULL,
+  `eoption_id` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_qa`
+--
+
+DROP TABLE IF EXISTS `build_logs_qa`;
+CREATE TABLE IF NOT EXISTS `build_logs_qa` (
+  `build_log_id` int(11) NOT NULL,
+  `summery_text` text NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_repoman`
+--
+
+DROP TABLE IF EXISTS `build_logs_repoman`;
+CREATE TABLE IF NOT EXISTS `build_logs_repoman` (
+  `build_job_id` int(11) NOT NULL,
+  `summery_text` text NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_log_use`
+--
+
+DROP TABLE IF EXISTS `build_log_use`;
+CREATE TABLE IF NOT EXISTS `build_log_use` (
+  `build_log_id` int(11) NOT NULL,
+  `use_id` int(11) NOT NULL,
+  `status` enum('True','False') NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `categories`
+--
+
+DROP TABLE IF EXISTS `categories`;
+CREATE TABLE IF NOT EXISTS `categories` (
+  `category_id` int(11) NOT NULL AUTO_INCREMENT,
+  `category` varchar(50) NOT NULL,
+  `active` enum('True','False') NOT NULL DEFAULT 'True',
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`category_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Categories main table (C)' AUTO_INCREMENT=158 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `configs`
+--
+
+DROP TABLE IF EXISTS `configs`;
+CREATE TABLE IF NOT EXISTS `configs` (
+  `config_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Config index',
+  `config` varchar(100) NOT NULL COMMENT 'Box/setup',
+  `default_config` enum('True','False') NOT NULL COMMENT 'Host setup',
+  PRIMARY KEY (`config_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Main config table' AUTO_INCREMENT=3 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `configs_emerge_options`
+--
+
+DROP TABLE IF EXISTS `configs_emerge_options`;
+CREATE TABLE IF NOT EXISTS `configs_emerge_options` (
+  `config_id` int(11) NOT NULL COMMENT 'config id',
+  `eoption_id` int(11) NOT NULL COMMENT 'emerge option id',
+  KEY `config_id` (`config_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Emerge command options for the configs';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `configs_metadata`
+--
+
+DROP TABLE IF EXISTS `configs_metadata`;
+CREATE TABLE IF NOT EXISTS `configs_metadata` (
+  `config_id` int(11) NOT NULL,
+  `profile` varchar(50) NOT NULL,
+  `keyword_id` int(11) NOT NULL,
+  `make_conf_text` text NOT NULL,
+  `checksum` varchar(100) NOT NULL,
+  `active` enum('True','False') NOT NULL,
+  `config_error_text` text NOT NULL,
+  `updating` enum('True','False') NOT NULL,
+  `status` enum('Waiting','Runing','Stoped') NOT NULL,
+  `auto` enum('True','False') NOT NULL,
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Config Status';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds`
+--
+
+DROP TABLE IF EXISTS `ebuilds`;
+CREATE TABLE IF NOT EXISTS `ebuilds` (
+  `ebuild_id` int(11) NOT NULL AUTO_INCREMENT,
+  `package_id` int(11) NOT NULL,
+  `version` varchar(50) NOT NULL,
+  `checksum` varchar(100) NOT NULL,
+  `active` enum('True','False') NOT NULL DEFAULT 'True',
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`ebuild_id`),
+  KEY `package_id` (`package_id`),
+  KEY `checksum` (`checksum`),
+  KEY `version` (`version`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Version main table (V)' AUTO_INCREMENT=32628 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds_iuse`
+--
+
+DROP TABLE IF EXISTS `ebuilds_iuse`;
+CREATE TABLE IF NOT EXISTS `ebuilds_iuse` (
+  `ebuild_id` int(11) NOT NULL,
+  `use_id` int(11) NOT NULL,
+  `status` enum('True','False') NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds_keywords`
+--
+
+DROP TABLE IF EXISTS `ebuilds_keywords`;
+CREATE TABLE IF NOT EXISTS `ebuilds_keywords` (
+  `ebuild_id` int(11) NOT NULL,
+  `keyword_id` int(11) NOT NULL,
+  `status` enum('Stable','Unstable','Negative') NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds_metadata`
+--
+
+DROP TABLE IF EXISTS `ebuilds_metadata`;
+CREATE TABLE IF NOT EXISTS `ebuilds_metadata` (
+  `ebuild_id` int(11) NOT NULL,
+  `revision` varchar(10) NOT NULL COMMENT 'CVS revision'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds_restrictions`
+--
+
+DROP TABLE IF EXISTS `ebuilds_restrictions`;
+CREATE TABLE IF NOT EXISTS `ebuilds_restrictions` (
+  `ebuild_id` int(11) NOT NULL,
+  `restriction_id` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `emerge_options`
+--
+
+DROP TABLE IF EXISTS `emerge_options`;
+CREATE TABLE IF NOT EXISTS `emerge_options` (
+  `eoption_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'emerge command options id',
+  `eoption` varchar(15) NOT NULL COMMENT 'emerge command options',
+  PRIMARY KEY (`eoption_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `jobs`
+--
+
+DROP TABLE IF EXISTS `jobs`;
+CREATE TABLE IF NOT EXISTS `jobs` (
+  `job_id` int(11) NOT NULL AUTO_INCREMENT,
+  `job` enum('updatedb','gitsync','esync','lsync') NOT NULL,
+  `status` enum('Runing','Done','Waiting') NOT NULL,
+  `user` varchar(20) NOT NULL,
+  `config_id` int(11) NOT NULL,
+  `run_config_id` int(11) NOT NULL,
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`job_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `keywords`
+--
+
+DROP TABLE IF EXISTS `keywords`;
+CREATE TABLE IF NOT EXISTS `keywords` (
+  `keyword_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'keyword index',
+  `keyword` varchar(15) NOT NULL COMMENT 'keyword',
+  PRIMARY KEY (`keyword_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='KEYWORD' AUTO_INCREMENT=41 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `logs`
+--
+
+DROP TABLE IF EXISTS `logs`;
+CREATE TABLE IF NOT EXISTS `logs` (
+  `log_id` int(11) NOT NULL AUTO_INCREMENT,
+  `config_id` int(11) NOT NULL,
+  `log_type` enum('info','error','debug') NOT NULL,
+  `msg` text NOT NULL,
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`log_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=185787 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `packages`
+--
+
+DROP TABLE IF EXISTS `packages`;
+CREATE TABLE IF NOT EXISTS `packages` (
+  `package_id` int(11) NOT NULL AUTO_INCREMENT,
+  `category_id` int(11) NOT NULL,
+  `package` varchar(50) NOT NULL,
+  `repo_id` int(11) NOT NULL,
+  `checksum` varchar(100) NOT NULL,
+  `active` enum('True','False') NOT NULL,
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`package_id`),
+  KEY `category_id` (`category_id`),
+  KEY `repo_id` (`repo_id`),
+  KEY `checksum` (`checksum`),
+  KEY `package` (`package`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Packages main table (P)' AUTO_INCREMENT=16312 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `repos`
+--
+
+DROP TABLE IF EXISTS `repos`;
+CREATE TABLE IF NOT EXISTS `repos` (
+  `repo_id` int(11) NOT NULL AUTO_INCREMENT,
+  `repo` varchar(100) NOT NULL,
+  PRIMARY KEY (`repo_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Repo main table (repo)' AUTO_INCREMENT=3 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `restrictions`
+--
+
+DROP TABLE IF EXISTS `restrictions`;
+CREATE TABLE IF NOT EXISTS `restrictions` (
+  `restriction_id` int(11) NOT NULL AUTO_INCREMENT,
+  `restriction` varchar(50) NOT NULL,
+  PRIMARY KEY (`restriction_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `uses`
+--
+
+DROP TABLE IF EXISTS `uses`;
+CREATE TABLE IF NOT EXISTS `uses` (
+  `use_id` int(11) NOT NULL AUTO_INCREMENT,
+  `flag` varchar(50) NOT NULL,
+  PRIMARY KEY (`use_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Use flags main table' AUTO_INCREMENT=4606 ;
+
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;