gump-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From stef...@apache.org
Subject svn commit: r109395 - in gump/dynagump/trunk: . src/sql webapp/WEB-INF/logs
Date Wed, 01 Dec 2004 23:08:20 GMT
Author: stefano
Date: Wed Dec  1 15:08:19 2004
New Revision: 109395

URL: http://svn.apache.org/viewcvs?view=rev&rev=109395
Log:
- updated the README (so that you guys know how to start it)
- removed a bunch of crap that got imported by mistake
- updated the database dump with the latest one

NOTE: this is still under heavy development and what's here is a proof of concept for you
to evaluate (if you feel like it).

Removed:
   gump/dynagump/trunk/.hibernateSynchronizer
   gump/dynagump/trunk/src/sql/queries.sql
   gump/dynagump/trunk/webapp/WEB-INF/logs/access.log
   gump/dynagump/trunk/webapp/WEB-INF/logs/core.log
   gump/dynagump/trunk/webapp/WEB-INF/logs/error.log
   gump/dynagump/trunk/webapp/WEB-INF/logs/flow.log
   gump/dynagump/trunk/webapp/WEB-INF/logs/handled-errors.log
   gump/dynagump/trunk/webapp/WEB-INF/logs/log4j.log
   gump/dynagump/trunk/webapp/WEB-INF/logs/sitemap.log
Modified:
   gump/dynagump/trunk/README.txt
   gump/dynagump/trunk/src/sql/mysql.dump

Deleted: /gump/dynagump/trunk/.hibernateSynchronizer
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/.hibernateSynchronizer?view=auto&rev=109394
==============================================================================

Modified: gump/dynagump/trunk/README.txt
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/README.txt?view=diff&rev=109395&p1=gump/dynagump/trunk/README.txt&r1=109394&p2=gump/dynagump/trunk/README.txt&r2=109395
==============================================================================
--- gump/dynagump/trunk/README.txt	(original)
+++ gump/dynagump/trunk/README.txt	Wed Dec  1 15:08:19 2004
@@ -22,7 +22,15 @@
   Who do I start it?
   ------------------
 
-  FIXME(SM): write this when stable.
+  1) you need mysql installed.
+  2) you need the mysql JDBC drivers installed and visibile (either in the classpath
+  or in the webapp/WEB-INF/lib directory) 
+  3) open webapp/WEB-INF/cocoon.xconf and modify the <dburl> tag according to your
setup
+  4) import the testing database dump that you find in src/sql/mysql.dump
+  5) run ./dynagump.sh
+  6) point your browser to http://localhost:8080/
+
+  That's it! 
 
 
                                  --- o ---

