summaryrefslogtreecommitdiff
path: root/src/odbc/pg.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/odbc/pg.sql')
-rw-r--r--src/odbc/pg.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql
index ba9ba089..9f88756f 100644
--- a/src/odbc/pg.sql
+++ b/src/odbc/pg.sql
@@ -118,6 +118,14 @@ CREATE TABLE privacy_list_data (
match_presence_out boolean NOT NULL
);
+CREATE TABLE private_storage (
+ username text NOT NULL,
+ namespace text NOT NULL,
+ data text NOT NULL
+);
+
+CREATE INDEX i_private_storage_username ON private_storage USING btree (username);
+CREATE UNIQUE INDEX i_private_storage_username_namespace ON private_storage USING btree (username, namespace);
--- To update from 0.9.8: