summaryrefslogtreecommitdiff
path: root/src/odbc/pg.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/odbc/pg.sql')
-rw-r--r--src/odbc/pg.sql12
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,