]> git.wh0rd.org - tt-rss.git/blob - schema/versions/pgsql/114.sql
schema: add feed/cat view_settings
[tt-rss.git] / schema / versions / pgsql / 114.sql
1 begin;
2
3 alter table ttrss_feeds add column view_settings varchar(250);
4 update ttrss_feeds set view_settings = '';
5 alter table ttrss_feeds alter column view_settings set not null;
6 alter table ttrss_feeds alter column view_settings set default '';
7
8 alter table ttrss_feed_categories add column view_settings varchar(250);
9 update ttrss_feed_categories set view_settings = '';
10 alter table ttrss_feed_categories alter column view_settings set not null;
11 alter table ttrss_feed_categories alter column view_settings set default '';
12
13 update ttrss_version set schema_version = 114;
14
15 commit;