Changeset 29902 for trunk/ippTools/share

Timestamp:

Dec 2, 2010, 3:10:33 PM (16 years ago)

Author:

bills

Message:

Save results of detection efficiency analaysis is the database.
resolve pxadmin_create_tables.sql with dbconfig and changes to the gpc1 database

Location:

trunk/ippTools/share

Files:

• camtool_find_pendingimfile.sql (modified) (1 diff, 1 prop)
• pxadmin_create_tables.sql (modified) (4 diffs, 1 prop)

trunk/ippTools/share/camtool_find_pendingimfile.sql

@@ -2 +2 @@
     camRun.cam_id,
     chipProcessedImfile.*,
+    (IF(exp_time IS NOT NULL AND deteff_magref IS NOT NULL,
+       (2.5 * LOG10(exp_time) + chipProcessedImfile.deteff_magref),  NULL))
+        AS deteff_inst,
     rawExp.exp_name,
     rawExp.camera,

trunk/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,