Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 19633)
+++ 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,
Index: trunk/ippTools/src/difftool.c
===================================================================
--- trunk/ippTools/src/difftool.c	(revision 19633)
+++ trunk/ippTools/src/difftool.c	(revision 19639)
@@ -477,5 +477,8 @@
     PXOPT_LOOKUP_F64(bg_stdev, config->args, "-bg_stdev", false, false);
     PXOPT_LOOKUP_F32(dtime_diff, config->args, "-dtime_diff", false, false);
+    PXOPT_LOOKUP_F32(dtime_match, config->args, "-dtime_match", false, false);
+    PXOPT_LOOKUP_F32(dtime_phot, config->args, "-dtime_phot", false, false);
     PXOPT_LOOKUP_S32(stamps_num, config->args, "-stamps_num", false, false);
+    PXOPT_LOOKUP_S32(stamps_mean, config->args, "-stamps_mean", false, false);
     PXOPT_LOOKUP_F32(stamps_rms, config->args, "-stamps_rms", false, false);
     PXOPT_LOOKUP_S32(sources, config->args, "-sources", false, false);
@@ -496,7 +499,10 @@
                            bg_stdev,
                            stamps_num,
+                           stamps_mean,
                            stamps_rms,
                            sources,
                            dtime_diff,
+                           dtime_match,
+                           dtime_phot,
                            hostname,
                            good_frac,
Index: trunk/ippTools/src/difftoolConfig.c
===================================================================
--- trunk/ippTools/src/difftoolConfig.c	(revision 19633)
+++ trunk/ippTools/src/difftoolConfig.c	(revision 19639)
@@ -96,5 +96,8 @@
     psMetadataAddF64(adddiffskyfileArgs, PS_LIST_TAIL, "-bg_stdev",  0,            "define exposure background mean stdev", NAN);
     psMetadataAddF32(adddiffskyfileArgs, PS_LIST_TAIL, "-dtime_diff",  0,            "define elapsed processing time", NAN);
+    psMetadataAddF32(adddiffskyfileArgs, PS_LIST_TAIL, "-dtime_match", 0, "define match processing time", NAN);
+    psMetadataAddF32(adddiffskyfileArgs, PS_LIST_TAIL, "-dtime_phot", 0, "define photometry processing time", NAN);
     psMetadataAddS32(adddiffskyfileArgs, PS_LIST_TAIL, "-stamps_num",  0,            "define subtraction stamp number", 0);
+    psMetadataAddF32(adddiffskyfileArgs, PS_LIST_TAIL, "-stamps_mean", 0, "define subtraction stamp mean", NAN);
     psMetadataAddF32(adddiffskyfileArgs, PS_LIST_TAIL, "-stamps_rms",  0,            "define subtraction stamp rms", NAN);
     psMetadataAddS32(adddiffskyfileArgs, PS_LIST_TAIL, "-sources",  0,            "define number of sources", 0);