Changeset 19622

Timestamp:

Sep 19, 2008, 4:05:33 PM (18 years ago)

Author:

bills

Message:

finish sql required to update detResidImfile

File:

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

trunk/dbconfig/changes.txt

@@ -472 +472 @@
 
 ALTER TABLE detResidImfile add column ref_det_id bigint after iteration;
-ALTER TABLE detResidImfile add column ref_iter int after iteration;
-
-ALTER TABLE detResidImfile add column ref_det_id bigint after iteration;
-ALTER TABLE detResidImfile add column ref_iter int after iteration;
+ALTER TABLE detResidImfile add column ref_iter int after ref_det_id;
 
 ALTER TABLE detRun change column parent ref_det_id bigint;
 ALTER TABLE detRun add column ref_iter int after ref_det_id;
 
--- XXX need to change the foreign key constraints on detResidImfile:
--- This
---    FOREIGN KEY (det_id, iteration)
---    REFERENCES  detNormalizedExp(det_id, iteration)
--- Becomes:
---    FOREIGN KEY (ref_det_id, ref_iter)
---    REFERENCES  detNormalizedExp(det_id, iteration)
-
--- XXX Need to population ref_det_id with the contents of det_id for detRun.mode == 'master'
+-- populate ref_det_id and ref_iter 
+UPDATE detResidImfile SET ref_det_id = det_id, ref_iter = iteration;
+
+-- Next we drop the old constraint and add the new one
+ALTER TABLE detResidImfile DROP FOREIGN KEY detResidImfile_ibfk_3;
+ALTER TABLE detResidImfile add FOREIGN KEY  (ref_det_id, ref_iter)
+    REFERENCES  detNormalizedExp(det_id, iteration);
+
+