Changeset 36071 for branches/eam_branches/ipp-20130711/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Aug 30, 2013, 4:48:58 PM (13 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/eam_branches/ipp-20130711/ippTools/share

Files:

• . (modified) (1 prop)
• pxadmin_create_tables.sql (modified) (3 diffs, 1 prop)

branches/eam_branches/ipp-20130711/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
+    mcal        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.
@@ -2273 +2277 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE dqstatsRun (
+  dqstats_id BIGINT NOT NULL AUTO_INCREMENT,
+  state VARCHAR(64) DEFAULT NULL,
+  registered TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  label VARCHAR(64) DEFAULT NULL,
+  fault SMALLINT NOT NULL,
+  PRIMARY KEY  (dqstats_id),
+  KEY label (label),
+  KEY fault (fault)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+CREATE TABLE dqstatsContent (
+  dqstats_id BIGINT,
+  exp_id BIGINT,
+  chip_id BIGINT,
+  cam_id BIGINT,
+  warp_id BIGINT,
+  invalid TINYINT DEFAULT NULL,
+  KEY dqstats_id (dqstats_id),
+  KEY exp_id (exp_id),
+  KEY chip_id (chip_id),
+  KEY cam_id (cam_id),
+  KEY warp_id (warp_id),
+  FOREIGN KEY (dqstats_id) REFERENCES dqstatsRun (dqstats_id),
+  FOREIGN KEY (exp_id) REFERENCES rawExp (exp_id),
+  FOREIGN KEY (chip_id) REFERENCES chipRun (chip_id),
+  FOREIGN KEY (cam_id) REFERENCES camRun (cam_id),
+  FOREIGN KEY (warp_id) REFERENCES warpRun (warp_id)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;