Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 28039)
+++ trunk/ippTools/share/Makefile.am	(revision 28043)
@@ -28,4 +28,5 @@
      chiptool_change_imfile_data_state.sql \
      chiptool_completely_processed_exp.sql \
+     chiptool_coalesce_run.sql \
      chiptool_definecopy.sql \
      chiptool_donecleanup.sql \
@@ -97,4 +98,5 @@
      difftool_change_run_state.sql \
      difftool_completed_runs.sql \
+     difftool_coalesce_run.sql \
      difftool_definewarpstack_part1.sql \
      difftool_definewarpstack_part2.sql \
@@ -298,4 +300,5 @@
      warptool_finished_run_select.sql \
      warptool_finish_run.sql \
+     warptool_coalesce_run.sql \
      warptool_imfile.sql \
      warptool_listrun.sql \
Index: trunk/ippTools/share/camtool_queue_chip_id.sql
===================================================================
--- trunk/ippTools/share/camtool_queue_chip_id.sql	(revision 28039)
+++ trunk/ippTools/share/camtool_queue_chip_id.sql	(revision 28043)
@@ -17,4 +17,10 @@
         '%s',           -- end_stage
         %lld,           -- magicked
+	'%s',           -- software ver
+	'%s',           -- maskfrac_npix
+	'%s',           --         _static
+	'%s',           --         _dynamic
+	'%s',           --         _magic
+	'%s',           --         _advisory
         '%s'            -- note
     FROM chipRun
Index: trunk/ippTools/share/chiptool_coalesce_run.sql
===================================================================
--- trunk/ippTools/share/chiptool_coalesce_run.sql	(revision 28043)
+++ trunk/ippTools/share/chiptool_coalesce_run.sql	(revision 28043)
@@ -0,0 +1,1 @@
+select software_ver,maskfrac_npix,maskfrac_static,maskfrac_dynamic,maskfrac_magic,maskfrac_advisory from chipProcessedImfile where data_state = 'full' AND fault = 0 AND chip_id = %lld
Index: trunk/ippTools/share/difftool_coalesce_run.sql
===================================================================
--- trunk/ippTools/share/difftool_coalesce_run.sql	(revision 28043)
+++ trunk/ippTools/share/difftool_coalesce_run.sql	(revision 28043)
@@ -0,0 +1,1 @@
+select software_ver,maskfrac_npix,maskfrac_static,maskfrac_dynamic,maskfrac_magic,maskfrac_advisory from diffSkyfile where diff_id = %lld
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 28039)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 28043)
@@ -276,4 +276,10 @@
     end_stage VARCHAR(64),
     magicked BIGINT,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     note VARCHAR(255),
     PRIMARY KEY(chip_id),
@@ -359,4 +365,10 @@
     fault SMALLINT NOT NULL,
     magicked BIGINT,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     PRIMARY KEY(chip_id, exp_id, class_id),
     KEY(data_state),
@@ -387,4 +399,10 @@
     end_stage VARCHAR(64),
     magicked BIGINT,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     note VARCHAR(255),
     PRIMARY KEY(cam_id),
@@ -464,4 +482,10 @@
     quality SMALLINT NOT NULL DEFAULT 0,
     fault SMALLINT NOT NULL,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     PRIMARY KEY(cam_id),
     KEY(fault),
@@ -867,4 +891,10 @@
     registered DATETIME,
     magicked BIGINT,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     note VARCHAR(255),
     PRIMARY KEY(warp_id),
@@ -923,4 +953,10 @@
     fault SMALLINT,
     magicked BIGINT,
+    software_ver VARCHAR(16),
+    maskfrac_npix INT,
+    maskfrac_static FLOAT,
+    maskfrac_dynamic FLOAT,
+    maskfrac_magic FLOAT,
+    maskfrac_advisory FLOAT,
     PRIMARY KEY(warp_id, skycell_id, tess_id),
     KEY(good_frac),
@@ -948,4 +984,5 @@
         tess_id VARCHAR(64),
         filter VARCHAR(64),
+	software_ver VARCHAR(16),
         note VARCHAR(255),
         PRIMARY KEY(stack_id),
@@ -995,4 +1032,5 @@
         quality SMALLINT NOT NULL DEFAULT 0,
         fault SMALLINT,
+	software_ver VARCHAR(16),
         PRIMARY KEY(stack_id),
         KEY(dtime_stack),
@@ -1017,4 +1055,10 @@
         exposure TINYINT DEFAULT 0,
         magicked BIGINT,
+	software_ver VARCHAR(16),
+        maskfrac_npix INT,
+        maskfrac_static FLOAT,
+        maskfrac_dynamic FLOAT,
+        maskfrac_magic FLOAT,
+        maskfrac_advisory FLOAT,
         diff_mode SMALLINT NOT NULL,
         note VARCHAR(255),
@@ -1080,4 +1124,10 @@
         fault SMALLINT,
         magicked BIGINT,
+	software_ver VARCHAR(16),
+	maskfrac_npix INT,
+	maskfrac_static FLOAT,
+	maskfrac_dynamic FLOAT,
+	maskfrac_magic FLOAT,
+        maskfrac_advisory FLOAT,
         PRIMARY KEY(diff_id, skycell_id),
         KEY(good_frac),
Index: trunk/ippTools/share/warptool_coalesce_run.sql
===================================================================
--- trunk/ippTools/share/warptool_coalesce_run.sql	(revision 28043)
+++ trunk/ippTools/share/warptool_coalesce_run.sql	(revision 28043)
@@ -0,0 +1,1 @@
+select software_ver,maskfrac_npix,maskfrac_static,maskfrac_dynamic,maskfrac_magic,maskfrac_advisory from warpSkyfile where warp_id = %lld