Changeset 38932

Timestamp:

Oct 21, 2015, 12:01:05 PM (11 years ago)

Author:

bills

Message:

Add state to warpRun

Location:

trunk/ippToPsps/test

Files:

• gpc1schema.sql (modified) (1 diff)
• mkgpc1data.dvo (modified) (1 diff)

trunk/ippToPsps/test/gpc1schema.sql

@@ -8 +8 @@
   CREATE TABLE fakeRun             ( fake_id INT, cam_id INT );
 
-  CREATE TABLE warpRun             ( warp_id INT, fake_id INT, tess_id CHAR(64) );
+  CREATE TABLE warpRun             ( warp_id INT, fake_id INT, tess_id CHAR(64), state CHAR(16) );
   CREATE TABLE warpSkyCellMap      ( warp_id INT, skycell_id CHAR(64), class_id CHAR(64) );
   CREATE TABLE warpImfile          ( warp_id INT, skycell_id CHAR(64), warp_skyfile_id INT );

trunk/ippToPsps/test/mkgpc1data.dvo

@@ -351 +351 @@
   dbinsert camProcessedExp (cam_id, path_base, fault) values ($myID, "$filename", 0)
   dbinsert fakeRun (fake_id, cam_id) values ($myID, $myID)
-  dbinsert warpRun (warp_id, fake_id, tess_id) values ($myID, $myID, $TESS_ID)
+  dbinsert warpRun (warp_id, fake_id, tess_id, state) values ($myID, $myID, $TESS_ID, "full")
   dbinsert warpSkyCellMap (warp_id, skycell_id, class_id) values ($myID, $SKYCELL, "XY00")
   dbinsert warpImfile (warp_id, skycell_id, warp_skyfile_id) values ($myID, $SKYCELL, $myID)