diff options
author | Alexey Shchepin <alexey@process-one.net> | 2006-10-05 03:17:41 +0000 |
---|---|---|
committer | Alexey Shchepin <alexey@process-one.net> | 2006-10-05 03:17:41 +0000 |
commit | fa7693d355f3bbc9a8938e92499a5efa49ba97b1 (patch) | |
tree | 03b56697e6997b0048ad30b49963490ecaa32902 /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.sql | 22 |
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; |