diff options
Diffstat (limited to 'src/odbc/pg.sql')
| -rw-r--r-- | src/odbc/pg.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql index 3cf3a0949..2273ad954 100644 --- a/src/odbc/pg.sql +++ b/src/odbc/pg.sql @@ -146,6 +146,11 @@ CREATE INDEX i_private_storage_username ON private_storage USING btree (username CREATE UNIQUE INDEX i_private_storage_username_namespace ON private_storage USING btree (username, namespace); +CREATE TABLE roster_version ( + username text PRIMARY KEY, + version text NOT NULL +); + -- To update from 0.9.8: -- CREATE SEQUENCE spool_seq_seq; -- ALTER TABLE spool ADD COLUMN seq integer; |