diff options
| author | Mickaël Rémond <mickael.remond@process-one.net> | 2006-11-05 15:51:26 +0000 |
|---|---|---|
| committer | Mickaël Rémond <mickael.remond@process-one.net> | 2006-11-05 15:51:26 +0000 |
| commit | d571a564d3cc4686327020f632e6d4ac98376593 (patch) | |
| tree | 44c856eb399683556c0812f03fa5de142966de01 /src/odbc/mysql.sql | |
| parent | * src/odbc/mysql: Database creation script should now be compliant with (diff) | |
* src/mod_private_odbc.erl: Support for MySQL and MSSQL.
* src/odbc/odbc_queries.erl: Likewise.
* src/odbc/mysql.sql: Likewise.
* src/odbc/mssql.sql: Likewise.
SVN Revision: 674
Diffstat (limited to 'src/odbc/mysql.sql')
| -rw-r--r-- | src/odbc/mysql.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index 2394f9901..607a7407f 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -93,6 +93,15 @@ 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 private_storage ( + username varchar(250) NOT NULL, + namespace varchar(250) NOT NULL, + data text NOT NULL +) CHARACTER SET utf8; + +CREATE INDEX i_private_storage_username USING BTREE ON private_storage(username); +CREATE UNIQUE INDEX i_private_storage_username_namespace USING BTREE ON private_storage(username, namespace); + --- To update from 1.x: -- ALTER TABLE rosterusers ADD COLUMN askmessage text AFTER ask; -- UPDATE rosterusers SET askmessage = ''; |