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

[Magnus Granberg]

commit:     6629ea39faed6d4c0f93301f833e73233ffab859
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Thu Dec 27 21:25:57 2012 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Thu Dec 27 21:25:57 2012 +0000
URL:        http://git.overlays.gentoo.org/gitweb/?p=dev/zorry.git;a=commit;h=6629ea39

Update sql db structure dump

---
 gobs/sql/zobcs.sql | 1175 ++++++++++++++++++++++++++--------------------------
 1 files changed, 588 insertions(+), 587 deletions(-)

diff --git a/gobs/sql/zobcs.sql b/gobs/sql/zobcs.sql
index 62ba3f4..805c2fa 100644
--- a/gobs/sql/zobcs.sql
+++ b/gobs/sql/zobcs.sql
@@ -1,31 +1,31 @@
--- phpMyAdmin SQL Dump
--- version 3.5.2.2
--- http://www.phpmyadmin.net
---
--- Host: localhost
--- Generation Time: Dec 24, 2012 at 01:29 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`
---
-
-DELIMITER $$
---
--- Procedures
---
-CREATE DEFINER=`zobcs`@`localhost` PROCEDURE `add_jobs`(IN `in_type` VARCHAR(20) CHARSET utf8)
-    MODIFIES SQL DATA
+-- phpMyAdmin SQL Dump
+-- version 3.5.2.2
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Dec 27, 2012 at 09:23 PM
+-- 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`
+--
+
+DELIMITER $$
+--
+-- Procedures
+--
+CREATE DEFINER=`zobcs`@`localhost` PROCEDURE `add_jobs`(IN `in_type` VARCHAR(20) CHARSET utf8)
+    MODIFIES SQL DATA
 BEGIN
   DECLARE in_config_id INT;
   DECLARE in_job_type_id INT;
@@ -44,565 +44,566 @@ BEGIN
   ELSE
     INSERT INTO jobs (job_type_id, user, config_id, run_config_id) VALUES ( in_job_type_id, 'cron', in_config_id, in_config_id);
   END IF;
