Changeset 19609 for branches/eam_branch_20080918/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Sep 18, 2008, 6:39:14 PM (18 years ago)

Author:

eugene

Message:

added ref_det_id, ref_iter references for verify mode and populate as needed

File:

• branches/eam_branch_20080918/ippTools/share/pxadmin_create_tables.sql (modified) (4 diffs)

branches/eam_branch_20080918/ippTools/share/pxadmin_create_tables.sql

@@ -444 +444 @@
     solang_max FLOAT,
     label VARCHAR(64),
-    parent INT,
+    ref_det_id BIGINT,
+    ref_iter INT,
+    -- parent INT, :: dropping this
     PRIMARY KEY(det_id),
     KEY(det_id),
@@ -452 +454 @@
     KEY(state),
     KEY(label),
-    KEY(parent),
+    -- KEY(parent), :: dropping this
     INDEX(det_id, iteration))
 ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -616 +618 @@
     det_id BIGINT,
     iteration INT,
+    ref_det_id BIGINT,
+    ref_iter INT,
     exp_id BIGINT,
     class_id VARCHAR(64),
@@ -645 +649 @@
     FOREIGN KEY (det_id, iteration, exp_id)
     REFERENCES  detInputExp(det_id, iteration, exp_id),
-    FOREIGN KEY (det_id, exp_id, class_id)
-    REFERENCES  detProcessedImfile(det_id, exp_id, class_id),
-    FOREIGN KEY (det_id, iteration)
+    -- FOREIGN KEY (det_id, exp_id, class_id)
+    -- REFERENCES  detProcessedImfile(det_id, exp_id, class_id),
+    FOREIGN KEY (ref_det_id, ref_iter)
     REFERENCES  detNormalizedExp(det_id, iteration)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;