Changeset 25014 for trunk/dbconfig/changes.txt

Timestamp:

Aug 7, 2009, 10:52:38 AM (17 years ago)

Author:

bills

Message:

add inv_magic_id to magicDSRun

File:

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

trunk/dbconfig/changes.txt

@@ -1204 +1204 @@
 ALTER TABLE pstampJob DROP COLUMN args;
 ALTER TABLE pstampJob DROP COLUMN uri;
+ALTER TABLE magicDSRun ADD COLUMN inv_magic_id BIGINT AFTER magic_id;
+ALTER TABLE magicDSRun ADD FOREIGN KEY (inv_magic_id) REFERENCES magicRun(magic_id);