-END$$
-
-DELIMITER ;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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`),
-  KEY `ebuild_id` (`ebuild_id`),
-  KEY `config_id` (`config_id`),
-  KEY `time_stamp` (`time_stamp`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='The build work list';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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,
-  KEY `build_job_id` (`build_job_id`),
-  KEY `eoption_id` (`eoption_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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(30) NOT NULL COMMENT 'Type of fail',
-  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Time',
-  KEY `build_job_id` (`build_job_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Build jobs that need to be redone';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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,
-  KEY `build_job_id` (`build_job_id`),
-  KEY `use_id` (`use_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `build_logs`
---
-
-CREATE TABLE IF NOT EXISTS `build_logs` (
-  `build_log_id` int(11) NOT NULL AUTO_INCREMENT,
-  `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,
-  PRIMARY KEY (`build_log_id`),
-  KEY `ebuild_id` (`ebuild_id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Main log info for the builds';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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',
-  KEY `config_id` (`config_id`),
-  KEY `build_log_id` (`build_log_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `build_logs_emerge_options`
---
-
-CREATE TABLE IF NOT EXISTS `build_logs_emerge_options` (
-  `build_logs_id` int(11) NOT NULL,
-  `eoption_id` int(11) NOT NULL,
-  KEY `eoption_id` (`eoption_id`),
-  KEY `build_logs_id` (`build_logs_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `build_logs_qa`
---
-
-CREATE TABLE IF NOT EXISTS `build_logs_qa` (
-  `build_log_id` int(11) NOT NULL,
-  `summery_text` text NOT NULL,
-  KEY `build_log_id` (`build_log_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `build_logs_repoman`
---
-
-CREATE TABLE IF NOT EXISTS `build_logs_repoman` (
-  `build_logs_id` int(11) NOT NULL,
-  `summery_text` text NOT NULL,
-  KEY `build_logs_id` (`build_logs_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `build_logs_use`
---
-
-CREATE TABLE IF NOT EXISTS `build_logs_use` (
-  `build_log_id` int(11) NOT NULL,
-  `use_id` int(11) NOT NULL,
-  `status` enum('True','False') NOT NULL,
-  KEY `build_log_id` (`build_log_id`),
-  KEY `use_id` (`use_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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)';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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`),
-  KEY `eoption_id` (`eoption_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Emerge command options for the configs';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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,
-  `git_www` varchar(100) NOT NULL COMMENT 'git repo www wiev address',
-  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  PRIMARY KEY (`config_id`),
-  KEY `keyword_id` (`keyword_id`),
-  KEY `config_id` (`config_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Config Status';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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)';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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,
-  KEY `ebuild_id` (`ebuild_id`),
-  KEY `use_id` (`use_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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,
-  KEY `ebuild_id` (`ebuild_id`),
-  KEY `keyword_id` (`keyword_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `ebuilds_metadata`
---
-
-CREATE TABLE IF NOT EXISTS `ebuilds_metadata` (
-  `ebuild_id` int(11) NOT NULL,
-  `revision` varchar(10) NOT NULL COMMENT 'CVS revision',
-  KEY `ebuild_id` (`ebuild_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `ebuilds_restrictions`
---
-
-CREATE TABLE IF NOT EXISTS `ebuilds_restrictions` (
-  `ebuild_id` int(11) NOT NULL,
-  `restriction_id` int(11) NOT NULL,
-  KEY `ebuild_id` (`ebuild_id`),
-  KEY `restriction_id` (`restriction_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `jobs`
---
-
-CREATE TABLE IF NOT EXISTS `jobs` (
-  `job_id` int(11) NOT NULL AUTO_INCREMENT,
-  `job_type_id` int(11) NOT NULL,
-  `status` enum('Runing','Done','Waiting') NOT NULL DEFAULT 'Waiting',
-  `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`),
-  KEY `config_id` (`config_id`),
-  KEY `run_config_id` (`run_config_id`),
-  KEY `job_type_id` (`job_type_id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `job_types`
---
-
-CREATE TABLE IF NOT EXISTS `job_types` (
-  `job_type_id` int(11) NOT NULL AUTO_INCREMENT,
-  `type` varchar(20) NOT NULL,
-  PRIMARY KEY (`job_type_id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Table for what type of work';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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`),
-  KEY `config_id` (`config_id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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)';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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)';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `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';
-
---
--- Constraints for dumped tables
---
-
---
--- Constraints for table `build_jobs`
---
-ALTER TABLE `build_jobs`
-  ADD CONSTRAINT `build_jobs_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`),
-  ADD CONSTRAINT `build_jobs_ibfk_2` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`);
-
---
--- Constraints for table `build_jobs_emerge_options`
---
-ALTER TABLE `build_jobs_emerge_options`
-  ADD CONSTRAINT `build_jobs_emerge_options_ibfk_1` FOREIGN KEY (`build_job_id`) REFERENCES `build_jobs` (`build_job_id`),
-  ADD CONSTRAINT `build_jobs_emerge_options_ibfk_2` FOREIGN KEY (`eoption_id`) REFERENCES `emerge_options` (`eoption_id`);
-
---
--- Constraints for table `build_jobs_redo`
---
-ALTER TABLE `build_jobs_redo`
-  ADD CONSTRAINT `build_jobs_redo_ibfk_1` FOREIGN KEY (`build_job_id`) REFERENCES `build_jobs` (`build_job_id`);
-
---
--- Constraints for table `build_jobs_use`
---
-ALTER TABLE `build_jobs_use`
-  ADD CONSTRAINT `build_jobs_use_ibfk_1` FOREIGN KEY (`build_job_id`) REFERENCES `build_jobs` (`build_job_id`),
-  ADD CONSTRAINT `build_jobs_use_ibfk_2` FOREIGN KEY (`use_id`) REFERENCES `uses` (`use_id`);
-
---
--- Constraints for table `build_logs`
---
-ALTER TABLE `build_logs`
-  ADD CONSTRAINT `build_logs_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`);
-
---
--- Constraints for table `build_logs_config`
---
-ALTER TABLE `build_logs_config`
-  ADD CONSTRAINT `build_logs_config_ibfk_1` FOREIGN KEY (`build_log_id`) REFERENCES `build_logs` (`build_log_id`),
-  ADD CONSTRAINT `build_logs_config_ibfk_2` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`);
-
---
--- Constraints for table `build_logs_emerge_options`
---
-ALTER TABLE `build_logs_emerge_options`
-  ADD CONSTRAINT `build_logs_emerge_options_ibfk_1` FOREIGN KEY (`build_logs_id`) REFERENCES `build_logs` (`build_log_id`),
-  ADD CONSTRAINT `build_logs_emerge_options_ibfk_2` FOREIGN KEY (`eoption_id`) REFERENCES `emerge_options` (`eoption_id`);
-
---
--- Constraints for table `build_logs_qa`
---
-ALTER TABLE `build_logs_qa`
-  ADD CONSTRAINT `build_logs_qa_ibfk_1` FOREIGN KEY (`build_log_id`) REFERENCES `build_logs` (`build_log_id`);
-
---
--- Constraints for table `build_logs_repoman`
---
-ALTER TABLE `build_logs_repoman`
-  ADD CONSTRAINT `build_logs_repoman_ibfk_1` FOREIGN KEY (`build_logs_id`) REFERENCES `build_logs` (`build_log_id`);
-
---
--- Constraints for table `build_logs_use`
---
-ALTER TABLE `build_logs_use`
-  ADD CONSTRAINT `build_logs_use_ibfk_1` FOREIGN KEY (`build_log_id`) REFERENCES `build_logs` (`build_log_id`),
-  ADD CONSTRAINT `build_logs_use_ibfk_2` FOREIGN KEY (`use_id`) REFERENCES `uses` (`use_id`);
-
---
--- Constraints for table `configs_emerge_options`
---
-ALTER TABLE `configs_emerge_options`
-  ADD CONSTRAINT `configs_emerge_options_ibfk_1` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`),
-  ADD CONSTRAINT `configs_emerge_options_ibfk_2` FOREIGN KEY (`eoption_id`) REFERENCES `emerge_options` (`eoption_id`);
-
---
--- Constraints for table `configs_metadata`
---
-ALTER TABLE `configs_metadata`
-  ADD CONSTRAINT `configs_metadata_ibfk_1` FOREIGN KEY (`keyword_id`) REFERENCES `keywords` (`keyword_id`),
-  ADD CONSTRAINT `configs_metadata_ibfk_2` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`);
-
---
--- Constraints for table `ebuilds`
---
-ALTER TABLE `ebuilds`
-  ADD CONSTRAINT `ebuilds_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`);
-
---
--- Constraints for table `ebuilds_iuse`
---
-ALTER TABLE `ebuilds_iuse`
-  ADD CONSTRAINT `ebuilds_iuse_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`),
-  ADD CONSTRAINT `ebuilds_iuse_ibfk_2` FOREIGN KEY (`use_id`) REFERENCES `uses` (`use_id`);
-
---
--- Constraints for table `ebuilds_keywords`
---
-ALTER TABLE `ebuilds_keywords`
-  ADD CONSTRAINT `ebuilds_keywords_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`),
-  ADD CONSTRAINT `ebuilds_keywords_ibfk_2` FOREIGN KEY (`keyword_id`) REFERENCES `keywords` (`keyword_id`);
-
---
--- Constraints for table `ebuilds_metadata`
---
-ALTER TABLE `ebuilds_metadata`
-  ADD CONSTRAINT `ebuilds_metadata_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`);
-
---
--- Constraints for table `ebuilds_restrictions`
---
-ALTER TABLE `ebuilds_restrictions`
-  ADD CONSTRAINT `ebuilds_restrictions_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`),
-  ADD CONSTRAINT `ebuilds_restrictions_ibfk_2` FOREIGN KEY (`restriction_id`) REFERENCES `restrictions` (`restriction_id`);
-
---
--- Constraints for table `jobs`
---
-ALTER TABLE `jobs`
-  ADD CONSTRAINT `jobs_ibfk_1` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`),
-  ADD CONSTRAINT `jobs_ibfk_2` FOREIGN KEY (`run_config_id`) REFERENCES `configs` (`config_id`),
-  ADD CONSTRAINT `jobs_ibfk_3` FOREIGN KEY (`job_type_id`) REFERENCES `job_types` (`job_type_id`);
-
---
--- Constraints for table `logs`
---
-ALTER TABLE `logs`
-  ADD CONSTRAINT `logs_ibfk_1` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`);
-
---
--- Constraints for table `packages`
---
-ALTER TABLE `packages`
-  ADD CONSTRAINT `packages_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`category_id`),
-  ADD CONSTRAINT `packages_ibfk_2` FOREIGN KEY (`repo_id`) REFERENCES `repos` (`repo_id`);
-
-DELIMITER $$
---
--- Events
---
+END$$
+
+DELIMITER ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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`),
+  KEY `ebuild_id` (`ebuild_id`),
+  KEY `config_id` (`config_id`),
+  KEY `time_stamp` (`time_stamp`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='The build work list';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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,
+  KEY `build_job_id` (`build_job_id`),
+  KEY `eoption_id` (`eoption_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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(30) NOT NULL COMMENT 'Type of fail',
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Time',
+  KEY `build_job_id` (`build_job_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Build jobs that need to be redone';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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,
+  KEY `build_job_id` (`build_job_id`),
+  KEY `use_id` (`use_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs` (
+  `build_log_id` int(11) NOT NULL AUTO_INCREMENT,
+  `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,
+  PRIMARY KEY (`build_log_id`),
+  KEY `ebuild_id` (`ebuild_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Main log info for the builds';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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',
+  KEY `config_id` (`config_id`),
+  KEY `build_log_id` (`build_log_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_emerge_options`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs_emerge_options` (
+  `build_logs_id` int(11) NOT NULL,
+  `eoption_id` int(11) NOT NULL,
+  KEY `eoption_id` (`eoption_id`),
+  KEY `build_logs_id` (`build_logs_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_qa`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs_qa` (
+  `build_log_id` int(11) NOT NULL,
+  `summery_text` text NOT NULL,
+  KEY `build_log_id` (`build_log_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_repoman`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs_repoman` (
+  `build_logs_id` int(11) NOT NULL,
+  `summery_text` text NOT NULL,
+  KEY `build_logs_id` (`build_logs_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_use`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs_use` (
+  `build_log_id` int(11) NOT NULL,
+  `use_id` int(11) NOT NULL,
+  `status` enum('True','False') NOT NULL,
+  KEY `build_log_id` (`build_log_id`),
+  KEY `use_id` (`use_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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)';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `configs`
+--
+
+CREATE TABLE IF NOT EXISTS `configs` (
+  `config_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Config index',
+  `hostname` varchar(50) NOT NULL,
+  `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';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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`),
+  KEY `eoption_id` (`eoption_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Emerge command options for the configs';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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,
+  `git_www` varchar(100) NOT NULL COMMENT 'git repo www wiev address',
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (`config_id`),
+  KEY `keyword_id` (`keyword_id`),
+  KEY `config_id` (`config_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Config Status';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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)';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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,
+  KEY `ebuild_id` (`ebuild_id`),
+  KEY `use_id` (`use_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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,
+  KEY `ebuild_id` (`ebuild_id`),
+  KEY `keyword_id` (`keyword_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds_metadata`
+--
+
+CREATE TABLE IF NOT EXISTS `ebuilds_metadata` (
+  `ebuild_id` int(11) NOT NULL,
+  `revision` varchar(10) NOT NULL COMMENT 'CVS revision',
+  KEY `ebuild_id` (`ebuild_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds_restrictions`
+--
+
+CREATE TABLE IF NOT EXISTS `ebuilds_restrictions` (
+  `ebuild_id` int(11) NOT NULL,
+  `restriction_id` int(11) NOT NULL,
+  KEY `ebuild_id` (`ebuild_id`),
+  KEY `restriction_id` (`restriction_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `jobs`
+--
+
+CREATE TABLE IF NOT EXISTS `jobs` (
+  `job_id` int(11) NOT NULL AUTO_INCREMENT,
+  `job_type_id` int(11) NOT NULL,
+  `status` enum('Runing','Done','Waiting') NOT NULL DEFAULT 'Waiting',
+  `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`),
+  KEY `config_id` (`config_id`),
+  KEY `run_config_id` (`run_config_id`),
+  KEY `job_type_id` (`job_type_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `job_types`
+--
+
+CREATE TABLE IF NOT EXISTS `job_types` (
+  `job_type_id` int(11) NOT NULL AUTO_INCREMENT,
+  `type` varchar(20) NOT NULL,
+  PRIMARY KEY (`job_type_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Table for what type of work';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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`),
+  KEY `config_id` (`config_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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)';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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)';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `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';
+
+--
+-- Constraints for dumped tables
+--
+
+--
+-- Constraints for table `build_jobs`
+--
+ALTER TABLE `build_jobs`
+  ADD CONSTRAINT `build_jobs_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`),
+  ADD CONSTRAINT `build_jobs_ibfk_2` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`);
+
+--
+-- Constraints for table `build_jobs_emerge_options`
+--
+ALTER TABLE `build_jobs_emerge_options`
+  ADD CONSTRAINT `build_jobs_emerge_options_ibfk_1` FOREIGN KEY (`build_job_id`) REFERENCES `build_jobs` (`build_job_id`),
+  ADD CONSTRAINT `build_jobs_emerge_options_ibfk_2` FOREIGN KEY (`eoption_id`) REFERENCES `emerge_options` (`eoption_id`);
+
+--
+-- Constraints for table `build_jobs_redo`
+--
+ALTER TABLE `build_jobs_redo`
+  ADD CONSTRAINT `build_jobs_redo_ibfk_1` FOREIGN KEY (`build_job_id`) REFERENCES `build_jobs` (`build_job_id`);
+
+--
+-- Constraints for table `build_jobs_use`
+--
+ALTER TABLE `build_jobs_use`
+  ADD CONSTRAINT `build_jobs_use_ibfk_1` FOREIGN KEY (`build_job_id`) REFERENCES `build_jobs` (`build_job_id`),
+  ADD CONSTRAINT `build_jobs_use_ibfk_2` FOREIGN KEY (`use_id`) REFERENCES `uses` (`use_id`);
+
+--
+-- Constraints for table `build_logs`
+--
+ALTER TABLE `build_logs`
+  ADD CONSTRAINT `build_logs_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`);
+
+--
+-- Constraints for table `build_logs_config`
+--
+ALTER TABLE `build_logs_config`
+  ADD CONSTRAINT `build_logs_config_ibfk_1` FOREIGN KEY (`build_log_id`) REFERENCES `build_logs` (`build_log_id`),
+  ADD CONSTRAINT `build_logs_config_ibfk_2` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`);
+
+--
+-- Constraints for table `build_logs_emerge_options`
+--
+ALTER TABLE `build_logs_emerge_options`
+  ADD CONSTRAINT `build_logs_emerge_options_ibfk_1` FOREIGN KEY (`build_logs_id`) REFERENCES `build_logs` (`build_log_id`),
+  ADD CONSTRAINT `build_logs_emerge_options_ibfk_2` FOREIGN KEY (`eoption_id`) REFERENCES `emerge_options` (`eoption_id`);
+
+--
+-- Constraints for table `build_logs_qa`
+--
+ALTER TABLE `build_logs_qa`
+  ADD CONSTRAINT `build_logs_qa_ibfk_1` FOREIGN KEY (`build_log_id`) REFERENCES `build_logs` (`build_log_id`);
+
+--
+-- Constraints for table `build_logs_repoman`
+--
+ALTER TABLE `build_logs_repoman`
+  ADD CONSTRAINT `build_logs_repoman_ibfk_1` FOREIGN KEY (`build_logs_id`) REFERENCES `build_logs` (`build_log_id`);
+
+--
+-- Constraints for table `build_logs_use`
+--
+ALTER TABLE `build_logs_use`
+  ADD CONSTRAINT `build_logs_use_ibfk_1` FOREIGN KEY (`build_log_id`) REFERENCES `build_logs` (`build_log_id`),
+  ADD CONSTRAINT `build_logs_use_ibfk_2` FOREIGN KEY (`use_id`) REFERENCES `uses` (`use_id`);
+
+--
+-- Constraints for table `configs_emerge_options`
+--
+ALTER TABLE `configs_emerge_options`
+  ADD CONSTRAINT `configs_emerge_options_ibfk_1` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`),
+  ADD CONSTRAINT `configs_emerge_options_ibfk_2` FOREIGN KEY (`eoption_id`) REFERENCES `emerge_options` (`eoption_id`);
+
+--
+-- Constraints for table `configs_metadata`
+--
+ALTER TABLE `configs_metadata`
+  ADD CONSTRAINT `configs_metadata_ibfk_1` FOREIGN KEY (`keyword_id`) REFERENCES `keywords` (`keyword_id`),
+  ADD CONSTRAINT `configs_metadata_ibfk_2` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`);
+
+--
+-- Constraints for table `ebuilds`
+--
+ALTER TABLE `ebuilds`
+  ADD CONSTRAINT `ebuilds_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_id`);
+
+--
+-- Constraints for table `ebuilds_iuse`
+--
+ALTER TABLE `ebuilds_iuse`
+  ADD CONSTRAINT `ebuilds_iuse_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`),
+  ADD CONSTRAINT `ebuilds_iuse_ibfk_2` FOREIGN KEY (`use_id`) REFERENCES `uses` (`use_id`);
+
+--
+-- Constraints for table `ebuilds_keywords`
+--
+ALTER TABLE `ebuilds_keywords`
+  ADD CONSTRAINT `ebuilds_keywords_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`),
+  ADD CONSTRAINT `ebuilds_keywords_ibfk_2` FOREIGN KEY (`keyword_id`) REFERENCES `keywords` (`keyword_id`);
+
+--
+-- Constraints for table `ebuilds_metadata`
+--
+ALTER TABLE `ebuilds_metadata`
+  ADD CONSTRAINT `ebuilds_metadata_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`);
+
+--
+-- Constraints for table `ebuilds_restrictions`
+--
+ALTER TABLE `ebuilds_restrictions`
+  ADD CONSTRAINT `ebuilds_restrictions_ibfk_1` FOREIGN KEY (`ebuild_id`) REFERENCES `ebuilds` (`ebuild_id`),
+  ADD CONSTRAINT `ebuilds_restrictions_ibfk_2` FOREIGN KEY (`restriction_id`) REFERENCES `restrictions` (`restriction_id`);
+
+--
+-- Constraints for table `jobs`
+--
+ALTER TABLE `jobs`
+  ADD CONSTRAINT `jobs_ibfk_1` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`),
+  ADD CONSTRAINT `jobs_ibfk_2` FOREIGN KEY (`run_config_id`) REFERENCES `configs` (`config_id`),
+  ADD CONSTRAINT `jobs_ibfk_3` FOREIGN KEY (`job_type_id`) REFERENCES `job_types` (`job_type_id`);
+
+--
+-- Constraints for table `logs`
+--
+ALTER TABLE `logs`
+  ADD CONSTRAINT `logs_ibfk_1` FOREIGN KEY (`config_id`) REFERENCES `configs` (`config_id`);
+
+--
+-- Constraints for table `packages`
+--
+ALTER TABLE `packages`
+  ADD CONSTRAINT `packages_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`category_id`),
+  ADD CONSTRAINT `packages_ibfk_2` FOREIGN KEY (`repo_id`) REFERENCES `repos` (`repo_id`);
+
+DELIMITER $$
+--
+-- Events
+--
 CREATE DEFINER=`zobcs`@`localhost` EVENT `add_esync_updatedb_jobs` ON SCHEDULE EVERY 1 HOUR STARTS '2012-12-23 17:15:13' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
   CALL add_jobs('esync');
   CALL add_jobs('updatedb');
-END$$
-
-DELIMITER ;
-
-/*!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 */;
+END$$
+
+DELIMITER ;
+
+/*!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 */;