From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) by finch.gentoo.org (Postfix) with ESMTP id 80A8D138247 for ; Sun, 5 Jan 2014 10:29:17 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 18381E0ABB; Sun, 5 Jan 2014 10:29:16 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) (using TLSv1 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 892C3E0ABB for ; Sun, 5 Jan 2014 10:29:15 +0000 (UTC) Received: from hornbill.gentoo.org (hornbill.gentoo.org [94.100.119.163]) (using TLSv1 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTPS id 3474933F141 for ; Sun, 5 Jan 2014 10:29:14 +0000 (UTC) Received: from localhost.localdomain (localhost [127.0.0.1]) by hornbill.gentoo.org (Postfix) with ESMTP id 7BB71E54AB for ; Sun, 5 Jan 2014 10:29:12 +0000 (UTC) From: "Magnus Granberg" To: gentoo-commits@lists.gentoo.org Content-Transfer-Encoding: 8bit Content-type: text/plain; charset=UTF-8 Reply-To: gentoo-dev@lists.gentoo.org, "Magnus Granberg" Message-ID: <1388917658.9329979150c291f77fa2082f2235baf8426842e5.zorry@gentoo> Subject: [gentoo-commits] dev/zorry:master commit in: gobs/sql/, ebuild/dev-python/gobs/, ebuild/dev-python/gobs/files/, gobs/pym/, ... X-VCS-Repository: dev/zorry X-VCS-Files: ebuild/dev-python/gobs/files/zobcs_portage_Scheduler.patch ebuild/dev-python/gobs/files/zobcs_portage_actions.patch ebuild/dev-python/gobs/files/zobcs_portage_main.patch ebuild/dev-python/gobs/gobs-9999.ebuild gobs/doc/Setup.txt gobs/pym/build_log.py gobs/pym/mysql_querys.py gobs/pym/package.py gobs/sql/zobcs.sql X-VCS-Directories: gobs/sql/ ebuild/dev-python/gobs/ ebuild/dev-python/gobs/files/ gobs/pym/ gobs/doc/ X-VCS-Committer: zorry X-VCS-Committer-Name: Magnus Granberg X-VCS-Revision: 9329979150c291f77fa2082f2235baf8426842e5 X-VCS-Branch: master Date: Sun, 5 Jan 2014 10:29:12 +0000 (UTC) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-commits@lists.gentoo.org X-Archives-Salt: d42b71f6-3755-4c49-ad60-02fdcdae1195 X-Archives-Hash: 053d82b20648661323d9b13fead9b6ac commit: 9329979150c291f77fa2082f2235baf8426842e5 Author: Magnus Granberg gentoo org> AuthorDate: Sun Jan 5 10:27:38 2014 +0000 Commit: Magnus Granberg gentoo org> CommitDate: Sun Jan 5 10:27:38 2014 +0000 URL: http://git.overlays.gentoo.org/gitweb/?p=dev/zorry.git;a=commit;h=93299791 update ebuild, errors, dump of db and setup text --- .../gobs/files/zobcs_portage_Scheduler.patch | 6 + .../gobs/files/zobcs_portage_actions.patch | 41 +- .../dev-python/gobs/files/zobcs_portage_main.patch | 27 +- ebuild/dev-python/gobs/gobs-9999.ebuild | 15 +- gobs/doc/Setup.txt | 2 +- gobs/pym/build_log.py | 2 +- gobs/pym/mysql_querys.py | 4 +- gobs/pym/package.py | 24 +- gobs/sql/zobcs.sql | 1444 ++++++++++---------- 9 files changed, 798 insertions(+), 767 deletions(-) diff --git a/ebuild/dev-python/gobs/files/zobcs_portage_Scheduler.patch b/ebuild/dev-python/gobs/files/zobcs_portage_Scheduler.patch index df76a7b..fafc818 100644 --- a/ebuild/dev-python/gobs/files/zobcs_portage_Scheduler.patch +++ b/ebuild/dev-python/gobs/files/zobcs_portage_Scheduler.patch @@ -1,3 +1,9 @@ +2014-01-05 Magnus Granberg + + We copy Scheduler.py from portage and patch it. + Fix so we can use add_buildlog_main() + We use add_buildlog_main() for loging. + --- a/gobs/pym/Scheduler.py 2013-03-22 17:57:23.000000000 +0100 +++ b/gobs/pym/Scheduler.py 2012-12-21 02:09:28.082301168 +0100 @@ -62,6 +62,8 @@ from _emerge.PackageMerge import Package diff --git a/ebuild/dev-python/gobs/files/zobcs_portage_actions.patch b/ebuild/dev-python/gobs/files/zobcs_portage_actions.patch index 2244ae7..546073d 100644 --- a/ebuild/dev-python/gobs/files/zobcs_portage_actions.patch +++ b/ebuild/dev-python/gobs/files/zobcs_portage_actions.patch @@ -1,3 +1,10 @@ +2014-01-05 Magnus Granberg + + We copy action.py from portage and patch it. + Use the patched Scheduler and add build_dict so it can be uset. + We use or own mydepgraph (build_mydepgraph) that call backtrack_depgraph. + And pass unresolvable in action_depclean so we can use it later. + --- a/gobs/pym/actions.py 2013-03-22 17:57:23.000000000 +0100 +++ b/gobs/pym/actions.py 2013-03-22 19:00:43.265582143 +0100 @@ -72,7 +72,7 @@ from _emerge.MetadataRegen import Metada @@ -13,7 +20,7 @@ from _emerge.UseFlagDisplay import pkg_use_display from _emerge.userquery import userquery -+from gobs.build_depgraph import build_mydepgraph ++from gobs.build_depgraph import build_mydepgraph + if sys.hexversion >= 0x3000000: long = int @@ -107,7 +114,7 @@ - if unresolved_deps(): - return 1, [], False, 0 + return 1, [], False, 0, [] -+ unresolvable = unresolved_deps(): ++ unresolvable = unresolved_deps() + if not unresolvable is None: + return 1, [], False, 0, unresolvable @@ -133,21 +140,21 @@ def action_deselect(settings, trees, opts, atoms): enter_invalid = '--ask-enter-invalid' in opts -@@ -3508,7 +3504,7 @@ def repo_name_duplicate_check(trees): +@@ -3607,7 +3607,7 @@ def repo_name_duplicate_check(trees): return bool(ignored_repos) --def run_action(settings, trees, mtimedb, myaction, myopts, myfiles, -+def run_action(settings, trees, mtimedb, myaction, myopts, myfiles, build_dict, - gc_locals=None): - - # The caller may have its local variables garbage collected, so -@@ -3925,7 +3921,7 @@ def run_action(settings, trees, mtimedb, - if "--pretend" not in myopts: - display_news_notification(root_config, myopts) - retval = action_build(settings, trees, mtimedb, -- myopts, myaction, myfiles, spinner) -+ myopts, myaction, myfiles, spinner, build_dict) - post_emerge(myaction, myopts, myfiles, settings['EROOT'], - trees, mtimedb, retval) - +-def run_action(emerge_config): ++def run_action(emerge_config, build_dict): + + # skip global updates prior to sync, since it's called after sync + if emerge_config.action not in ('help', 'info', 'sync', 'version') and \ +@@ -4059,7 +4059,7 @@ def run_action(emerge_config): + retval = action_build(emerge_config.target_config.settings, + emerge_config.trees, emerge_config.target_config.mtimedb, + emerge_config.opts, emerge_config.action, +- emerge_config.args, spinner) ++ emerge_config.args, spinner, build_dict) + post_emerge(emerge_config.action, emerge_config.opts, + emerge_config.args, emerge_config.target_config.root, + emerge_config.trees, emerge_config.target_config.mtimedb, retval) diff --git a/ebuild/dev-python/gobs/files/zobcs_portage_main.patch b/ebuild/dev-python/gobs/files/zobcs_portage_main.patch index dc54b95..4031dbd 100644 --- a/ebuild/dev-python/gobs/files/zobcs_portage_main.patch +++ b/ebuild/dev-python/gobs/files/zobcs_portage_main.patch @@ -1,3 +1,9 @@ +2014-01-05 Magnus Granberg + + We copy main.py from portage and patch it. + Use or own patched actions. + We pass build_dict to some functions. + --- a/gobs/pym/main.py 2013-03-22 17:57:23.000000000 +0100 +++ b/gobs/pym/main.py 2012-12-06 03:32:56.104889716 +0100 @@ -11,7 +11,7 @@ portage.proxy.lazyimport.lazyimport(glob @@ -9,7 +15,7 @@ 'validate_ebuild_environment', '_emerge.help:help@emerge_help', ) -@@ -991,14 +966,19 @@ def profile_check(trees, myaction): +@@ -968,15 +968,20 @@ def profile_check(trees, myaction): return 1 return os.EX_OK @@ -24,16 +30,19 @@ if args is None: args = sys.argv[1:] + args = portage._decode_argv(args) ++ + if build_dict is None: + build_dict = {} -+ + # Disable color until we're sure that it should be enabled (after # EMERGE_DEFAULT_OPTS has been parsed). - portage.output.havecolor = 0 -@@ -1040,5 +1022,5 @@ def emerge_main(args=None): - tmpcmdline.extend(args) - myaction, myopts, myfiles = parse_opts(tmpcmdline) +@@ -1028,7 +1028,7 @@ def emerge_main(args=None): + parse_opts(tmpcmdline) -- return run_action(settings, trees, mtimedb, myaction, myopts, myfiles, -+ return run_action(settings, trees, mtimedb, myaction, myopts, myfiles, build_dict, - gc_locals=locals().clear) + try: +- return run_action(emerge_config) ++ return run_action(emerge_config, build_dict) + finally: + # Call destructors for our portdbapi instances. + for x in emerge_config.trees.values(): diff --git a/ebuild/dev-python/gobs/gobs-9999.ebuild b/ebuild/dev-python/gobs/gobs-9999.ebuild index c1cb510..878f222 100644 --- a/ebuild/dev-python/gobs/gobs-9999.ebuild +++ b/ebuild/dev-python/gobs/gobs-9999.ebuild @@ -1,12 +1,12 @@ -# Copyright 1999-2010 Gentoo Foundation +# Copyright 1999-2014 Gentoo Foundation # Distributed under the terms of the GNU General Public License v2 # $Header: $ -EAPI="2" -PYTHON_DEPEND="*:2.7" +EAPI="5" +PYTHON_COMPAT=( python{2_7, 3_2, 3_3} ) SUPPORT_PYTHON_ABIS="1" -inherit distutils git-2 eutils +inherit distutils-r1 git-2 DESCRIPTION="Gobs" HOMEPAGE="http://git.overlays.gentoo.org/gitroot/dev/zorry.git" @@ -17,14 +17,11 @@ SLOT="0" IUSE="+mysql" RDEPEND="sys-apps/portage - >=dev-python/git-python-0.3.2_rc1 mysql? ( dev-python/mysql-connector-python )" DEPEND="${RDEPEND} dev-python/setuptools" -# RESTRICT_PYTHON_ABIS="3.*" - EGIT_REPO_URI="http://git.overlays.gentoo.org/gitroot/dev/zorry.git" PYTHON_MODNAME="gobs" @@ -47,8 +44,8 @@ src_install() { doins ${FILESDIR}/gobs.conf || die dosbin ${S}/gobs/bin/gobs_host_jobs || die dosbin ${S}/gobs/bin/gobs_guest_jobs || die - dodoc ${S}/gobs/sql/pgdump.sql.gz || die + dodoc ${S}/gobs/sql/zobcs.sql || die dodoc ${S}/gobs/doc/Setup.txt || die - distutils_src_install + distutils-r1_src_install } diff --git a/gobs/doc/Setup.txt b/gobs/doc/Setup.txt index 3c01382..e88da72 100644 --- a/gobs/doc/Setup.txt +++ b/gobs/doc/Setup.txt @@ -1,6 +1,6 @@ 1. Setup the Backend Setup the gobs.conf for the db. Change GOBSGITREPONAME to point to the git repo with your configs for the profiles/setups. -Import the *dump.sql.gz to your sql. +Import the *zobcs.sql to your mysql. The portage/base/make.conf should be in the base profile/setup The porfiles dir need a dir call config with a parent file that point to base profile diff --git a/gobs/pym/build_log.py b/gobs/pym/build_log.py index 38e2e25..10b0d2e 100644 --- a/gobs/pym/build_log.py +++ b/gobs/pym/build_log.py @@ -189,7 +189,7 @@ def search_buildlog(conn, logfile_text): i = i + 1 adict = {} adict['hilight'] = hilight_tmp['hilight'] - new_hilight_dict[hilight_tmp[i] = adict + new_hilight_dict[hilight_tmp[i]] = adict elif index in new_hilight_dict: if new_hilight_dict[hilight_tmp[index]][['hilight'] == None: new_hilight_dict[hilight_tmp[index]][['hilight'] = hilight_tmp['hilight'] diff --git a/gobs/pym/mysql_querys.py b/gobs/pym/mysql_querys.py index b5c2953..e8f2073 100644 --- a/gobs/pym/mysql_querys.py +++ b/gobs/pym/mysql_querys.py @@ -166,7 +166,7 @@ def get_package_metadata_sql(connection, package_id): return entries[0] return None -def update_package_metadata((connection, package_metadataDict): +def update_package_metadata(connection, package_metadataDict): cursor = connection.cursor() sqlQ1 ='SELECT package_id FROM packages_metadata WHERE package_id = %s' sqlQ2 = 'UPDATE packages_metadata SET checksum = %s, email = %s, active = %s WHERE package_id = %s' @@ -406,7 +406,7 @@ def add_old_ebuild(connection, package_id, old_ebuild_list): sqlQ1 = "UPDATE ebuilds SET active = 'False' WHERE ebuild_id = %s" sqlQ3 = "SELECT build_job_id FROM build_jobs WHERE ebuild_id = %s" for ebuild_id in old_ebuild_list: - cursor.execute(sqlQ3, (ebuild_id)) + cursor.execute(sqlQ3, (ebuild_id),) build_job_id_list = cursor.fetchall() if build_job_id_list is not None: for build_job_id in build_job_id_list: diff --git a/gobs/pym/package.py b/gobs/pym/package.py index 12f1afa..a287826 100644 --- a/gobs/pym/package.py +++ b/gobs/pym/package.py @@ -9,7 +9,7 @@ from gobs.mysql_querys import get_config, get_config_id, add_gobs_logs, get_defa add_new_build_job, get_config_id_list, update_manifest_sql, add_new_manifest_sql, \ add_new_ebuild_sql, get_ebuild_id_db, add_old_ebuild, get_ebuild_id_list, \ get_ebuild_checksum, get_manifest_db, get_cp_repo_from_package_id, \ - get_cp_from_package_id + get_cp_from_package_id, get_package_metadata_sql, update_package_metadata from gobs.readconf import get_conf_settings reader=get_conf_settings() gobs_settings_dict=reader.read_gobs_settings_all() @@ -160,15 +160,25 @@ class gobs_package(object): package_metadataDict = {} # changelog_checksum_tree = portage.checksum.sha256hash(pkgdir + "/ChangeLog") # changelog_text_tree = get_file_text(pkgdir + "/ChangeLog") - pkg_md = MetaDataXMLpkgdir + "/metadata.xml") + herd = None + pkg_md = MetaDataXML(pkgdir + "/metadata.xml", herd) #metadata_xml_text_tree = get_file_text(pkgdir + "/metadata.xml") # attDict['changelog_checksum'] = changelog_checksum_tree[0] # attDict['changelog_text'] = changelog_text_tree - # attDict['metadata_xml_herds'] = pkg_md.herds() + tmp_herds = pkg_md.herds() + if tmp_herds == (): + attDict['metadata_xml_herds'] = 'none' + else: + attDict['metadata_xml_herds'] = tmp_herds[0] md_email_list = [] for maint in pkg_md.maintainers(): md_email_list.append(maint.email) - attDict['metadata_xml_email'] = md_email_list + if md_email_list == []: + if tmp_herds == (): + log_msg = "Metadata file %s missing Email" % (pkgdir + "/metadata.xml") + add_gobs_logs(self._conn, log_msg, "qa", self._config_id) + md_email_list.append(attDict['metadata_xml_herds'] + '@gentoo.org') + attDict['metadata_xml_email'] = md_email_list attDict['metadata_xml_checksum'] = portage.checksum.sha256hash(pkgdir + "/metadata.xml")[0] #attDict['metadata_xml_text'] = metadata_xml_text_tree package_metadataDict[package_id] = attDict @@ -189,7 +199,7 @@ class gobs_package(object): add_old_ebuild(self._conn, package_id, old_ebuild_id_list) package_metadata_checksum_sql = get_package_metadata_sql(self._conn, package_id) - if package_metadata_checksum_sql is None or package_metadata_checksum_sql != package_metadataDict['package_id']['metadata_xml_checksum']: + if package_metadata_checksum_sql is None or package_metadata_checksum_sql != package_metadataDict[package_id]['metadata_xml_checksum']: update_package_metadata(self._conn, package_metadataDict) # update the cp manifest checksum @@ -226,7 +236,7 @@ class gobs_package(object): return package_id = add_new_manifest_sql(self._conn, cp, repo) - package_metadataDict = get_package_metadataDict(self, pkgdir, package_id) + package_metadataDict = self.get_package_metadataDict(pkgdir, package_id) # Get the ebuild list for cp mytree = [] mytree.append(repodir) @@ -329,7 +339,7 @@ class gobs_package(object): # Remove cpv from packageDict and add ebuild to new ebuils list del packageDict[cpv] new_ebuild_id_list.append(get_ebuild_id_db(self._conn, ebuild_version_checksum_tree, package_id)[0]) - package_metadataDict = get_package_metadataDict(self, pkgdir, package_id) + package_metadataDict = self.get_package_metadataDict(pkgdir, package_id) self.add_package(packageDict, package_metadataDict, package_id, new_ebuild_id_list, old_ebuild_id_list, manifest_checksum_tree) log_msg = "C %s:%s ... Done." % (cp, repo) diff --git a/gobs/sql/zobcs.sql b/gobs/sql/zobcs.sql index a87136c..2d1090e 100644 --- a/gobs/sql/zobcs.sql +++ b/gobs/sql/zobcs.sql @@ -1,32 +1,31 @@ --- phpMyAdmin SQL Dump --- version 3.5.2.2 --- http://www.phpmyadmin.net --- --- Host: localhost --- Generation Time: Apr 25, 2013 at 12:32 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 --- -DROP PROCEDURE IF EXISTS `add_jobs`$$ -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: Jan 05, 2014 at 10:19 AM +-- Server version: 5.5.32-MariaDB-log +-- PHP Version: 5.4.23-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; @@ -45,698 +44,701 @@ 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` --- - -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`), - 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' AUTO_INCREMENT=23547 ; - --- -------------------------------------------------------- - --- --- 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, - KEY `build_job_id` (`build_job_id`), - KEY `eoption_id` (`eoption_id`) -) 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(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` --- - -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, - KEY `build_job_id` (`build_job_id`), - KEY `use_id` (`use_id`) -) 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 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' AUTO_INCREMENT=19591 ; - --- -------------------------------------------------------- - --- --- Table structure for table `build_logs_config` --- - -DROP TABLE IF EXISTS `build_logs_config`; -CREATE TABLE IF NOT EXISTS `build_logs_config` ( - `log_id` int(11) NOT NULL AUTO_INCREMENT, - `build_log_id` int(11) NOT NULL, - `config_id` int(11) NOT NULL, - `logname` varchar(150) NOT NULL COMMENT 'filename of the log', - PRIMARY KEY (`log_id`), - KEY `config_id` (`config_id`), - KEY `build_log_id` (`build_log_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19636 ; - --- -------------------------------------------------------- - --- --- 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_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_errors` --- - -DROP TABLE IF EXISTS `build_logs_errors`; -CREATE TABLE IF NOT EXISTS `build_logs_errors` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `build_log_id` int(11) NOT NULL, - `error_id` int(11) NOT NULL, - PRIMARY KEY (`id`), - KEY `build_log_id` (`build_log_id`), - KEY `error_id` (`error_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; - --- -------------------------------------------------------- - --- --- Table structure for table `build_logs_hilight` --- - -DROP TABLE IF EXISTS `build_logs_hilight`; -CREATE TABLE IF NOT EXISTS `build_logs_hilight` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `log_id` int(11) NOT NULL, - `start_line` int(11) NOT NULL, - `end_line` int(11) NOT NULL, - `hilight_css_id` int(11) NOT NULL, - PRIMARY KEY (`id`), - KEY `log_id` (`log_id`), - KEY `hilight_id` (`hilight_css_id`), - KEY `hilight_css_id` (`hilight_css_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=110809 ; - --- -------------------------------------------------------- - --- --- 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, - KEY `build_log_id` (`build_log_id`) -) 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_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` --- - -DROP TABLE IF EXISTS `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` --- - -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=160 ; - --- -------------------------------------------------------- - --- --- 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', - `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' 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`), - KEY `eoption_id` (`eoption_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, - `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` --- - -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=69287 ; - --- -------------------------------------------------------- - --- --- 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, - KEY `ebuild_id` (`ebuild_id`), - KEY `use_id` (`use_id`) -) 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, - KEY `ebuild_id` (`ebuild_id`), - KEY `keyword_id` (`keyword_id`) -) 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', - KEY `ebuild_id` (`ebuild_id`) -) 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, - KEY `ebuild_id` (`ebuild_id`), - KEY `restriction_id` (`restriction_id`) -) 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 `errors` --- - -DROP TABLE IF EXISTS `errors`; -CREATE TABLE IF NOT EXISTS `errors` ( - `error_id` int(11) NOT NULL AUTO_INCREMENT, - `error_name` varchar(10) NOT NULL, - `error_search` varchar(20) NOT NULL, - PRIMARY KEY (`error_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; - --- -------------------------------------------------------- - --- --- Table structure for table `hilight` --- - -DROP TABLE IF EXISTS `hilight`; -CREATE TABLE IF NOT EXISTS `hilight` ( - `hilight_id` int(11) NOT NULL AUTO_INCREMENT, - `hilight_search` varchar(30) NOT NULL, - `hilight_search_end` varchar(30) NOT NULL, - `hilight_css_id` int(11) NOT NULL, - `hilight_start` int(11) NOT NULL, - `hilight_end` int(11) NOT NULL, - PRIMARY KEY (`hilight_id`), - KEY `hilight_css_id` (`hilight_css_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ; - --- -------------------------------------------------------- - --- --- Table structure for table `hilight_css` --- - -DROP TABLE IF EXISTS `hilight_css`; -CREATE TABLE IF NOT EXISTS `hilight_css` ( - `hilight_css_id` int(11) NOT NULL AUTO_INCREMENT, - `hilight_css_name` varchar(11) NOT NULL, - `hilight_css_collor` varchar(10) NOT NULL, - PRIMARY KEY (`hilight_css_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; - --- -------------------------------------------------------- - --- --- 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_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 AUTO_INCREMENT=4 ; - --- -------------------------------------------------------- - --- --- Table structure for table `job_types` --- - -DROP TABLE IF EXISTS `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' AUTO_INCREMENT=3 ; - --- -------------------------------------------------------- - --- --- 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`), - KEY `config_id` (`config_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=892335 ; - --- -------------------------------------------------------- - --- --- 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=16842 ; - --- -------------------------------------------------------- - --- --- 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=35 ; - --- -------------------------------------------------------- - --- --- 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=4875 ; - --- --- 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_errors` --- -ALTER TABLE `build_logs_errors` - ADD CONSTRAINT `build_logs_errors_ibfk_2` FOREIGN KEY (`error_id`) REFERENCES `errors` (`error_id`), - ADD CONSTRAINT `build_logs_errors_ibfk_1` FOREIGN KEY (`build_log_id`) REFERENCES `build_logs` (`build_log_id`); - --- --- Constraints for table `build_logs_hilight` --- -ALTER TABLE `build_logs_hilight` - ADD CONSTRAINT `build_logs_hilight_ibfk_5` FOREIGN KEY (`log_id`) REFERENCES `build_logs_config` (`log_id`), - ADD CONSTRAINT `build_logs_hilight_ibfk_4` FOREIGN KEY (`hilight_css_id`) REFERENCES `hilight_css` (`hilight_css_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 `hilight` --- -ALTER TABLE `hilight` - ADD CONSTRAINT `hilight_ibfk_1` FOREIGN KEY (`hilight_css_id`) REFERENCES `hilight_css` (`hilight_css_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 --- -DROP EVENT `add_esync_updatedb_jobs`$$ +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, + `bug_id` int(10) NOT NULL DEFAULT '0', + `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` ( + `log_id` int(11) NOT NULL AUTO_INCREMENT, + `build_log_id` int(11) NOT NULL, + `config_id` int(11) NOT NULL, + `einfo_id` int(11) NOT NULL DEFAULT '1', + `logname` varchar(150) NOT NULL COMMENT 'filename of the log', + `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + PRIMARY KEY (`log_id`), + KEY `config_id` (`config_id`), + KEY `build_log_id` (`build_log_id`), + KEY `einfo_id` (`einfo_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_errors` +-- + +CREATE TABLE IF NOT EXISTS `build_logs_errors` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `build_log_id` int(11) NOT NULL, + `error_id` int(11) NOT NULL, + PRIMARY KEY (`id`), + KEY `build_log_id` (`build_log_id`), + KEY `error_id` (`error_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `build_logs_hilight` +-- + +CREATE TABLE IF NOT EXISTS `build_logs_hilight` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `log_id` int(11) NOT NULL, + `start_line` int(11) NOT NULL, + `end_line` int(11) NOT NULL, + `hilight_css_id` int(11) NOT NULL, + PRIMARY KEY (`id`), + KEY `log_id` (`log_id`), + KEY `hilight_id` (`hilight_css_id`), + KEY `hilight_css_id` (`hilight_css_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_info` +-- + +CREATE TABLE IF NOT EXISTS `emerge_info` ( + `einfo_id` int(11) NOT NULL AUTO_INCREMENT, + `checksum` varchar(30) NOT NULL, + `emerge_info_text` text NOT NULL, + UNIQUE KEY `einfo_id` (`einfo_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 `errors_info` +-- + +CREATE TABLE IF NOT EXISTS `errors_info` ( + `error_id` int(11) NOT NULL AUTO_INCREMENT, + `error_name` varchar(10) NOT NULL, + `error_search` varchar(20) NOT NULL, + PRIMARY KEY (`error_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `hilight` +-- + +CREATE TABLE IF NOT EXISTS `hilight` ( + `hilight_id` int(11) NOT NULL AUTO_INCREMENT, + `hilight_search` varchar(30) NOT NULL, + `hilight_search_end` varchar(30) NOT NULL, + `hilight_css_id` int(11) NOT NULL, + `hilight_start` int(11) NOT NULL, + `hilight_end` int(11) NOT NULL, + PRIMARY KEY (`hilight_id`), + KEY `hilight_css_id` (`hilight_css_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `hilight_css` +-- + +CREATE TABLE IF NOT EXISTS `hilight_css` ( + `hilight_css_id` int(11) NOT NULL AUTO_INCREMENT, + `hilight_css_name` varchar(11) NOT NULL, + `hilight_css_collor` varchar(10) NOT NULL, + PRIMARY KEY (`hilight_css_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','qa') 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 `packages_metadata` +-- + +CREATE TABLE IF NOT EXISTS `packages_metadata` ( + `package_id` int(11) NOT NULL, + `email` varchar(50) NOT NULL, + `checksum` varchar(100) NOT NULL, + KEY `package_id` (`package_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- 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_3` FOREIGN KEY (`einfo_id`) REFERENCES `emerge_info` (`einfo_id`), + 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_errors` +-- +ALTER TABLE `build_logs_errors` + ADD CONSTRAINT `build_logs_errors_ibfk_1` FOREIGN KEY (`build_log_id`) REFERENCES `build_logs` (`build_log_id`), + ADD CONSTRAINT `build_logs_errors_ibfk_2` FOREIGN KEY (`error_id`) REFERENCES `errors_info` (`error_id`); + +-- +-- Constraints for table `build_logs_hilight` +-- +ALTER TABLE `build_logs_hilight` + ADD CONSTRAINT `build_logs_hilight_ibfk_4` FOREIGN KEY (`hilight_css_id`) REFERENCES `hilight_css` (`hilight_css_id`), + ADD CONSTRAINT `build_logs_hilight_ibfk_5` FOREIGN KEY (`log_id`) REFERENCES `build_logs_config` (`log_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 `hilight` +-- +ALTER TABLE `hilight` + ADD CONSTRAINT `hilight_ibfk_1` FOREIGN KEY (`hilight_css_id`) REFERENCES `hilight_css` (`hilight_css_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`); + +-- +-- Constraints for table `packages_metadata` +-- +ALTER TABLE `packages_metadata` + ADD CONSTRAINT `packages_metadata_ibfk_1` FOREIGN KEY (`package_id`) REFERENCES `packages` (`package_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 */;