Changeset 24552 for trunk/dbconfig

Timestamp:

Jun 25, 2009, 1:49:09 PM (17 years ago)

Author:

bills

Message:

changed the columns magicked from TINYINT to BIGINT
store magic_ds_id of the magicDSRun that was used for destreaking

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• chip.md (modified) (2 diffs)
• diff.md (modified) (2 diffs)
• magic.md (modified) (1 diff)
• raw.md (modified) (2 diffs)
• warp.md (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -1164 +1164 @@
 
 -- 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;
+
+

trunk/dbconfig/chip.md

@@ -11 +11 @@
     tess_id     STR         64
     end_stage   STR         64      # Key
-    magicked    BOOL        f
+    magicked    S64         0
 END
 
@@ -89 +89 @@
     fault           S16     0       # Key NOT NULL
     quality         S16     0
-    magicked        BOOL    f
+    magicked        S64     0
 END
 

trunk/dbconfig/diff.md

@@ -12 +12 @@
     bothways    BOOL        f
     exposure    BOOL        f
-    magicked    BOOL        f
+    magicked    S64         0
 END
 
@@ -57 +57 @@
     fault        S16        0       # Key
     quality      S16        0
-    magicked     BOOL       f
+    magicked    S64         0
 END

trunk/dbconfig/magic.md

@@ -64 +64 @@
     recovery_path_base STR        255
     fault       S16         0
+    data_state  STR        64     # Key
 END

trunk/dbconfig/raw.md

@@ -65 +65 @@
     fault       S16         0       # Key NOT NULL
     epoch       UTC         0001-01-01T00:00:00Z
-    magicked    BOOL        f
+    magicked    S64         0
 END
 
@@ -135 +135 @@
     quality     S16         0
     epoch       UTC         0001-01-01T00:00:00Z
-    magicked    BOOL        f
+    magicked    S64         0
 END

trunk/dbconfig/warp.md

@@ -22 +22 @@
     end_stage   STR         64      # Key
     registered  TAI         NULL
-    magicked    BOOL        f
+    magicked    S64         0
 END
 
@@ -58 +58 @@
     fault          S16      0       # Key
     quality        S16      0
-    magicked       BOOL     f
+    magicked       S64      0
 END