summaryrefslogtreecommitdiff
path: root/perl/sql/Wallet-Schema-0.08-0.09-PostgreSQL.sql
diff options
context:
space:
mode:
authorRuss Allbery <eagle@eyrie.org>2014-07-16 13:46:50 -0700
committerRuss Allbery <eagle@eyrie.org>2014-07-16 13:46:50 -0700
commit1796d631f0846ec98cd286bc4284898a7300ee78 (patch)
tree6fd42de6dc858ef06c6d270410c32ec61f39e593 /perl/sql/Wallet-Schema-0.08-0.09-PostgreSQL.sql
parentf5194217566a6f4cdeffbae551153feb1412210d (diff)
parent6409733ee3b7b1910dc1c166a392cc628834146c (diff)
Merge tag 'upstream/1.1' into debian
Upstream version 1.1 Conflicts: NEWS README client/keytab.c perl/lib/Wallet/ACL.pm perl/sql/Wallet-Schema-0.08-PostgreSQL.sql perl/t/general/admin.t perl/t/verifier/ldap-attr.t Change-Id: I1a1dc09b97c9258e61f1c8877d0837193c8ae2c6
Diffstat (limited to 'perl/sql/Wallet-Schema-0.08-0.09-PostgreSQL.sql')
-rw-r--r--perl/sql/Wallet-Schema-0.08-0.09-PostgreSQL.sql19
1 files changed, 19 insertions, 0 deletions
diff --git a/perl/sql/Wallet-Schema-0.08-0.09-PostgreSQL.sql b/perl/sql/Wallet-Schema-0.08-0.09-PostgreSQL.sql
new file mode 100644
index 0000000..a1d3fa3
--- /dev/null
+++ b/perl/sql/Wallet-Schema-0.08-0.09-PostgreSQL.sql
@@ -0,0 +1,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;
+