Index: /branches/eam_branches/ipp-20121219/ippToPsps/test/mkgpc1.sh
===================================================================
--- /branches/eam_branches/ipp-20121219/ippToPsps/test/mkgpc1.sh	(revision 34927)
+++ /branches/eam_branches/ipp-20121219/ippToPsps/test/mkgpc1.sh	(revision 34927)
@@ -0,0 +1,154 @@
+#!/bin/csh -f
+
+## this script creates a database for testing dvopsps
+
+if ($#argv < 3) goto usage;
+
+if ("$1" == "user") then
+  if ($#argv != 4) goto usage;
+  set dbhost = $2
+  set dbuser = $3
+  set dbpass = $4
+
+  mysql -h $dbhost -u root -p <<EOF
+   grant all on *.* to $dbuser@"$dbhost" identified by '$dbpass';
+EOF
+    exit 0;
+endif
+
+if ("$1" == "create") then
+  if ($#argv != 4) goto usage;
+  set dbhost = $2
+  set dbname = $3
+  set dbuser = $4
+
+  # create a database with completely minimal tables needed to test
+  mysql -h $dbhost -u $dbuser -p <<EOF
+   CREATE DATABASE $dbname;
+   USE $dbname;
+  CREATE TABLE addRun (
+    stage CHAR 64,
+    state CHAR 64,
+    stage_id INT,
+    minidvodb_name CHAR 64
+  );
+  CREATE TABLE camProcessedExp (
+    path_base CHAR 255,
+    cam_id INT
+  );
+  CREATE TABLE camRun (
+    cam_id INT,
+    chip_id INT,
+    dist_group CHAR 64,
+    software_ver CHAR 16
+  );
+  CREATE TABLE chipRun (
+    exp_id INT,
+    chip_id INT
+  );
+  CREATE TABLE fakeRun (
+    fake_id INT,
+    cam_id INT
+  );
+  CREATE TABLE mergedvodbProcessed (
+   merge_id INT,
+   fault INT
+  );
+  CREATE TABLE mergedvodbRun (
+   minidvodb_id INT,
+   merge_id INT,
+   state CHAR 64,
+   mergedvodb CHAR 64
+  );
+  CREATE TABLE minidvodbProcessed (
+   minidvodb_id INT,
+   fault INT
+  );
+  CREATE TABLE minidvodbRun (
+   minidvodb_name CHAR 64,
+   minidvodb_id INT,
+   state CHAR 64
+  );
+  CREATE TABLE rawExp (
+   exp_id INT,
+   exp_name CHAR 64,
+   exp_time REAL,
+   bg REAL,
+   bg_stdev REAL,
+   ra FLOAT,
+   decl FLOAT
+  );
+  CREATE TABLE skycalResult (
+   path_base CHAR 255,
+   skycal_id INT
+  );
+  CREATE TABLE skycalRun (
+   skycal_id INT,
+   stack_id INT
+  );
+  CREATE TABLE skycell (
+   radec REAL,
+   decdeg REAL,
+   skycell_id CHAR 64
+  );
+  CREATE TABLE stackInputSkyfile (
+   warp_id INT
+  );
+  CREATE TABLE stackRun (
+   stack_id INT,
+   skycell_id CHAR 64,
+   filter CHAR 64,
+   software_ver CHAR 16
+  );
+  CREATE TABLE stackSumSkyfile (
+   stack_id INT
+  );
+  CREATE TABLE warpRun (
+   warp_id INT
+  );
+  CREATE TABLE warpSkyCellMap (
+   warp_id INT,
+   skycell_id CHAR 64,
+   class_id CHAR 64
+  );
+EOF
+    exit 0;
+endif
+
+if ("$1" == "delete") then
+  if ($#argv != 4) goto usage;
+  set dbhost = $2
+  set dbname = $3
+  set dbuser = $4
+
+  mysql -h $dbhost -u $dbuser -p <<EOF > /dev/null
+   USE $dbname;
+   describe dvoDetection;
+EOF
+
+  if ($status) then
+    echo "database does not contain dvoDetections, not deleting"
+    exit 1;
+  endif
+
+  echo "database is valid, deleting"
+  mysql -h $dbhost -u $dbuser -p <<EOF
+   drop database $dbname;
+EOF
+
+   exit 0;
+endif
+
+usage:
+  echo "USAGE: dbadmin.sh (options)"
+  echo ""
+  echo "  dbadmin.sh create (dbhost) (dbname) (dbuser)"
+  echo "      create a new test db"
+  echo ""
+  echo "  dbadmin.sh delete (dbhost) (dbname) (dbuser)"
+  echo "      delete an existing test db (enter pass 2x)"
+  echo ""
+  echo "  dbadmin.sh user (dbhost) (dbuser) (password)"
+  echo "      create a new user and password for the test db"
+  echo ""
+  exit 2
Index: /branches/eam_branches/ipp-20121219/ippToPsps/test/tables.txt
===================================================================
--- /branches/eam_branches/ipp-20121219/ippToPsps/test/tables.txt	(revision 34927)
+++ /branches/eam_branches/ipp-20121219/ippToPsps/test/tables.txt	(revision 34927)
@@ -0,0 +1,67 @@
+addRun
+  stage
+  state
+  stage_id
+  minidvodb_name
+camProcessedExp
+  path_base
+  cam_id
+camRun
+  cam_id
+  chip_id
+  dist_group
+  software_ver
+chipRun
+  exp_id
+  chip_id
+fakeRun
+  fake_id
+  cam_id
+mergedvodbProcessed
+ merge_id
+ fault
+mergedvodbRun
+ minidvodb_id
+ merge_id
+ state
+ mergedvodb
+minidvodbProcessed
+ minidvodb_id
+ fault
+minidvodbRun
+ minidvodb_name
+ minidvodb_id
+ state
+rawExp
+ exp_id
+ exp_name
+ exp_time
+ bg
+ bg_stdev
+ ra
+ decl
+skycalResult
+ path_base
+ skycal_id
+skycalRun
+ skycal_id
+ stack_id
+skycell
+ radec
+ decdeg
+ skycell_id
+stackInputSkyfile
+ warp_id
+stackRun
+ stack_id
+ skycell_id
+ filter
+ software_ver
+stackSumSkyfile
+ stack_id
+warpRun
+ warp_id
+warpSkyCellMap
+ warp_id
+ skycell_id
+ class_id