gump-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From leosim...@apache.org
Subject svn commit: r407790 - in /gump/branches/Gump3/dynagump/src/database: Gump3DB.sql Gump3TempDB.sql
Date Fri, 19 May 2006 13:19:15 GMT
Author: leosimons
Date: Fri May 19 06:19:14 2006
New Revision: 407790

URL: http://svn.apache.org/viewvc?rev=407790&view=rev
Log:
Clean up db files.

 * Gump3/dynagump/src/database/Gump3DB.sql, Gump3/dynagump/src/database/Gump3TempDB.sql: some small non-functional tweaks. Adding a license header and file description, pointing to the other db source files, replacing comments to be in English, removing phpadmin header, and reformatting files as (unix) ASCII.

Modified:
    gump/branches/Gump3/dynagump/src/database/Gump3DB.sql
    gump/branches/Gump3/dynagump/src/database/Gump3TempDB.sql

Modified: gump/branches/Gump3/dynagump/src/database/Gump3DB.sql
URL: http://svn.apache.org/viewvc/gump/branches/Gump3/dynagump/src/database/Gump3DB.sql?rev=407790&r1=407789&r2=407790&view=diff
==============================================================================
--- gump/branches/Gump3/dynagump/src/database/Gump3DB.sql (original)
+++ gump/branches/Gump3/dynagump/src/database/Gump3DB.sql Fri May 19 06:19:14 2006
@@ -1,161 +1,171 @@
--- phpMyAdmin SQL Dump
--- version 2.6.2
--- http://www.phpmyadmin.net
--- 
--- Värd: localhost
--- Skapad: 19 augusti 2005 kl 16:05
--- Serverversion: 4.0.24
--- PHP-version: 4.3.11
--- 
--- Databas: `gump`
--- 
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `builds`
--- 
-
-CREATE TABLE `builds` (
-  `id` varchar(255) NOT NULL default '',
-  `run_id` varchar(255) NOT NULL default '',
-  `project_version_id` varchar(255) NOT NULL default '',
-  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `result` int(2) NOT NULL default '0',
-  `log` text,
-  PRIMARY KEY  (`id`),
-  KEY `run_id` (`run_id`),
-  KEY `project_version_id` (`project_version_id`),
-  KEY `result` (`result`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `causes`
--- 
-
-CREATE TABLE `causes` (
-  `build_id` varchar(255) NOT NULL default '',
-  `cause_id` varchar(255) NOT NULL default '',
-  `cause_table` varchar(32) NOT NULL default 'project_versions',
-  KEY `build_id` (`build_id`),
-  KEY `cause_id` (`cause_id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `hosts`
--- 
-
-CREATE TABLE `hosts` (
-  `address` varchar(255) NOT NULL default '',
-  `description` text,
-  `cpu_arch` varchar(8) NOT NULL default 'x86',
-  `cpu_number` int(2) unsigned NOT NULL default '1',
-  `cpu_speed_Mhz` int(8) unsigned default NULL,
-  `memory_Mb` int(8) unsigned default NULL,
-  `disk_Gb` int(8) unsigned default NULL,
-  `name` varchar(32) NOT NULL default '',
-  PRIMARY KEY  (`address`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `modules`
--- 
-
-CREATE TABLE `modules` (
-  `id` varchar(255) NOT NULL default '',
-  `name` varchar(32) NOT NULL default '',
-  `description` tinytext,
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `project_dependencies`
--- 
-
-CREATE TABLE `project_dependencies` (
-  `dependee` varchar(255) NOT NULL default '',
-  `dependant` varchar(255) NOT NULL default '',
-  KEY `dependee` (`dependee`),
-  KEY `dependant` (`dependant`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `project_versions`
--- 
-
-CREATE TABLE `project_versions` (
-  `id` varchar(255) NOT NULL default '',
-  `project_id` varchar(255) NOT NULL default '',
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `projects`
--- 
-
-CREATE TABLE `projects` (
-  `id` varchar(255) NOT NULL default '',
-  `name` varchar(255) NOT NULL default '',
-  `description` tinytext,
-  `module_id` varchar(255) NOT NULL default '',
-  PRIMARY KEY  (`id`),
-  KEY `name` (`name`),
-  KEY `module_id` (`module_id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `results`
--- 
-
-CREATE TABLE `results` (
-  `id` int(2) NOT NULL default '0',
-  `name` varchar(32) NOT NULL default '',
-  `description` text,
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `runs`
--- 
-
-CREATE TABLE `runs` (
-  `id` varchar(255) NOT NULL default '',
-  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `workspace_id` varchar(255) NOT NULL default '',
-  `name` varchar(12) NOT NULL default '',
-  PRIMARY KEY  (`id`),
-  KEY `workspace_id` (`workspace_id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `workspaces`
--- 
-
-CREATE TABLE `workspaces` (
-  `id` varchar(255) NOT NULL default '0',
-  `name` varchar(32) NOT NULL default '',
-  `host` varchar(255) NOT NULL default '',
-  `description` tinytext,
-  PRIMARY KEY  (`id`),
-  KEY `host` (`host`)
-) TYPE=MyISAM;
+-----------------------------------------------------------------------------
+-- Copyright 2005,2006 The Apache Software Foundation
+--
+-- Licensed under the Apache License, Version 2.0 (the "License");
+-- you may not use this file except in compliance with the License.
+-- You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+-----------------------------------------------------------------------------
+
+--
+-- Database schema used by dynagump. See also:
+--    https://svn.apache.org/repos/asf/gump/branches/Gump3/gumpdb/src/sql
+--
+-- TODO: figure out differences between these schemas
+--       and which one should be the 'master' version
+--
+
+--
+-- Structure for table `builds`
+-- 
+
+CREATE TABLE `builds` (
+  `id` varchar(255) NOT NULL default '',
+  `run_id` varchar(255) NOT NULL default '',
+  `project_version_id` varchar(255) NOT NULL default '',
+  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `result` int(2) NOT NULL default '0',
+  `log` text,
+  PRIMARY KEY  (`id`),
+  KEY `run_id` (`run_id`),
+  KEY `project_version_id` (`project_version_id`),
+  KEY `result` (`result`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Structure for table `causes`
+-- 
+
+CREATE TABLE `causes` (
+  `build_id` varchar(255) NOT NULL default '',
+  `cause_id` varchar(255) NOT NULL default '',
+  `cause_table` varchar(32) NOT NULL default 'project_versions',
+  KEY `build_id` (`build_id`),
+  KEY `cause_id` (`cause_id`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Structure for table `hosts`
+-- 
+
+CREATE TABLE `hosts` (
+  `address` varchar(255) NOT NULL default '',
+  `description` text,
+  `cpu_arch` varchar(8) NOT NULL default 'x86',
+  `cpu_number` int(2) unsigned NOT NULL default '1',
+  `cpu_speed_Mhz` int(8) unsigned default NULL,
+  `memory_Mb` int(8) unsigned default NULL,
+  `disk_Gb` int(8) unsigned default NULL,
+  `name` varchar(32) NOT NULL default '',
+  PRIMARY KEY  (`address`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Structure for table `modules`
+-- 
+
+CREATE TABLE `modules` (
+  `id` varchar(255) NOT NULL default '',
+  `name` varchar(32) NOT NULL default '',
+  `description` tinytext,
+  PRIMARY KEY  (`id`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Structure for table `project_dependencies`
+-- 
+
+CREATE TABLE `project_dependencies` (
+  `dependee` varchar(255) NOT NULL default '',
+  `dependant` varchar(255) NOT NULL default '',
+  KEY `dependee` (`dependee`),
+  KEY `dependant` (`dependant`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Structure for table `project_versions`
+-- 
+
+CREATE TABLE `project_versions` (
+  `id` varchar(255) NOT NULL default '',
+  `project_id` varchar(255) NOT NULL default '',
+  PRIMARY KEY  (`id`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Structure for table `projects`
+-- 
+
+CREATE TABLE `projects` (
+  `id` varchar(255) NOT NULL default '',
+  `name` varchar(255) NOT NULL default '',
+  `description` tinytext,
+  `module_id` varchar(255) NOT NULL default '',
+  PRIMARY KEY  (`id`),
+  KEY `name` (`name`),
+  KEY `module_id` (`module_id`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Structure for table `results`
+-- 
+
+CREATE TABLE `results` (
+  `id` int(2) NOT NULL default '0',
+  `name` varchar(32) NOT NULL default '',
+  `description` text,
+  PRIMARY KEY  (`id`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Structure for table `runs`
+-- 
+
+CREATE TABLE `runs` (
+  `id` varchar(255) NOT NULL default '',
+  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
+  `workspace_id` varchar(255) NOT NULL default '',
+  `name` varchar(12) NOT NULL default '',
+  PRIMARY KEY  (`id`),
+  KEY `workspace_id` (`workspace_id`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+-- 
+-- Structure for table `workspaces`
+-- 
+
+CREATE TABLE `workspaces` (
+  `id` varchar(255) NOT NULL default '0',
+  `name` varchar(32) NOT NULL default '',
+  `host` varchar(255) NOT NULL default '',
+  `description` tinytext,
+  PRIMARY KEY  (`id`),
+  KEY `host` (`host`)
+) TYPE=MyISAM;

Modified: gump/branches/Gump3/dynagump/src/database/Gump3TempDB.sql
URL: http://svn.apache.org/viewvc/gump/branches/Gump3/dynagump/src/database/Gump3TempDB.sql?rev=407790&r1=407789&r2=407790&view=diff
==============================================================================
--- gump/branches/Gump3/dynagump/src/database/Gump3TempDB.sql (original)
+++ gump/branches/Gump3/dynagump/src/database/Gump3TempDB.sql Fri May 19 06:19:14 2006
@@ -1,323 +1,203 @@
--- phpMyAdmin SQL Dump
--- version 2.6.2
--- http://www.phpmyadmin.net
--- 
--- Värd: localhost
--- Skapad: 19 augusti 2005 kl 16:01
--- Serverversion: 4.0.24
--- PHP-version: 4.3.11
--- 
--- Databas: `gump`
--- 
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `builds`
--- 
-
-CREATE TABLE `builds` (
-  `id` varchar(255) NOT NULL default '',
-  `run_id` varchar(255) NOT NULL default '',
-  `project_version_id` varchar(255) NOT NULL default '',
-  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `result` int(2) NOT NULL default '0',
-  `log` text,
-  PRIMARY KEY  (`id`),
-  KEY `run_id` (`run_id`),
-  KEY `project_version_id` (`project_version_id`),
-  KEY `result` (`result`)
-) TYPE=MyISAM;
-
--- 
--- Data i tabell `builds`
--- 
-
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:0', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xjavac', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:1', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/jaxp', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:2', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/bootstrap-ant', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:3', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-apis', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 1, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:4', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-resolver', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:5', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-commons-resolver', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:6', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-xerces', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:7', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-commons-which', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:8', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/ant', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:9', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/dist-xerces', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:10', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-xercesImpl', '2005-07-05 13:51:54', '2005-07-05 12:51:54', 2, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:11', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/jaxr', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:12', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/jaxm', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:13', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/jaxrpc', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:0', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-1', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:1', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-2', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:2', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:3', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-dir-management-1', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:4', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-ant-based-1', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:5', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-failure-1', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
-INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:6', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `causes`
--- 
-
-CREATE TABLE `causes` (
-  `build_id` varchar(255) NOT NULL default '',
-  `cause_id` varchar(255) NOT NULL default '',
-  `cause_table` varchar(32) NOT NULL default 'project_versions',
-  KEY `build_id` (`build_id`),
-  KEY `cause_id` (`cause_id`)
-) TYPE=MyISAM;
-
--- 
--- Data i tabell `causes`
--- 
-
-INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:4', 'giraffe/generic@200507051351/xml-apis', 'project_versions');
-INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:5', 'giraffe/generic@200507051351/xml-resolver', 'project_versions');
-INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:6', 'giraffe/generic@200507051351/xml-commons-resolver', 'project_versions');
-INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:7', 'giraffe/generic@200507051351/xml-xerces', 'project_versions');
-INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:8', 'giraffe/generic@200507051351/xml-xerces', 'project_versions');
-INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:9', 'giraffe/generic@200507051351/ant', 'project_versions');
-INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:10', 'giraffe/generic@200507051351/xml-xerces', 'project_versions');
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `hosts`
--- 
-
-CREATE TABLE `hosts` (
-  `address` varchar(255) NOT NULL default '',
-  `description` text,
-  `cpu_arch` varchar(8) NOT NULL default 'x86',
-  `cpu_number` int(2) unsigned NOT NULL default '1',
-  `cpu_speed_Mhz` int(8) unsigned default NULL,
-  `memory_Mb` int(8) unsigned default NULL,
-  `disk_Gb` int(8) unsigned default NULL,
-  `name` varchar(32) NOT NULL default '',
-  PRIMARY KEY  (`address`)
-) TYPE=MyISAM;
-
--- 
--- Data i tabell `hosts`
--- 
-
-INSERT INTO `hosts` VALUES ('giraffe', 'giraffe (Linux,2.6.10-5-386,#1 Fri May 20 13:52:48 UTC 2005,i686,)', '', 0, 0, 0, 0, 'giraffe');
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `modules`
--- 
-
-CREATE TABLE `modules` (
-  `id` varchar(255) NOT NULL default '',
-  `name` varchar(32) NOT NULL default '',
-  `description` tinytext,
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
-
--- 
--- Data i tabell `modules`
--- 
-
-INSERT INTO `modules` VALUES ('giraffe/generic/xml-xerces2', 'xml-xerces2', '\n    Java XML Parser - the sequel with no equal\n  ');
-INSERT INTO `modules` VALUES ('giraffe/generic/java-xml-pack', 'java-xml-pack', '\n    Java XML Pack\n  ');
-INSERT INTO `modules` VALUES ('giraffe/generic/ant', 'ant', '\n    Java based build tool\n  ');
-INSERT INTO `modules` VALUES ('giraffe/generic/xml-commons', 'xml-commons', '\n    XML commons($Revision: 1.24 $) externally defined standards - DOM,SAX,JAXP; plus xml utilities\n  ');
-INSERT INTO `modules` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn', 'gump-fixture-svn', 'None');
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `project_dependencies`
--- 
-
-CREATE TABLE `project_dependencies` (
-  `dependee` varchar(255) NOT NULL default '',
-  `dependant` varchar(255) NOT NULL default '',
-  KEY `dependee` (`dependee`),
-  KEY `dependant` (`dependant`)
-) TYPE=MyISAM;
-
--- 
--- Data i tabell `project_dependencies`
--- 
-
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/bootstrap-ant', 'giraffe/generic@200507051351/jaxp');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-apis', 'giraffe/generic@200507051351/bootstrap-ant');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-apis', 'giraffe/generic@200507051351/jaxp');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-resolver', 'giraffe/generic@200507051351/jaxp');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-resolver', 'giraffe/generic@200507051351/xml-apis');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-resolver', 'giraffe/generic@200507051351/bootstrap-ant');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-commons-resolver', 'giraffe/generic@200507051351/xml-resolver');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-xerces', 'giraffe/generic@200507051351/bootstrap-ant');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-xerces', 'giraffe/generic@200507051351/xjavac');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-xerces', 'giraffe/generic@200507051351/xml-commons-resolver');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-xerces', 'giraffe/generic@200507051351/jaxp');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-commons-which', 'giraffe/generic@200507051351/xml-xerces');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-commons-which', 'giraffe/generic@200507051351/bootstrap-ant');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/ant', 'giraffe/generic@200507051351/bootstrap-ant');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/ant', 'giraffe/generic@200507051351/xml-xerces');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/ant', 'giraffe/generic@200507051351/xml-apis');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/dist-xerces', 'giraffe/generic@200507051351/ant');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/dist-xerces', 'giraffe/generic@200507051351/xjavac');
-INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-xercesImpl', 'giraffe/generic@200507051351/xml-xerces');
-INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-2', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-1');
-INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-1');
-INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-2');
-INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-dir-management-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-2');
-INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-ant-based-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3');
-INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-ant-based-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-dir-management-1');
-INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-1');
-INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3');
-INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-ant-based-1');
-INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-failure-1');
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `project_versions`
--- 
-
-CREATE TABLE `project_versions` (
-  `id` varchar(255) NOT NULL default '',
-  `project_id` varchar(255) NOT NULL default '',
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
-
--- 
--- Data i tabell `project_versions`
--- 
-
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xjavac', 'giraffe/generic/xml-xerces2/xjavac');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/jaxp', 'giraffe/generic/java-xml-pack/jaxp');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/bootstrap-ant', 'giraffe/generic/ant/bootstrap-ant');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-apis', 'giraffe/generic/xml-commons/xml-apis');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-resolver', 'giraffe/generic/xml-commons/xml-resolver');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-commons-resolver', 'giraffe/generic/xml-commons/xml-commons-resolver');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-xerces', 'giraffe/generic/xml-xerces2/xml-xerces');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-commons-which', 'giraffe/generic/xml-commons/xml-commons-which');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/ant', 'giraffe/generic/ant/ant');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/dist-xerces', 'giraffe/generic/xml-xerces2/dist-xerces');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-xercesImpl', 'giraffe/generic/xml-xerces2/xml-xercesImpl');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/jaxr', 'giraffe/generic/java-xml-pack/jaxr');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/jaxm', 'giraffe/generic/java-xml-pack/jaxm');
-INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/jaxrpc', 'giraffe/generic/java-xml-pack/jaxrpc');
-INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-1', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-1');
-INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-2', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-2');
-INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-3');
-INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-dir-management-1', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-dir-management-1');
-INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-ant-based-1', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-ant-based-1');
-INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-failure-1', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-failure-1');
-INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-prereq-failure-1');
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `projects`
--- 
-
-CREATE TABLE `projects` (
-  `id` varchar(255) NOT NULL default '',
-  `name` varchar(255) NOT NULL default '',
-  `description` tinytext,
-  `module_id` varchar(255) NOT NULL default '',
-  PRIMARY KEY  (`id`),
-  KEY `name` (`name`),
-  KEY `module_id` (`module_id`)
-) TYPE=MyISAM;
-
--- 
--- Data i tabell `projects`
--- 
-
-INSERT INTO `projects` VALUES ('giraffe/generic/xml-xerces2/xjavac', 'xjavac', 'None', 'giraffe/generic/xml-xerces2');
-INSERT INTO `projects` VALUES ('giraffe/generic/java-xml-pack/jaxp', 'jaxp', 'None', 'giraffe/generic/java-xml-pack');
-INSERT INTO `projects` VALUES ('giraffe/generic/ant/bootstrap-ant', 'bootstrap-ant', 'None', 'giraffe/generic/ant');
-INSERT INTO `projects` VALUES ('giraffe/generic/xml-commons/xml-apis', 'xml-apis', 'None', 'giraffe/generic/xml-commons');
-INSERT INTO `projects` VALUES ('giraffe/generic/xml-commons/xml-resolver', 'xml-resolver', 'None', 'giraffe/generic/xml-commons');
-INSERT INTO `projects` VALUES ('giraffe/generic/xml-commons/xml-commons-resolver', 'xml-commons-resolver', 'None', 'giraffe/generic/xml-commons');
-INSERT INTO `projects` VALUES ('giraffe/generic/xml-xerces2/xml-xerces', 'xml-xerces', 'None', 'giraffe/generic/xml-xerces2');
-INSERT INTO `projects` VALUES ('giraffe/generic/xml-commons/xml-commons-which', 'xml-commons-which', 'None', 'giraffe/generic/xml-commons');
-INSERT INTO `projects` VALUES ('giraffe/generic/ant/ant', 'ant', 'None', 'giraffe/generic/ant');
-INSERT INTO `projects` VALUES ('giraffe/generic/xml-xerces2/dist-xerces', 'dist-xerces', 'None', 'giraffe/generic/xml-xerces2');
-INSERT INTO `projects` VALUES ('giraffe/generic/xml-xerces2/xml-xercesImpl', 'xml-xercesImpl', 'None', 'giraffe/generic/xml-xerces2');
-INSERT INTO `projects` VALUES ('giraffe/generic/java-xml-pack/jaxr', 'jaxr', 'None', 'giraffe/generic/java-xml-pack');
-INSERT INTO `projects` VALUES ('giraffe/generic/java-xml-pack/jaxm', 'jaxm', 'None', 'giraffe/generic/java-xml-pack');
-INSERT INTO `projects` VALUES ('giraffe/generic/java-xml-pack/jaxrpc', 'jaxrpc', 'None', 'giraffe/generic/java-xml-pack');
-INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-1', 'gump-fixture-svn-project-1', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
-INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-2', 'gump-fixture-svn-project-2', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
-INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-3', 'gump-fixture-svn-project-3', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
-INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-dir-management-1', 'gump-fixture-svn-project-dir-management-1', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
-INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-ant-based-1', 'gump-fixture-svn-project-ant-based-1', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
-INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-failure-1', 'gump-fixture-svn-project-failure-1', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
-INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-prereq-failure-1', 'gump-fixture-svn-project-prereq-failure-1', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `results`
--- 
-
-CREATE TABLE `results` (
-  `id` int(2) NOT NULL default '0',
-  `name` varchar(32) NOT NULL default '',
-  `description` text,
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM;
-
--- 
--- Data i tabell `results`
--- 
-
-INSERT INTO `results` VALUES (0, 'success', 'This is the status of a successful project build');
-INSERT INTO `results` VALUES (1, 'failure', 'This is the status of a failed project build');
-INSERT INTO `results` VALUES (2, 'stalled', 'This is the status of a project that cannot build due to unsatisfied dependencies');
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `runs`
--- 
-
-CREATE TABLE `runs` (
-  `id` varchar(255) NOT NULL default '',
-  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
-  `workspace_id` varchar(255) NOT NULL default '',
-  `name` varchar(12) NOT NULL default '',
-  PRIMARY KEY  (`id`),
-  KEY `workspace_id` (`workspace_id`)
-) TYPE=MyISAM;
-
--- 
--- Data i tabell `runs`
--- 
-
-INSERT INTO `runs` VALUES ('giraffe/generic@200507051351', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 'giraffe/generic', '200507051351');
-INSERT INTO `runs` VALUES ('giraffe/gump3-test-fixture@200507051352', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 'giraffe/gump3-test-fixture', '200507051352');
-
--- --------------------------------------------------------
-
--- 
--- Struktur för tabell `workspaces`
--- 
-
-CREATE TABLE `workspaces` (
-  `id` varchar(255) NOT NULL default '0',
-  `name` varchar(32) NOT NULL default '',
-  `host` varchar(255) NOT NULL default '',
-  `description` tinytext,
-  PRIMARY KEY  (`id`),
-  KEY `host` (`host`)
-) TYPE=MyISAM;
-
--- 
--- Data i tabell `workspaces`
--- 
-
-INSERT INTO `workspaces` VALUES ('giraffe/generic', 'generic', 'giraffe', 'None');
-INSERT INTO `workspaces` VALUES ('giraffe/gump3-test-fixture', 'gump3-test-fixture', 'giraffe', 'None');
+-----------------------------------------------------------------------------
+-- Copyright 2005,2006 The Apache Software Foundation
+--
+-- Licensed under the Apache License, Version 2.0 (the "License");
+-- you may not use this file except in compliance with the License.
+-- You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing, software
+-- distributed under the License is distributed on an "AS IS" BASIS,
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+-- See the License for the specific language governing permissions and
+-- limitations under the License.
+-----------------------------------------------------------------------------
+
+--
+-- Sample data generated using the Gump3 test fixture workspace. See also:
+--    https://svn.apache.org/repos/asf/gump/branches/Gump3/gumpdb/src/sql
+--
+-- TODO: figure out differences between these schemas
+--       and which one should be the 'master' version
+--
+
+-- 
+-- Data for table `builds`
+-- 
+
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:0', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xjavac', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:1', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/jaxp', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:2', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/bootstrap-ant', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:3', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-apis', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 1, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:4', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-resolver', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:5', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-commons-resolver', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:6', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-xerces', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:7', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-commons-which', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:8', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/ant', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:9', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/dist-xerces', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 2, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:10', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/xml-xercesImpl', '2005-07-05 13:51:54', '2005-07-05 12:51:54', 2, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:11', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/jaxr', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:12', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/jaxm', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/generic@200507051351:13', 'giraffe/generic@200507051351', 'giraffe/generic@200507051351/jaxrpc', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:0', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-1', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:1', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-2', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:2', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:3', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-dir-management-1', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:4', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-ant-based-1', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:5', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-failure-1', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
+INSERT INTO `builds` VALUES ('giraffe/gump3-test-fixture@200507051352:6', 'giraffe/gump3-test-fixture@200507051352', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 0, 'Log saving still a TODO!');
+
+-- --------------------------------------------------------
+
+-- 
+-- Data for table `causes`
+-- 
+
+INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:4', 'giraffe/generic@200507051351/xml-apis', 'project_versions');
+INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:5', 'giraffe/generic@200507051351/xml-resolver', 'project_versions');
+INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:6', 'giraffe/generic@200507051351/xml-commons-resolver', 'project_versions');
+INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:7', 'giraffe/generic@200507051351/xml-xerces', 'project_versions');
+INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:8', 'giraffe/generic@200507051351/xml-xerces', 'project_versions');
+INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:9', 'giraffe/generic@200507051351/ant', 'project_versions');
+INSERT INTO `causes` VALUES ('giraffe/generic@200507051351:10', 'giraffe/generic@200507051351/xml-xerces', 'project_versions');
+
+-- --------------------------------------------------------
+
+-- 
+-- Data for table `hosts`
+-- 
+
+INSERT INTO `hosts` VALUES ('giraffe', 'giraffe (Linux,2.6.10-5-386,#1 Fri May 20 13:52:48 UTC 2005,i686,)', '', 0, 0, 0, 0, 'giraffe');
+
+-- --------------------------------------------------------
+
+-- 
+-- Data for table `modules`
+-- 
+
+INSERT INTO `modules` VALUES ('giraffe/generic/xml-xerces2', 'xml-xerces2', '\n    Java XML Parser - the sequel with no equal\n  ');
+INSERT INTO `modules` VALUES ('giraffe/generic/java-xml-pack', 'java-xml-pack', '\n    Java XML Pack\n  ');
+INSERT INTO `modules` VALUES ('giraffe/generic/ant', 'ant', '\n    Java based build tool\n  ');
+INSERT INTO `modules` VALUES ('giraffe/generic/xml-commons', 'xml-commons', '\n    XML commons($Revision: 1.24 $) externally defined standards - DOM,SAX,JAXP; plus xml utilities\n  ');
+INSERT INTO `modules` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn', 'gump-fixture-svn', 'None');
+
+-- --------------------------------------------------------
+
+-- 
+-- Data for table `project_dependencies`
+-- 
+
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/bootstrap-ant', 'giraffe/generic@200507051351/jaxp');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-apis', 'giraffe/generic@200507051351/bootstrap-ant');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-apis', 'giraffe/generic@200507051351/jaxp');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-resolver', 'giraffe/generic@200507051351/jaxp');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-resolver', 'giraffe/generic@200507051351/xml-apis');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-resolver', 'giraffe/generic@200507051351/bootstrap-ant');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-commons-resolver', 'giraffe/generic@200507051351/xml-resolver');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-xerces', 'giraffe/generic@200507051351/bootstrap-ant');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-xerces', 'giraffe/generic@200507051351/xjavac');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-xerces', 'giraffe/generic@200507051351/xml-commons-resolver');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-xerces', 'giraffe/generic@200507051351/jaxp');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-commons-which', 'giraffe/generic@200507051351/xml-xerces');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-commons-which', 'giraffe/generic@200507051351/bootstrap-ant');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/ant', 'giraffe/generic@200507051351/bootstrap-ant');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/ant', 'giraffe/generic@200507051351/xml-xerces');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/ant', 'giraffe/generic@200507051351/xml-apis');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/dist-xerces', 'giraffe/generic@200507051351/ant');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/dist-xerces', 'giraffe/generic@200507051351/xjavac');
+INSERT INTO `project_dependencies` VALUES ('giraffe/generic@200507051351/xml-xercesImpl', 'giraffe/generic@200507051351/xml-xerces');
+INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-2', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-1');
+INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-1');
+INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-2');
+INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-dir-management-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-2');
+INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-ant-based-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3');
+INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-ant-based-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-dir-management-1');
+INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-1');
+INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3');
+INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-ant-based-1');
+INSERT INTO `project_dependencies` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', 'giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-failure-1');
+
+-- --------------------------------------------------------
+
+-- 
+-- Data for table `project_versions`
+-- 
+
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xjavac', 'giraffe/generic/xml-xerces2/xjavac');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/jaxp', 'giraffe/generic/java-xml-pack/jaxp');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/bootstrap-ant', 'giraffe/generic/ant/bootstrap-ant');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-apis', 'giraffe/generic/xml-commons/xml-apis');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-resolver', 'giraffe/generic/xml-commons/xml-resolver');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-commons-resolver', 'giraffe/generic/xml-commons/xml-commons-resolver');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-xerces', 'giraffe/generic/xml-xerces2/xml-xerces');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-commons-which', 'giraffe/generic/xml-commons/xml-commons-which');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/ant', 'giraffe/generic/ant/ant');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/dist-xerces', 'giraffe/generic/xml-xerces2/dist-xerces');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/xml-xercesImpl', 'giraffe/generic/xml-xerces2/xml-xercesImpl');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/jaxr', 'giraffe/generic/java-xml-pack/jaxr');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/jaxm', 'giraffe/generic/java-xml-pack/jaxm');
+INSERT INTO `project_versions` VALUES ('giraffe/generic@200507051351/jaxrpc', 'giraffe/generic/java-xml-pack/jaxrpc');
+INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-1', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-1');
+INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-2', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-2');
+INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-3', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-3');
+INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-dir-management-1', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-dir-management-1');
+INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-ant-based-1', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-ant-based-1');
+INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-failure-1', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-failure-1');
+INSERT INTO `project_versions` VALUES ('giraffe/gump3-test-fixture@200507051352/gump-fixture-svn-project-prereq-failure-1', 'giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-prereq-failure-1');
+
+-- --------------------------------------------------------
+
+-- 
+-- Data for table `projects`
+-- 
+
+INSERT INTO `projects` VALUES ('giraffe/generic/xml-xerces2/xjavac', 'xjavac', 'None', 'giraffe/generic/xml-xerces2');
+INSERT INTO `projects` VALUES ('giraffe/generic/java-xml-pack/jaxp', 'jaxp', 'None', 'giraffe/generic/java-xml-pack');
+INSERT INTO `projects` VALUES ('giraffe/generic/ant/bootstrap-ant', 'bootstrap-ant', 'None', 'giraffe/generic/ant');
+INSERT INTO `projects` VALUES ('giraffe/generic/xml-commons/xml-apis', 'xml-apis', 'None', 'giraffe/generic/xml-commons');
+INSERT INTO `projects` VALUES ('giraffe/generic/xml-commons/xml-resolver', 'xml-resolver', 'None', 'giraffe/generic/xml-commons');
+INSERT INTO `projects` VALUES ('giraffe/generic/xml-commons/xml-commons-resolver', 'xml-commons-resolver', 'None', 'giraffe/generic/xml-commons');
+INSERT INTO `projects` VALUES ('giraffe/generic/xml-xerces2/xml-xerces', 'xml-xerces', 'None', 'giraffe/generic/xml-xerces2');
+INSERT INTO `projects` VALUES ('giraffe/generic/xml-commons/xml-commons-which', 'xml-commons-which', 'None', 'giraffe/generic/xml-commons');
+INSERT INTO `projects` VALUES ('giraffe/generic/ant/ant', 'ant', 'None', 'giraffe/generic/ant');
+INSERT INTO `projects` VALUES ('giraffe/generic/xml-xerces2/dist-xerces', 'dist-xerces', 'None', 'giraffe/generic/xml-xerces2');
+INSERT INTO `projects` VALUES ('giraffe/generic/xml-xerces2/xml-xercesImpl', 'xml-xercesImpl', 'None', 'giraffe/generic/xml-xerces2');
+INSERT INTO `projects` VALUES ('giraffe/generic/java-xml-pack/jaxr', 'jaxr', 'None', 'giraffe/generic/java-xml-pack');
+INSERT INTO `projects` VALUES ('giraffe/generic/java-xml-pack/jaxm', 'jaxm', 'None', 'giraffe/generic/java-xml-pack');
+INSERT INTO `projects` VALUES ('giraffe/generic/java-xml-pack/jaxrpc', 'jaxrpc', 'None', 'giraffe/generic/java-xml-pack');
+INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-1', 'gump-fixture-svn-project-1', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
+INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-2', 'gump-fixture-svn-project-2', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
+INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-3', 'gump-fixture-svn-project-3', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
+INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-dir-management-1', 'gump-fixture-svn-project-dir-management-1', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
+INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-ant-based-1', 'gump-fixture-svn-project-ant-based-1', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
+INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-failure-1', 'gump-fixture-svn-project-failure-1', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
+INSERT INTO `projects` VALUES ('giraffe/gump3-test-fixture/gump-fixture-svn/gump-fixture-svn-project-prereq-failure-1', 'gump-fixture-svn-project-prereq-failure-1', 'None', 'giraffe/gump3-test-fixture/gump-fixture-svn');
+
+-- --------------------------------------------------------
+
+-- 
+-- Data for table `results`
+-- 
+
+INSERT INTO `results` VALUES (0, 'success', 'This is the status of a successful project build');
+INSERT INTO `results` VALUES (1, 'failure', 'This is the status of a failed project build');
+INSERT INTO `results` VALUES (2, 'stalled', 'This is the status of a project that cannot build due to unsatisfied dependencies');
+
+-- --------------------------------------------------------
+
+-- 
+-- Data for table `runs`
+-- 
+
+INSERT INTO `runs` VALUES ('giraffe/generic@200507051351', '2005-07-05 13:51:54', '2005-07-05 13:51:54', 'giraffe/generic', '200507051351');
+INSERT INTO `runs` VALUES ('giraffe/gump3-test-fixture@200507051352', '2005-07-05 13:52:11', '2005-07-05 13:52:11', 'giraffe/gump3-test-fixture', '200507051352');
+
+-- --------------------------------------------------------
+
+-- 
+-- Data for table `workspaces`
+-- 
+
+INSERT INTO `workspaces` VALUES ('giraffe/generic', 'generic', 'giraffe', 'None');
+INSERT INTO `workspaces` VALUES ('giraffe/gump3-test-fixture', 'gump3-test-fixture', 'giraffe', 'None');



Mime
View raw message