Modified: gump/dynagump/trunk/src/sql/mysql.dump
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/src/sql/mysql.dump?view=diff&rev=109395&p1=gump/dynagump/trunk/src/sql/mysql.dump&r1=109394&p2=gump/dynagump/trunk/src/sql/mysql.dump&r2=109395
==============================================================================
--- gump/dynagump/trunk/src/sql/mysql.dump	(original)
+++ gump/dynagump/trunk/src/sql/mysql.dump	Wed Dec  1 15:08:19 2004
@@ -1,26 +1,21 @@
--- MySQL dump 10.8
---
--- Host: localhost    Database: gump
--- ------------------------------------------------------
--- Server version	4.1.7-standard
-
-/*!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 */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */;
-
---
--- Table structure for table `builds`
---
+# CocoaMySQL dump
+# Version 0.5
+# http://cocoamysql.sourceforge.net
+#
+# Host: localhost (MySQL 4.1.7-standard)
+# Database: gump
+# Generation Time: 2004-11-30 22:22:01 -0800
+# ************************************************************
+
+# Dump of table builds
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `builds`;
+
 CREATE TABLE `builds` (
   `id` varchar(96) NOT NULL default '',
   `run` varchar(64) NOT NULL default '',
-  `project_version` varchar(32) NOT NULL default '',
+  `project_version` varchar(64) 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(1) NOT NULL default '0',
@@ -29,22 +24,25 @@
   KEY `run` (`run`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `builds`
---
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test1.blah.com:main:200411080000:0","test1.blah.com:main:200411080000","test1.blah.com:main:200411080000:project1","2004-11-08
00:01:03","2004-11-08 00:08:32","0",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test1.blah.com:main:200411080100:0","test1.blah.com:main:200411080100","test1.blah.com:main:200411080100:project1","2004-11-08
01:01:03","2004-11-08 01:08:32","0",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test1.blah.com:main:200411080000:1","test1.blah.com:main:200411080000","test1.blah.com:main:200411080000:project2","2004-11-08
00:10:09","2004-11-08 00:14:22","1",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test1.blah.com:main:200411080100:1","test1.blah.com:main:200411080100","test1.blah.com:main:200411080100:project2","2004-11-08
01:10:09","2004-11-08 01:14:22","0",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test2.blah.com:main:200411080000:0","test2.blah.com:main:200411080000","test2.blah.com:main:200411080000:project1","2004-11-08
00:01:03","2004-11-08 00:08:32","1",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test2.blah.com:main:200411080100:0","test2.blah.com:main:200411080100","test2.blah.com:main:200411080100:project1","2004-11-08
01:01:03","2004-11-08 01:08:32","0",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test2.blah.com:main:200411080000:1","test2.blah.com:main:200411080000","test2.blah.com:main:200411080000:project2","2004-11-08
00:10:09","2004-11-08 00:14:22","2",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test2.blah.com:main:200411080100:1","test2.blah.com:main:200411080100","test2.blah.com:main:200411080100:project2","2004-11-08
01:10:09","2004-11-08 01:14:22","0",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test1.blah.com:main:200411080000:2","test1.blah.com:main:200411080000","test1.blah.com:main:200411080000:project3","2004-11-08
00:15:29","2004-11-08 00:15:32","2",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test1.blah.com:main:200411080100:2","test1.blah.com:main:200411080100","test1.blah.com:main:200411080100:project3","2004-11-08
01:15:30","2004-11-08 01:15:37","1",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test2.blah.com:main:200411080000:2","test2.blah.com:main:200411080000","test2.blah.com:main:200411080000:project3","2004-11-08
00:15:29","2004-11-08 00:15:33","2",NULL);
+INSERT INTO `builds` (`id`,`run`,`project_version`,`start_time`,`end_time`,`result`,`log`)
VALUES ("test2.blah.com:main:200411080100:2","test2.blah.com:main:200411080100","test2.blah.com:main:200411080100:project3","2004-11-08
01:15:39","2004-11-08 01:15:43","0",NULL);
 
 
-/*!40000 ALTER TABLE `builds` DISABLE KEYS */;
-LOCK TABLES `builds` WRITE;
-INSERT INTO `builds` VALUES ('test1:main:200411080000:0','test1:main:200411080000','test1:main:200411080000:project1','2004-11-08
00:01:03','2004-11-08 00:08:32',0,NULL),('test1:main:200411080100:0','test1:main:200411080100','test1:main:200411080100:project1','2004-11-08
01:01:03','2004-11-08 01:08:32',0,NULL),('test1:main:200411080000:1','test1:main:200411080000','test1:main:200411080000:project2','2004-11-08
00:10:09','2004-11-08 00:14:22',1,NULL),('test1:main:200411080100:1','test1:main:200411080100','test1:main:200411080100:project2','2004-11-08
01:10:09','2004-11-08 01:14:22',0,NULL),('test2:main:200411080000:0','test2:main:200411080000','test2:main:200411080000:project1','2004-11-08
00:01:03','2004-11-08 00:08:32',1,NULL),('test2:main:200411080100:0','test2:main:200411080100','test2:main:200411080100:project1','2004-11-08
01:01:03','2004-11-08 01:08:32',0,NULL),('test2:main:200411080000:1','test2:main:200411080000','test2:main:200411080000:project2','2004-11-08
00:10:09','2004-11-08 00:14:22',2,NULL),('test2:main:200411080100:1','test2:main:200411080100','test2:main:200411080100:project2','2004-11-08
01:10:09','2004-11-08 01:14:22',0,NULL),('test1:main:200411080000:2','test1:main:200411080000','test1:main:200411080000:project3','2004-11-08
00:15:29','2004-11-08 00:15:32',2,NULL),('test1:main:200411080100:2','test1:main:200411080100','test1:main:200411080100:project3','2004-11-08
01:15:30','2004-11-08 01:15:37',1,NULL),('test2:main:200411080000:2','test2:main:200411080000','test2:main:200411080000:project3','2004-11-08
00:15:29','2004-11-08 00:15:33',2,NULL),('test2:main:200411080100:2','test2:main:200411080100','test2:main:200411080100:project3','2004-11-08
01:15:39','2004-11-08 01:15:43',0,NULL);
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `builds` ENABLE KEYS */;
-
---
--- Table structure for table `hosts`
---
+# Dump of table hosts
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `hosts`;
+
 CREATE TABLE `hosts` (
   `address` varchar(32) NOT NULL default '',
   `description` text,
@@ -53,25 +51,19 @@
   `cpu_speed_Mhz` int(8) unsigned default NULL,
   `memory_Mb` int(8) unsigned default NULL,
   `disk_Gb` int(8) unsigned default NULL,
+  `name` varchar(16) NOT NULL default '',
   PRIMARY KEY  (`address`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `hosts`
---
+INSERT INTO `hosts` (`address`,`description`,`cpu_arch`,`cpu_number`,`cpu_speed_Mhz`,`memory_Mb`,`disk_Gb`,`name`)
VALUES ("test1.blah.com","debug host 1","x86","1",NULL,NULL,NULL,"Test 1");
+INSERT INTO `hosts` (`address`,`description`,`cpu_arch`,`cpu_number`,`cpu_speed_Mhz`,`memory_Mb`,`disk_Gb`,`name`)
VALUES ("test2.blah.com","debug host 2","x86","1",NULL,NULL,NULL,"Test 2");
 
 
-/*!40000 ALTER TABLE `hosts` DISABLE KEYS */;
-LOCK TABLES `hosts` WRITE;
-INSERT INTO `hosts` VALUES ('test1','debug host 1','x86',1,NULL,NULL,NULL),('test2','debug
host 2','x86',1,NULL,NULL,NULL);
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `hosts` ENABLE KEYS */;
-
---
--- Table structure for table `modules`
---
+# Dump of table modules
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `modules`;
+
 CREATE TABLE `modules` (
   `name` varchar(32) NOT NULL default '',
   `description` tinytext,
@@ -79,88 +71,79 @@
   PRIMARY KEY  (`name`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `modules`
---
+INSERT INTO `modules` (`name`,`description`,`descriptor`) VALUES ("module1",NULL,"http://blah.com/module1/gump.xml");
+INSERT INTO `modules` (`name`,`description`,`descriptor`) VALUES ("module2",NULL,"http://blah.com/module2/gump.xml");
 
 
-/*!40000 ALTER TABLE `modules` DISABLE KEYS */;
-LOCK TABLES `modules` WRITE;
-INSERT INTO `modules` VALUES ('module1',NULL,'http://blah.com/module1/gump.xml'),('module2',NULL,'http://blah.com/module2/gump.xml');
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `modules` ENABLE KEYS */;
-
---
--- Table structure for table `packages`
---
+# Dump of table packages
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `packages`;
+
 CREATE TABLE `packages` (
   `uri` varchar(64) NOT NULL default '',
   `version` varchar(16) NOT NULL default '1.0',
-  `location` varchar(64) NOT NULL default '/',
+  `location` varchar(64) NOT NULL default ':',
   `name` varchar(16) NOT NULL default ''
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `packages`
---
 
 
-/*!40000 ALTER TABLE `packages` DISABLE KEYS */;
-LOCK TABLES `packages` WRITE;
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `packages` ENABLE KEYS */;
-
---
--- Table structure for table `project_dependencies`
---
+# Dump of table project_dependencies
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `project_dependencies`;
+
 CREATE TABLE `project_dependencies` (
-  `dependee` varchar(32) NOT NULL default '',
-  `dependant` varchar(32) NOT NULL default '',
+  `dependee` varchar(64) NOT NULL default '',
+  `dependant` varchar(64) NOT NULL default '',
   KEY `dependee` (`dependee`),
   KEY `dependant` (`dependant`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `project_dependencies`
---
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test1.blah.com:main:200411080000:project1","test1.blah.com:main:200411080000:project2");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test1.blah.com:main:200411080000:project3","test1.blah.com:main:200411080000:project2");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test1.blah.com:main:200411080000:project3","test1.blah.com:main:200411080000:project1");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test2.blah.com:main:200411080000:project2","test2.blah.com:main:200411080000:project1");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test2.blah.com:main:200411080000:project3","test2.blah.com:main:200411080000:project2");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test2.blah.com:main:200411080000:project3","test2.blah.com:main:200411080000:project1");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test1.blah.com:main:200411080100:project2","test1.blah.com:main:200411080100:project1");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test1.blah.com:main:200411080100:project3","test1.blah.com:main:200411080100:project2");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test1.blah.com:main:200411080100:project3","test1.blah.com:main:200411080100:project1");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test2.blah.com:main:200411080100:project2","test2.blah.com:main:200411080100:project1");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test2.blah.com:main:200411080100:project3","test2.blah.com:main:200411080100:project2");
+INSERT INTO `project_dependencies` (`dependee`,`dependant`) VALUES ("test2.blah.com:main:200411080100:project3","test2.blah.com:main:200411080100:project1");
 
 
-/*!40000 ALTER TABLE `project_dependencies` DISABLE KEYS */;
-LOCK TABLES `project_dependencies` WRITE;
-INSERT INTO `project_dependencies` VALUES ('test1:main:200411080000:project2','test1:main:200411080000:project1'),('test1:main:200411080000:project3','test1:main:200411080000:project2'),('test1:main:200411080000:project3','test1:main:200411080000:project1'),('test2:main:200411080000:project2','test2:main:200411080000:project1'),('test2:main:200411080000:project3','test2:main:200411080000:project2'),('test2:main:200411080000:project3','test2:main:200411080000:project1'),('test1:main:200411080100:project2','test1:main:200411080100:project1'),('test1:main:200411080100:project3','test1:main:200411080100:project2'),('test1:main:200411080100:project3','test1:main:200411080100:project1'),('test2:main:200411080100:project2','test2:main:200411080100:project1'),('test2:main:200411080100:project3','test2:main:200411080100:project2'),('test2:main:200411080100:project3','test2:main:200411080100:project1');
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `project_dependencies` ENABLE KEYS */;
-
---
--- Table structure for table `project_versions`
---
+# Dump of table project_versions
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `project_versions`;
+
 CREATE TABLE `project_versions` (
-  `id` varchar(32) NOT NULL default '',
-  `project` varchar(32) NOT NULL default ''
+  `id` varchar(64) NOT NULL default '',
+  `project` varchar(64) NOT NULL default ''
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `project_versions`
---
-
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test1.blah.com:main:200411080000:project1","project1");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test1.blah.com:main:200411080000:project2","project2");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test1.blah.com:main:200411080000:project3","project3");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test1.blah.com:main:200411080100:project1","project1");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test1.blah.com:main:200411080100:project3","project3");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test1.blah.com:main:200411080100:project2","project2");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test2.blah.com:main:200411080000:project1","project1");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test2.blah.com:main:200411080000:project2","project2");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test2.blah.com:main:200411080000:project3","project3");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test2.blah.com:main:200411080100:project1","project1");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test2.blah.com:main:200411080100:project2","project2");
+INSERT INTO `project_versions` (`id`,`project`) VALUES ("test2.blah.com:main:200411080100:project3","project3");
 
-/*!40000 ALTER TABLE `project_versions` DISABLE KEYS */;
-LOCK TABLES `project_versions` WRITE;
-INSERT INTO `project_versions` VALUES ('test1:main:200411080000:project1','project1'),('test1:main:200411080000:project2','project2'),('test1:main:200411080000:project3','project3'),('test1:main:200411080100:project1','project1'),('test1:main:200411080100:project3','project3'),('test1:main:200411080100:project2','project2'),('test2:main:200411080000:project1','project1'),('test2:main:200411080000:project2','project2'),('test2:main:200411080000:project3','project3'),('test2:main:200411080100:project1','project1'),('test2:main:200411080100:project2','project2'),('test2:main:200411080100:project3','project3');
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `project_versions` ENABLE KEYS */;
 
---
--- Table structure for table `projects`
---
+# Dump of table projects
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `projects`;
+
 CREATE TABLE `projects` (
   `name` varchar(32) NOT NULL default '',
   `description` tinytext,
@@ -170,22 +153,16 @@
   KEY `module` (`module`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `projects`
---
+INSERT INTO `projects` (`name`,`description`,`module`,`descriptor`) VALUES ("project1","The
first project","module1",NULL);
+INSERT INTO `projects` (`name`,`description`,`module`,`descriptor`) VALUES ("project2","The
second project","module1",NULL);
+INSERT INTO `projects` (`name`,`description`,`module`,`descriptor`) VALUES ("project3","The
third project","module2",NULL);
 
 
-/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
-LOCK TABLES `projects` WRITE;
-INSERT INTO `projects` VALUES ('project1',NULL,'module1',NULL),('project2',NULL,'module1',NULL),('project3',NULL,'module2',NULL);
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
-
---
--- Table structure for table `results`
---
+# Dump of table results
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `results`;
+
 CREATE TABLE `results` (
   `id` int(1) NOT NULL default '0',
   `name` varchar(16) NOT NULL default '',
@@ -193,67 +170,49 @@
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `results`
---
+INSERT INTO `results` (`id`,`name`,`description`) VALUES ("0","success","This is the status
of a successful project build");
+INSERT INTO `results` (`id`,`name`,`description`) VALUES ("1","failure","This is the status
of a failed project build");
+INSERT INTO `results` (`id`,`name`,`description`) VALUES ("2","stalled","This is the status
of a project that cannot build due to unsatisfied dependencies");
 
 
-/*!40000 ALTER TABLE `results` DISABLE KEYS */;
-LOCK TABLES `results` WRITE;
-INSERT INTO `results` VALUES (0,'success','This is the status of a successful project build'),(1,'failure','This
is the status of a failed project build'),(2,'stalled','This is the status of a project that
cannot build due to unsatisfied dependencies');
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `results` ENABLE KEYS */;
-
---
--- Table structure for table `runs`
---
+# Dump of table runs
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `runs`;
+
 CREATE TABLE `runs` (
   `id` varchar(64) 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` varchar(48) NOT NULL default '',
+  `name` varchar(12) NOT NULL default '',
   PRIMARY KEY  (`id`),
   KEY `workspace` (`workspace`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `runs`
---
+INSERT INTO `runs` (`id`,`start_time`,`end_time`,`workspace`,`name`) VALUES ("test1.blah.com:main:200411080000","2004-11-08
00:00:00","2004-11-08 00:22:00","test1.blah.com:main","200411080000");
+INSERT INTO `runs` (`id`,`start_time`,`end_time`,`workspace`,`name`) VALUES ("test1.blah.com:main:200411080100","2004-11-08
01:00:00","2004-11-08 01:33:00","test1.blah.com:main","200411080100");
+INSERT INTO `runs` (`id`,`start_time`,`end_time`,`workspace`,`name`) VALUES ("test2.blah.com:main:200411080000","2004-11-08
00:00:00","2004-11-08 00:22:00","test2.blah.com:main","200411080000");
+INSERT INTO `runs` (`id`,`start_time`,`end_time`,`workspace`,`name`) VALUES ("test2.blah.com:main:200411080100","2004-11-08
01:00:00","2004-11-08 01:33:00","test2.blah.com:main","200411080100");
 
 
-/*!40000 ALTER TABLE `runs` DISABLE KEYS */;
-LOCK TABLES `runs` WRITE;
-INSERT INTO `runs` VALUES ('test1:main:200411080000','2004-11-08 00:00:00','2004-11-08 00:22:00','test1:main'),('test1:main:200411080100','2004-11-08
01:00:00','2004-11-08 01:33:00','test1:main'),('test2:main:200411080000','2004-11-08 00:00:00','2004-11-08
00:22:00','test2:main'),('test2:main:200411080100','2004-11-08 01:00:00','2004-11-08 01:33:00','test2:main');
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `runs` ENABLE KEYS */;
-
---
--- Table structure for table `runtime_dependencies`
---
+# Dump of table runtime_dependencies
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `runtime_dependencies`;
+
 CREATE TABLE `runtime_dependencies` (
   `run` varchar(64) NOT NULL default '',
   `package` varchar(64) NOT NULL default ''
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `runtime_dependencies`
---
 
 
-/*!40000 ALTER TABLE `runtime_dependencies` DISABLE KEYS */;
-LOCK TABLES `runtime_dependencies` WRITE;
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `runtime_dependencies` ENABLE KEYS */;
-
---
--- Table structure for table `workspaces`
---
+# Dump of table workspaces
+# ------------------------------------------------------------
 
 DROP TABLE IF EXISTS `workspaces`;
+
 CREATE TABLE `workspaces` (
   `id` varchar(48) NOT NULL default '0',
   `name` varchar(16) NOT NULL default '',
@@ -263,21 +222,7 @@
   KEY `host` (`host`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `workspaces`
---
-
-
-/*!40000 ALTER TABLE `workspaces` DISABLE KEYS */;
-LOCK TABLES `workspaces` WRITE;
-INSERT INTO `workspaces` VALUES ('test1:main','main','test1',NULL),('test2:main','main','test2',NULL);
-UNLOCK TABLES;
-/*!40000 ALTER TABLE `workspaces` ENABLE KEYS */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!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 */;
+INSERT INTO `workspaces` (`id`,`name`,`host`,`description`) VALUES ("test1.blah.com:main","main","test1.blah.com","The
Main Run");
+INSERT INTO `workspaces` (`id`,`name`,`host`,`description`) VALUES ("test2.blah.com:main","main","test2.blah.com","The
Main Run");
+
 

Deleted: /gump/dynagump/trunk/src/sql/queries.sql
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/src/sql/queries.sql?view=auto&rev=109394
==============================================================================

Deleted: /gump/dynagump/trunk/webapp/WEB-INF/logs/access.log
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/webapp/WEB-INF/logs/access.log?view=auto&rev=109394
==============================================================================

Deleted: /gump/dynagump/trunk/webapp/WEB-INF/logs/core.log
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/webapp/WEB-INF/logs/core.log?view=auto&rev=109394
==============================================================================

Deleted: /gump/dynagump/trunk/webapp/WEB-INF/logs/error.log
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/webapp/WEB-INF/logs/error.log?view=auto&rev=109394
==============================================================================

Deleted: /gump/dynagump/trunk/webapp/WEB-INF/logs/flow.log
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/webapp/WEB-INF/logs/flow.log?view=auto&rev=109394
==============================================================================

Deleted: /gump/dynagump/trunk/webapp/WEB-INF/logs/handled-errors.log
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/webapp/WEB-INF/logs/handled-errors.log?view=auto&rev=109394
==============================================================================

Deleted: /gump/dynagump/trunk/webapp/WEB-INF/logs/log4j.log
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/webapp/WEB-INF/logs/log4j.log?view=auto&rev=109394
==============================================================================

Deleted: /gump/dynagump/trunk/webapp/WEB-INF/logs/sitemap.log
Url: http://svn.apache.org/viewcvs/gump/dynagump/trunk/webapp/WEB-INF/logs/sitemap.log?view=auto&rev=109394
==============================================================================

Mime
View raw message