Changeset 13990 for branches/backtrack/ippTools/share/chiptool_queuerawimfile.sql

Timestamp:

Jun 28, 2007, 12:01:22 PM (19 years ago)

Author:

jhoblitt

Message:

refactor chiptool & db to preserve metadata history

File:

• branches/backtrack/ippTools/share/chiptool_queuerawimfile.sql (modified) (1 diff)

branches/backtrack/ippTools/share/chiptool_queuerawimfile.sql

@@ -1 +1 @@
 INSERT INTO chipPendingImfile
     SELECT
-        chipPendingExp.chip_id,
-        rawImfile.class_id,
-        rawImfile.uri
-    FROM chipPendingExp
-    JOIN rawImfile
+        LAST_INSERT_ID(),
+        rawImfile.exp_tag,
+        rawImfile.class_id
+    FROM rawImfile
+    JOIN newExp
         USING(exp_tag)
     WHERE
         rawImfile.fault = 0
-        AND chipPendingExp.chip_id = LAST_INSERT_ID()
+        AND newExp.state = 'stop'
+        AND rawImfile.exp_tag = '%s'
+