Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 18764)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 19092)
@@ -485,4 +485,5 @@
     user_5 DOUBLE,
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, exp_id, class_id),
@@ -512,4 +513,5 @@
     user_5 DOUBLE,
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, exp_id),
@@ -535,4 +537,5 @@
     user_4 DOUBLE,
     user_5 DOUBLE,
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, iteration, class_id),
@@ -549,4 +552,5 @@
     class_id VARCHAR(64),
     norm FLOAT,
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, iteration, class_id),
@@ -572,4 +576,5 @@
     user_5 DOUBLE,
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, iteration, class_id),
@@ -595,4 +600,5 @@
     user_5 DOUBLE,
     path_base VARCHAR(255),
+    data_state VARCHAR(64),
     fault SMALLINT NOT NULL,
     PRIMARY KEY(det_id, iteration),
@@ -629,4 +635,5 @@
     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,7 +648,77 @@
 ) 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 detRunSummary (det_id BIGINT, iteration INT, 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 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 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),
+       data_state VARCHAR(64),
+       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 (