Changeset 25051 for branches/czw_branch/cleanup/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Aug 11, 2009, 3:54:00 PM (17 years ago)

Author:

watersc1

Message:

Bringing branch up-to-date at revision 25049

Location:

branches/czw_branch/cleanup

Files:

• . (modified) (1 prop)
• ippTools/share/pxadmin_create_tables.sql (modified) (3 diffs)

branches/czw_branch/cleanup/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;
 
@@ -1203 +1205 @@
         jobType VARCHAR(16),
         fault SMALLINT,
-        uri VARCHAR(255),
         exp_id BIGINT,
         outputBase VARCHAR(255),
-        args VARCHAR(511),
         PRIMARY KEY(job_id, req_id),
         KEY(job_id),