diff options
| author | Alexey Shchepin <alexey@process-one.net> | 2006-01-29 04:38:31 +0000 |
|---|---|---|
| committer | Alexey Shchepin <alexey@process-one.net> | 2006-01-29 04:38:31 +0000 |
| commit | 50f44530d2943e91ab2d4e3d08ced8f8c2689dab (patch) | |
| tree | dfca1c0ee75f69095a117ec17d759b950fbd4258 /src/odbc/pg.sql | |
| parent | * src/ejabberd_update.erl: Support for run-time ejabberd updating (diff) | |
* src/odbc/pg.sql: Fixed syntax error
* src/ejabberd_router.erl: Updated to use gen_server behaviour
* src/ejabberd_sm.erl: Likewise
* src/ejabberd_s2s.erl: Likewise
* src/gen_iq_handler.erl: Likewise
* src/ejabberd_sup.erl: Added supervisor for ejabberd_receiver
* src/ejabberd_receiver.erl: Updated
SVN Revision: 495
Diffstat (limited to '')
| -rw-r--r-- | src/odbc/pg.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql index e8404b13..0db27d2c 100644 --- a/src/odbc/pg.sql +++ b/src/odbc/pg.sql @@ -36,12 +36,12 @@ CREATE TABLE rostergroups ( CREATE INDEX pk_rosterg_user_jid ON rostergroups USING btree (username, jid); -;; To update from previous table definition: -; CREATE SEQUENCE spool_seq_seq; -; ALTER TABLE spool ADD COLUMN seq integer; -; ALTER TABLE spool ALTER COLUMN seq SET DEFAULT nextval('spool_seq_seq'); -; UPDATE spool SET seq = DEFAULT; -; ALTER TABLE spool ALTER COLUMN seq SET NOT NULL; +--- To update from previous table definition: +-- CREATE SEQUENCE spool_seq_seq; +-- ALTER TABLE spool ADD COLUMN seq integer; +-- ALTER TABLE spool ALTER COLUMN seq SET DEFAULT nextval('spool_seq_seq'); +-- UPDATE spool SET seq = DEFAULT; +-- ALTER TABLE spool ALTER COLUMN seq SET NOT NULL; CREATE TABLE spool ( username text NOT NULL, |