diff options
| author | Alexey Shchepin <alexey@process-one.net> | 2006-10-19 04:46:24 +0000 |
|---|---|---|
| committer | Alexey Shchepin <alexey@process-one.net> | 2006-10-19 04:46:24 +0000 |
| commit | cd7595e3f41ff103cf7c96d0699f5a738405d82f (patch) | |
| tree | 6574b5af7fa662e7d92db6b7ba1f9d58ebf0416d /src/odbc | |
| parent | * ChangeLog: Fixed typo. (diff) | |
* src/ejabberd_socket.erl: Added sockname/1 and peername/1
functions
* src/ejabberd_frontend_socket.erl: Likewise
* src/tls/tls.erl: Likewise
* src/ejabberd_zlib/ejabberd_zlib.erl: Likewise
* src/mod_private_odbc.erl: Private storage support using odbc
* src/odbc/pg.sql: Likewise
SVN Revision: 663
Diffstat (limited to 'src/odbc')
| -rw-r--r-- | src/odbc/pg.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql index ba9ba089c..9f88756fe 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: |