Changeset 28980 for branches/eam_branches/ipp-20100621/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Aug 19, 2010, 6:50:13 PM (16 years ago)

Author:

eugene

Message:

updates from trunk

File:

• branches/eam_branches/ipp-20100621/ippTools/share/pxadmin_create_tables.sql (modified) (3 diffs)

branches/eam_branches/ipp-20100621/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;