Changeset 28874

Timestamp:

Aug 9, 2010, 5:45:44 PM (16 years ago)

Author:

watersc1

Message:

forgotten change to summary tables. Already made to running gpc1.

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -987 +987 @@
        projection_cell VARCHAR(64) NOT NULL,
        path_base     VARCHAR(255) NOT NULL,
-       PRIMARY KEY(warp_id),
-       KEY(projection_cell),
+       PRIMARY KEY(warp_id, projection_cell),
        FOREIGN KEY(warp_id) REFERENCES warpRun(warp_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1086 +1085 @@
     projection_cell VARCHAR(64) NOT NULL,
     path_base   VARCHAR(255) NOT NULL,
-    PRIMARY KEY(sass_id),
-    KEY(projection_cell),
+    PRIMARY KEY(sass_id, projection_cell),
     FOREIGN KEY(sass_id) REFERENCES stackAssociation(sass_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1192 +1190 @@
     projection_cell VARCHAR(64) NOT NULL,
     path_base   VARCHAR(255) NOT NULL,
-    PRIMARY KEY(diff_id),
-    KEY(projection_cell),
+    PRIMARY KEY(diff_id, projection_cell),
     FOREIGN KEY(diff_id) REFERENCES diffRun(diff_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;