Changeset 18996

Timestamp:

Aug 8, 2008, 5:22:15 PM (18 years ago)

Author:

eugene

Message:

adding cleanup feature to dettool

File:

• branches/eam_branch_20080719/ippTools/share/pxadmin_create_tables.sql (modified) (8 diffs)

branches/eam_branch_20080719/ippTools/share/pxadmin_create_tables.sql

@@ -485 +485 @@
     user_5 DOUBLE,
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, exp_id, class_id),
@@ -512 +513 @@
     user_5 DOUBLE,
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, exp_id),
@@ -535 +537 @@
     user_4 DOUBLE,
     user_5 DOUBLE,
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, iteration, class_id),
@@ -549 +552 @@
     class_id VARCHAR(64),
     norm FLOAT,
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, iteration, class_id),
@@ -572 +576 @@
     user_5 DOUBLE,
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, iteration, class_id),
@@ -595 +600 @@
     user_5 DOUBLE,
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, iteration),
@@ -629 +635 @@
     user_5 DOUBLE,
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, iteration, exp_id, class_id),
@@ -641 +648 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
-CREATE TABLE detResidExp (det_id BIGINT, iteration INT, exp_id BIGINT, recipe VARCHAR(64), bg DOUBLE, bg_stdev DOUBLE, bg_mean_stdev DOUBLE, bg_skewness DOUBLE, bg_kurtosis DOUBLE, bin_stdev DOUBLE, fringe_0 DOUBLE, fringe_1 DOUBLE, fringe_2 DOUBLE, fringe_resid_0 DOUBLE, fringe_resid_1 DOUBLE, fringe_resid_2 DOUBLE, user_1 DOUBLE, user_2 DOUBLE, user_3 DOUBLE, user_4 DOUBLE, user_5 DOUBLE, path_base VARCHAR(255), accept TINYINT, fault SMALLINT NOT NULL, PRIMARY KEY(det_id, iteration, exp_id), KEY(fault), INDEX(det_id, iteration), FOREIGN KEY (det_id, iteration, exp_id)  REFERENCES  detInputExp(det_id, iteration, exp_id), FOREIGN KEY (det_id, iteration, exp_id)  REFERENCES  detResidImfile(det_id, iteration, exp_id)) ENGINE=innodb DEFAULT CHARSET=latin1;
+CREATE TABLE detResidExp (
+       det_id BIGINT, 
+       iteration INT, 
+       exp_id BIGINT, 
+       recipe VARCHAR(64), 
+       bg DOUBLE, 
+       bg_stdev DOUBLE, 
+       bg_mean_stdev DOUBLE, 
+       bg_skewness DOUBLE, 
+       bg_kurtosis DOUBLE, 
+       bin_stdev DOUBLE, 
+       fringe_0 DOUBLE, 
+       fringe_1 DOUBLE, 
+       fringe_2 DOUBLE, 
+       fringe_resid_0 DOUBLE, 
+       fringe_resid_1 DOUBLE, 
+       fringe_resid_2 DOUBLE, 
+       user_1 DOUBLE, 
+       user_2 DOUBLE, 
+       user_3 DOUBLE, 
+       user_4 DOUBLE, 
+       user_5 DOUBLE, 
+       path_base VARCHAR(255), 
+       data_state VARCHAR(64),
+       accept TINYINT, 
+       fault SMALLINT NOT NULL, 
+       PRIMARY KEY(det_id, iteration, exp_id), 
+       KEY(fault), 
+       INDEX(det_id, iteration), 
+       FOREIGN KEY (det_id, iteration, exp_id)  
+       REFERENCES  detInputExp(det_id, iteration, exp_id), 
+       FOREIGN KEY (det_id, iteration, exp_id)  
+       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;