Changeset 19064

Timestamp:

Aug 14, 2008, 9:53:21 AM (18 years ago)

Author:

eugene

Message:

cleanup detRunSummary, detRegisteredImfile, added data_state

File:

• branches/eam_branch_20080719/ippTools/share/pxadmin_create_tables.sql (modified) (1 diff)

branches/eam_branch_20080719/ippTools/share/pxadmin_create_tables.sql

@@ -682 +682 @@
        REFERENCES  detResidImfile(det_id, iteration, exp_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
-CREATE TABLE detRunSummary (det_id BIGINT, iteration INT, data_state VARHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, accept TINYINT, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detInputExp(det_id, iteration), FOREIGN KEY (det_id, iteration)  REFERENCES  detResidExp(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
-CREATE TABLE detRegisteredImfile (det_id BIGINT, iteration INT, class_id VARCHAR(64), uri VARCHAR(255), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, class_id), KEY(fault), FOREIGN KEY (det_id, iteration)  REFERENCES  detRun(det_id, iteration)) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE detRunSummary (
+       det_id BIGINT, 
+       iteration INT, 
+       data_state VARCHAR(64), 
+       bg DOUBLE, 
+       bg_stdev DOUBLE, 
+       bg_mean_stdev DOUBLE, 
+       accept TINYINT, 
+       fault SMALLINT NOT NULL, 
+       PRIMARY KEY(det_id, iteration), 
+       KEY(fault), 
+       FOREIGN KEY (det_id, iteration)  
+         REFERENCES  detInputExp(det_id, iteration), 
+       FOREIGN KEY (det_id, iteration)  
+         REFERENCES  detResidExp(det_id, iteration)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE detRegisteredImfile (
+       det_id BIGINT, 
+       iteration INT, 
+       class_id VARCHAR(64), 
+       uri VARCHAR(255), 
+       bg DOUBLE, 
+       bg_stdev DOUBLE, 
+       bg_mean_stdev DOUBLE, 
+       user_1 DOUBLE, 
+       user_2 DOUBLE, 
+       user_3 DOUBLE, 
+       user_4 DOUBLE, 
+       user_5 DOUBLE, 
+       path_base VARCHAR(255),
+       fault SMALLINT NOT NULL, 
+       PRIMARY KEY(det_id, iteration, class_id), 
+       KEY(fault), 
+       FOREIGN KEY (det_id, iteration)  
+         REFERENCES  detRun(det_id, iteration)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
 
 CREATE TABLE warpRun (