Changeset 20841 for trunk/dbconfig/changes.txt

Timestamp:

Nov 25, 2008, 5:21:13 PM (17 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

File:

• trunk/dbconfig/changes.txt (modified) (1 diff)

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;
+