Index: branches/czw_branch/20101203/ippTools/share/chiptool_processedimfile.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/chiptool_processedimfile.sql	(revision 30586)
+++ branches/czw_branch/20101203/ippTools/share/chiptool_processedimfile.sql	(revision 30587)
@@ -29,6 +29,8 @@
     rawImfile.magicked AS raw_magicked,
     rawImfile.burntool_state,
-    magicDSRun.state AS dsRun_state,
-    IFNULL(magicDSRun.magic_ds_id, 0) AS magic_ds_id
+    IFNULL(magicDSRun.magic_ds_id, 0) AS magic_ds_id,
+    IFNULL(magicDSRun.state,0) AS dsRun_state,
+    IFNULL(magicDSFile.fault,0) AS dsFile_fault,
+    IFNULL(magicDSFile.data_state,0) AS dsFile_data_state
 FROM chipRun
 JOIN chipImfile
@@ -43,2 +45,3 @@
 LEFT JOIN magicDSRun
     ON stage_id = chip_id AND stage = 'chip' AND magicDSRun.re_place AND magicDSRun.state != 'drop'
+LEFT JOIN magicDSFile ON magicDSRun.magic_ds_id = magicDSFile.magic_ds_id AND chipProcessedImfile.class_id = magicDSFile.component
Index: branches/czw_branch/20101203/ippTools/share/difftool_pendingcleanupskyfile.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/difftool_pendingcleanupskyfile.sql	(revision 30586)
+++ branches/czw_branch/20101203/ippTools/share/difftool_pendingcleanupskyfile.sql	(revision 30587)
@@ -9,5 +9,5 @@
     USING(diff_id)
 WHERE
-   ((diffRun.state = 'goto_cleaned'  AND diffSkyfile.data_state = 'full')
+   ((diffRun.state = 'goto_cleaned'  AND (diffSkyfile.data_state = 'full' OR diffSkyfile.data_state = 'update'))
     OR
     (diffRun.state = 'goto_scrubbed' AND diffSkyfile.data_state != 'scrubbed')
Index: branches/czw_branch/20101203/ippTools/share/difftool_setskyfiletoupdate.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/difftool_setskyfiletoupdate.sql	(revision 30586)
+++ branches/czw_branch/20101203/ippTools/share/difftool_setskyfiletoupdate.sql	(revision 30587)
@@ -1,11 +1,9 @@
 UPDATE diffRun
     JOIN diffSkyfile USING(diff_id)
-    LEFT JOIN magicDSRun ON (stage_id = diff_id AND stage = 'diff')
-    LEFT JOIN magicDSFile ON (magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
-                              AND component = skycell_id)
 SET diffRun.state = 'update', 
-    diffSkyfile.data_state = 'update'
+    diffSkyfile.data_state = 'update',
+    diffSkyfile.fault = 0
     -- set hook %s
 WHERE diff_id = %lld
     AND (diffRun.state = 'cleaned' OR diffRun.state = 'update')
-    AND (diffSkyfile.data_state = 'cleaned')
+    AND (diffSkyfile.data_state = 'cleaned' OR diffSkyfile.data_state = 'update')
Index: branches/czw_branch/20101203/ippTools/share/magicdstool_setfiletoupdate.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/magicdstool_setfiletoupdate.sql	(revision 30586)
+++ branches/czw_branch/20101203/ippTools/share/magicdstool_setfiletoupdate.sql	(revision 30587)
@@ -7,3 +7,3 @@
 WHERE magic_ds_id = %lld
     AND (magicDSRun.state = 'cleaned' OR magicDSRun.state = 'update')
-    AND (magicDSFile.data_state = 'cleaned')
+    AND (magicDSFile.data_state = 'cleaned' OR magicDSFile.data_state ='update')
Index: branches/czw_branch/20101203/ippTools/share/warptool_change_skyfile_data_state.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/warptool_change_skyfile_data_state.sql	(revision 30586)
+++ branches/czw_branch/20101203/ippTools/share/warptool_change_skyfile_data_state.sql	(revision 30587)
@@ -1,5 +1,5 @@
 -- handle changes in warpSkyfile.data_state.
 -- Used for the modes tofullskyfile, tocleanedskyfile and topurgedskyfile
--- args are new data_state, string for magic hook, warp_id, skycell_id and current expected state for warpRun
+-- arguments are are new data_state, string for magic hook, warp_id, skycell_id
 UPDATE warpSkyfile
 JOIN warpRun USING(warp_id)
Index: branches/czw_branch/20101203/ippTools/share/warptool_scmap.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/warptool_scmap.sql	(revision 30586)
+++ branches/czw_branch/20101203/ippTools/share/warptool_scmap.sql	(revision 30587)
@@ -12,4 +12,5 @@
     IFNULL(magicDSRun.magic_ds_id, 0) AS magic_ds_id,
     IFNULL(magicDSRun.state, 0) AS dsRun_state,
+    IFNULL(magicDSFile.data_state, 0) AS dsFile_data_state,
     IFNULL(magicDSFile.fault, 0) as dsFile_fault
 FROM warpRun
Index: branches/czw_branch/20101203/ippTools/share/warptool_setskyfiletoupdate.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/warptool_setskyfiletoupdate.sql	(revision 30586)
+++ branches/czw_branch/20101203/ippTools/share/warptool_setskyfiletoupdate.sql	(revision 30587)
@@ -1,11 +1,9 @@
 UPDATE warpRun
     JOIN warpSkyfile USING(warp_id)
-    LEFT JOIN magicDSRun ON (stage_id = warp_id AND stage = 'warp')
-    LEFT JOIN magicDSFile ON (magicDSRun.magic_ds_id = magicDSFile.magic_ds_id
-                              AND component = skycell_id)
 SET warpRun.state = 'update', 
-    warpSkyfile.data_state = 'update'
+    warpSkyfile.data_state = 'update',
+    warpSkyfile.fault = 0
     -- set hook %s
 WHERE warp_id = %lld
     AND (warpRun.state = 'cleaned' OR warpRun.state = 'update')
-    AND (warpSkyfile.data_state = 'cleaned')
+    AND (warpSkyfile.data_state = 'cleaned' OR warpSkyfile.data_state = 'update')
Index: branches/czw_branch/20101203/ippTools/share/warptool_towarped.sql
===================================================================
--- branches/czw_branch/20101203/ippTools/share/warptool_towarped.sql	(revision 30586)
+++ branches/czw_branch/20101203/ippTools/share/warptool_towarped.sql	(revision 30587)
@@ -11,4 +11,5 @@
     exp_tag,
     workdir,
+    label,
     magicked,
     path_base,
@@ -23,4 +24,5 @@
         warpRun.state,
         warpRun.reduction,
+        warpRun.label,
         camRun.cam_id,
         rawExp.camera,
@@ -76,4 +78,5 @@
         warpRun.state,
         warpRun.reduction,
+        warpRun.label,
         camRun.cam_id,
         rawExp.camera,