* src/odbc/pg.sql: Added spool.seq field for offline messages

sorting
* src/mod_offline_odbc.erl: Likewise

SVN Revision: 424

1 files changed, 8 insertions, 1 deletions

diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql
index 5d0799ccd..e8404b134 100644
--- a/src/odbc/pg.sql
+++ b/src/odbc/pg.sql
@@ -36,10 +36,17 @@ 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;
 
 CREATE TABLE spool (
     username text NOT NULL,
-    xml text
+    xml text,
+    seq SERIAL
 );
 
 CREATE INDEX i_despool ON spool USING btree (username);