Changeset 20841 for trunk/dbconfig

Timestamp:

Nov 25, 2008, 5:21:13 PM (18 years ago)

Author:

bills

Message:

Add the stage_id and cam_id to magicDSRun. This vastly reduces the
number of JOINs that we have to do

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• magic.md (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -713 +713 @@
 ) 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;
+

trunk/dbconfig/magic.md

@@ -1 @@
-# $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 +45 @@
     state       STR         0       # Key
     stage       STR         64
+    stage_id    S64         0
+    cam_id      S64         0
     outroot     STR         255
     recoveryroot    STR     255