Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 19621)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 19639)
@@ -656,74 +656,74 @@
 
 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, 
+       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),
-       fault SMALLINT NOT NULL, 
-       PRIMARY KEY(det_id, iteration, class_id), 
-       KEY(fault), 
-       FOREIGN KEY (det_id, iteration)  
+       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;
@@ -828,5 +828,5 @@
         uri VARCHAR(255),
         path_base VARCHAR(255),
-	data_state VARCHAR(64),
+        data_state VARCHAR(64),
         bg DOUBLE,
         bg_stdev DOUBLE,
@@ -882,11 +882,14 @@
         uri VARCHAR(255),
         path_base VARCHAR(255),
-	data_state VARCHAR(64),
+        data_state VARCHAR(64),
         bg DOUBLE,
         bg_stdev DOUBLE,
         stamps_num INT,
+        stamps_mean FLOAT,
         stamps_rms FLOAT,
         sources INT,
         dtime_diff FLOAT,
+        dtime_match FLOAT,
+        dtime_phot FLOAT,
         hostname VARCHAR(64),
         good_frac FLOAT,