Changeset 24120 for branches/pap_magic/dbconfig/changes.txt

Timestamp:

May 8, 2009, 5:21:35 PM (17 years ago)

Author:

Paul Price

Message:

Branching for magic development (make it work with warpwarp diffs).

Location:

branches/pap_magic

Files:

• . (copied) (copied from trunk )
• dbconfig/changes.txt (modified) (1 diff)

branches/pap_magic/dbconfig/changes.txt

@@ -1102 +1102 @@
 ALTER TABLE receiveFile ADD COLUMN component VARCHAR(64);
 
+-- Playing with the diffs for warp-warp
+ALTER TABLE diffRun ADD COLUMN bothways TINYINT DEFAULT 0 AFTER tess_id;
+UPDATE diffRun SET bothways = 1 WHERE reduction = 'WARPWARP';
+ALTER TABLE diffRun DROP FOREIGN KEY diffRun_ibfk_1;
+ALTER TABLE diffRun DROP COLUMN exp_id;
+ALTER TABLE diffRun ADD KEY(label);
+ALTER TABLE diffRun ADD COLUMN exposure TINYINT DEFAULT 0 AFTER bothways;
+UPDATE diffRun, diffInputSkyfile SET diffRun.exposure = 1 WHERE diffRun.diff_id = diffInputSkyfile.diff_id and diffInputSkyfile.warp1 IS NOT NULL;
+ALTER TABLE stackRun ADD KEY(label);