diff options
| author | Russ Allbery <eagle@eyrie.org> | 2014-07-11 19:26:46 -0700 |
|---|---|---|
| committer | Russ Allbery <rra@stanford.edu> | 2014-07-11 22:38:17 -0700 |
| commit | f1b9938282d80179dc793aadeb123fb7cbed2e45 (patch) | |
| tree | 364c834daed3daa1857feb41f8a8357ed29365e5 /perl/sql/Wallet-Schema-0.08-0.09-MySQL.sql | |
| parent | 02a629dcc319e418b2f4185acb5bfb22bc86b3eb (diff) | |
Clean up foreign keys and indices for history tables
Previous versions had erroneous foreign key constraints between the
object history table and the objects table. Remove those constraints,
and an incorrect linkage in the schema for the ACL history, and add
indices for the object type, name, and ACL instead.
Change-Id: Ie0ff2448caa82c7a533a1b9ff5c13029bb6ae4ef
Reviewed-on: https://gerrit.stanford.edu/1526
Reviewed-by: Russ Allbery <rra@stanford.edu>
Tested-by: Russ Allbery <rra@stanford.edu>
Diffstat (limited to 'perl/sql/Wallet-Schema-0.08-0.09-MySQL.sql')
| -rw-r--r-- | perl/sql/Wallet-Schema-0.08-0.09-MySQL.sql | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/perl/sql/Wallet-Schema-0.08-0.09-MySQL.sql b/perl/sql/Wallet-Schema-0.08-0.09-MySQL.sql index acc517e..8127613 100644 --- a/perl/sql/Wallet-Schema-0.08-0.09-MySQL.sql +++ b/perl/sql/Wallet-Schema-0.08-0.09-MySQL.sql @@ -4,14 +4,19 @@ BEGIN; SET foreign_key_checks=0; -CREATE TABLE `duo` ( - `du_name` varchar(255) NOT NULL, - `du_key` varchar(255) NOT NULL, - PRIMARY KEY (`du_name`) +CREATE TABLE duo ( + du_name varchar(255) NOT NULL, + du_key varchar(255) NOT NULL, + PRIMARY KEY (du_name) ); SET foreign_key_checks=1; +ALTER TABLE acl_history ADD INDEX acl_history_idx_ah_acl (ah_acl); + +ALTER TABLE object_history DROP FOREIGN KEY object_history_fk_oh_type_oh_name, + ALTER TABLE object_history; + COMMIT; |