Changeset 31378

Timestamp:

Apr 25, 2011, 3:03:32 PM (15 years ago)

Author:

heather

Message:

merging addstar changes

Location:

trunk/dbconfig

Files:

• add.md (modified) (1 diff)
• changes.txt (modified) (1 diff)

trunk/dbconfig/add.md

@@ -2 +2 @@
 addRun METADATA
     add_id          S64     0       # Primary Key AUTO_INCREMENT
-    cam_id          S64     0       # Key INDEX(add_id,cam_id) fkey(cam_id) ref camRun(cam_id)
+    stage           STR     64      # what the stage is (warp, cam, diff,
+    stage_id          S64     0       # Key INDEX(add_id,cam_id) fkey(cam_id) ref camRun(cam_id)
     state           STR     64      # Key
     workdir         STR     255

trunk/dbconfig/changes.txt

@@ -2057 +2057 @@
 
 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';
+
+