Changeset 29902 for trunk/ippTools/share/camtool_find_pendingimfile.sql

Timestamp:

Dec 2, 2010, 3:10:33 PM (15 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

File:

• trunk/ippTools/share/camtool_find_pendingimfile.sql (modified) (1 diff, 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,