diff options
| author | Alexey Shchepin <alexey@process-one.net> | 2006-05-26 00:00:32 +0000 |
|---|---|---|
| committer | Alexey Shchepin <alexey@process-one.net> | 2006-05-26 00:00:32 +0000 |
| commit | c737ce1b8cdcf70a4b6d9afda9e019564e332ed3 (patch) | |
| tree | baac0e6161da26f185cd2614c5c59aba47ab753b /src/odbc | |
| parent | * src/mod_roster.erl: The subscribe request are now resend at (diff) | |
* src/odbc/pg.sql: Updated
* src/mod_shared_roster.erl: Updated
* src/ejabberd_sm.erl: Bugfix
* src/mod_roster.erl: Bugfix
* src/mod_roster_odbc.erl: Likewise
SVN Revision: 570
Diffstat (limited to 'src/odbc')
| -rw-r--r-- | src/odbc/pg.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql index d115e1e5a..a7059d503 100644 --- a/src/odbc/pg.sql +++ b/src/odbc/pg.sql @@ -18,7 +18,7 @@ CREATE TABLE rosterusers ( nick text, subscription character(1) NOT NULL, ask character(1) NOT NULL, - askmessage text, + askmessage text NOT NULL, server character(1) NOT NULL, subscribe text, "type" text @@ -99,4 +99,6 @@ CREATE INDEX i_vcard_search_lorgunit ON vcard_search(lorgunit); -- ALTER TABLE spool ALTER COLUMN seq SET NOT NULL; --- To update from 1.x: --- ALTER TABLE rosterusers ADD COLUMN askmessage text AFTER ask; +-- ALTER TABLE rosterusers ADD COLUMN askmessage text; +-- UPDATE rosterusers SET askmessage = ''; +-- ALTER TABLE rosterusers ALTER COLUMN askmessage SET NOT NULL; |