Changeset 25014

Timestamp:

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

Author:

bills

Message:

add inv_magic_id to magicDSRun

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• magic.md (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);

trunk/dbconfig/magic.md

@@ -47 +47 @@
     magic_ds_id S64         0       # Primary Key
     magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
+    inv_magic_id S64        0      # Primary Key fkey(inverse_magic_id) ref magicRun(magic_id)
     state       STR         0       # Key
     stage       STR         64