Index: trunk/ippTools/share/magicdstool_torevert_camera.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_camera.sql	(revision 27012)
+++ trunk/ippTools/share/magicdstool_torevert_camera.sql	(revision 27015)
@@ -11,4 +11,5 @@
     camProcessedExp.path_base,
     camProcessedExp.path_base AS cam_path_base,
+    0 AS bothways,
     0 AS bytes,
     0 AS md5sum
Index: trunk/ippTools/share/magicdstool_torevert_chip.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_chip.sql	(revision 27012)
+++ trunk/ippTools/share/magicdstool_torevert_chip.sql	(revision 27015)
@@ -11,4 +11,5 @@
     chipProcessedImfile.path_base,
     camProcessedExp.path_base AS cam_path_base,
+    0 AS bothways,
     0 AS bytes,
     0 AS md5sum
Index: trunk/ippTools/share/magicdstool_torevert_diff.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_diff.sql	(revision 27012)
+++ trunk/ippTools/share/magicdstool_torevert_diff.sql	(revision 27015)
@@ -11,4 +11,5 @@
     diffSkyfile.path_base,
     "NULL" AS cam_path_base,
+    CAST(diffRun.bothways AS SIGNED) AS bothways,
     0 AS bytes,
     0 AS md5sum
@@ -17,4 +18,5 @@
     JOIN magicDSFile USING(magic_ds_id)
     JOIN diffSkyfile ON (stage_id = diffSkyfile.diff_id AND component = skycell_id)
+    JOIN diffRun ON diffSkyfile.diff_id = diffRun.diff_id
     JOIN rawExp USING(exp_id)
 WHERE magicDSRun.stage = 'diff'
Index: trunk/ippTools/share/magicdstool_torevert_raw.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_raw.sql	(revision 27012)
+++ trunk/ippTools/share/magicdstool_torevert_raw.sql	(revision 27015)
@@ -11,4 +11,5 @@
     rawImfile.uri AS path_base,
     NULL AS cam_path_base,
+    0 AS bothways,
     bytes,
     md5sum
Index: trunk/ippTools/share/magicdstool_torevert_warp.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_warp.sql	(revision 27012)
+++ trunk/ippTools/share/magicdstool_torevert_warp.sql	(revision 27015)
@@ -11,4 +11,5 @@
     warpSkyfile.path_base,
     "NULL" AS cam_path_base,
+    0 AS bothways,
     0 AS bytes,
     0 AS md5sum
