From 50f44530d2943e91ab2d4e3d08ced8f8c2689dab Mon Sep 17 00:00:00 2001 From: Alexey Shchepin Date: Sun, 29 Jan 2006 04:38:31 +0000 Subject: * 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 --- src/odbc/pg.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'src/odbc') 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, -- cgit v1.2.3