Changeset 35471 for trunk/ippTools/share

Timestamp:

May 2, 2013, 10:35:12 AM (13 years ago)

Author:

bills

Message:

Forgot to add unique keys

ippRelease UNIQUE KEY(surveyID, release_name)
relExp UNIQUE KEY(rel_id, exp_id)

Fixed name of table relStack
(It was set to relStackTest as a test. That change should not have been committed)

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -2172 +2172 @@
     priority    INT,
     PRIMARY KEY(rel_id),
+    UNIQUE KEY(surveyID, release_name),
     KEY(release_name),
     KEY(release_state),
@@ -2196 +2197 @@
     PRIMARY KEY (relexp_id),
     FOREIGN KEY(rel_id) REFERENCES ippRelease(rel_id),
+    UNIQUE KEY(rel_id, exp_id),
     KEY (state),
     KEY (fault),
@@ -2204 +2206 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
-CREATE TABLE relStackTest (
+CREATE TABLE relStack (
     relstack_id BIGINT AUTO_INCREMENT,
     rel_id      INT,