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$$
