Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 24513)
+++ trunk/dbconfig/changes.txt	(revision 24552)
@@ -1164,2 +1164,34 @@
 
 -- Version 1.1.54
+
+-- changed magicked from a flag to a BIGINT
+-- The value is the magic_ds_id of the magicDSRun that destreaked the file/run
+
+ALTER TABLE magicDSFile ADD COLUMN data_state VARCHAR(64);
+ALTER TABLE magicDSFile ADD KEY(data_state);
+UPDATE magicDSFile SET data_state = 'full' WHERE data_state IS NULL;
+
+ALTER TABLE rawImfile CHANGE COLUMN magicked  magicked BIGINT;
+ALTER TABLE rawExp CHANGE COLUMN magicked  magicked BIGINT;
+
+ALTER TABLE chipProcessedImfile CHANGE COLUMN magicked  magicked BIGINT;
+ALTER TABLE chipRun CHANGE COLUMN magicked  magicked BIGINT;
+
+-- so far only chipRuns have been magicked in product
+UPDATE chipProcessedImfile JOIN magicDSRun ON stage = 'chip' AND chip_id = stage_id
+    SET chipProcessedImfile.magicked = magic_ds_id 
+    WHERE magicDSRun.re_place
+    AND chipProcessedImfile.magicked > 0;
+
+UPDATE chipRun JOIN magicDSRun ON stage = 'chip' AND chip_id = stage_id
+    SET chipRun.magicked = magic_ds_id 
+    WHERE magicDSRun.re_place
+    AND chipRun.magicked > 0;
+
+ALTER TABLE warpSkyfile CHANGE COLUMN magicked  magicked BIGINT;
+ALTER TABLE warpRun CHANGE COLUMN magicked  magicked BIGINT;
+
+ALTER TABLE diffSkyfile CHANGE COLUMN magicked  magicked BIGINT;
+ALTER TABLE diffRun CHANGE COLUMN magicked  magicked BIGINT;
+
+
Index: trunk/dbconfig/chip.md
===================================================================
--- trunk/dbconfig/chip.md	(revision 24513)
+++ trunk/dbconfig/chip.md	(revision 24552)
@@ -11,5 +11,5 @@
     tess_id     STR         64
     end_stage   STR         64      # Key
-    magicked	BOOL        f
+    magicked    S64         0
 END
 
@@ -89,5 +89,5 @@
     fault           S16     0       # Key NOT NULL
     quality         S16     0
-    magicked        BOOL    f
+    magicked        S64     0
 END
 
Index: trunk/dbconfig/diff.md
===================================================================
--- trunk/dbconfig/diff.md	(revision 24513)
+++ trunk/dbconfig/diff.md	(revision 24552)
@@ -12,5 +12,5 @@
     bothways    BOOL	    f
     exposure	BOOL	    f
-    magicked	BOOL        f
+    magicked    S64         0
 END
 
@@ -57,4 +57,4 @@
     fault        S16        0       # Key
     quality      S16        0
-    magicked     BOOL       f
+    magicked    S64         0
 END
Index: trunk/dbconfig/magic.md
===================================================================
--- trunk/dbconfig/magic.md	(revision 24513)
+++ trunk/dbconfig/magic.md	(revision 24552)
@@ -64,3 +64,4 @@
     recovery_path_base STR        255
     fault       S16         0
+    data_state  STR        64     # Key
 END
Index: trunk/dbconfig/raw.md
===================================================================
--- trunk/dbconfig/raw.md	(revision 24513)
+++ trunk/dbconfig/raw.md	(revision 24552)
@@ -65,5 +65,5 @@
     fault       S16         0       # Key NOT NULL
     epoch       UTC         0001-01-01T00:00:00Z
-    magicked	BOOL        f
+    magicked    S64         0
 END
 
@@ -135,4 +135,4 @@
     quality     S16         0
     epoch       UTC         0001-01-01T00:00:00Z
-    magicked    BOOL        f
+    magicked    S64         0
 END
Index: trunk/dbconfig/warp.md
===================================================================
--- trunk/dbconfig/warp.md	(revision 24513)
+++ trunk/dbconfig/warp.md	(revision 24552)
@@ -22,5 +22,5 @@
     end_stage   STR         64      # Key
     registered  TAI         NULL
-    magicked	BOOL        f
+    magicked    S64         0
 END
 
@@ -58,5 +58,5 @@
     fault          S16      0       # Key
     quality        S16      0
-    magicked       BOOL     f
+    magicked       S64      0
 END