Changeset 29900

Timestamp:

Dec 2, 2010, 2:27:38 PM (15 years ago)

Author:

bills

Message:

Add new columns for detection efficiency. Add stackSumSkyfile.mjd_obs (which has been in ippdb01.gpc1 for a while now)
and fix location of camProcessedExp.quality which didn't match dbconfig/camera.md or the gpc1 database

File:

• tags/ipp-20101029/ippTools/share/pxadmin_create_tables.sql (modified) (4 diffs)

tags/ipp-20101029/ippTools/share/pxadmin_create_tables.sql

@@ -371 +371 @@
     maskfrac_magic FLOAT,
     maskfrac_advisory FLOAT,
+    deteff_magref FLOAT,
     PRIMARY KEY(chip_id, exp_id, class_id),
     KEY(data_state),
@@ -486 +487 @@
     n_astrom INT,
     path_base VARCHAR(255),
-    quality SMALLINT NOT NULL DEFAULT 0,
     fault SMALLINT NOT NULL,
     software_ver VARCHAR(16),
@@ -499 +499 @@
     maskfrac_max_magic FLOAT,
     maskfrac_max_advisory FLOAT,
+    deteff FLOAT,
+    deteff_err FLOAT,
+    deteff_lq FLOAT,
+    deteff_uq FLOAT,
+    quality SMALLINT NOT NULL DEFAULT 0,
     PRIMARY KEY(cam_id),
     KEY(fault),
@@ -1050 +1055 @@
         hostname VARCHAR(64),
         good_frac FLOAT,
+        mjd_obs DOUBLE,
         quality SMALLINT NOT NULL DEFAULT 0,
         fault SMALLINT,