Index: trunk/ippTools/share/disttool_definebyquery_camera.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_camera.sql	(revision 25511)
+++ trunk/ippTools/share/disttool_definebyquery_camera.sql	(revision 25513)
@@ -3,4 +3,5 @@
     camRun.cam_id as stage_id,
     rawExp.exp_name as run_tag,
+    camRun.magicked,
     distTarget.label,
     distTarget.target_id,
Index: trunk/ippTools/share/disttool_definebyquery_chip.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_chip.sql	(revision 25511)
+++ trunk/ippTools/share/disttool_definebyquery_chip.sql	(revision 25513)
@@ -2,4 +2,5 @@
     'chip' as stage,
     chipRun.chip_id as stage_id,
+    chipRun.magicked,
     rawExp.exp_name as run_tag,
     chipRun.label,
Index: trunk/ippTools/share/disttool_definebyquery_diff.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_diff.sql	(revision 25511)
+++ trunk/ippTools/share/disttool_definebyquery_diff.sql	(revision 25513)
@@ -2,4 +2,5 @@
     'diff' as stage,
     diffRun.diff_id AS stage_id,
+    diffRun.magicked,
     rawExp.exp_name as run_tag,
     distTarget.label,
Index: trunk/ippTools/share/disttool_definebyquery_fake.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_fake.sql	(revision 25511)
+++ trunk/ippTools/share/disttool_definebyquery_fake.sql	(revision 25513)
@@ -2,4 +2,5 @@
     'fake' as stage,
     fakeRun.fake_id AS stage_id,
+    CAST(0 AS BIGINT) AS magicked,
     rawExp.exp_name as run_tag,
     distTarget.label,
Index: trunk/ippTools/share/disttool_definebyquery_raw.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_raw.sql	(revision 25511)
+++ trunk/ippTools/share/disttool_definebyquery_raw.sql	(revision 25513)
@@ -3,4 +3,5 @@
     rawExp.exp_id AS stage_id,
     rawExp.exp_name AS run_tag,
+    rawExp.magicked,
     distTarget.label,
     distTarget.target_id,
Index: trunk/ippTools/share/disttool_definebyquery_stack.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_stack.sql	(revision 25511)
+++ trunk/ippTools/share/disttool_definebyquery_stack.sql	(revision 25513)
@@ -2,4 +2,5 @@
     'stack' as stage,
     stackRun.stack_id AS stage_id,
+    CAST(0 AS BIGINT AS magicked,
     -- run tag in the form 'stack.$skycell_id.$stack_id'
     CONCAT_WS('.', 'stack', stackRun.skycell_id, convert(stackRun.stack_id, CHAR)) as run_tag,
Index: trunk/ippTools/share/disttool_definebyquery_warp.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_warp.sql	(revision 25511)
+++ trunk/ippTools/share/disttool_definebyquery_warp.sql	(revision 25513)
@@ -2,4 +2,5 @@
     'warp' as stage,
     warpRun.warp_id AS stage_id,
+    warpRun.magicked,
     rawExp.exp_name as run_tag,
     distTarget.label,
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 25511)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 25513)
@@ -1271,4 +1271,5 @@
     stage       VARCHAR(64),
     stage_id    BIGINT,
+    magic_ds_id BIGINT,
     label       VARCHAR(64),
     outroot     VARCHAR(255),