diff options
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; |