Changeset 13997 for branches/backtrack/ippTools/share/chiptool_pendingimfile.sql

Timestamp:

Jul 2, 2007, 4:29:59 PM (19 years ago)

Author:

jhoblitt

Message:

rename chipPendingImfile table -> chipInputImfile

File:

• branches/backtrack/ippTools/share/chiptool_pendingimfile.sql (modified) (2 diffs)

branches/backtrack/ippTools/share/chiptool_pendingimfile.sql

@@ -1 +1 @@
 SELECT
     chipRun.*,
-    chipPendingImfile.exp_tag,
-    chipPendingImfile.class_id,
+    chipInputImfile.exp_tag,
+    chipInputImfile.class_id,
     rawImfile.uri,
     rawExp.exp_id,
@@ -9 +9 @@
     rawExp.filelevel
 FROM chipRun
-JOIN chipPendingImfile
+JOIN chipInputImfile
     USING(chip_id)
 LEFT JOIN chipProcessedImfile
-    ON chipPendingImfile.chip_id = chipProcessedImfile.chip_id
-    AND chipPendingImfile.exp_tag = chipProcessedImfile.exp_tag
-    AND chipPendingImfile.class_id = chipProcessedImfile.class_id
+    ON chipInputImfile.chip_id = chipProcessedImfile.chip_id
+    AND chipInputImfile.exp_tag = chipProcessedImfile.exp_tag
+    AND chipInputImfile.class_id = chipProcessedImfile.class_id
 JOIN rawImfile
-    ON chipPendingImfile.exp_tag = rawImfile.exp_tag
-    AND chipPendingImfile.class_id = rawImfile.class_id
+    ON chipInputImfile.exp_tag = rawImfile.exp_tag
+    AND chipInputImfile.class_id = rawImfile.class_id
 JOIN rawExp
     ON rawImfile.exp_tag = rawExp.exp_tag