Changeset 31280 for branches/haf_branches/haf_add2011/dbconfig/changes.txt

Timestamp:

Apr 14, 2011, 2:57:53 PM (15 years ago)

Author:

heather

Message:

addrun branch

Location:

branches/haf_branches/haf_add2011

Files:

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

branches/haf_branches/haf_add2011/dbconfig/changes.txt

@@ -2058 +2058 @@
 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;
+##alter table addRun drop cam_id;  (those stupid keys?)
+alter table addRun modify cam_id bigint(20) after minidvodb_name;
+
+
+
+##ALTER TABLE addRun CHANGE cam_id stage_id bigint(20);
+
+
+