diff options
author | Andrew Dolgov <[email protected]> | 2008-09-18 06:02:43 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-09-18 06:02:43 +0100 |
commit | f7f939b29c44fbc13e567c855bcb2a35e1083030 (patch) | |
tree | 65adf6dd66d1a8e84c66aca7091771126bdc724f /schema/versions/pgsql | |
parent | 5a437c88d78ab42fa17ba29176be58e46561b4c6 (diff) |
alter ttrss_labels.sql_exp to text, bump schema (closes #221)
Diffstat (limited to 'schema/versions/pgsql')
-rw-r--r-- | schema/versions/pgsql/43.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/schema/versions/pgsql/43.sql b/schema/versions/pgsql/43.sql new file mode 100644 index 000000000..52bc365cc --- /dev/null +++ b/schema/versions/pgsql/43.sql @@ -0,0 +1,7 @@ +alter table ttrss_labels rename column sql_exp to sql_exp_old; +alter table ttrss_labels add column sql_exp text; +update ttrss_labels set sql_exp = sql_exp_old; +alter table ttrss_labels alter column sql_exp set not null; +alter table ttrss_labels drop column sql_exp_old; + +update ttrss_version set schema_version = 43; |