diff options
| author | Mickaël Rémond <mickael.remond@process-one.net> | 2006-05-23 20:19:37 +0000 |
|---|---|---|
| committer | Mickaël Rémond <mickael.remond@process-one.net> | 2006-05-23 20:19:37 +0000 |
| commit | 42cdf80cd4fd6d398639b4d722282ab29473b311 (patch) | |
| tree | 0b509225e98de272c903ff9bb02e0d479af83d54 /src/odbc/mysql.sql | |
| parent | * src/ejabberd_sm.erl: The max_user_sessions has been moved to (diff) | |
* src/mod_roster.erl: The subscribe request are now resend at
login as long as they have not been answered. mod_roster do no more
depends on mod_offline.
* src/ejabberd_sm.erl: Likewise.
* src/ejabberd_c2s.erl: Likewise.
* src/mod_roster_odbc.erl: Likewise (The ODBC/relational support
has not yet been tested).
* src/mod_roster.hrl: Likewise.
* src/mod_offline.erl: Likewise.
* src/mod_offline_odbc.erl: Likewise.
* odbc/pg.sql: Likewise.
* odbc/mysql.sql: Likewise.
SVN Revision: 569
Diffstat (limited to 'src/odbc/mysql.sql')
| -rw-r--r-- | src/odbc/mysql.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index 89c7f65b8..8642d72a4 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -19,6 +19,7 @@ CREATE TABLE rosterusers ( nick text, subscription character(1) NOT NULL, ask character(1) NOT NULL, + askmessage text, server character(1) NOT NULL, subscribe text, type text @@ -91,3 +92,5 @@ 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); +--- To update from 1.x: +-- ALTER TABLE rosterusers ADD COLUMN askmessage text AFTER ask; |