diff options
Diffstat (limited to 'perl/sql/Wallet-Schema-0.08-0.09-SQLite.sql')
| -rw-r--r-- | perl/sql/Wallet-Schema-0.08-0.09-SQLite.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/perl/sql/Wallet-Schema-0.08-0.09-SQLite.sql b/perl/sql/Wallet-Schema-0.08-0.09-SQLite.sql new file mode 100644 index 0000000..df0fa09 --- /dev/null +++ b/perl/sql/Wallet-Schema-0.08-0.09-SQLite.sql @@ -0,0 +1,17 @@ +-- Convert schema 'sql/Wallet-Schema-0.08-SQLite.sql' to 'sql/Wallet-Schema-0.09-SQLite.sql':; + +BEGIN; + +CREATE TABLE duo ( + du_name varchar(255) NOT NULL, + du_key varchar(255) NOT NULL, + PRIMARY KEY (du_name) +); + +ALTER TABLE acl_history ADD ah_name varchar(255) default null; + +CREATE INDEX acl_history_idx_ah_acl ON acl_history (ah_acl); + +CREATE INDEX acl_history_idx_ah_name ON acl_history (ah_name); + +COMMIT; |