Changeset 25789 for trunk/ippTools/share

Timestamp:

Oct 6, 2009, 3:48:25 PM (17 years ago)

Author:

eugene

Message:

fixed up addtool

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• addtool_donecleanup.sql (added)
• addtool_find_cam_id.sql (added)
• addtool_find_pendingexp.sql (modified) (1 diff)
• addtool_find_processedexp.sql (added)
• addtool_pendingcleanupexp.sql (added)
• addtool_pendingcleanuprun.sql (added)

trunk/ippTools/share/Makefile.am

@@ -4 +4 @@
 
 dist_pkgdata_DATA = \
+     addtool_donecleanup.sql \
+     addtool_find_cam_id.sql \
      addtool_find_pendingexp.sql \
+     addtool_find_processedexp.sql \
+     addtool_pendingcleanupexp.sql \
+     addtool_pendingcleanuprun.sql \
      addtool_queue_cam_id.sql \
      addtool_reset_faulted_runs.sql \

trunk/ippTools/share/addtool_find_pendingexp.sql

@@ -12 +12 @@
 JOIN chipRun
     USING(chip_id)
-JOIN chipProcessedImfile
-    USING(chip_id)
 JOIN rawExp
-    ON chipRun.exp_id = rawExp.exp_id
+    USING(exp_id)
 LEFT JOIN addProcessedExp
     USING(add_id)