aboutsummaryrefslogtreecommitdiff
path: root/src/odbc/pg.sql
diff options
context:
space:
mode:
authorEvgeniy Khramtsov <ekhramtsov@process-one.net>2012-04-02 15:21:54 +1000
committerEvgeniy Khramtsov <ekhramtsov@process-one.net>2012-04-02 15:21:54 +1000
commitca5f028016078244853456cbfdd9bd35b794432a (patch)
tree80b078bcf5909f2e38515ef082437e40feb517a3 /src/odbc/pg.sql
parentODBC support for mod_announce (diff)
ODBC support for mod_vcard_xupdate
Diffstat (limited to 'src/odbc/pg.sql')
-rw-r--r--src/odbc/pg.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql
index f28cf8af2..30ea19ca5 100644
--- a/src/odbc/pg.sql
+++ b/src/odbc/pg.sql
@@ -74,6 +74,12 @@ CREATE TABLE vcard (
created_at TIMESTAMP NOT NULL DEFAULT now()
);
+CREATE TABLE vcard_xupdate (
+ username text PRIMARY KEY,
+ hash text NOT NULL,
+ created_at TIMESTAMP NOT NULL DEFAULT now()
+);
+
CREATE TABLE vcard_search (
username text NOT NULL,
lusername text PRIMARY KEY,