[gentoo-commits] proj/tinderbox-cluster:master commit in: sql/

[Magnus Granberg]

commit:     f537c2e91bc998a49122bbbe2318e20856295319
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Mon Dec 28 21:21:16 2015 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Mon Dec 28 21:21:16 2015 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=f537c2e9

update the sql structure

 sql/structure_dump.sql | 50 +++++++++++++++++++++++++++++++++++++-------------
 1 file changed, 37 insertions(+), 13 deletions(-)

diff --git a/sql/structure_dump.sql b/sql/structure_dump.sql
index cb1b30f..55b5041 100644
--- a/sql/structure_dump.sql
+++ b/sql/structure_dump.sql
@@ -3,9 +3,9 @@
 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
--- Generation Time: Jul 21, 2015 at 03:29 PM
--- Server version: 10.0.15-MariaDB-log
--- PHP Version: 5.6.10-pl0-gentoo
+-- Generation Time: Dec 27, 2015 at 10:25 PM
+-- Server version: 10.0.22-MariaDB-log
+-- PHP Version: 5.6.16-pl0-gentoo
 
 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
 SET time_zone = "+00:00";
@@ -31,9 +31,9 @@ BEGIN
   DECLARE in_job_id INT;
   SET in_config_id = (SELECT config_id
     FROM configs WHERE default_config = True);
-  SET in_job_id = (SELECT job_id FROM jobs 
+  SET in_job_id = (SELECT job_id FROM jobs
     WHERE job_type = 'esync'
-    AND config_id = in_config_id 
+    AND config_id = in_config_id
     AND status = 'Done'
     LIMIT 1);
   IF in_job_id >= 1 THEN
@@ -111,8 +111,6 @@ CREATE TABLE IF NOT EXISTS `build_logs` (
 `build_log_id` int(11) NOT NULL,
   `ebuild_id` int(11) NOT NULL,
   `fail` tinyint(1) NOT NULL DEFAULT '0',
-  `rmqa` tinyint(1) NOT NULL,
-  `others` tinyint(1) NOT NULL,
   `summery_text` longtext NOT NULL,
   `log_hash` varchar(100) NOT NULL,
   `bug_id` int(10) NOT NULL DEFAULT '0',
@@ -320,7 +318,8 @@ CREATE TABLE IF NOT EXISTS `ebuilds_keywords` (
 CREATE TABLE IF NOT EXISTS `ebuilds_metadata` (
 `id` int(11) NOT NULL,
   `ebuild_id` int(11) NOT NULL,
-  `revision` varchar(10) NOT NULL COMMENT 'CVS revision',
+  `commit` varchar(100) NOT NULL COMMENT 'Git commit',
+  `New` tinyint(1) NOT NULL,
   `descriptions` varchar(200) NOT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -487,9 +486,22 @@ CREATE TABLE IF NOT EXISTS `packages_emails` (
 CREATE TABLE IF NOT EXISTS `packages_metadata` (
 `id` int(11) NOT NULL,
   `package_id` int(11) NOT NULL,
-  `checksum` varchar(100) NOT NULL,
-  `checksum_chlog` varchar(100) NOT NULL,
-  `changlog` text NOT NULL
+  `gitlog` text NOT NULL,
+  `descriptions` text NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `packages_repoman`
+--
+
+CREATE TABLE IF NOT EXISTS `packages_repoman` (
+`id` int(11) NOT NULL,
+  `package_id` int(11) NOT NULL,
+  `repoman_hash` varchar(100) NOT NULL,
+  `repoman_text` text NOT NULL,
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
@@ -665,7 +677,7 @@ ALTER TABLE `ebuilds_metadata`
 -- Indexes for table `ebuilds_restrictions`
 --
 ALTER TABLE `ebuilds_restrictions`
- ADD PRIMARY KEY (`id`), ADD KEY `ebuild_id` (`ebuild_id`), ADD KEY `restriction_id` (`restriction_id`);
+ ADD PRIMARY KEY (`id`), ADD KEY `restriction_id` (`restriction_id`), ADD KEY `ebuild_id` (`ebuild_id`);
 
 --
 -- Indexes for table `emails`
@@ -740,6 +752,12 @@ ALTER TABLE `packages_metadata`
  ADD PRIMARY KEY (`id`), ADD KEY `package_id` (`package_id`);
 
 --
+-- Indexes for table `packages_repoman`
+--
+ALTER TABLE `packages_repoman`
+ ADD PRIMARY KEY (`id`);
+
+--
 -- Indexes for table `repos`
 --
 ALTER TABLE `repos`
@@ -933,6 +951,11 @@ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 ALTER TABLE `packages_metadata`
 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
+-- AUTO_INCREMENT for table `packages_repoman`
+--
+ALTER TABLE `packages_repoman`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+--
 -- AUTO_INCREMENT for table `repos`
 --
 ALTER TABLE `repos`
@@ -956,7 +979,8 @@ DELIMITER $$
 --
 -- Events
 --
-CREATE DEFINER=`tbc`@`localhost` EVENT `add_esync_jobs` ON SCHEDULE EVERY 30 MINUTE STARTS '2012-12-23 17:15:13' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
+CREATE DEFINER=`tbc`@`localhost` EVENT `add_esync_jobs` ON SCHEDULE EVERY 30 MINUTE STARTS '2012-12-23 17:15:13' ON COMPLETION NOT PRESERVE ENABLE DO
+BEGIN
   CALL add_jobs_esync();
 END$$