Changeset 39276 for trunk

Timestamp:

Dec 15, 2015, 2:52:49 PM (11 years ago)

Author:

watersc1

Message:

Changes needed to fix the sastest at diff stage.

Location:

trunk/ippToPsps/test

Files:

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

trunk/ippToPsps/test/gpc1schema.sql

@@ -21 +21 @@
   CREATE TABLE diffRun             ( diff_id INT, tess_id CHAR(64), state CHAR(16), diff_mode INT, software_ver CHAR(16) );
   CREATE TABLE diffInputSkyfile    ( diff_id INT, warp1 INT, stack2 INT, diff_skyfile_id INT, tess_id CHAR(64), skycell_id CHAR(64) );
-  CREATE TABLE diffSkyfile         ( diff_id INT, skycell_id CHAR(64), path_base CHAR(255) );
+  CREATE TABLE diffSkyfile         ( diff_id INT, tess_id CHAR(64), skycell_id CHAR(64), path_base CHAR(255) );
 
   CREATE TABLE addRun              ( add_id INT, stage CHAR(64), stage_extra1 INT, state CHAR(64), stage_id INT, minidvodb_name CHAR(64) );

trunk/ippToPsps/test/mksasdata.dvo

@@ -442 +442 @@
     dbinsert diffRun (diff_id, tess_id, state, diff_mode, software_ver) values ($difID, $TESS_ID, "full", 2, "38000M")
     dbinsert diffInputSkyfile (diff_id, warp1, stack2, diff_skyfile_id, tess_id, skycell_id) values ($difID, $wrpID, $stkID, $diffSkyfileID, $TESS_ID, $skycell )
-    dbinsert diffSkyfile (diff_id, diff_skyfile_id, tess_id, skycell_id, path_base) values ($difID, $diffSkyfileID, $TESS_ID, $skycell, "$path_base")
+    dbinsert diffSkyfile (diff_id, tess_id, skycell_id, path_base) values ($difID, $TESS_ID, $skycell, "$path_base")
   end
 end