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

[Magnus Granberg]

commit:     e2a967980a4f71a2abbc925b301cc41b75599782
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Sun Jan 31 14:14:03 2016 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Sun Jan 31 14:14:03 2016 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=e2a96798

update config and sql structure

 conf/tbc.conf          | 4 ++++
 sql/structure_dump.sql | 8 +++-----
 2 files changed, 7 insertions(+), 5 deletions(-)

diff --git a/conf/tbc.conf b/conf/tbc.conf
index 88fb9ec..d1254f3 100644
--- a/conf/tbc.conf
+++ b/conf/tbc.conf
@@ -8,4 +8,8 @@ SQLHOST=localhost
 SQLUSER=buildhost
 # Sql Password
 SQLPASSWD=buildhost
+# loging level
+#LOG=INFO
+# logfile
+#LOGFILE=/var/log/tbc.log
 

diff --git a/sql/structure_dump.sql b/sql/structure_dump.sql
index 55b5041..194c8ee 100644
--- a/sql/structure_dump.sql
+++ b/sql/structure_dump.sql
@@ -3,7 +3,7 @@
 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
--- Generation Time: Dec 27, 2015 at 10:25 PM
+-- Generation Time: Jan 31, 2016 at 01:39 PM
 -- Server version: 10.0.22-MariaDB-log
 -- PHP Version: 5.6.16-pl0-gentoo
 
@@ -460,7 +460,6 @@ CREATE TABLE IF NOT EXISTS `packages` (
   `category_id` int(11) NOT NULL,
   `package` varchar(50) NOT NULL,
   `repo_id` int(11) NOT NULL,
-  `checksum` varchar(100) NOT NULL,
   `active` tinyint(1) NOT NULL,
   `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Packages main table (P)';
@@ -737,7 +736,7 @@ ALTER TABLE `logs`
 -- Indexes for table `packages`
 --
 ALTER TABLE `packages`
- ADD PRIMARY KEY (`package_id`), ADD KEY `category_id` (`category_id`), ADD KEY `repo_id` (`repo_id`), ADD KEY `checksum` (`checksum`), ADD KEY `package` (`package`);
+ ADD PRIMARY KEY (`package_id`), ADD KEY `category_id` (`category_id`), ADD KEY `repo_id` (`repo_id`), ADD KEY `package` (`package`);
 
 --
 -- Indexes for table `packages_emails`
@@ -979,8 +978,7 @@ 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$$