diff options
Diffstat (limited to 'src/odbc/pg.sql')
-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, |