Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 20793)
+++ trunk/dbconfig/changes.txt	(revision 20841)
@@ -713,2 +713,6 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+-- add to the run table to make the queries far less expensive
+alter table magicDSRun add column stage_id BIGINT after stage
+alter table magicDSRun add column cam_id BIGINT after stage_id;
+
Index: trunk/dbconfig/magic.md
===================================================================
--- trunk/dbconfig/magic.md	(revision 20793)
+++ trunk/dbconfig/magic.md	(revision 20841)
@@ -1,3 +1,3 @@
-# $Id: magic.md,v 1.11 2008-11-18 01:54:01 bills Exp $
+# $Id: magic.md,v 1.12 2008-11-26 03:21:13 bills Exp $
 
 ### Fault in magicRun indicates that the processing tree failed
@@ -45,4 +45,6 @@
     state       STR         0       # Key
     stage       STR         64
+    stage_id    S64         0
+    cam_id      S64         0
     outroot     STR         255
     recoveryroot    STR     255