Changeset 35048 for trunk/ippTools/share/releasetool_listrelexp.sql

Timestamp:

Jan 24, 2013, 4:54:58 PM (14 years ago)

Author:

bills

Message:

define relStack table
add ippRelease.priority
Change ippRelease.state to ippRelease.release_state

File:

• trunk/ippTools/share/releasetool_listrelexp.sql (modified) (3 diffs)

trunk/ippTools/share/releasetool_listrelexp.sql

@@ -1 +1 @@
 SELECT
     relexp_id,
-    releaseName,
     relExp.state,
-    rel_id,
+    ippRelease.releaseName,
+    ippRelease.release_state,
+    ippRelease.rel_id,
+    ippRelease.priority,
     survey.surveyName,
-    exp_name,
+    rawExp.exp_name,
     relExp.flags,
     relExp.zpt_obs,
@@ -12 +14 @@
     relExp.registered,
     relExp.time_stamp,
-    exp_id,
-    chip_id,
+    relExp.exp_id,
+    relExp.chip_id,
     chipRun.state as chip_state,
-    cam_id,
+    relExp.cam_id,
     camRun.state as cam_state,
     camProcessedExp.path_base as cam_path_base,
     camProcessedExp.fwhm_major,
-    warp_id,
+    warpRun.warp_id,
     warpRun.state as warp_state,
     rawExp.filter,
@@ -25 +27 @@
     TRUNCATE(DEGREES(rawExp.ra), 4) AS radeg,
     TRUNCATE(DEGREES(rawExp.decl), 4) AS decdeg,
-    rawExp.object,
     rawExp.comment
 FROM relExp