aboutsummaryrefslogtreecommitdiff
path: root/src/odbc
diff options
context:
space:
mode:
authorAlexey Shchepin <alexey@process-one.net>2006-10-05 03:17:41 +0000
committerAlexey Shchepin <alexey@process-one.net>2006-10-05 03:17:41 +0000
commitfa7693d355f3bbc9a8938e92499a5efa49ba97b1 (patch)
tree03b56697e6997b0048ad30b49963490ecaa32902 /src/odbc
parent* src/shaper.erl: Bugfix (diff)
* src/mod_privacy.erl: Use hooks instead of direct function calls
* src/ejabberd_c2s.erl: Updated SVN Revision: 659
Diffstat (limited to 'src/odbc')
-rw-r--r--src/odbc/pg.sql22
1 files changed, 22 insertions, 0 deletions
diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql
index 32f20fdd0..9246c591b 100644
--- a/src/odbc/pg.sql
+++ b/src/odbc/pg.sql
@@ -91,6 +91,28 @@ CREATE INDEX i_vcard_search_lemail ON vcard_search(lemail);
CREATE INDEX i_vcard_search_lorgname ON vcard_search(lorgname);
CREATE INDEX i_vcard_search_lorgunit ON vcard_search(lorgunit);
+CREATE TABLE privacy_default_list (
+ username text PRIMARY KEY,
+ name text NOT NULL
+);
+
+CREATE TABLE privacy_list (
+ username text NOT NULL,
+ name text NOT NULL,
+ type character(1) NOT NULL,
+ value text NOT NULL,
+ action character(1) NOT NULL,
+ ord NUMERIC NOT NULL,
+ match_all boolean NOT NULL,
+ match_iq boolean NOT NULL,
+ match_message boolean NOT NULL,
+ match_presence_in boolean NOT NULL,
+ match_presence_out boolean NOT NULL
+);
+
+CREATE INDEX i_privacy_list_username ON privacy_list USING btree (username);
+
+
--- To update from 0.9.8:
-- CREATE SEQUENCE spool_seq_seq;
-- ALTER TABLE spool ADD COLUMN seq integer;