Changeset 39015 for trunk/ippToPsps/test/gpc1schema.sql

Timestamp:

Oct 30, 2015, 5:01:15 PM (11 years ago)

Author:

watersc1

Message:

Updates to make DF batches work. Test suite changes to implement that. There are still a few issues with header keywords not being respected completely, but I'm not fully sure if that's due to the simulated data or not. Change to fulltest.sh to move dbuser/pass into variables that can be changed easily.

File:

• trunk/ippToPsps/test/gpc1schema.sql (modified) (2 diffs)

trunk/ippToPsps/test/gpc1schema.sql

@@ -1 +1 @@
 
   CREATE TABLE ippToPspsFake       ( my_id INT  );
-  CREATE TABLE skycell             ( skycell_id CHAR(64), radeg REAL, decdeg REAL );
+  CREATE TABLE skycell             ( tess_id CHAR(64), skycell_id CHAR(64), radeg REAL, decdeg REAL );
   CREATE TABLE rawExp              ( exp_id INT, exp_name CHAR(64), exp_time REAL, filter CHAR(64), bg REAL, bg_stdev REAL, ra FLOAT, decl FLOAT, dateobs DATETIME );
   CREATE TABLE chipRun             ( exp_id INT, chip_id INT );
@@ -19 +19 @@
   CREATE TABLE skycalResult        ( skycal_id INT, path_base CHAR(255));
 
+  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, diff_skyfile_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) );
   CREATE TABLE addProcessedExp     ( add_id INT, fault INT );