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

Timestamp:

May 11, 2009, 4:38:18 PM (17 years ago)

Author:

Paul Price

Message:

Make magictool -definebyquery work with inverse subtractions (A-B and B-A). Small change to DB schema.

File:

• branches/pap_magic/dbconfig/changes.txt (modified) (1 diff)

branches/pap_magic/dbconfig/changes.txt

@@ -1111 +1111 @@
 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);
+
+ALTER TABLE magicRun ADD COLUMN inverse TINYINT NOT NULL DEFAULT 0 AFTER diff_id;