Index: branches/pap/ippTools/share/Makefile.am
===================================================================
--- branches/pap/ippTools/share/Makefile.am	(revision 23948)
+++ branches/pap/ippTools/share/Makefile.am	(revision 25027)
@@ -1,6 +1,5 @@
 pxadmin_create_mirror_tables.sql: pxadmin_create_tables.sql
 	-$(RM) pxadmin_create_mirror_tables.sql
-	$(SED) -n -e '/^  *$$/ d' -e 's/--.*//' -e '/./ H' -e '/;/ !b' -e 'x ; s/\n//g ; /^CREATE TABLE receive/ { b print }' -e 's/AUTO_INCREMENT//g ; s/,\{0,1\} *FOREIGN *KEY *([a-zA-Z][a-zA-Z0-9\-\_, ]*) *REFERENCES *[a-zA-Z]\{1,\}([a-zA-Z][a-zA-Z0-9\-\_, ]*)//g' -e ': print' -e 's/( */(/g ; s/ *)/)/g ; s/  */ /g ; p ; s/.*//g ; x'  pxadmin_create_tables.sql > pxadmin_create_mirror_tables.sql
-	echo '-- This comment line is here to avoid empty query error.' >> pxadmin_create_mirror_tables.sql
+	./parse_pxadmin_create_tables.pl pxadmin_create_tables.sql > pxadmin_create_mirror_tables.sql
 
 dist_pkgdata_DATA = \
@@ -81,7 +80,9 @@
      dettool_tostacked.sql \
      difftool_completed_runs.sql \
-     difftool_definebyquery_part1.sql \
-     difftool_definebyquery_part2.sql \
-     difftool_definebyquery_temp_create.sql \
+     difftool_definewarpstack_part1.sql \
+     difftool_definewarpstack_part2.sql \
+     difftool_definewarpstack_temp_create.sql \
+     difftool_definewarpwarp_temp_create.sql \
+     difftool_definewarpwarp_temp_insert.sql \
      difftool_definewarpwarp_select.sql \
      difftool_definewarpwarp_insert.sql \
@@ -136,11 +137,12 @@
      flatcorr_dropcamera.sql \
      magictool_addmask.sql \
+     magictool_censor_raw.sql \
+     magictool_censor_chip.sql \
+     magictool_censor_camera.sql \
+     magictool_censor_warp.sql \
+     magictool_censor_diff.sql \
      magictool_create_tmp_warpcomplete.sql \
-     magictool_definebyquery.sql \
      magictool_definebyquery_insert.sql \
      magictool_definebyquery_select.sql \
-     magictool_definebyquery_select_test.sql \
-     magictool_definebyquery_temp_create.sql \
-     magictool_definebyquery_temp_insert.sql \
      magictool_inputs.sql \
      magictool_inputskyfile.sql \
@@ -148,4 +150,5 @@
      magictool_tomask.sql \
      magictool_toprocess_inputs.sql \
+     magictool_toprocess_runs.sql \
      magictool_toprocess_tree.sql \
      magictool_toskyfilemask.sql \
@@ -156,8 +159,20 @@
      magictool_rawimfile.sql \
      magictool_revertnode.sql \
+     magicdstool_completed_runs.sql \
+     magicdstool_definebyquery_raw.sql \
+     magicdstool_definebyquery_chip.sql \
+     magicdstool_definebyquery_camera.sql \
+     magicdstool_definebyquery_warp.sql \
+     magicdstool_definebyquery_diff.sql \
+     magicdstool_getrunids.sql \
+     magicdstool_getskycells.sql \
      magicdstool_todestreak.sql \
-     magicdstool_completed_runs.sql \
-     magicdstool_getskycells.sql \
-     magicdstool_getrunids.sql \
+     magicdstool_toremove.sql \
+     magicdstool_torestore.sql \
+     magicdstool_torevert_raw.sql \
+     magicdstool_torevert_chip.sql \
+     magicdstool_torevert_camera.sql \
+     magicdstool_torevert_warp.sql \
+     magicdstool_torevert_diff.sql \
      pstamptool_addjob_otherjob.sql \
      pstamptool_addjob_stampjob.sql \
@@ -169,4 +184,7 @@
      pxadmin_create_mirror_tables.sql \
      pxadmin_drop_tables.sql \
+     pubtool_definerun.sql \
+     pubtool_pending.sql \
+     pubtool_revert.sql \
      pztool_find_completed_exp.sql \
      pztool_pendingimfile.sql \
@@ -179,4 +197,5 @@
      receivetool_pendingfile.sql \
      receivetool_revert.sql \
+     receivetool_toadvance.sql \
      regtool_create_dup_table.sql \
      regtool_export_exp.sql \
@@ -205,5 +224,4 @@
      stacktool_pendingcleanupskyfile.sql \
      stacktool_revertsumskyfile_delete.sql \
-     stacktool_revertsumskyfile_update.sql \
      stacktool_sumskyfile.sql \
      stacktool_tosum.sql \
@@ -222,5 +240,5 @@
      warptool_pendingcleanuprun.sql \
      warptool_pendingcleanupskyfile.sql \
-     warptool_revertwarped_update.sql \
+     warptool_revertoverlap.sql \
      warptool_revertwarped_delete.sql \
      warptool_scmap.sql \