Changeset 19620 for trunk/dbconfig/changes.txt

Timestamp:

Sep 19, 2008, 2:10:32 PM (18 years ago)

Author:

eugene

Message:

adding ref_det_id, ref_iter to detRun and detResidImfile, modifying the foreign constraint

File:

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

trunk/dbconfig/changes.txt

@@ -469 +469 @@
 update fakeProcessedImfile set data_state ='full';
 
+-- adding ref_det_id and ref_iter to detRun and detResidImfile
+
+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 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'