Changeset 35896 for trunk/ippTools/share

Timestamp:

Aug 6, 2013, 11:05:55 AM (13 years ago)

Author:

bills

Message:

Add columns ippRelease.dvodb and ippRelease.ubercal_file and relExp.ubercal_dist

Location:

trunk/ippTools/share

Files:

• pxadmin_create_tables.sql (modified) (3 diffs)
• pxadmin_drop_tables.sql (modified) (1 diff)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -2172 +2172 @@
     dataRelease INT,         -- PSPS dataRelease
     priority    INT,
+    dvodb       VARCHAR(255),
+    ubercal_file VARCHAR(255),
     PRIMARY KEY(rel_id),
     UNIQUE KEY(surveyID, release_name),
@@ -2186 +2188 @@
     chip_id     BIGINT,         -- links to the runs that supplied the data
     cam_id      BIGINT,         -- for this release
-    group_id    INT,         -- id of relGroup that this exposure is contained in
+    group_id    INT,            -- id of relGroup that this exposure is contained in
     state       VARCHAR(16),    -- released, pending, archive, drop  
-    flags       INT UNSIGNED,  -- flags for relphot, relastro, ??
+    flags       INT UNSIGNED,   -- flags for relphot, relastro, ??
     zpt_obs     FLOAT,          -- calibrated zero point for this release of
     zpt_stdev   FLOAT,          -- this exposure
+    ubercal_dist INT,           -- ubercal distance (from dvo calibration)
     path_base   VARCHAR(255),   -- path_base of any supporting files for this
                                 -- release of this exposure.
@@ -2303 +2306 @@
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
+
 -- These comment lines are here to avoid an empty query error.
 -- Another way to avoid that problem is to omit the semicolon above but I think that is untidy.

trunk/ippTools/share/pxadmin_drop_tables.sql

@@ -118 +118 @@
 DROP TABLE IF EXISTS mergedvodbProcessed;
 DROP TABLE IF EXISTS mergedvodbRun;
+DROP TABLE IF EXISTS dqstatsContent;
 DROP TABLE IF EXISTS dqstatsRun;
-DROP TABLE IF EXISTS dqstatsContent;
 
 SET FOREIGN_KEY_CHECKS=1