Index: branches/czw_branch/20110406/dbconfig/changes.txt
===================================================================
--- branches/czw_branch/20110406/dbconfig/changes.txt	(revision 31407)
+++ branches/czw_branch/20110406/dbconfig/changes.txt	(revision 31434)
@@ -2057,4 +2057,20 @@
 
 UPDATE dbversion set schema_version = '1.1.69', updated= CURRENT_TIMESTAMP();
+ALTER TABLE addRun ADD COLUMN stage VARCHAR(64) AFTER add_id;
+ALTER TABLE addRun ADD COLUMN stage_id bigint(20) after stage;
+UPDATE addRun set stage_id = cam_id;
+
+-- these next steps I don't know if it's generic or not. This is how to drop
+   the cam_id table in addRun for gpc1
+
+show create table addRun;
+alter table `addRun` drop foreign key `addRun_ibfk_1`, drop column cam_id;
+
+-- this sets the addRun stage for all the old addRuns to 'cam' 
+
+
+--do this update only once, so I'm commenting it out (it's been done)
+-- update addRun set stage = 'cam';
+
 
 -- Version 1.1.70
@@ -2115,2 +2131,3 @@
 
 UPDATE dbversion set schema_version = '1.1.70', updated= CURRENT_TIMESTAMP();
+