perl/sql/Wallet-Schema-0.08-0.09-SQLite.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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;