Changeset 35295 for trunk/ippTools/share

Timestamp:

Mar 11, 2013, 2:03:24 PM (13 years ago)

Author:

bills

Message:

add username, proj_id, and registered to table pstampRequest

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1441 +1441 @@
         outProduct VARCHAR(64),
         uri VARCHAR(255),
-        outdir     VARCHAR(255),
+        outdir VARCHAR(255),
+        username VARCHAR(255),
+        proj_id BIGINT,
+        registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         timestamp TIMESTAMP,
         fault SMALLINT,
@@ -1448 +1451 @@
         KEY(state),
         KEY(fault),
-        KEY(label)
+        KEY(label),
+        KEY(username)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -2194 +2198 @@
     KEY (state),
     KEY (fault),
+    KEY (group_id),
     FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id),
     FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id),