Index: /branches/eam_branch_20080706/ippTools/share/magictool_create_tmp_warpcomplete.sql
===================================================================
--- /branches/eam_branch_20080706/ippTools/share/magictool_create_tmp_warpcomplete.sql	(revision 18495)
+++ /branches/eam_branch_20080706/ippTools/share/magictool_create_tmp_warpcomplete.sql	(revision 18495)
@@ -0,0 +1,3 @@
+CREATE TEMPORARY TABLE warpComplete
+ (warp_id BIGINT, skycell_id VARCHAR(64), tess_id VARCHAR(64),
+ PRIMARY KEY(warp_id, skycell_id, tess_id)) ENGINE=MEMORY;
Index: /branches/eam_branch_20080706/ippTools/share/pstamptool_addjob_otherjob.sql
===================================================================
--- /branches/eam_branch_20080706/ippTools/share/pstamptool_addjob_otherjob.sql	(revision 18495)
+++ /branches/eam_branch_20080706/ippTools/share/pstamptool_addjob_otherjob.sql	(revision 18495)
@@ -0,0 +1,3 @@
+INSERT INTO pstampJob
+ (req_id, state, jobType, uri, outputBase, result)
+ VALUES( %s, '%s', '%s', '%s', '%s', %s);
Index: /branches/eam_branch_20080706/ippTools/share/pstamptool_addjob_stampjob.sql
===================================================================
--- /branches/eam_branch_20080706/ippTools/share/pstamptool_addjob_stampjob.sql	(revision 18495)
+++ /branches/eam_branch_20080706/ippTools/share/pstamptool_addjob_stampjob.sql	(revision 18495)
@@ -0,0 +1,3 @@
+INSERT INTO pstampJob
+ (req_id, state, jobType, uri, outputBase, result, args)
+ VALUES( %s, '%s', '%s', '%s', '%s', %s, '%s');
Index: /branches/eam_branch_20080706/ippTools/share/pstamptool_datastore.sql
===================================================================
--- /branches/eam_branch_20080706/ippTools/share/pstamptool_datastore.sql	(revision 18495)
+++ /branches/eam_branch_20080706/ippTools/share/pstamptool_datastore.sql	(revision 18495)
@@ -0,0 +1,1 @@
+SELECT * FROM pstampDataStore
Index: /branches/eam_branch_20080706/ippTools/share/pstamptool_pendingjob.sql
===================================================================
--- /branches/eam_branch_20080706/ippTools/share/pstamptool_pendingjob.sql	(revision 18495)
+++ /branches/eam_branch_20080706/ippTools/share/pstamptool_pendingjob.sql	(revision 18495)
@@ -0,0 +1,4 @@
+SELECT
+ *
+ FROM pstampJob
+ WHERE state = 'run'
Index: /branches/eam_branch_20080706/ippTools/share/pstamptool_pendingreq.sql
===================================================================
--- /branches/eam_branch_20080706/ippTools/share/pstamptool_pendingreq.sql	(revision 18495)
+++ /branches/eam_branch_20080706/ippTools/share/pstamptool_pendingreq.sql	(revision 18495)
@@ -0,0 +1,4 @@
+SELECT
+ *
+ FROM pstampRequest
+ WHERE state = 'new'