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

public inbox for gentoo-commits@lists.gentoo.org
 help / color / mirror / Atom feed

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2015-04-18 20:50 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2015-04-18 20:50 UTC (permalink / raw
  To: gentoo-commits

commit:     c7b21ba441075d3ee5e78702337781e292ac6621
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Sat Apr 18 20:49:56 2015 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Sat Apr 18 20:49:56 2015 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=c7b21ba4

add the structure dump of the sql

 sql/structure_dump.sql | 961 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 961 insertions(+)

diff --git a/sql/structure_dump.sql b/sql/structure_dump.sql
new file mode 100644
index 0000000..5fe548b
--- /dev/null
+++ b/sql/structure_dump.sql
@@ -0,0 +1,961 @@
+-- phpMyAdmin SQL Dump
+-- version 4.2.13
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Apr 18, 2015 at 08:31 PM
+-- Server version: 10.0.15-MariaDB-log
+-- PHP Version: 5.6.5-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: `tbc`
+--
+
+DELIMITER $$
+--
+-- Procedures
+--
+CREATE DEFINER=`tbc`@`localhost` PROCEDURE `add_jobs_esync`()
+    MODIFIES SQL DATA
+BEGIN
+  DECLARE in_config_id INT;
+  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 
+    WHERE job_type = 'esync'
+    AND config_id = in_config_id 
+    AND status = 'Done'
+    LIMIT 1);
+  IF in_job_id >= 1 THEN
+    UPDATE jobs SET user = 'cron', status = 'Waiting' WHERE job_type = 'esync';
+  ELSE
+  	SET in_job_id = 0;
+  END IF;
+END$$
+
+DELIMITER ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_jobs`
+--
+
+CREATE TABLE IF NOT EXISTS `build_jobs` (
+`build_job_id` int(11) NOT NULL,
+  `ebuild_id` int(11) NOT NULL,
+  `setup_id` int(11) NOT NULL,
+  `config_id` int(11) NOT NULL,
+  `status` enum('Waiting','Building','Looked') NOT NULL DEFAULT 'Waiting',
+  `build_now` tinyint(1) NOT NULL DEFAULT '0',
+  `removebin` tinyint(1) NOT NULL,
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
+) ENGINE=MyISAM AUTO_INCREMENT=1325 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` (
+`id` int(11) NOT NULL,
+  `build_job_id` int(11) NOT NULL,
+  `eoption_id` int(11) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_jobs_redo`
+--
+
+CREATE TABLE IF NOT EXISTS `build_jobs_redo` (
+`id` int(11) NOT NULL,
+  `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'
+) ENGINE=MyISAM 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` (
+`id` int(11) NOT NULL,
+  `build_job_id` int(11) NOT NULL,
+  `use_id` int(11) NOT NULL,
+  `status` tinyint(1) NOT NULL DEFAULT '0'
+) ENGINE=MyISAM AUTO_INCREMENT=6067 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs`
+--
+
+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',
+  `summery_text` longtext 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
+) ENGINE=MyISAM AUTO_INCREMENT=15154 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,
+  `build_log_id` int(11) NOT NULL,
+  `config_id` int(11) NOT NULL,
+  `einfo_id` int(11) NOT NULL,
+  `logname` varchar(150) NOT NULL COMMENT 'filename of the log',
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
+) ENGINE=MyISAM AUTO_INCREMENT=41689 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_emerge_options`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs_emerge_options` (
+`id` int(11) NOT NULL,
+  `build_logs_id` int(11) NOT NULL,
+  `eoption_id` int(11) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_errors`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs_errors` (
+`id` int(11) NOT NULL,
+  `build_log_id` int(11) NOT NULL,
+  `error_id` int(11) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=2616 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_hilight`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs_hilight` (
+`id` int(11) NOT NULL,
+  `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
+) ENGINE=MyISAM AUTO_INCREMENT=350435 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_qa`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs_qa` (
+`id` int(11) NOT NULL,
+  `build_log_id` int(11) NOT NULL,
+  `summery_text` text NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_repoman`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs_repoman` (
+`id` int(11) NOT NULL,
+  `build_logs_id` int(11) NOT NULL,
+  `summery_text` text NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `build_logs_use`
+--
+
+CREATE TABLE IF NOT EXISTS `build_logs_use` (
+`id` int(11) NOT NULL,
+  `build_log_id` int(11) NOT NULL,
+  `use_id` int(11) NOT NULL,
+  `status` tinyint(1) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=66200 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `categories`
+--
+
+CREATE TABLE IF NOT EXISTS `categories` (
+`category_id` int(11) NOT NULL,
+  `category` varchar(50) NOT NULL,
+  `active` tinyint(1) NOT NULL DEFAULT '0',
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
+) ENGINE=MyISAM AUTO_INCREMENT=181 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 COMMENT 'Config index',
+  `hostname` varchar(50) NOT NULL,
+  `setup_id` int(11) NOT NULL COMMENT 'setup',
+  `default_config` tinyint(1) NOT NULL COMMENT 'Host setup'
+) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Main config table';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `configs_emerge_options`
+--
+
+CREATE TABLE IF NOT EXISTS `configs_emerge_options` (
+`id` int(11) NOT NULL,
+  `config_id` int(11) NOT NULL COMMENT 'config id',
+  `eoption_id` int(11) NOT NULL COMMENT 'emerge option id'
+) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='Emerge command options for the configs';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `configs_metadata`
+--
+
+CREATE TABLE IF NOT EXISTS `configs_metadata` (
+`id` int(11) NOT NULL,
+  `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,
+  `configsync` tinyint(1) NOT NULL,
+  `active` tinyint(1) NOT NULL,
+  `config_error_text` text NOT NULL,
+  `updateing` tinyint(1) NOT NULL,
+  `status` enum('Waiting','Runing','Stoped') NOT NULL,
+  `auto` tinyint(1) 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
+) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Config Status';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds`
+--
+
+CREATE TABLE IF NOT EXISTS `ebuilds` (
+`ebuild_id` int(11) NOT NULL,
+  `package_id` int(11) NOT NULL,
+  `version` varchar(50) NOT NULL,
+  `checksum` varchar(100) NOT NULL,
+  `active` tinyint(1) NOT NULL DEFAULT '0',
+  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
+) ENGINE=MyISAM AUTO_INCREMENT=78536 DEFAULT CHARSET=utf8 COMMENT='Version main table (V)';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds_iuse`
+--
+
+CREATE TABLE IF NOT EXISTS `ebuilds_iuse` (
+`id` int(11) NOT NULL,
+  `ebuild_id` int(11) NOT NULL,
+  `use_id` int(11) NOT NULL,
+  `status` tinyint(1) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=427416 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds_keywords`
+--
+
+CREATE TABLE IF NOT EXISTS `ebuilds_keywords` (
+`id` int(11) NOT NULL,
+  `ebuild_id` int(11) NOT NULL,
+  `keyword_id` int(11) NOT NULL,
+  `status` enum('Stable','Unstable','Negative') NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=532825 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds_metadata`
+--
+
+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'
+) ENGINE=MyISAM AUTO_INCREMENT=78536 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ebuilds_restrictions`
+--
+
+CREATE TABLE IF NOT EXISTS `ebuilds_restrictions` (
+`id` int(11) NOT NULL,
+  `ebuild_id` int(11) NOT NULL,
+  `restriction_id` int(11) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=13453 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `emails`
+--
+
+CREATE TABLE IF NOT EXISTS `emails` (
+`email_id` int(11) NOT NULL,
+  `email` varchar(150) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=675 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `emerge_info`
+--
+
+CREATE TABLE IF NOT EXISTS `emerge_info` (
+`einfo_id` int(11) NOT NULL,
+  `emerge_info_text` text NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=16164 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `emerge_options`
+--
+
+CREATE TABLE IF NOT EXISTS `emerge_options` (
+`eoption_id` int(11) NOT NULL COMMENT 'emerge command options id',
+  `eoption` varchar(15) NOT NULL COMMENT 'emerge command options'
+) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `errors_info`
+--
+
+CREATE TABLE IF NOT EXISTS `errors_info` (
+`error_id` int(11) NOT NULL,
+  `error_name` varchar(10) NOT NULL,
+  `error_search` varchar(20) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `hilight`
+--
+
+CREATE TABLE IF NOT EXISTS `hilight` (
+`hilight_id` int(11) NOT NULL,
+  `hilight_search` varchar(30) NOT NULL,
+  `hilight_search_end` varchar(30) NOT NULL,
+  `hilight_search_pattern` varchar(30) NOT NULL,
+  `hilight_css_id` int(11) NOT NULL,
+  `hilight_start` int(11) NOT NULL,
+  `hilight_end` int(11) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `hilight_css`
+--
+
+CREATE TABLE IF NOT EXISTS `hilight_css` (
+`hilight_css_id` int(11) NOT NULL,
+  `hilight_css_name` varchar(11) NOT NULL,
+  `hilight_css_collor` varchar(10) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `jobs`
+--
+
+CREATE TABLE IF NOT EXISTS `jobs` (
+`job_id` int(11) NOT NULL,
+  `job_type` enum('esync','updatedb') 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
+) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `keywords`
+--
+
+CREATE TABLE IF NOT EXISTS `keywords` (
+`keyword_id` int(11) NOT NULL COMMENT 'keyword index',
+  `keyword` varchar(15) NOT NULL COMMENT 'keyword'
+) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='KEYWORD';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `logs`
+--
+
+CREATE TABLE IF NOT EXISTS `logs` (
+`log_id` int(11) NOT NULL,
+  `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
+) ENGINE=MyISAM AUTO_INCREMENT=9536253 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `packages`
+--
+
+CREATE TABLE IF NOT EXISTS `packages` (
+`package_id` int(11) NOT NULL,
+  `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 AUTO_INCREMENT=18476 DEFAULT CHARSET=utf8 COMMENT='Packages main table (P)';
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `packages_emails`
+--
+
+CREATE TABLE IF NOT EXISTS `packages_emails` (
+`id` int(11) NOT NULL,
+  `package_id` int(11) NOT NULL,
+  `email_id` int(11) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=22297 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `packages_metadata`
+--
+
+CREATE TABLE IF NOT EXISTS `packages_metadata` (
+`id` int(11) NOT NULL,
+  `package_id` int(11) NOT NULL,
+  `checksum` varchar(100) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=18475 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `repos`
+--
+
+CREATE TABLE IF NOT EXISTS `repos` (
+`repo_id` int(11) NOT NULL,
+  `repo` varchar(100) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=3 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,
+  `restriction` varchar(50) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `setups`
+--
+
+CREATE TABLE IF NOT EXISTS `setups` (
+`setup_id` int(11) NOT NULL,
+  `setup` varchar(100) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `uses`
+--
+
+CREATE TABLE IF NOT EXISTS `uses` (
+`use_id` int(11) NOT NULL,
+  `flag` varchar(50) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=6153 DEFAULT CHARSET=utf8 COMMENT='Use flags main table';
+
+--
+-- Indexes for dumped tables
+--
+
+--
+-- Indexes for table `build_jobs`
+--
+ALTER TABLE `build_jobs`
+ ADD PRIMARY KEY (`build_job_id`), ADD KEY `ebuild_id` (`ebuild_id`), ADD KEY `config_id` (`config_id`), ADD KEY `time_stamp` (`time_stamp`);
+
+--
+-- Indexes for table `build_jobs_emerge_options`
+--
+ALTER TABLE `build_jobs_emerge_options`
+ ADD PRIMARY KEY (`id`), ADD KEY `build_job_id` (`build_job_id`), ADD KEY `eoption_id` (`eoption_id`);
+
+--
+-- Indexes for table `build_jobs_redo`
+--
+ALTER TABLE `build_jobs_redo`
+ ADD PRIMARY KEY (`id`), ADD KEY `build_job_id` (`build_job_id`);
+
+--
+-- Indexes for table `build_jobs_use`
+--
+ALTER TABLE `build_jobs_use`
+ ADD PRIMARY KEY (`id`), ADD KEY `build_job_id` (`build_job_id`), ADD KEY `use_id` (`use_id`);
+
+--
+-- Indexes for table `build_logs`
+--
+ALTER TABLE `build_logs`
+ ADD PRIMARY KEY (`build_log_id`), ADD KEY `ebuild_id` (`ebuild_id`);
+
+--
+-- Indexes for table `build_logs_config`
+--
+ALTER TABLE `build_logs_config`
+ ADD PRIMARY KEY (`log_id`), ADD KEY `config_id` (`config_id`), ADD KEY `build_log_id` (`build_log_id`), ADD KEY `einfo_id` (`einfo_id`);
+
+--
+-- Indexes for table `build_logs_emerge_options`
+--
+ALTER TABLE `build_logs_emerge_options`
+ ADD PRIMARY KEY (`id`), ADD KEY `eoption_id` (`eoption_id`), ADD KEY `build_logs_id` (`build_logs_id`);
+
+--
+-- Indexes for table `build_logs_errors`
+--
+ALTER TABLE `build_logs_errors`
+ ADD PRIMARY KEY (`id`), ADD KEY `build_log_id` (`build_log_id`), ADD KEY `error_id` (`error_id`);
+
+--
+-- Indexes for table `build_logs_hilight`
+--
+ALTER TABLE `build_logs_hilight`
+ ADD PRIMARY KEY (`id`), ADD KEY `log_id` (`log_id`), ADD KEY `hilight_id` (`hilight_css_id`), ADD KEY `hilight_css_id` (`hilight_css_id`);
+
+--
+-- Indexes for table `build_logs_qa`
+--
+ALTER TABLE `build_logs_qa`
+ ADD PRIMARY KEY (`id`), ADD KEY `build_log_id` (`build_log_id`);
+
+--
+-- Indexes for table `build_logs_repoman`
+--
+ALTER TABLE `build_logs_repoman`
+ ADD PRIMARY KEY (`id`), ADD KEY `build_logs_id` (`build_logs_id`);
+
+--
+-- Indexes for table `build_logs_use`
+--
+ALTER TABLE `build_logs_use`
+ ADD PRIMARY KEY (`id`), ADD KEY `build_log_id` (`build_log_id`), ADD KEY `use_id` (`use_id`);
+
+--
+-- Indexes for table `categories`
+--
+ALTER TABLE `categories`
+ ADD PRIMARY KEY (`category_id`);
+
+--
+-- Indexes for table `configs`
+--
+ALTER TABLE `configs`
+ ADD PRIMARY KEY (`config_id`);
+
+--
+-- Indexes for table `configs_emerge_options`
+--
+ALTER TABLE `configs_emerge_options`
+ ADD PRIMARY KEY (`id`), ADD KEY `config_id` (`config_id`), ADD KEY `eoption_id` (`eoption_id`);
+
+--
+-- Indexes for table `configs_metadata`
+--
+ALTER TABLE `configs_metadata`
+ ADD PRIMARY KEY (`id`), ADD KEY `keyword_id` (`keyword_id`), ADD KEY `config_id` (`config_id`);
+
+--
+-- Indexes for table `ebuilds`
+--
+ALTER TABLE `ebuilds`
+ ADD PRIMARY KEY (`ebuild_id`), ADD KEY `package_id` (`package_id`), ADD KEY `checksum` (`checksum`), ADD KEY `version` (`version`);
+
+--
+-- Indexes for table `ebuilds_iuse`
+--
+ALTER TABLE `ebuilds_iuse`
+ ADD PRIMARY KEY (`id`), ADD KEY `ebuild_id` (`ebuild_id`), ADD KEY `use_id` (`use_id`);
+
+--
+-- Indexes for table `ebuilds_keywords`
+--
+ALTER TABLE `ebuilds_keywords`
+ ADD PRIMARY KEY (`id`), ADD KEY `ebuild_id` (`ebuild_id`), ADD KEY `keyword_id` (`keyword_id`);
+
+--
+-- Indexes for table `ebuilds_metadata`
+--
+ALTER TABLE `ebuilds_metadata`
+ ADD PRIMARY KEY (`id`), ADD KEY `ebuild_id` (`ebuild_id`);
+
+--
+-- 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`);
+
+--
+-- Indexes for table `emails`
+--
+ALTER TABLE `emails`
+ ADD PRIMARY KEY (`email_id`);
+
+--
+-- Indexes for table `emerge_info`
+--
+ALTER TABLE `emerge_info`
+ ADD UNIQUE KEY `einfo_id` (`einfo_id`);
+
+--
+-- Indexes for table `emerge_options`
+--
+ALTER TABLE `emerge_options`
+ ADD PRIMARY KEY (`eoption_id`);
+
+--
+-- Indexes for table `errors_info`
+--
+ALTER TABLE `errors_info`
+ ADD PRIMARY KEY (`error_id`);
+
+--
+-- Indexes for table `hilight`
+--
+ALTER TABLE `hilight`
+ ADD PRIMARY KEY (`hilight_id`), ADD KEY `hilight_css_id` (`hilight_css_id`);
+
+--
+-- Indexes for table `hilight_css`
+--
+ALTER TABLE `hilight_css`
+ ADD PRIMARY KEY (`hilight_css_id`);
+
+--
+-- Indexes for table `jobs`
+--
+ALTER TABLE `jobs`
+ ADD PRIMARY KEY (`job_id`), ADD KEY `config_id` (`config_id`), ADD KEY `run_config_id` (`run_config_id`), ADD KEY `job_type_id` (`job_type`);
+
+--
+-- Indexes for table `keywords`
+--
+ALTER TABLE `keywords`
+ ADD PRIMARY KEY (`keyword_id`);
+
+--
+-- Indexes for table `logs`
+--
+ALTER TABLE `logs`
+ ADD PRIMARY KEY (`log_id`), ADD KEY `config_id` (`config_id`);
+
+--
+-- 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`);
+
+--
+-- Indexes for table `packages_emails`
+--
+ALTER TABLE `packages_emails`
+ ADD PRIMARY KEY (`id`), ADD KEY `package_id` (`package_id`,`email_id`);
+
+--
+-- Indexes for table `packages_metadata`
+--
+ALTER TABLE `packages_metadata`
+ ADD PRIMARY KEY (`id`), ADD KEY `package_id` (`package_id`);
+
+--
+-- Indexes for table `repos`
+--
+ALTER TABLE `repos`
+ ADD PRIMARY KEY (`repo_id`);
+
+--
+-- Indexes for table `restrictions`
+--
+ALTER TABLE `restrictions`
+ ADD PRIMARY KEY (`restriction_id`);
+
+--
+-- Indexes for table `setups`
+--
+ALTER TABLE `setups`
+ ADD PRIMARY KEY (`setup_id`), ADD UNIQUE KEY `setup_id` (`setup_id`);
+
+--
+-- Indexes for table `uses`
+--
+ALTER TABLE `uses`
+ ADD PRIMARY KEY (`use_id`);
+
+--
+-- AUTO_INCREMENT for dumped tables
+--
+
+--
+-- AUTO_INCREMENT for table `build_jobs`
+--
+ALTER TABLE `build_jobs`
+MODIFY `build_job_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1325;
+--
+-- AUTO_INCREMENT for table `build_jobs_emerge_options`
+--
+ALTER TABLE `build_jobs_emerge_options`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `build_jobs_redo`
+--
+ALTER TABLE `build_jobs_redo`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `build_jobs_use`
+--
+ALTER TABLE `build_jobs_use`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6067;
+--
+-- AUTO_INCREMENT for table `build_logs`
+--
+ALTER TABLE `build_logs`
+MODIFY `build_log_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15154;
+--
+-- AUTO_INCREMENT for table `build_logs_config`
+--
+ALTER TABLE `build_logs_config`
+MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=41689;
+--
+-- AUTO_INCREMENT for table `build_logs_emerge_options`
+--
+ALTER TABLE `build_logs_emerge_options`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `build_logs_errors`
+--
+ALTER TABLE `build_logs_errors`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2616;
+--
+-- AUTO_INCREMENT for table `build_logs_hilight`
+--
+ALTER TABLE `build_logs_hilight`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=350435;
+--
+-- AUTO_INCREMENT for table `build_logs_qa`
+--
+ALTER TABLE `build_logs_qa`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `build_logs_repoman`
+--
+ALTER TABLE `build_logs_repoman`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `build_logs_use`
+--
+ALTER TABLE `build_logs_use`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=66200;
+--
+-- AUTO_INCREMENT for table `categories`
+--
+ALTER TABLE `categories`
+MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=181;
+--
+-- AUTO_INCREMENT for table `configs`
+--
+ALTER TABLE `configs`
+MODIFY `config_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Config index',AUTO_INCREMENT=7;
+--
+-- AUTO_INCREMENT for table `configs_emerge_options`
+--
+ALTER TABLE `configs_emerge_options`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
+--
+-- AUTO_INCREMENT for table `configs_metadata`
+--
+ALTER TABLE `configs_metadata`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
+--
+-- AUTO_INCREMENT for table `ebuilds`
+--
+ALTER TABLE `ebuilds`
+MODIFY `ebuild_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=78536;
+--
+-- AUTO_INCREMENT for table `ebuilds_iuse`
+--
+ALTER TABLE `ebuilds_iuse`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=427416;
+--
+-- AUTO_INCREMENT for table `ebuilds_keywords`
+--
+ALTER TABLE `ebuilds_keywords`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=532825;
+--
+-- AUTO_INCREMENT for table `ebuilds_metadata`
+--
+ALTER TABLE `ebuilds_metadata`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=78536;
+--
+-- AUTO_INCREMENT for table `ebuilds_restrictions`
+--
+ALTER TABLE `ebuilds_restrictions`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13453;
+--
+-- AUTO_INCREMENT for table `emails`
+--
+ALTER TABLE `emails`
+MODIFY `email_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=675;
+--
+-- AUTO_INCREMENT for table `emerge_info`
+--
+ALTER TABLE `emerge_info`
+MODIFY `einfo_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16164;
+--
+-- AUTO_INCREMENT for table `emerge_options`
+--
+ALTER TABLE `emerge_options`
+MODIFY `eoption_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'emerge command options id',AUTO_INCREMENT=7;
+--
+-- AUTO_INCREMENT for table `errors_info`
+--
+ALTER TABLE `errors_info`
+MODIFY `error_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
+--
+-- AUTO_INCREMENT for table `hilight`
+--
+ALTER TABLE `hilight`
+MODIFY `hilight_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=52;
+--
+-- AUTO_INCREMENT for table `hilight_css`
+--
+ALTER TABLE `hilight_css`
+MODIFY `hilight_css_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
+--
+-- AUTO_INCREMENT for table `jobs`
+--
+ALTER TABLE `jobs`
+MODIFY `job_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
+--
+-- AUTO_INCREMENT for table `keywords`
+--
+ALTER TABLE `keywords`
+MODIFY `keyword_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'keyword index',AUTO_INCREMENT=42;
+--
+-- AUTO_INCREMENT for table `logs`
+--
+ALTER TABLE `logs`
+MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9536253;
+--
+-- AUTO_INCREMENT for table `packages`
+--
+ALTER TABLE `packages`
+MODIFY `package_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18476;
+--
+-- AUTO_INCREMENT for table `packages_emails`
+--
+ALTER TABLE `packages_emails`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22297;
+--
+-- AUTO_INCREMENT for table `packages_metadata`
+--
+ALTER TABLE `packages_metadata`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18475;
+--
+-- AUTO_INCREMENT for table `repos`
+--
+ALTER TABLE `repos`
+MODIFY `repo_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
+--
+-- AUTO_INCREMENT for table `restrictions`
+--
+ALTER TABLE `restrictions`
+MODIFY `restriction_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=55;
+--
+-- AUTO_INCREMENT for table `setups`
+--
+ALTER TABLE `setups`
+MODIFY `setup_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
+--
+-- AUTO_INCREMENT for table `uses`
+--
+ALTER TABLE `uses`
+MODIFY `use_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6153;
+DELIMITER $$
+--
+-- Events
+--
+CREATE DEFINER=`tbc`@`localhost` EVENT `add_esync_jobs` ON SCHEDULE EVERY 1 HOUR STARTS '2012-12-23 17:15:13' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
+  CALL add_jobs_esync();
+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 */;


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2015-05-09 15:30 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2015-05-09 15:30 UTC (permalink / raw
  To: gentoo-commits

commit:     51b09c2569d8e354f03586497b5a5b1fdb9a1f3d
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Sat May  9 15:30:09 2015 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Sat May  9 15:30:09 2015 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=51b09c25

Update db structur

 sql/structure_dump.sql | 136 ++++++++++++++++++++++++-------------------------
 1 file changed, 68 insertions(+), 68 deletions(-)

diff --git a/sql/structure_dump.sql b/sql/structure_dump.sql
index 9d9ecba..e418964 100644
--- a/sql/structure_dump.sql
+++ b/sql/structure_dump.sql
@@ -3,7 +3,7 @@
 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
--- Generation Time: May 09, 2015 at 02:34 PM
+-- Generation Time: May 09, 2015 at 03:13 PM
 -- Server version: 10.0.15-MariaDB-log
 -- PHP Version: 5.6.5-pl0-gentoo
 
@@ -17,7 +17,7 @@ SET time_zone = "+00:00";
 /*!40101 SET NAMES utf8 */;
 
 --
--- Database: `zobcs`
+-- Database: `tbc`
 --
 
 DELIMITER $$
@@ -60,7 +60,7 @@ CREATE TABLE IF NOT EXISTS `build_jobs` (
   `build_now` tinyint(1) NOT NULL,
   `removebin` tinyint(1) NOT NULL,
   `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
-) ENGINE=MyISAM AUTO_INCREMENT=3113 DEFAULT CHARSET=utf8 COMMENT='The build work list';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='The build work list';
 
 -- --------------------------------------------------------
 
@@ -99,7 +99,7 @@ CREATE TABLE IF NOT EXISTS `build_jobs_use` (
   `build_job_id` int(11) NOT NULL,
   `use_id` int(11) NOT NULL,
   `status` tinyint(1) NOT NULL DEFAULT '0'
-) ENGINE=MyISAM AUTO_INCREMENT=17343 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -115,7 +115,7 @@ CREATE TABLE IF NOT EXISTS `build_logs` (
   `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
-) ENGINE=MyISAM AUTO_INCREMENT=17625 DEFAULT CHARSET=utf8 COMMENT='Main log info for the builds';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Main log info for the builds';
 
 -- --------------------------------------------------------
 
@@ -130,7 +130,7 @@ CREATE TABLE IF NOT EXISTS `build_logs_config` (
   `einfo_id` int(11) NOT NULL,
   `logname` varchar(150) NOT NULL COMMENT 'filename of the log',
   `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
-) ENGINE=MyISAM AUTO_INCREMENT=44160 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -154,7 +154,7 @@ CREATE TABLE IF NOT EXISTS `build_logs_errors` (
 `id` int(11) NOT NULL,
   `build_log_id` int(11) NOT NULL,
   `error_id` int(11) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=3379 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -168,7 +168,7 @@ CREATE TABLE IF NOT EXISTS `build_logs_hilight` (
   `start_line` int(11) NOT NULL,
   `end_line` int(11) NOT NULL,
   `hilight_css_id` int(11) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=413189 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -192,7 +192,7 @@ CREATE TABLE IF NOT EXISTS `build_logs_repoman` (
 `id` int(11) NOT NULL,
   `build_log_id` int(11) NOT NULL,
   `summery_text` text NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -205,7 +205,7 @@ CREATE TABLE IF NOT EXISTS `build_logs_use` (
   `build_log_id` int(11) NOT NULL,
   `use_id` int(11) NOT NULL,
   `status` tinyint(1) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=76204 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -218,7 +218,7 @@ CREATE TABLE IF NOT EXISTS `categories` (
   `category` varchar(50) NOT NULL,
   `active` tinyint(1) NOT NULL DEFAULT '0',
   `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
-) ENGINE=MyISAM AUTO_INCREMENT=181 DEFAULT CHARSET=utf8 COMMENT='Categories main table (C)';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Categories main table (C)';
 
 -- --------------------------------------------------------
 
@@ -231,7 +231,7 @@ CREATE TABLE IF NOT EXISTS `configs` (
   `hostname` varchar(50) NOT NULL,
   `setup_id` int(11) NOT NULL COMMENT 'setup',
   `default_config` tinyint(1) NOT NULL COMMENT 'Host setup'
-) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Main config table';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Main config table';
 
 -- --------------------------------------------------------
 
@@ -243,7 +243,7 @@ CREATE TABLE IF NOT EXISTS `configs_emerge_options` (
 `id` int(11) NOT NULL,
   `config_id` int(11) NOT NULL COMMENT 'config id',
   `eoption_id` int(11) NOT NULL COMMENT 'emerge option id'
-) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='Emerge command options for the configs';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Emerge command options for the configs';
 
 -- --------------------------------------------------------
 
@@ -266,7 +266,7 @@ CREATE TABLE IF NOT EXISTS `configs_metadata` (
   `auto` tinyint(1) 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
-) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Config Status';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Config Status';
 
 -- --------------------------------------------------------
 
@@ -281,7 +281,7 @@ CREATE TABLE IF NOT EXISTS `ebuilds` (
   `checksum` varchar(100) NOT NULL,
   `active` tinyint(1) NOT NULL DEFAULT '0',
   `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
-) ENGINE=MyISAM AUTO_INCREMENT=81657 DEFAULT CHARSET=utf8 COMMENT='Version main table (V)';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Version main table (V)';
 
 -- --------------------------------------------------------
 
@@ -294,7 +294,7 @@ CREATE TABLE IF NOT EXISTS `ebuilds_iuse` (
   `ebuild_id` int(11) NOT NULL,
   `use_id` int(11) NOT NULL,
   `status` tinyint(1) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=456109 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -307,7 +307,7 @@ 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
-) ENGINE=MyISAM AUTO_INCREMENT=559659 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -319,7 +319,7 @@ 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'
-) ENGINE=MyISAM AUTO_INCREMENT=81657 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -331,7 +331,7 @@ CREATE TABLE IF NOT EXISTS `ebuilds_restrictions` (
 `id` int(11) NOT NULL,
   `ebuild_id` int(11) NOT NULL,
   `restriction_id` int(11) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=14328 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -342,7 +342,7 @@ CREATE TABLE IF NOT EXISTS `ebuilds_restrictions` (
 CREATE TABLE IF NOT EXISTS `emails` (
 `email_id` int(11) NOT NULL,
   `email` varchar(150) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=679 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -353,7 +353,7 @@ CREATE TABLE IF NOT EXISTS `emails` (
 CREATE TABLE IF NOT EXISTS `emerge_info` (
 `einfo_id` int(11) NOT NULL,
   `emerge_info_text` text NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=18635 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -364,7 +364,7 @@ CREATE TABLE IF NOT EXISTS `emerge_info` (
 CREATE TABLE IF NOT EXISTS `emerge_options` (
 `eoption_id` int(11) NOT NULL COMMENT 'emerge command options id',
   `eoption` varchar(15) NOT NULL COMMENT 'emerge command options'
-) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -376,7 +376,7 @@ CREATE TABLE IF NOT EXISTS `errors_info` (
 `error_id` int(11) NOT NULL,
   `error_name` varchar(10) NOT NULL,
   `error_search` varchar(20) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -392,7 +392,7 @@ CREATE TABLE IF NOT EXISTS `hilight` (
   `hilight_css_id` int(11) NOT NULL,
   `hilight_start` int(11) NOT NULL,
   `hilight_end` int(11) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -404,7 +404,7 @@ CREATE TABLE IF NOT EXISTS `hilight_css` (
 `hilight_css_id` int(11) NOT NULL,
   `hilight_css_name` varchar(11) NOT NULL,
   `hilight_css_collor` varchar(10) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -420,7 +420,7 @@ CREATE TABLE IF NOT EXISTS `jobs` (
   `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
-) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -431,7 +431,7 @@ CREATE TABLE IF NOT EXISTS `jobs` (
 CREATE TABLE IF NOT EXISTS `keywords` (
 `keyword_id` int(11) NOT NULL COMMENT 'keyword index',
   `keyword` varchar(15) NOT NULL COMMENT 'keyword'
-) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='KEYWORD';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='KEYWORD';
 
 -- --------------------------------------------------------
 
@@ -445,7 +445,7 @@ CREATE TABLE IF NOT EXISTS `logs` (
   `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
-) ENGINE=MyISAM AUTO_INCREMENT=22201403 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -461,7 +461,7 @@ CREATE TABLE IF NOT EXISTS `packages` (
   `checksum` varchar(100) NOT NULL,
   `active` tinyint(1) NOT NULL,
   `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
-) ENGINE=MyISAM AUTO_INCREMENT=18514 DEFAULT CHARSET=utf8 COMMENT='Packages main table (P)';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Packages main table (P)';
 
 -- --------------------------------------------------------
 
@@ -473,7 +473,7 @@ CREATE TABLE IF NOT EXISTS `packages_emails` (
 `id` int(11) NOT NULL,
   `package_id` int(11) NOT NULL,
   `email_id` int(11) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=22365 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -485,7 +485,7 @@ CREATE TABLE IF NOT EXISTS `packages_metadata` (
 `id` int(11) NOT NULL,
   `package_id` int(11) NOT NULL,
   `checksum` varchar(100) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=18513 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -496,7 +496,7 @@ CREATE TABLE IF NOT EXISTS `packages_metadata` (
 CREATE TABLE IF NOT EXISTS `repos` (
 `repo_id` int(11) NOT NULL,
   `repo` varchar(100) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Repo main table (repo)';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Repo main table (repo)';
 
 -- --------------------------------------------------------
 
@@ -507,7 +507,7 @@ CREATE TABLE IF NOT EXISTS `repos` (
 CREATE TABLE IF NOT EXISTS `restrictions` (
 `restriction_id` int(11) NOT NULL,
   `restriction` varchar(50) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -519,7 +519,7 @@ CREATE TABLE IF NOT EXISTS `setups` (
 `setup_id` int(11) NOT NULL,
   `setup` varchar(100) NOT NULL,
   `profile` varchar(150) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -530,7 +530,7 @@ CREATE TABLE IF NOT EXISTS `setups` (
 CREATE TABLE IF NOT EXISTS `uses` (
 `use_id` int(11) NOT NULL,
   `flag` varchar(50) NOT NULL
-) ENGINE=MyISAM AUTO_INCREMENT=6180 DEFAULT CHARSET=utf8 COMMENT='Use flags main table';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Use flags main table';
 
 --
 -- Indexes for dumped tables
@@ -766,7 +766,7 @@ ALTER TABLE `uses`
 -- AUTO_INCREMENT for table `build_jobs`
 --
 ALTER TABLE `build_jobs`
-MODIFY `build_job_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3113;
+MODIFY `build_job_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `build_jobs_emerge_options`
 --
@@ -781,17 +781,17 @@ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 -- AUTO_INCREMENT for table `build_jobs_use`
 --
 ALTER TABLE `build_jobs_use`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17343;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `build_logs`
 --
 ALTER TABLE `build_logs`
-MODIFY `build_log_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17625;
+MODIFY `build_log_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `build_logs_config`
 --
 ALTER TABLE `build_logs_config`
-MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=44160;
+MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `build_logs_emerge_options`
 --
@@ -801,12 +801,12 @@ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 -- AUTO_INCREMENT for table `build_logs_errors`
 --
 ALTER TABLE `build_logs_errors`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3379;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `build_logs_hilight`
 --
 ALTER TABLE `build_logs_hilight`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=413189;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `build_logs_qa`
 --
@@ -816,137 +816,137 @@ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 -- AUTO_INCREMENT for table `build_logs_repoman`
 --
 ALTER TABLE `build_logs_repoman`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=51;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `build_logs_use`
 --
 ALTER TABLE `build_logs_use`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=76204;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `categories`
 --
 ALTER TABLE `categories`
-MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=181;
+MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `configs`
 --
 ALTER TABLE `configs`
-MODIFY `config_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Config index',AUTO_INCREMENT=7;
+MODIFY `config_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Config index';
 --
 -- AUTO_INCREMENT for table `configs_emerge_options`
 --
 ALTER TABLE `configs_emerge_options`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `configs_metadata`
 --
 ALTER TABLE `configs_metadata`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `ebuilds`
 --
 ALTER TABLE `ebuilds`
-MODIFY `ebuild_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=81657;
+MODIFY `ebuild_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `ebuilds_iuse`
 --
 ALTER TABLE `ebuilds_iuse`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=456109;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `ebuilds_keywords`
 --
 ALTER TABLE `ebuilds_keywords`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=559659;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `ebuilds_metadata`
 --
 ALTER TABLE `ebuilds_metadata`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=81657;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `ebuilds_restrictions`
 --
 ALTER TABLE `ebuilds_restrictions`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14328;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `emails`
 --
 ALTER TABLE `emails`
-MODIFY `email_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=679;
+MODIFY `email_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `emerge_info`
 --
 ALTER TABLE `emerge_info`
-MODIFY `einfo_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18635;
+MODIFY `einfo_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `emerge_options`
 --
 ALTER TABLE `emerge_options`
-MODIFY `eoption_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'emerge command options id',AUTO_INCREMENT=7;
+MODIFY `eoption_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'emerge command options id';
 --
 -- AUTO_INCREMENT for table `errors_info`
 --
 ALTER TABLE `errors_info`
-MODIFY `error_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
+MODIFY `error_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `hilight`
 --
 ALTER TABLE `hilight`
-MODIFY `hilight_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=52;
+MODIFY `hilight_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `hilight_css`
 --
 ALTER TABLE `hilight_css`
-MODIFY `hilight_css_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
+MODIFY `hilight_css_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `jobs`
 --
 ALTER TABLE `jobs`
-MODIFY `job_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
+MODIFY `job_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `keywords`
 --
 ALTER TABLE `keywords`
-MODIFY `keyword_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'keyword index',AUTO_INCREMENT=42;
+MODIFY `keyword_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'keyword index';
 --
 -- AUTO_INCREMENT for table `logs`
 --
 ALTER TABLE `logs`
-MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22201403;
+MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `packages`
 --
 ALTER TABLE `packages`
-MODIFY `package_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18514;
+MODIFY `package_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `packages_emails`
 --
 ALTER TABLE `packages_emails`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22365;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `packages_metadata`
 --
 ALTER TABLE `packages_metadata`
-MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18513;
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `repos`
 --
 ALTER TABLE `repos`
-MODIFY `repo_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
+MODIFY `repo_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `restrictions`
 --
 ALTER TABLE `restrictions`
-MODIFY `restriction_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=55;
+MODIFY `restriction_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `setups`
 --
 ALTER TABLE `setups`
-MODIFY `setup_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
+MODIFY `setup_id` int(11) NOT NULL AUTO_INCREMENT;
 --
 -- AUTO_INCREMENT for table `uses`
 --
 ALTER TABLE `uses`
-MODIFY `use_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6180;
+MODIFY `use_id` int(11) NOT NULL AUTO_INCREMENT;
 DELIMITER $$
 --
 -- Events


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2015-12-28 21:21 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2015-12-28 21:21 UTC (permalink / raw
  To: gentoo-commits

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


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2016-03-03 16:11 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2016-03-03 16:11 UTC (permalink / raw
  To: gentoo-commits

commit:     b1033bc8487313febdd1d7bf7a46270f3563185e
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Thu Mar  3 16:12:06 2016 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Thu Mar  3 16:12:06 2016 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=b1033bc8

update db structure for test

 sql/structure_dump.sql | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

diff --git a/sql/structure_dump.sql b/sql/structure_dump.sql
index cf4bab7..e9443c0 100644
--- a/sql/structure_dump.sql
+++ b/sql/structure_dump.sql
@@ -3,7 +3,7 @@
 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
--- Generation Time: Feb 21, 2016 at 08:08 PM
+-- Generation Time: Mar 03, 2016 at 03:48 PM
 -- Server version: 10.0.22-MariaDB-log
 -- PHP Version: 7.0.3-pl0-gentoo
 
@@ -565,7 +565,9 @@ CREATE TABLE IF NOT EXISTS `restrictions` (
 CREATE TABLE IF NOT EXISTS `setups` (
 `setup_id` int(11) NOT NULL,
   `setup` varchar(100) NOT NULL,
-  `profile` varchar(150) NOT NULL
+  `profile` varchar(150) NOT NULL,
+  `test` tinyint(1) NOT NULL DEFAULT '0',
+  `repoman` tinyint(1) NOT NULL DEFAULT '0'
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2021-12-14  9:14 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2021-12-14  9:14 UTC (permalink / raw
  To: gentoo-commits

commit:     f6730941febb196140447cda6b553961134c5d93
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Tue Dec 14 09:13:49 2021 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Tue Dec 14 09:13:49 2021 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=f6730941

Add search pattern in a sql file for the buildlog parser

Signed-off-by: Magnus Granberg <zorry <AT> gentoo.org>

 sql/search_pattern.sql | 759 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 759 insertions(+)

diff --git a/sql/search_pattern.sql b/sql/search_pattern.sql
new file mode 100644
index 0000000..31d4692
--- /dev/null
+++ b/sql/search_pattern.sql
@@ -0,0 +1,759 @@
+--
+-- PostgreSQL database dump
+--
+
+-- Dumped from database version 13.2
+-- Dumped by pg_dump version 13.3
+
+-- Started on 2021-11-14 19:29:15 CET
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
+
+--
+-- TOC entry 2324 (class 0 OID 155940)
+-- Dependencies: 211
+-- Data for Name: projects_pattern; Type: TABLE DATA; Schema: public; Owner: buildbot
+--
+
+-- The patten is from https://github.com/toralf/tinderbox/tree/master/data files.
+-- Is stored in a db instead of files.
+
+-- File CATCH_ISSUES
+INSERT INTO public.projects_pattern VALUES (1, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'FileNotFoundError:', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (2, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'dial tcp: lookup proxy.golang.org', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (3, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'go:.* read: connection refused', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (4, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Fetched file: .* VERIFY FAILED!', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (5, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ':Reason: Filesize does not match recorded size', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (6, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Couldn''t download .* Aborting.', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (7, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Fetch failed for', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (8, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \* multilib-strict check failed!', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (9, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The ebuild phase .* has exited unexpectedly. This type of', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (10, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ecompress-file failed', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (11, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unsupported EAPI', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (12, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Files matching a file type that is not allowed:', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (13, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ninja: build stopped:', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (14, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '\* ERROR: .* failed:', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (15, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': No such file or directory.  Stop.', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (16, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ln: failed to create symbolic link .*: File exists', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (17, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Segmentation fault', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (18, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^Error:', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (19, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': error:', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (20, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'sed:.*expression.*unknown option', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (21, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'sed.*failed', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (22, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^ERROR:', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (23, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.:.*: Error:', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (24, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: .', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (25, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please fix the ebuild to use correct FHS/Gentoo policy paths', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (26, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^ERROR', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (27, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error .', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (28, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   .* failed', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (29, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unsupported kernel version!', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (30, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \* ERROR:', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (31, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cmake failed', 0, 0, 'issues', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (32, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'rake aborted!', 0, 0, 'issues', 'error', 'search');
+
+-- File CATCH.compile
+INSERT INTO public.projects_pattern VALUES (50, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The futex facility returned an unexpected error code.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (51, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'asciidoctor.*cannot load', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (52, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'gems.*asciidocter.*LoadError', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (53, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'is not a compiled interface for this version of OCaml', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (54, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': multiple definition of.*: first defined here', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (55, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.atal error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (56, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': internal compiler error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (57, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'undefined reference to', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (58, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Can''t read', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (59, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'class file .* not found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (60, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: redefinition of', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (61, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'has incomplete type', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (62, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'undefined symbol:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (63, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'exited with code: 1.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (64, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'I can''t find the format file', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (65, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '; recompile with -fPIC', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (66, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'must be installed to use', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (67, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Non type-variable argument', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (68, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'too few arguments to function', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (69, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': redefining predefined macro', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (70, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Line indented less than expected', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (71, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'final link failed: Nonrepresentable section on output', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (72, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ld: cannot find', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (73, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'file cannot create directory:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (74, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Not in scope:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (75, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ld: -r and -pie may not be used together', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (76, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.so: error adding symbols:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (77, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'recompile with -fPIE', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (78, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': syntax error in', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (79, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': error adding symbol', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (80, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Parse error .', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (81, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'object has no attribute', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (82, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.*.texinfo:.*: unknown command', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (83, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'reference to Parameter is ambiguous', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (84, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unknown M68KMAKE directive', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (85, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ModuleNotFoundError: No module named', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (86, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Invalid C declaration:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (87, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': undefined method', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (88, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'make inconsistent assumptions over', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (89, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'file was not found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (90, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Cannot specify link libraries for target .* which is not built', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (91, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'include called with wrong number of arguments', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (92, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': fatal error: .*', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (93, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'internal error in relocate', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (94, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failure:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (95, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' A duplicate ELSE command was found inside an IF block.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (96, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed to load interface for', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (97, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ImportError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (98, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The .* distribution was not found and is required by', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (99, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'stack smashing detected', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (100, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Errors in .* projects', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (101, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': undefined reference', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (102, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'CSC: error .*:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (103, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': error adding symbols:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (104, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error: No implementations provided for the following modules:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (105, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'LoadError', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (106, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cannot find symbol', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (107, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'bad class file:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (108, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Compile failed; see the compiler error', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (109, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed Patch:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (110, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'can''t get .* relocation type', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (111, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'texi2info failed', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (112, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'is not a function name', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (113, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unable to find program', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (114, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'javac: invalid source release', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (115, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unknown channel', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (116, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'bad option', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (117, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Assertion .* failed', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (118, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'dereferencing pointer to', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (119, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error getting', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (120, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error on line', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (121, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'is not on the classpath.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (122, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed Running automake', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (123, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error while loading shared libraries', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (124, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'mv: cannot stat', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (125, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'No CommonLisp implementation found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (126, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not link test program to Python', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (127, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'is banned in EAPI=', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (128, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'exceeds the 32 bit address space', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (129, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please upgrade your Go installation.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (130, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please install go.* or later.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (131, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'make:.* Stop.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (132, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error adding symbols:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (133, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'pdflatex failed', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (134, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'An exception has occurred in the compiler', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (135, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error in .* command', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (136, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Can''t locate .* in @INC', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (137, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: expected expression before', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (138, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' error: narrowing conversion of', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (139, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' error: implicit declaration of', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (140, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' failed: .*glib-genmarshal', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (141, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: signals-marshal.h: No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (142, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error:.*command not found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (143, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'gck-marshal.list: Permission denied', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (144, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'This expression has type .* but an expression', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (145, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'mmap: wanted .* bytes at .*, actually mapped at .*', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (146, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'pushd.*No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (147, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unable to set SELinux security labels', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (148, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'patch .* failed with', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (149, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'csc: invalid option', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (150, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unknown module(s) in QT', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (151, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'LaTeX Error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (152, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error producing PDF from TeX source', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (153, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error .*GCING.* in', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (154, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Warning as Error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (155, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'pdfetex exited with bad status', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (156, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'SyntaxError: invalid syntax', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (157, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'SyntaxError: Missing parentheses in call to', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (158, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'AppArmor parser error for', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (159, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/usr/bin/install: will not overwrite just-created', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (160, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'gettext infrastructure mismatch', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (161, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'missing binary operator before token', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (162, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'are incompatible when linking', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (163, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'POD document had syntax errors', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (164, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'No supported Python implementation', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (165, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Ambiguous occurrence', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (166, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Compilation failed in require at', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (167, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'failed to load "', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (168, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Type of arg .* to shift must be array', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (169, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'java.lang.NoSuchMethodError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (170, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Document .* does not validate', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (171, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'not enough memory for initialization', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (172, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'dblatex or fop must be installed to use', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (173, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'could not be found, but is required.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (174, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The library ''System.Xml.dll'' could not be found.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (175, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'mktextfm:.*failed to make', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (176, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed Running autopoint', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (177, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/bin/sh: .* No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (178, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'requires support for 32-bit executables.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (179, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed setting classpath from Ant task', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (180, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Option .* requires an argument', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (181, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: .* undeclared', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (182, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'parser error : .* not defined', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (183, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' invalid option', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (184, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'This BEAM file was compiled for a later version of the run-time system than', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (185, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Uncaught error in', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (186, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Project ERROR: .* package not found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (187, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.*:.*:.*: error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (188, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': Error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (189, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'recipe for target .* failed', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (190, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'backend requires .* - aborting', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (191, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'convert: no', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (192, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'syntax error', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (193, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'record .* undefined', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (194, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'E: Failure', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (195, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'terminated with error code', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (196, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'setup.py:.*: UserWarning: .* must be installed to build', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (197, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Function .* not defined', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (198, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'extra arguments no longer supported; please file a bug', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (199, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Buildfile: .* does not exist!', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (200, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'E: Cannot find external tool', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (201, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'pushd: too many arguments', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (202, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'are banned in EAPI', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (203, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'gmcs: No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (204, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'python_export called without a python implementation and EPYTHON is unset', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (205, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Discovering .* failed', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (206, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Usage: mmc', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (207, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'make.*Command not found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (208, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' (OTHER_FAULT)', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (209, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Errors while running', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (210, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Not supported in your configuration: ocamlopt', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (211, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': Analysis failed with error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (212, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: expected', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (213, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'env.*No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (214, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'RuntimeError: failed to run:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (215, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: static declaration of', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (216, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Not in scope:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (217, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error\[.*\]:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (218, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'sh: .* No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (219, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/bin/sh: .* Not a directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (220, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' (RuntimeError)', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (221, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' API requires the .* utility to be installed', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (222, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '  unbound variable:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (224, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'rm: cannot remove ''libsrtp.a'': No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (225, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'OTP release .* does not match required regex', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (226, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Can''t open heap image file', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (227, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '\[ERROR\]', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (228, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Relocatable linking .* is not supported', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (229, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Makefile.* Terminated', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (230, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'asciidoc: Command not found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (231, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'PermissionError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (232, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'missing separator.  Stop.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (233, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not import extension', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (234, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'is illegal here', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (235, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'fatal error: .*: No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (236, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'IOError: Unable to', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (237, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'OSError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (238, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error: Could not find suitable distribution for Requirement', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (239, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'TypeError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (240, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'moc: could not find a Qt installation', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (241, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'lrelease: could not exec', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (242, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'loadable library and perl binaries are mismatched', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (243, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ModuleNotFoundError: No module named', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (244, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed to get connection to xfconfd:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (245, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'setup: can''t find source for', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (246, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ':Error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (247, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'RuntimeError: maximum recursion depth exceeded while calling a Python object', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (248, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unable to access the X Display, is $DISPLAY set properly?', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (249, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The variable KERN_DIR must be a kernel build folder', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (250, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'fatal: (?!not a git)', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (251, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Compiling .*.erl failed:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (252, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Need to define GLIB_MKENUMS', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (253, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'mkdir /root/cache: permission denied', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (254, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^IOError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (255, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not find servlet-api.jar in', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (256, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.xml:.*Execute failed:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (257, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Fatal Error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (258, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' relocation target .* not defined', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (259, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'tput: unknown terminal', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (260, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'marshal.list: Permission denied', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (261, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please port gnulib .* to your platform', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (262, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'no required module provides', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (263, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^command failed:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (264, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'NameError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (265, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'build cache is disabled by GOCACHE=off, but required as of Go', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (266, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error while opening .* for reading: No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (267, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Bad file descriptor, skipping file,', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (268, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': file not recognized: File format not recognized', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (269, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^Cannot open assembly', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (270, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^Makefile:.*.* does not exist.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (271, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ValueError: Only strings are accepted for the license field, files are not accepted', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (272, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'go: cannot find GOROOT directory:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (273, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Metadata file .* could not be found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (274, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'rl:.*: .* undefined', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (275, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'This crate is only compatible with', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (276, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' error:.*:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (277, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Abnormal terminated', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (278, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.go:.*:.*: undefined:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (279, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': cannot open linker script', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (280, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'go: error loading module requirements', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (281, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'utf8 .* does not map to Unicode', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (282, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'flag provided but not defined', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (283, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'build flag .* only valid when using modules', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (284, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Exception: ERROR: cannot find a valid pkg-config entry', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (285, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'unlink: .* Permission denied', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (286, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'RuntimeError: ERROR: Your setuptools version is too old', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (287, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'python.*: can''t open file .*] No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (288, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Variable .* not found in the output', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (289, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ocamlfind: Package .* not found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (290, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'This expression has type .* but an expression was expected', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (291, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Makefile.* is required .*.*Stop', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (292, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ghc: unrecognised flag:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (293, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'trying to run .* on Elixir .* but', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (294, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'This .* might be unmatched', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (295, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'iconv:.*Invalid argument', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (296, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': fatal error:.*No such file or directory', 0, 0, 'compile', 'error', 'search');
+-- Non valid regex pattern
+-- INSERT INTO public.projects_pattern VALUES (297, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please install it manually.(pip .*', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (298, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: invalid integral value', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (299, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'DISTUTILS_USE_SETUPTOOLS value is probably incorrect', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (300, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ragel:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (301, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Execution failed for task', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (302, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.*: No such file or directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (303, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'AssertionError: Need at least', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (304, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'AttributeError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (305, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ValueError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (306, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'No rule to make target', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (307, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'RuntimeError: Could not find qmake executable', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (308, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed to determine Qt version', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (309, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Cannot find file', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (310, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'go: cannot find main module', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (311, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'go install: version is required', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (312, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ModuleNotFoundError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (313, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'libtool: error', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (314, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', './shtool:Error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (315, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ld: cannot use executable', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (316, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ar: libdeps specified more than once', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (317, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': Fatal error', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (318, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'uh-oh! RDoc had a problem:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (319, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Makefile:.* Stop.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (320, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Cannot build with randomized sbrk.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (321, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^\[error\]', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (322, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'UnicodeEncodeError:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (323, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Package .* was not found in the .* path.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (324, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ld: i386 architecture of input file', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (325, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'final link failed:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (326, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ld returned .* exit status', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (327, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'a: malformed archive', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (328, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'rdlibtool: command not found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (329, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cp: cannot create regular file', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (330, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Couldn''t open', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (331, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'gdbm_fetch: Item not found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (332, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' Illegal qualifier', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (333, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': cannot find package', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (334, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   .* not found,', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (335, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.*: no input file given', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (336, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Configuration error:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (337, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.* not found in the JDK being used for compilation', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (338, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cc1: some warnings being treated as errors', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (339, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'rdlibtool: error', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (340, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'installed package .* is broken due to missing package', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (341, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'mkdir: cannot create directory', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (342, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'root file .* not found', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (343, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'go: updates to .* needed,', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (344, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Symbol .* at .* has no .* type.', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (345, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'pkg_resources.UnknownExtra:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (346, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'can.t write to file', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (347, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^No module named', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (348, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/usr/bin/python.*: No module named', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (349, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'pyglet.canvas.xlib.NoSuchDisplayException:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (350, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': no input files', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (351, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Internal or unrecoverable error in:', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (352, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Got signal before environment was installed on our thread', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (353, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^FAILED: .', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (354, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ':\d+:\d+: error: ', 1, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (355, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': undefined reference to', 0, 0, 'compile', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (356, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ':\d+:\d+: note: ', 1, 0, 'compile', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (357, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ':\d+:\d+: warning: ', 1, 0, 'compile', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (358, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'LoadError:', 0, 0, 'compile', 'error', 'search');
+
+-- File CATCH.configure
+INSERT INTO public.projects_pattern VALUES (400, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The futex facility returned an unexpected error code.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (401, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unknown CMake command', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (402, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'CMake will not be able to correctly generate this project.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (403, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'required internal CMake variable not set', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (404, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed Running autoconf', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (405, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed Running aclocal', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (406, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'no configure script found', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (407, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'You do not have the SDL/SDL_rotozoom.h headers installed. Exiting.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (408, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not run psql test program, checking why...', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (409, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'PostgreSQL slot must be set to one of:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (410, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   PostgreSQL slot is not set to .* or higher.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (411, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.* library not found, but required for .* module.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (412, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: Fortran 77 compiler', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (413, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: fortran compiler does not work', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (414, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'CMake will exit', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (415, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'You need build codec to run the tests', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (416, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not find a package configuration file provided by', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (417, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Project .rostime. tried to find library .-lpthread.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (418, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Cannot execute 32-bit applications', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (419, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unable to find clang libraries', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (420, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'extconf.rb:.* (RuntimeError)', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (421, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The .* version in .* must be updated.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (422, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'bad option:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (423, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Meson encountered an error', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (424, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Invalid option:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (425, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Project ERROR:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (426, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unrecognized option', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (427, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Can''t locate .* in @INC', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (428, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'SyntaxError: invalid syntax', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (429, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'This version of Camlp4 is for OCaml', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (430, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': uninitialized constant', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (431, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'meson.build.*ERROR:.*', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (432, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'USE Flag .* not in IUSE for', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (433, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'configure in /.* failed', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (434, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'This expression has type .* but an expression was', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (435, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please, run .haskell-updater', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (436, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Detected broken packages:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (437, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: unsupported', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (438, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: setupterm:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (439, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'bison: .* cannot open: Permission denied', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (440, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'meson_options.txt:.* Option name debug is reserved.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (441, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'glib-mk.* not found', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (442, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'glib-genmarshal needs to be installed', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (443, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'glib-genmarshal: command not found', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (444, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'You must install glib-genmarshal', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (445, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '\-\-.*: command not found', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (446, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', './configure: line .*: syntax error near unexpected', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (447, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'You do not have the SDL/SDL_.* headers installed.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (448, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Cargo package manager not found', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (449, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The Motif libraries are not installed.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (450, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'flex: could not', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (451, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'asciidoctor:.*cannot load such file', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (453, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ERROR: unable to find', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (454, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.* requires .* install the dependency', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (455, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'SyntaxError:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (456, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'but please install the FUSE libraries and headers to build this module', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (457, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': fatal error:.*No such file or directory', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (458, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'C compiler cannot create executables', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (459, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unable to find Qt', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (460, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Package dependency requirement ''.* could not be satisfied.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (461, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'A required package was not found', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (462, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': No such file or directory', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (463, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.* will not be built.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (464, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' was not found.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (465, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'sed:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (466, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The version of your compiler is not supported at this time', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (467, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not create Makefile due to some reason', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (468, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'environment: .*: command not found', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (469, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.*: Required feature .* not found', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (470, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' .CONFIG_', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (471, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'checking version of x86_64-pc-linux-gnu-gcc ... .* - old version, at least .* required!', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (472, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '  Flow control statements are not properly nested.', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (473, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' error: Unable to find', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (474, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The following variables are used in this project, but they are set to NOTFOUND.', 0, 0, 'configure', 'error', 'search');
+-- Non valid regex pattern
+-- INSERT INTO public.projects_pattern VALUES (475, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could NOT find .* (missing:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (476, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'configure: error:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (477, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'CMake Error at', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (478, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'CMake Error:', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (479, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Configuring incomplete', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (480, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cmake failed', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (481, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   Failed to find configuration', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (482, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Reason: UndefinedError', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (483, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^fatal: not a git repository', 0, 0, 'configure', 'info', 'search');
+
+-- File CATCH.install
+INSERT INTO public.projects_pattern VALUES (500, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Can''t locate Locale/gettext.pm in @INC', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (501, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'newinitd:.* does not exist', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (502, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \* .* is not a valid file/directory', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (503, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' !!! .* does not exist', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (504, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '!!! doexe:', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (505, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'chown: invalid user', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (506, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'chown: invalid group:', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (507, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ERROR:root', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (508, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'install: cannot stat .*: No such file or directory', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (509, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': fatal error:', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (510, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/bin/sh: .* cd: .*: Not a directory', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (511, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'make.* No rule to make target .* needed by .* Stop.', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (512, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unhandled exception:', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (513, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'rm: .* No such file or directory', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (514, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '! LaTeX Error:', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (515, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cp: cannot stat.*: No such file or directory', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (516, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cp: target .* is not a directory', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (517, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cp: cannot create regular file', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (518, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'sed: .*: No such file or directory', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (519, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: .* Not a directory:', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (520, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/usr/bin/install: will not overwrite', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (521, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'File Finder Failed for', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (522, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/bin/sed: symbol lookup error:', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (523, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: static declaration of', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (524, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/usr/bin/install crash', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (525, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'install: cannot create regular file', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (526, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'environment: line .*: cd: .* No such file or directory', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (527, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'mv: cannot stat .* No such file or directory', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (528, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'java.lang.NoSuchMethodError:', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (529, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': No such file', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (530, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed to set XATTR_PAX markings', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (531, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Fatal error .', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (532, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'glib-mkenums: command not found', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (533, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'AttributeError:', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (534, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: unknown target', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (535, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error: The .* plugin is not installed', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (536, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': Permission denied', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (537, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' note: each undeclared identifier is reported only once for each function it appears in', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (538, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' undefined reference to', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (539, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'mkdir: cannot create directory', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (540, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'install: .* does not exist', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (541, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'convert: no', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (542, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': multiple definition of.*: first defined here', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (543, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   Header checksum mismatch, aborting.', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (544, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \* Ebuild author forgot an entry', 0, 0, 'install', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (545, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ModuleNotFoundError:', 0, 0, 'install', 'error', 'search');
+
+
+-- File CATCH.postinst
+INSERT INTO public.projects_pattern VALUES (570, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'chown: cannot', 0, 0, 'postinst', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (571, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cp: cannot', 0, 0, 'postinst', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (572, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': command not found', 0, 0, 'postinst', 'error', 'search');
+
+-- File CATCH.prepare
+INSERT INTO public.projects_pattern VALUES (600, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'patch .* failed with', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (601, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Cannot find \$EPATCH_SOURCE!', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (602, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'you need to fix the relative paths in patch', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (603, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'must be called in src_prepare', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (604, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed Running libtoolize', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (605, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'eapply: no files specified', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (606, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The source directory .* doesn.t exist', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (607, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'rm: cannot remove .*: No such file or directory', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (608, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cp: cannot stat', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (609, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'sed: can''t read requirements.txt: No such file or directory', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (610, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please disable .* support in your kernel config and recompile your kernel', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (611, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': No such file or directory', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (612, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'possibly undefined macro:', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (613, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not find gem', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (614, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'sed: .* unterminated .* command', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (615, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'can''t find file to patch at input', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (616, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'LoadError:', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (617, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.*: command not found', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (618, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Project ERROR: Unknown module', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (619, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'iconv: unrecognized option:', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (620, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Bad system call', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (621, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cp: not writing through', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (622, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'convert:', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (623, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   .* not found', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (624, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \* Failed running', 0, 0, 'prepare', 'error', 'search');
+
+-- File CATCH.pretend
+INSERT INTO public.projects_pattern VALUES (640, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please switch to a gcc version built with USE=', 0, 0, 'pretend', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (641, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Space constraints set in the ebuild were not met', 0, 0, 'pretend', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (642, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   Unsupported version of Rust selected', 0, 0, 'pretend', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (643, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \* Please check to make sure these options are set correctly.', 0, 0, 'pretend', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (644, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   Kernel not configured; no .config found in', 0, 0, 'pretend', 'error', 'search');
+
+-- File CATCH.setup
+INSERT INTO public.projects_pattern VALUES (650, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'You need package', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (651, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please specify at least one package name on the command line.', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (652, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not find a package configuration file provided by', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (653, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'You have to install development tools first.', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (654, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error in setup command', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (655, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not find', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (656, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Requires at least PyQ.*', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (657, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'The Motif libraries are not installed.', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (658, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'setup: At least the following dependencies are missing:', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (659, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'This ebuild will need the', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (660, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'This package will need access to .* cds.', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (670, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'These fortunes have offensive content. Enable offensive USE Flag', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (671, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'PYTHON needs to be set for', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (672, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Add .* to DEPEND', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (673, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cannot find package', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (674, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Ebuild author forgot an entry', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (675, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please install required programs:', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (676, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Invalid use of .*.eclass', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (677, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'EPYTHON unset', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (678, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'One of the following USE flags is needed:', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (679, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'python_pkg_setup() not called', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (680, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Missing USE flags in', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (681, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'is banned in EAPI', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (682, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Select exactly one database type out of these: mysql oracle postgres sqlite', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (683, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unable to find version .* of package', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (684, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'No Python implementation set', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (685, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*.*CONFIG_.*is not set when it should be', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (686, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   .* requires .* (CONFIG_.*) to be', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (687, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   Kernel not configured;', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (688, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'USE=modules and in-kernel ipset support detected.', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (689, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   Linux .* is the latest supported version', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (690, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \* WireGuard has been merged upstream into this kernel. Therefore', 0, 0, 'setup', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (691, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   One of the postgres_targets_postgresSL_OT use flags must be enabled', 0, 0, 'setup', 'error', 'search');
+
+-- File CATCH.test
+INSERT INTO public.projects_pattern VALUES (700, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '\<internal:/', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (701, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^ValueError:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (702, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'E   ImportError:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (703, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '____ ERROR coll', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (704, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'argparse.ArgumentError:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (705, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^E       .*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (706, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ImportError:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (707, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Need FEATURES=.* to run this testsuite', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (708, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^E: Failure', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (709, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \.\.\. FAILED', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (710, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': FAILED (.*:.*)', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (711, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.* failed unexpectedly.', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (712, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^ERROR:.*test', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (713, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failing test(s):', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (714, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' (Failed)', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (715, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '#   Failed test', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (716, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \.\.\. ERROR', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (717, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'FAILED: .*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (718, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'FAILED .*test', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (719, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed tests:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (720, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^FAIL .*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (721, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^FAIL\t.*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (722, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^FAIL: .*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (723, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^Failure:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (724, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' FAIL .*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (725, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': FAIL', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (726, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*\*\*Failed', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (727, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*\*\*Exception:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (728, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': FAILED:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (729, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^FAILED', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (730, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed .* tests, .*% okay, .* tests skipped.', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (731, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'testsuite: .* failed', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (732, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Test .* from suite .* failed.', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (733, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Test suite test-threads: FAIL', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (734, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.* tests executed, .* failures', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (735, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ERROR: test(s) failed in', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (736, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed test', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (737, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '\.\.\. FAILED', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (738, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ERROR: ld.so: object', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (739, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'sudo: no tty present and no askpass program specified', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (740, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/bin/sh: cppcheck: command not found', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (741, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Line .* failed', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (742, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '\-\- FAIL:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (743, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '\[  FAILED  \]', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (744, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.*:.*: exit status 1', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (745, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'missing separator', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (746, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Can''t locate .* in @INC', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (747, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^FAIL!', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (748, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'QFATAL :', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (749, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'LoadError:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (750, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'rake aborted!', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (751, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error decrypting signature:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (752, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'syntax error near', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (753, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': undefined reference to', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (754, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Fatal Error by .*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (755, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': error:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (756, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': fatal error:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (757, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'make.* Command not found', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (758, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'test.*NOT ok', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (759, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'CMake Error at', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (760, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': exit status 1', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (761, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'fatal: making test-suite.log:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (762, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Programs failed: .', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (763, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': Assertion failure', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (764, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Failed .* tests', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (765, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error: .*:test', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (766, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'No such file or directory', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (767, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': cannot execute binary file', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (768, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'AssertionError', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (769, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'make.* No rule to make target', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (770, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': Command not found', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (771, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'assertion .* failed', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (772, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' NOT ok', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (773, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ocamlc: unknown option', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (774, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'failed conch', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (775, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^FAILED: .', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (776, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'SyntaxError: .', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (777, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Resolve library did not return a fully qualified domain name.', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (778, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.* Tests in .* Category Failed', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (779, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '  *FAILED  ess', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (780, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ':Error:', 0, 0, 'test', 'info', 'search');
+-- Need i fix for >= python 3.7 FutureWarning: Possible nested set at position 9
+--INSERT INTO public.projects_pattern VALUES (781, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^not ok [[:digit:]]*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (782, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'test in .* failed', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (783, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/bin/bash: docker: command not found', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (784, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '\.\.\.\.\.\.\. no', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (785, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \.\. Failed .* subtests', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (786, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '==== Testing .* failed', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (787, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 't/.*.t.* module .* not found:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (788, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 't/.*.t.* Dubious,', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (789, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unescaped left brace in regex is illegal here', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (790, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.. \[fail\]', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (791, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Error: This expression has type .* but an expression was expected', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (792, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^\?: .*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (793, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Test .* failed:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (794, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ModuleNotFoundError:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (795, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' FAILED (.*)', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (796, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' FAILED .*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (797, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Missing /', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (798, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Some packages may not be found', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (799, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' failed: Cannot create directory', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (800, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'UnicodeEncodeError:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (801, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'PluginValidationError:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (802, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'git: command not found', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (803, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'ests failed .* python', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (804, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'INTERNALERROR. AttributeError:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (805, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'INTERNALERROR', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (806, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: The .* command requires the .* package', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (807, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'LLVM ERROR:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (808, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'distutils.errors.', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (809, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Couldn''t resolve host', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (810, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'PermissionError: .* Permission denied', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (811, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': Errorf call has arguments but no formatting directives', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (812, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': py.test: command not found', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (813, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'mkdir /root/cache: permission denied', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (814, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'RuntimeError:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (815, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'error: invalid command', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (816, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Can''t use ''defined', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (817, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'FAILED (.*)', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (818, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^vet: .*', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (819, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'FAIL.* \[.*\]', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (820, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Errors while running CTest', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (821, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'make:.* test', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (822, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'can''t load package:', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (823, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ': cannot find package', 0, 0, 'test', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (824, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' command not found', 0, 0, 'test', 'info', 'search');
+
+-- File CATCH.unpack
+INSERT INTO public.projects_pattern VALUES (850, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '/usr/bin/rpm2tar: line .*:', 0, 0, 'unpack', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (851, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unsupported type of integrity check', 0, 0, 'unpack', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (852, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'tar: This does not look like a tar archive', 0, 0, 'unpack', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (853, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'tar: Exiting with failure status due to previous errors', 0, 0, 'unpack', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (854, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cp: .* No such file or directory', 0, 0, 'unpack', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (855, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'rm: cannot remove', 0, 0, 'unpack', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (856, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'mv: cannot stat', 0, 0, 'unpack', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (857, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'asciidoctor', 0, 0, 'unpack', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (858, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'failure unpacking', 0, 0, 'unpack', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (859, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'unpack: .* does not exist', 0, 0, 'unpack', 'error', 'search');
+
+-- File CATCH.qa
+INSERT INTO public.projects_pattern VALUES (900, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '.automake. called by src_prepare', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (901, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Automake "maintainer mode" detected:', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (902, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'broken .png files found', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (903, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'cmake-utils_src_prepare has not been run', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (904, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'dosym target omits basename:', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (905, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'econf called in .* instead of', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (906, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'function is deprecated', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (907, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'inherited illegally', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (908, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'is deprecated, use .* instead', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (909, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'One or more CMake variables were not used by the project', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (911, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'python_.*_all() didn''t call', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (912, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'running automake in configure phase', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (913, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'This ebuild installs into', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (914, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Unrecognized configure options:', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (915, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'USE Flag .* not in IUSE for', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (916, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'warning: python_fix_shebang', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (917, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'SetuptoolsDeprecationWarning: 2to3', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (918, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'SetuptoolsDeprecationWarning: setup.py install', 0, 0, 'qa', 'warning', 'search');
+INSERT INTO public.projects_pattern VALUES (919, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' * QA Notice:', 0, 0, 'qa', 'warning', 'startswith');
+
+--
+-- TOC entry 2332 (class 0 OID 0)
+-- Dependencies: 212
+-- Name: projects_pattern_id_seq; Type: SEQUENCE SET; Schema: public; Owner: buildbot
+--
+
+--SELECT pg_catalog.setval('public.projects_pattern_id_seq', 453, true);
+
+
+-- Completed on 2021-11-14 19:29:15 CET
+
+--
+-- PostgreSQL database dump complete
+--
+


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2022-07-08 21:56 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2022-07-08 21:56 UTC (permalink / raw
  To: gentoo-commits

commit:     43f7d0d6fe1817b5b8c21beb11207f4f9fa17324
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Fri Jul  8 21:56:07 2022 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Fri Jul  8 21:56:07 2022 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=43f7d0d6

Add 2 configure search pattern

Signed-off-by: Magnus Granberg <zorry <AT> gentoo.org>

 sql/search_pattern.sql | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/sql/search_pattern.sql b/sql/search_pattern.sql
index 31d4692..d2e2197 100644
--- a/sql/search_pattern.sql
+++ b/sql/search_pattern.sql
@@ -457,6 +457,8 @@ INSERT INTO public.projects_pattern VALUES (480, 'e89c2c1a-46e0-4ded-81dd-c51afe
 INSERT INTO public.projects_pattern VALUES (481, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   Failed to find configuration', 0, 0, 'configure', 'error', 'search');
 INSERT INTO public.projects_pattern VALUES (482, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Reason: UndefinedError', 0, 0, 'configure', 'error', 'search');
 INSERT INTO public.projects_pattern VALUES (483, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^fatal: not a git repository', 0, 0, 'configure', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (484, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ', not found$', 0, 0, 'configure', 'info', 'search');
+INSERT INTO public.projects_pattern VALUES (485, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not find', 0, 0, 'configure', 'error', 'search');
 
 -- File CATCH.install
 INSERT INTO public.projects_pattern VALUES (500, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Can''t locate Locale/gettext.pm in @INC', 0, 0, 'install', 'error', 'search');


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2022-07-13 19:53 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2022-07-13 19:53 UTC (permalink / raw
  To: gentoo-commits

commit:     bb330a4f317e06324138a80a4099cface0386b34
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Wed Jul 13 19:50:55 2022 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Wed Jul 13 19:50:55 2022 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=bb330a4f

Add ignore lines >>> / and ./usr/

Signed-off-by: Magnus Granberg <zorry <AT> gentoo.org>

 sql/search_pattern.sql | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

diff --git a/sql/search_pattern.sql b/sql/search_pattern.sql
index d2e2197..50fb4e1 100644
--- a/sql/search_pattern.sql
+++ b/sql/search_pattern.sql
@@ -459,6 +459,7 @@ INSERT INTO public.projects_pattern VALUES (482, 'e89c2c1a-46e0-4ded-81dd-c51afe
 INSERT INTO public.projects_pattern VALUES (483, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^fatal: not a git repository', 0, 0, 'configure', 'info', 'search');
 INSERT INTO public.projects_pattern VALUES (484, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ', not found$', 0, 0, 'configure', 'info', 'search');
 INSERT INTO public.projects_pattern VALUES (485, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not find', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (486, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'No such file or directory', 0, 0, 'configure', 'error', 'search');
 
 -- File CATCH.install
 INSERT INTO public.projects_pattern VALUES (500, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Can''t locate Locale/gettext.pm in @INC', 0, 0, 'install', 'error', 'search');
@@ -742,7 +743,12 @@ INSERT INTO public.projects_pattern VALUES (915, 'e89c2c1a-46e0-4ded-81dd-c51afe
 INSERT INTO public.projects_pattern VALUES (916, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'warning: python_fix_shebang', 0, 0, 'qa', 'warning', 'search');
 INSERT INTO public.projects_pattern VALUES (917, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'SetuptoolsDeprecationWarning: 2to3', 0, 0, 'qa', 'warning', 'search');
 INSERT INTO public.projects_pattern VALUES (918, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'SetuptoolsDeprecationWarning: setup.py install', 0, 0, 'qa', 'warning', 'search');
-INSERT INTO public.projects_pattern VALUES (919, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' * QA Notice:', 0, 0, 'qa', 'warning', 'startswith');
+INSERT INTO public.projects_pattern VALUES (919, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^ * QA Notice:', 0, 0, 'qa', 'warning', 'search');
+
+-- ignore
+INSERT INTO public.projects_pattern VALUES (950, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^>>> /', 0, 0, 'ignore', 'ignore', 'search');
+INSERT INTO public.projects_pattern VALUES (950, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^./usr/', 0, 0, 'ignore', 'ignore', 'search');
+
 
 --
 -- TOC entry 2332 (class 0 OID 0)


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2022-08-21  8:43 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2022-08-21  8:43 UTC (permalink / raw
  To: gentoo-commits

commit:     208581e198518f70fa2bfad0e01418eed8b345a1
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Sun Aug 21 08:43:00 2022 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Sun Aug 21 08:43:00 2022 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=208581e1

Add gentoo ci db schema

Signed-off-by: Magnus Granberg <zorry <AT> gentoo.org>

 sql/gentoo_ci_schema.sql | 1525 ++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 1525 insertions(+)

diff --git a/sql/gentoo_ci_schema.sql b/sql/gentoo_ci_schema.sql
new file mode 100644
index 0000000..f1725fa
--- /dev/null
+++ b/sql/gentoo_ci_schema.sql
@@ -0,0 +1,1525 @@
+--
+-- PostgreSQL database dump
+--
+
+-- Dumped from database version 13.3
+-- Dumped by pg_dump version 13.5
+
+-- Started on 2022-08-21 10:37:12 CEST
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
+
+--
+-- TOC entry 2475 (class 1262 OID 155811)
+-- Name: gentoo-ci; Type: DATABASE; Schema: -; Owner: buildbot
+--
+
+CREATE DATABASE "gentoo-ci" WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'sv_SE.utf8';
+
+
+ALTER DATABASE "gentoo-ci" OWNER TO buildbot;
+
+\connect -reuse-previous=on "dbname='gentoo-ci'"
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SELECT pg_catalog.set_config('search_path', '', false);
+SET check_function_bodies = false;
+SET xmloption = content;
+SET client_min_messages = warning;
+SET row_security = off;
+
+--
+-- TOC entry 655 (class 1247 OID 155813)
+-- Name: projects_builds_status; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.projects_builds_status AS ENUM (
+    'failed',
+    'completed',
+    'in-progress',
+    'waiting',
+    'warning'
+);
+
+
+ALTER TYPE public.projects_builds_status OWNER TO buildbot;
+
+--
+-- TOC entry 658 (class 1247 OID 155824)
+-- Name: projects_pattern_search_type; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.projects_pattern_search_type AS ENUM (
+    'in',
+    'startswith',
+    'endswith',
+    'search'
+);
+
+
+ALTER TYPE public.projects_pattern_search_type OWNER TO buildbot;
+
+--
+-- TOC entry 661 (class 1247 OID 155834)
+-- Name: projects_pattern_status; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.projects_pattern_status AS ENUM (
+    'info',
+    'warning',
+    'error',
+    'ignore'
+);
+
+
+ALTER TYPE public.projects_pattern_status OWNER TO buildbot;
+
+--
+-- TOC entry 664 (class 1247 OID 155844)
+-- Name: projects_pattern_type; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.projects_pattern_type AS ENUM (
+    'info',
+    'qa',
+    'compile',
+    'configure',
+    'install',
+    'postinst',
+    'prepare',
+    'setup',
+    'test',
+    'unpack',
+    'ignore',
+    'issues',
+    'misc',
+    'elog',
+    'pretend'
+);
+
+
+ALTER TYPE public.projects_pattern_type OWNER TO buildbot;
+
+--
+-- TOC entry 667 (class 1247 OID 155868)
+-- Name: projects_portage_directorys; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.projects_portage_directorys AS ENUM (
+    'make.profile',
+    'repos.conf'
+);
+
+
+ALTER TYPE public.projects_portage_directorys OWNER TO buildbot;
+
+--
+-- TOC entry 761 (class 1247 OID 550221)
+-- Name: projects_portage_package_directorys; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.projects_portage_package_directorys AS ENUM (
+    'use',
+    'accept_keywords',
+    'exclude',
+    'env'
+);
+
+
+ALTER TYPE public.projects_portage_package_directorys OWNER TO buildbot;
+
+--
+-- TOC entry 670 (class 1247 OID 155874)
+-- Name: projects_repositorys_pkgcheck; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.projects_repositorys_pkgcheck AS ENUM (
+    'package',
+    'full',
+    'none'
+);
+
+
+ALTER TYPE public.projects_repositorys_pkgcheck OWNER TO buildbot;
+
+--
+-- TOC entry 673 (class 1247 OID 155882)
+-- Name: projects_status; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.projects_status AS ENUM (
+    'stable',
+    'all',
+    'unstable'
+);
+
+
+ALTER TYPE public.projects_status OWNER TO buildbot;
+
+--
+-- TOC entry 777 (class 1247 OID 1708870)
+-- Name: repositorys_method; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE public.repositorys_method AS ENUM (
+    'clobber',
+    'fresh',
+    'clean',
+    'copy'
+);
+
+
+ALTER TYPE public.repositorys_method OWNER TO postgres;
+
+--
+-- TOC entry 774 (class 1247 OID 1708856)
+-- Name: repositorys_mode; Type: TYPE; Schema: public; Owner: postgres
+--
+
+CREATE TYPE public.repositorys_mode AS ENUM (
+    'full',
+    'incremental'
+);
+
+
+ALTER TYPE public.repositorys_mode OWNER TO postgres;
+
+--
+-- TOC entry 676 (class 1247 OID 155890)
+-- Name: repositorys_type; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.repositorys_type AS ENUM (
+    'gitpuller',
+    'git',
+    'gitlab'
+);
+
+
+ALTER TYPE public.repositorys_type OWNER TO buildbot;
+
+--
+-- TOC entry 679 (class 1247 OID 155894)
+-- Name: versions_keywords_status; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.versions_keywords_status AS ENUM (
+    'stable',
+    'unstable',
+    'negative',
+    'all'
+);
+
+
+ALTER TYPE public.versions_keywords_status OWNER TO buildbot;
+
+--
+-- TOC entry 767 (class 1247 OID 698031)
+-- Name: versions_metadata_type; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.versions_metadata_type AS ENUM (
+    'iuse',
+    'properties',
+    'required use',
+    'restrict',
+    'keyword'
+);
+
+
+ALTER TYPE public.versions_metadata_type OWNER TO buildbot;
+
+--
+-- TOC entry 758 (class 1247 OID 488393)
+-- Name: workers_type; Type: TYPE; Schema: public; Owner: buildbot
+--
+
+CREATE TYPE public.workers_type AS ENUM (
+    'default',
+    'local',
+    'latent',
+    'chroot',
+    'docker'
+);
+
+
+ALTER TYPE public.workers_type OWNER TO buildbot;
+
+SET default_tablespace = '';
+
+SET default_table_access_method = heap;
+
+--
+-- TOC entry 200 (class 1259 OID 155903)
+-- Name: categorys; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.categorys (
+    uuid character varying(36) NOT NULL,
+    name character varying(100) NOT NULL
+);
+
+
+ALTER TABLE public.categorys OWNER TO buildbot;
+
+--
+-- TOC entry 201 (class 1259 OID 155906)
+-- Name: keywords; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.keywords (
+    id integer NOT NULL,
+    name character varying(50) NOT NULL
+);
+
+
+ALTER TABLE public.keywords OWNER TO buildbot;
+
+--
+-- TOC entry 202 (class 1259 OID 155909)
+-- Name: migrate_version; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.migrate_version (
+    repository_id character varying(250) NOT NULL,
+    repository_path text,
+    version integer
+);
+
+
+ALTER TABLE public.migrate_version OWNER TO buildbot;
+
+--
+-- TOC entry 203 (class 1259 OID 155915)
+-- Name: packages; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.packages (
+    name character varying(100) NOT NULL,
+    category_uuid character varying(36),
+    repository_uuid character varying(36),
+    deleted boolean,
+    deleted_at integer,
+    uuid character varying(36) NOT NULL
+);
+
+
+ALTER TABLE public.packages OWNER TO buildbot;
+
+--
+-- TOC entry 204 (class 1259 OID 155918)
+-- Name: portages_makeconf; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.portages_makeconf (
+    id integer NOT NULL,
+    variable character varying(50) NOT NULL
+);
+
+
+ALTER TABLE public.portages_makeconf OWNER TO buildbot;
+
+--
+-- TOC entry 205 (class 1259 OID 155921)
+-- Name: portages_makeconf_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.portages_makeconf_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.portages_makeconf_id_seq OWNER TO buildbot;
+
+--
+-- TOC entry 2477 (class 0 OID 0)
+-- Dependencies: 205
+-- Name: portages_makeconf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
+--
+
+ALTER SEQUENCE public.portages_makeconf_id_seq OWNED BY public.portages_makeconf.id;
+
+
+--
+-- TOC entry 206 (class 1259 OID 155923)
+-- Name: projects; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects (
+    uuid character varying(36) NOT NULL,
+    name character varying(50) NOT NULL,
+    description text,
+    profile character varying(255) NOT NULL,
+    profile_repository_uuid character varying(36) NOT NULL,
+    keyword_id integer,
+    status public.projects_status,
+    auto boolean,
+    enabled boolean,
+    created_by integer NOT NULL,
+    use_default boolean,
+    image character varying(255),
+    git_project_name character varying(255)
+);
+
+
+ALTER TABLE public.projects OWNER TO buildbot;
+
+--
+-- TOC entry 207 (class 1259 OID 155929)
+-- Name: projects_builds; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects_builds (
+    id integer NOT NULL,
+    project_uuid character varying(36),
+    version_uuid character varying(36),
+    build_id integer NOT NULL,
+    buildbot_build_id integer DEFAULT 0,
+    status public.projects_builds_status,
+    requested boolean,
+    created_at integer,
+    updated_at integer,
+    deleted_at integer,
+    deleted boolean
+);
+
+
+ALTER TABLE public.projects_builds OWNER TO buildbot;
+
+--
+-- TOC entry 208 (class 1259 OID 155933)
+-- Name: projects_builds_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.projects_builds_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.projects_builds_id_seq OWNER TO buildbot;
+
+--
+-- TOC entry 2478 (class 0 OID 0)
+-- Dependencies: 208
+-- Name: projects_builds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
+--
+
+ALTER SEQUENCE public.projects_builds_id_seq OWNED BY public.projects_builds.id;
+
+
+--
+-- TOC entry 209 (class 1259 OID 155935)
+-- Name: projects_emerge_options; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects_emerge_options (
+    id integer NOT NULL,
+    project_uuid character varying(36),
+    oneshot boolean,
+    depclean boolean,
+    preserved_libs boolean
+);
+
+
+ALTER TABLE public.projects_emerge_options OWNER TO buildbot;
+
+--
+-- TOC entry 210 (class 1259 OID 155938)
+-- Name: projects_emerge_options_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.projects_emerge_options_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.projects_emerge_options_id_seq OWNER TO buildbot;
+
+--
+-- TOC entry 2479 (class 0 OID 0)
+-- Dependencies: 210
+-- Name: projects_emerge_options_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
+--
+
+ALTER SEQUENCE public.projects_emerge_options_id_seq OWNED BY public.projects_emerge_options.id;
+
+
+--
+-- TOC entry 211 (class 1259 OID 155940)
+-- Name: projects_pattern; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects_pattern (
+    id integer NOT NULL,
+    project_uuid character varying(36),
+    search character varying(100) NOT NULL,
+    start integer,
+    "end" integer,
+    type public.projects_pattern_type,
+    status public.projects_pattern_status,
+    search_type public.projects_pattern_search_type
+);
+
+
+ALTER TABLE public.projects_pattern OWNER TO buildbot;
+
+--
+-- TOC entry 212 (class 1259 OID 155943)
+-- Name: projects_pattern_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.projects_pattern_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.projects_pattern_id_seq OWNER TO buildbot;
+
+--
+-- TOC entry 2480 (class 0 OID 0)
+-- Dependencies: 212
+-- Name: projects_pattern_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
+--
+
+ALTER SEQUENCE public.projects_pattern_id_seq OWNED BY public.projects_pattern.id;
+
+
+--
+-- TOC entry 213 (class 1259 OID 155945)
+-- Name: projects_portage; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects_portage (
+    id integer NOT NULL,
+    project_uuid character varying(36),
+    directorys public.projects_portage_directorys,
+    value character varying(255) NOT NULL
+);
+
+
+ALTER TABLE public.projects_portage OWNER TO buildbot;
+
+--
+-- TOC entry 214 (class 1259 OID 155948)
+-- Name: projects_portage_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.projects_portage_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.projects_portage_id_seq OWNER TO buildbot;
+
+--
+-- TOC entry 2481 (class 0 OID 0)
+-- Dependencies: 214
+-- Name: projects_portage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
+--
+
+ALTER SEQUENCE public.projects_portage_id_seq OWNED BY public.projects_portage.id;
+
+
+--
+-- TOC entry 215 (class 1259 OID 155950)
+-- Name: projects_portages_env; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects_portages_env (
+    id integer NOT NULL,
+    project_uuid character varying(36),
+    makeconf_id integer,
+    name character varying(50) NOT NULL,
+    value character varying(255) NOT NULL
+);
+
+
+ALTER TABLE public.projects_portages_env OWNER TO buildbot;
+
+--
+-- TOC entry 216 (class 1259 OID 155953)
+-- Name: projects_portages_env_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.projects_portages_env_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.projects_portages_env_id_seq OWNER TO buildbot;
+
+--
+-- TOC entry 2482 (class 0 OID 0)
+-- Dependencies: 216
+-- Name: projects_portages_env_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
+--
+
+ALTER SEQUENCE public.projects_portages_env_id_seq OWNED BY public.projects_portages_env.id;
+
+
+--
+-- TOC entry 217 (class 1259 OID 155955)
+-- Name: projects_portages_makeconf; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects_portages_makeconf (
+    id integer NOT NULL,
+    project_uuid character varying(36),
+    makeconf_id integer,
+    value character varying(255) NOT NULL
+);
+
+
+ALTER TABLE public.projects_portages_makeconf OWNER TO buildbot;
+
+--
+-- TOC entry 218 (class 1259 OID 155958)
+-- Name: projects_portages_makeconf_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.projects_portages_makeconf_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.projects_portages_makeconf_id_seq OWNER TO buildbot;
+
+--
+-- TOC entry 2483 (class 0 OID 0)
+-- Dependencies: 218
+-- Name: projects_portages_makeconf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
+--
+
+ALTER SEQUENCE public.projects_portages_makeconf_id_seq OWNED BY public.projects_portages_makeconf.id;
+
+
+--
+-- TOC entry 230 (class 1259 OID 550229)
+-- Name: projects_portages_package; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects_portages_package (
+    id bigint NOT NULL,
+    project_uuid character varying(36),
+    directory public.projects_portage_package_directorys,
+    package character varying(50),
+    value character varying(10)
+);
+
+
+ALTER TABLE public.projects_portages_package OWNER TO buildbot;
+
+--
+-- TOC entry 219 (class 1259 OID 155960)
+-- Name: projects_repositorys; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects_repositorys (
+    id integer NOT NULL,
+    project_uuid character varying(36),
+    repository_uuid character varying(36),
+    auto boolean,
+    pkgcheck public.projects_repositorys_pkgcheck,
+    build boolean,
+    test boolean,
+    test_mr boolean
+);
+
+
+ALTER TABLE public.projects_repositorys OWNER TO buildbot;
+
+--
+-- TOC entry 220 (class 1259 OID 155963)
+-- Name: projects_repositorys_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.projects_repositorys_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.projects_repositorys_id_seq OWNER TO buildbot;
+
+--
+-- TOC entry 2484 (class 0 OID 0)
+-- Dependencies: 220
+-- Name: projects_repositorys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
+--
+
+ALTER SEQUENCE public.projects_repositorys_id_seq OWNED BY public.projects_repositorys.id;
+
+
+--
+-- TOC entry 229 (class 1259 OID 484107)
+-- Name: projects_workers; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.projects_workers (
+    id bigint NOT NULL,
+    project_uuid character varying(36),
+    worker_uuid character varying(36)
+);
+
+
+ALTER TABLE public.projects_workers OWNER TO buildbot;
+
+--
+-- TOC entry 221 (class 1259 OID 155965)
+-- Name: repositorys; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.repositorys (
+    name character varying(255) NOT NULL,
+    description text,
+    url character varying(255),
+    auto boolean,
+    enabled boolean,
+    ebuild boolean,
+    type public.repositorys_type,
+    uuid character varying(36) NOT NULL,
+    branch character varying(255),
+    mode public.repositorys_mode,
+    method public.repositorys_method,
+    alwaysuselatest boolean,
+    merge boolean,
+    sshprivatekey character varying(50),
+    sshhostkey character varying(50)
+);
+
+
+ALTER TABLE public.repositorys OWNER TO buildbot;
+
+--
+-- TOC entry 222 (class 1259 OID 155971)
+-- Name: repositorys_gitpullers; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.repositorys_gitpullers (
+    id integer NOT NULL,
+    repository_uuid character varying(36),
+    project character varying(255) NOT NULL,
+    url character varying(255) NOT NULL,
+    branches character varying(255) NOT NULL,
+    poll_interval integer NOT NULL,
+    poll_random_delay_min integer NOT NULL,
+    poll_random_delay_max integer NOT NULL,
+    updated_at integer DEFAULT 0
+);
+
+
+ALTER TABLE public.repositorys_gitpullers OWNER TO buildbot;
+
+--
+-- TOC entry 223 (class 1259 OID 155978)
+-- Name: repositorys_gitpullers_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.repositorys_gitpullers_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.repositorys_gitpullers_id_seq OWNER TO buildbot;
+
+--
+-- TOC entry 2485 (class 0 OID 0)
+-- Dependencies: 223
+-- Name: repositorys_gitpullers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
+--
+
+ALTER SEQUENCE public.repositorys_gitpullers_id_seq OWNED BY public.repositorys_gitpullers.id;
+
+
+--
+-- TOC entry 224 (class 1259 OID 155980)
+-- Name: users; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.users (
+    uid integer NOT NULL,
+    email character varying(255) NOT NULL,
+    bb_username character varying(128) DEFAULT NULL::character varying,
+    bb_password character varying(128) DEFAULT NULL::character varying
+);
+
+
+ALTER TABLE public.users OWNER TO buildbot;
+
+--
+-- TOC entry 225 (class 1259 OID 155988)
+-- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.users_uid_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.users_uid_seq OWNER TO buildbot;
+
+--
+-- TOC entry 2486 (class 0 OID 0)
+-- Dependencies: 225
+-- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: buildbot
+--
+
+ALTER SEQUENCE public.users_uid_seq OWNED BY public.users.uid;
+
+
+--
+-- TOC entry 226 (class 1259 OID 155990)
+-- Name: versions; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.versions (
+    uuid character varying(36) NOT NULL,
+    name character varying(255) NOT NULL,
+    package_uuid character varying(36),
+    file_hash character varying(255) NOT NULL,
+    commit_id character varying(255) NOT NULL,
+    deleted boolean,
+    deleted_at integer
+);
+
+
+ALTER TABLE public.versions OWNER TO buildbot;
+
+--
+-- TOC entry 227 (class 1259 OID 155996)
+-- Name: versions_keywords; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.versions_keywords (
+    uuid character varying(36) NOT NULL,
+    keyword_id integer NOT NULL,
+    version_uuid character varying(36),
+    status public.versions_keywords_status
+);
+
+
+ALTER TABLE public.versions_keywords OWNER TO buildbot;
+
+--
+-- TOC entry 232 (class 1259 OID 702199)
+-- Name: versions_metadata_id_seq; Type: SEQUENCE; Schema: public; Owner: buildbot
+--
+
+CREATE SEQUENCE public.versions_metadata_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    MAXVALUE 2147483647
+    CACHE 1;
+
+
+ALTER TABLE public.versions_metadata_id_seq OWNER TO buildbot;
+
+--
+-- TOC entry 231 (class 1259 OID 698041)
+-- Name: versions_metadata; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.versions_metadata (
+    version_uuid character varying(36),
+    metadata public.versions_metadata_type,
+    value character varying(255),
+    id integer DEFAULT nextval('public.versions_metadata_id_seq'::regclass) NOT NULL
+);
+
+
+ALTER TABLE public.versions_metadata OWNER TO buildbot;
+
+--
+-- TOC entry 228 (class 1259 OID 484104)
+-- Name: workers; Type: TABLE; Schema: public; Owner: buildbot
+--
+
+CREATE TABLE public.workers (
+    uuid character varying(36),
+    enable boolean,
+    type public.workers_type
+);
+
+
+ALTER TABLE public.workers OWNER TO buildbot;
+
+--
+-- TOC entry 2228 (class 2604 OID 155999)
+-- Name: portages_makeconf id; Type: DEFAULT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.portages_makeconf ALTER COLUMN id SET DEFAULT nextval('public.portages_makeconf_id_seq'::regclass);
+
+
+--
+-- TOC entry 2230 (class 2604 OID 156000)
+-- Name: projects_builds id; Type: DEFAULT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_builds ALTER COLUMN id SET DEFAULT nextval('public.projects_builds_id_seq'::regclass);
+
+
+--
+-- TOC entry 2231 (class 2604 OID 156001)
+-- Name: projects_emerge_options id; Type: DEFAULT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_emerge_options ALTER COLUMN id SET DEFAULT nextval('public.projects_emerge_options_id_seq'::regclass);
+
+
+--
+-- TOC entry 2232 (class 2604 OID 156002)
+-- Name: projects_pattern id; Type: DEFAULT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_pattern ALTER COLUMN id SET DEFAULT nextval('public.projects_pattern_id_seq'::regclass);
+
+
+--
+-- TOC entry 2233 (class 2604 OID 156003)
+-- Name: projects_portage id; Type: DEFAULT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portage ALTER COLUMN id SET DEFAULT nextval('public.projects_portage_id_seq'::regclass);
+
+
+--
+-- TOC entry 2234 (class 2604 OID 156004)
+-- Name: projects_portages_env id; Type: DEFAULT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_env ALTER COLUMN id SET DEFAULT nextval('public.projects_portages_env_id_seq'::regclass);
+
+
+--
+-- TOC entry 2235 (class 2604 OID 156005)
+-- Name: projects_portages_makeconf id; Type: DEFAULT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_makeconf ALTER COLUMN id SET DEFAULT nextval('public.projects_portages_makeconf_id_seq'::regclass);
+
+
+--
+-- TOC entry 2236 (class 2604 OID 156006)
+-- Name: projects_repositorys id; Type: DEFAULT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_repositorys ALTER COLUMN id SET DEFAULT nextval('public.projects_repositorys_id_seq'::regclass);
+
+
+--
+-- TOC entry 2238 (class 2604 OID 156007)
+-- Name: repositorys_gitpullers id; Type: DEFAULT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.repositorys_gitpullers ALTER COLUMN id SET DEFAULT nextval('public.repositorys_gitpullers_id_seq'::regclass);
+
+
+--
+-- TOC entry 2241 (class 2604 OID 156008)
+-- Name: users uid; Type: DEFAULT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.users ALTER COLUMN uid SET DEFAULT nextval('public.users_uid_seq'::regclass);
+
+
+--
+-- TOC entry 2244 (class 2606 OID 156010)
+-- Name: categorys categorys_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.categorys
+    ADD CONSTRAINT categorys_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2246 (class 2606 OID 156012)
+-- Name: categorys categorys_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.categorys
+    ADD CONSTRAINT categorys_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2248 (class 2606 OID 156014)
+-- Name: keywords keywords_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.keywords
+    ADD CONSTRAINT keywords_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2250 (class 2606 OID 156016)
+-- Name: keywords keywords_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.keywords
+    ADD CONSTRAINT keywords_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2252 (class 2606 OID 156018)
+-- Name: migrate_version migrate_version_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.migrate_version
+    ADD CONSTRAINT migrate_version_pkey PRIMARY KEY (repository_id);
+
+
+--
+-- TOC entry 2254 (class 2606 OID 156020)
+-- Name: packages packages_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.packages
+    ADD CONSTRAINT packages_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2256 (class 2606 OID 156022)
+-- Name: packages packages_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.packages
+    ADD CONSTRAINT packages_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2258 (class 2606 OID 156024)
+-- Name: portages_makeconf portages_makeconf_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.portages_makeconf
+    ADD CONSTRAINT portages_makeconf_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2260 (class 2606 OID 156026)
+-- Name: portages_makeconf portages_makeconf_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.portages_makeconf
+    ADD CONSTRAINT portages_makeconf_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2266 (class 2606 OID 156028)
+-- Name: projects_builds projects_builds_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_builds
+    ADD CONSTRAINT projects_builds_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2268 (class 2606 OID 156030)
+-- Name: projects_builds projects_builds_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_builds
+    ADD CONSTRAINT projects_builds_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2270 (class 2606 OID 156032)
+-- Name: projects_emerge_options projects_emerge_options_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_emerge_options
+    ADD CONSTRAINT projects_emerge_options_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2272 (class 2606 OID 156034)
+-- Name: projects_emerge_options projects_emerge_options_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_emerge_options
+    ADD CONSTRAINT projects_emerge_options_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2274 (class 2606 OID 156036)
+-- Name: projects_pattern projects_pattern_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_pattern
+    ADD CONSTRAINT projects_pattern_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2276 (class 2606 OID 156038)
+-- Name: projects_pattern projects_pattern_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_pattern
+    ADD CONSTRAINT projects_pattern_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2262 (class 2606 OID 156040)
+-- Name: projects projects_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects
+    ADD CONSTRAINT projects_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2316 (class 2606 OID 550233)
+-- Name: projects_portages_package projects_portage_package_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_package
+    ADD CONSTRAINT projects_portage_package_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2278 (class 2606 OID 156042)
+-- Name: projects_portage projects_portage_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portage
+    ADD CONSTRAINT projects_portage_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2280 (class 2606 OID 156044)
+-- Name: projects_portage projects_portage_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portage
+    ADD CONSTRAINT projects_portage_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2282 (class 2606 OID 156046)
+-- Name: projects_portages_env projects_portages_env_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_env
+    ADD CONSTRAINT projects_portages_env_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2284 (class 2606 OID 156048)
+-- Name: projects_portages_env projects_portages_env_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_env
+    ADD CONSTRAINT projects_portages_env_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2286 (class 2606 OID 156050)
+-- Name: projects_portages_makeconf projects_portages_makeconf_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_makeconf
+    ADD CONSTRAINT projects_portages_makeconf_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2288 (class 2606 OID 156052)
+-- Name: projects_portages_makeconf projects_portages_makeconf_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_makeconf
+    ADD CONSTRAINT projects_portages_makeconf_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2290 (class 2606 OID 156054)
+-- Name: projects_repositorys projects_repositorys_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_repositorys
+    ADD CONSTRAINT projects_repositorys_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2292 (class 2606 OID 156056)
+-- Name: projects_repositorys projects_repositorys_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_repositorys
+    ADD CONSTRAINT projects_repositorys_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2264 (class 2606 OID 156058)
+-- Name: projects projects_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects
+    ADD CONSTRAINT projects_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2314 (class 2606 OID 484111)
+-- Name: projects_workers projects_workers_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_workers
+    ADD CONSTRAINT projects_workers_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2298 (class 2606 OID 156060)
+-- Name: repositorys_gitpullers repositorys_gitpullers_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.repositorys_gitpullers
+    ADD CONSTRAINT repositorys_gitpullers_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2300 (class 2606 OID 156062)
+-- Name: repositorys_gitpullers repositorys_gitpullers_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.repositorys_gitpullers
+    ADD CONSTRAINT repositorys_gitpullers_unique UNIQUE (id);
+
+
+--
+-- TOC entry 2294 (class 2606 OID 156064)
+-- Name: repositorys repositorys_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.repositorys
+    ADD CONSTRAINT repositorys_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2296 (class 2606 OID 156066)
+-- Name: repositorys repositorys_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.repositorys
+    ADD CONSTRAINT repositorys_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2302 (class 2606 OID 156068)
+-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.users
+    ADD CONSTRAINT users_pkey PRIMARY KEY (uid);
+
+
+--
+-- TOC entry 2304 (class 2606 OID 156070)
+-- Name: users users_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.users
+    ADD CONSTRAINT users_unique UNIQUE (uid);
+
+
+--
+-- TOC entry 2310 (class 2606 OID 156072)
+-- Name: versions_keywords versions_keywords_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.versions_keywords
+    ADD CONSTRAINT versions_keywords_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2312 (class 2606 OID 156074)
+-- Name: versions_keywords versions_keywords_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.versions_keywords
+    ADD CONSTRAINT versions_keywords_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2318 (class 2606 OID 698703)
+-- Name: versions_metadata versions_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.versions_metadata
+    ADD CONSTRAINT versions_metadata_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 2306 (class 2606 OID 156076)
+-- Name: versions versions_pkey; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.versions
+    ADD CONSTRAINT versions_pkey PRIMARY KEY (uuid);
+
+
+--
+-- TOC entry 2308 (class 2606 OID 156078)
+-- Name: versions versions_unique; Type: CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.versions
+    ADD CONSTRAINT versions_unique UNIQUE (uuid);
+
+
+--
+-- TOC entry 2319 (class 2606 OID 156079)
+-- Name: packages category_uuid_fk; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.packages
+    ADD CONSTRAINT category_uuid_fk FOREIGN KEY (category_uuid) REFERENCES public.categorys(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2321 (class 2606 OID 156084)
+-- Name: projects keywords_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects
+    ADD CONSTRAINT keywords_fkey FOREIGN KEY (keyword_id) REFERENCES public.keywords(id) NOT VALID;
+
+
+--
+-- TOC entry 2336 (class 2606 OID 156089)
+-- Name: versions_keywords keywords_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.versions_keywords
+    ADD CONSTRAINT keywords_fkey FOREIGN KEY (keyword_id) REFERENCES public.keywords(id) NOT VALID;
+
+
+--
+-- TOC entry 2328 (class 2606 OID 156094)
+-- Name: projects_portages_env makeconf_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_env
+    ADD CONSTRAINT makeconf_fkey FOREIGN KEY (makeconf_id) REFERENCES public.portages_makeconf(id) NOT VALID;
+
+
+--
+-- TOC entry 2330 (class 2606 OID 156099)
+-- Name: projects_portages_makeconf makeconf_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_makeconf
+    ADD CONSTRAINT makeconf_fkey FOREIGN KEY (makeconf_id) REFERENCES public.portages_makeconf(id) NOT VALID;
+
+
+--
+-- TOC entry 2335 (class 2606 OID 156104)
+-- Name: versions packages_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.versions
+    ADD CONSTRAINT packages_fkey FOREIGN KEY (package_uuid) REFERENCES public.packages(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2322 (class 2606 OID 156109)
+-- Name: projects profile_repositorys_uuid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects
+    ADD CONSTRAINT profile_repositorys_uuid_fkey FOREIGN KEY (profile_repository_uuid) REFERENCES public.repositorys(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2338 (class 2606 OID 550234)
+-- Name: projects_portages_package project_portage_package_pkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_package
+    ADD CONSTRAINT project_portage_package_pkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2323 (class 2606 OID 156114)
+-- Name: projects_builds projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_builds
+    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2325 (class 2606 OID 156119)
+-- Name: projects_emerge_options projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_emerge_options
+    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2326 (class 2606 OID 156124)
+-- Name: projects_pattern projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_pattern
+    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2327 (class 2606 OID 156129)
+-- Name: projects_portage projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portage
+    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2329 (class 2606 OID 156134)
+-- Name: projects_portages_env projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_env
+    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2331 (class 2606 OID 156139)
+-- Name: projects_portages_makeconf projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_portages_makeconf
+    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2332 (class 2606 OID 156144)
+-- Name: projects_repositorys projects_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_repositorys
+    ADD CONSTRAINT projects_fkey FOREIGN KEY (project_uuid) REFERENCES public.projects(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2333 (class 2606 OID 156149)
+-- Name: projects_repositorys repositorys_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_repositorys
+    ADD CONSTRAINT repositorys_fkey FOREIGN KEY (repository_uuid) REFERENCES public.repositorys(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2334 (class 2606 OID 156154)
+-- Name: repositorys_gitpullers repositorys_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.repositorys_gitpullers
+    ADD CONSTRAINT repositorys_fkey FOREIGN KEY (repository_uuid) REFERENCES public.repositorys(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2320 (class 2606 OID 156159)
+-- Name: packages repositorys_uuid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.packages
+    ADD CONSTRAINT repositorys_uuid_fkey FOREIGN KEY (repository_uuid) REFERENCES public.repositorys(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2324 (class 2606 OID 156164)
+-- Name: projects_builds versions_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.projects_builds
+    ADD CONSTRAINT versions_fkey FOREIGN KEY (version_uuid) REFERENCES public.versions(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2337 (class 2606 OID 156169)
+-- Name: versions_keywords versions_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.versions_keywords
+    ADD CONSTRAINT versions_fkey FOREIGN KEY (version_uuid) REFERENCES public.versions(uuid) NOT VALID;
+
+
+--
+-- TOC entry 2339 (class 2606 OID 698046)
+-- Name: versions_metadata versions_metadata_version_uuid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: buildbot
+--
+
+ALTER TABLE ONLY public.versions_metadata
+    ADD CONSTRAINT versions_metadata_version_uuid_fkey FOREIGN KEY (version_uuid) REFERENCES public.versions(uuid);
+
+
+--
+-- TOC entry 2476 (class 0 OID 0)
+-- Dependencies: 3
+-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
+--
+
+REVOKE ALL ON SCHEMA public FROM postgres;
+GRANT ALL ON SCHEMA public TO buildbot;
+
+
+-- Completed on 2022-08-21 10:37:13 CEST
+
+--
+-- PostgreSQL database dump complete
+--
+


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2022-08-22 22:35 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2022-08-22 22:35 UTC (permalink / raw
  To: gentoo-commits

commit:     e0aa266cf65e0fecd032ef58b188b71e51d5e340
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Mon Aug 22 21:44:13 2022 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Mon Aug 22 21:44:13 2022 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=e0aa266c

Remove gitpuller from repositorys_type in db

Signed-off-by: Magnus Granberg <zorry <AT> gentoo.org>

 sql/gentoo_ci_schema.sql | 1 -
 1 file changed, 1 deletion(-)

diff --git a/sql/gentoo_ci_schema.sql b/sql/gentoo_ci_schema.sql
index f1725fa..70a7401 100644
--- a/sql/gentoo_ci_schema.sql
+++ b/sql/gentoo_ci_schema.sql
@@ -203,7 +203,6 @@ ALTER TYPE public.repositorys_mode OWNER TO postgres;
 --
 
 CREATE TYPE public.repositorys_type AS ENUM (
-    'gitpuller',
     'git',
     'gitlab'
 );


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2022-09-11 21:48 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2022-09-11 21:48 UTC (permalink / raw
  To: gentoo-commits

commit:     01811de291a75c1b65b71575b33217b189509413
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Sun Sep 11 21:48:32 2022 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Sun Sep 11 21:48:32 2022 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=01811de2

Fix a id error on id 950

Signed-off-by: Magnus Granberg <zorry <AT> gentoo.org>

 sql/search_pattern.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sql/search_pattern.sql b/sql/search_pattern.sql
index 50fb4e1..afa87d4 100644
--- a/sql/search_pattern.sql
+++ b/sql/search_pattern.sql
@@ -747,7 +747,7 @@ INSERT INTO public.projects_pattern VALUES (919, 'e89c2c1a-46e0-4ded-81dd-c51afe
 
 -- ignore
 INSERT INTO public.projects_pattern VALUES (950, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^>>> /', 0, 0, 'ignore', 'ignore', 'search');
-INSERT INTO public.projects_pattern VALUES (950, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^./usr/', 0, 0, 'ignore', 'ignore', 'search');
+INSERT INTO public.projects_pattern VALUES (951, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', '^./usr/', 0, 0, 'ignore', 'ignore', 'search');
 
 
 --


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2022-10-04 23:58 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2022-10-04 23:58 UTC (permalink / raw
  To: gentoo-commits

commit:     74dc875a027df21c3aa0504e4fc9526fb3c6944d
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Tue Oct  4 23:58:19 2022 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Tue Oct  4 23:58:19 2022 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=74dc875a

Fix owner to buildbot

Signed-off-by: Magnus Granberg <zorry <AT> gentoo.org>

 sql/gentoo_ci_schema.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/sql/gentoo_ci_schema.sql b/sql/gentoo_ci_schema.sql
index fc10eff..ff81661 100644
--- a/sql/gentoo_ci_schema.sql
+++ b/sql/gentoo_ci_schema.sql
@@ -137,7 +137,7 @@ CREATE TYPE public.projects_status AS ENUM (
 ALTER TYPE public.projects_status OWNER TO buildbot;
 
 --
--- Name: repositorys_method; Type: TYPE; Schema: public; Owner: postgres
+-- Name: repositorys_method; Type: TYPE; Schema: public; Owner: buildbot
 --
 
 CREATE TYPE public.repositorys_method AS ENUM (
@@ -148,10 +148,10 @@ CREATE TYPE public.repositorys_method AS ENUM (
 );
 
 
-ALTER TYPE public.repositorys_method OWNER TO postgres;
+ALTER TYPE public.repositorys_method OWNER TO buildbot;
 
 --
--- Name: repositorys_mode; Type: TYPE; Schema: public; Owner: postgres
+-- Name: repositorys_mode; Type: TYPE; Schema: public; Owner: buildbot
 --
 
 CREATE TYPE public.repositorys_mode AS ENUM (
@@ -160,7 +160,7 @@ CREATE TYPE public.repositorys_mode AS ENUM (
 );
 
 
-ALTER TYPE public.repositorys_mode OWNER TO postgres;
+ALTER TYPE public.repositorys_mode OWNER TO buildbot;
 
 --
 -- Name: repositorys_type; Type: TYPE; Schema: public; Owner: buildbot


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2023-02-21  2:34 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2023-02-21  2:34 UTC (permalink / raw
  To: gentoo-commits

commit:     7ca1b498984d6cb5c788cde2a68ba82d44e23965
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Tue Feb 21 02:33:49 2023 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Tue Feb 21 02:33:49 2023 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=7ca1b498

Add Could NOT find to search pattern db

Signed-off-by: Magnus Granberg <zorry <AT> gentoo.org>

 sql/search_pattern.sql | 1 +
 1 file changed, 1 insertion(+)

diff --git a/sql/search_pattern.sql b/sql/search_pattern.sql
index afa87d4..1969442 100644
--- a/sql/search_pattern.sql
+++ b/sql/search_pattern.sql
@@ -460,6 +460,7 @@ INSERT INTO public.projects_pattern VALUES (483, 'e89c2c1a-46e0-4ded-81dd-c51afe
 INSERT INTO public.projects_pattern VALUES (484, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ', not found$', 0, 0, 'configure', 'info', 'search');
 INSERT INTO public.projects_pattern VALUES (485, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could not find', 0, 0, 'configure', 'error', 'search');
 INSERT INTO public.projects_pattern VALUES (486, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'No such file or directory', 0, 0, 'configure', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (487, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Could NOT find', 0, 0, 'configure', 'error', 'search');
 
 -- File CATCH.install
 INSERT INTO public.projects_pattern VALUES (500, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Can''t locate Locale/gettext.pm in @INC', 0, 0, 'install', 'error', 'search');


^ permalink raw reply related	[flat|nested] 13+ messages in thread

* [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/
@ 2023-06-05  8:16 Magnus Granberg
  0 siblings, 0 replies; 13+ messages in thread
From: Magnus Granberg @ 2023-06-05  8:16 UTC (permalink / raw
  To: gentoo-commits

commit:     1abf3371807d22c82014ee335286db137a373300
Author:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
AuthorDate: Mon Jun  5 08:15:54 2023 +0000
Commit:     Magnus Granberg <zorry <AT> gentoo <DOT> org>
CommitDate: Mon Jun  5 08:15:54 2023 +0000
URL:        https://gitweb.gentoo.org/proj/tinderbox-cluster.git/commit/?id=1abf3371

Add requires to build (prepare)

Signed-off-by: Magnus Granberg <zorry <AT> gentoo.org>

 sql/search_pattern.sql | 1 +
 1 file changed, 1 insertion(+)

diff --git a/sql/search_pattern.sql b/sql/search_pattern.sql
index 1969442..65695a4 100644
--- a/sql/search_pattern.sql
+++ b/sql/search_pattern.sql
@@ -542,6 +542,7 @@ INSERT INTO public.projects_pattern VALUES (621, 'e89c2c1a-46e0-4ded-81dd-c51afe
 INSERT INTO public.projects_pattern VALUES (622, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'convert:', 0, 0, 'prepare', 'error', 'search');
 INSERT INTO public.projects_pattern VALUES (623, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   .* not found', 0, 0, 'prepare', 'error', 'search');
 INSERT INTO public.projects_pattern VALUES (624, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \* Failed running', 0, 0, 'prepare', 'error', 'search');
+INSERT INTO public.projects_pattern VALUES (625, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', ' \*   .* requires .* to build', 0, 0, 'prepare', 'error', 'search');
 
 -- File CATCH.pretend
 INSERT INTO public.projects_pattern VALUES (640, 'e89c2c1a-46e0-4ded-81dd-c51afeb7fcff', 'Please switch to a gcc version built with USE=', 0, 0, 'pretend', 'error', 'search');


^ permalink raw reply related	[flat|nested] 13+ messages in thread

end of thread, other threads:[~2023-06-05  8:16 UTC | newest]

Thread overview: 13+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2022-10-04 23:58 [gentoo-commits] proj/tinderbox-cluster:master commit in: sql/ Magnus Granberg
  -- strict thread matches above, loose matches on Subject: below --
2023-06-05  8:16 Magnus Granberg
2023-02-21  2:34 Magnus Granberg
2022-09-11 21:48 Magnus Granberg
2022-08-22 22:35 Magnus Granberg
2022-08-21  8:43 Magnus Granberg
2022-07-13 19:53 Magnus Granberg
2022-07-08 21:56 Magnus Granberg
2021-12-14  9:14 Magnus Granberg
2016-03-03 16:11 Magnus Granberg
2015-12-28 21:21 Magnus Granberg
2015-05-09 15:30 Magnus Granberg
2015-04-18 20:50 Magnus Granberg

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox