Changeset 25012 for trunk/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Aug 7, 2009, 10:48:59 AM (17 years ago)

Author:

bills

Message:

add inv_magic_id to magicDSRun to support warp-warp diffs

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (2 diffs)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1071 +1071 @@
         magic_ds_id BIGINT AUTO_INCREMENT,
         magic_id BIGINT,
+        inv_magic_id BIGINT,
         state VARCHAR(64),
         stage VARCHAR(64),
@@ -1086 +1087 @@
         KEY(label),
         FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id)
+        FOREIGN KEY(inv_magic_id) REFERENCES magicRun(magic_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;