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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

-- Convert schema 'sql/Wallet-Schema-0.08-PostgreSQL.sql' to 'sql/Wallet-Schema-0.09-PostgreSQL.sql':;

BEGIN;

CREATE TABLE "duo" (
  "du_name" character varying(255) NOT NULL,
  "du_key" character varying(255) NOT NULL,
  PRIMARY KEY ("du_name")
);

ALTER TABLE acl_history ADD COLUMN ah_name character varying(255);

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;