]> git.wh0rd.org - tt-rss.git/blob - schema/versions/pgsql/36.sql
add ttrss_user_entries.score; bump schema
[tt-rss.git] / schema / versions / pgsql / 36.sql
1 alter table ttrss_user_entries add column score int;
2 update ttrss_user_entries set score = 0;
3 alter table ttrss_user_entries alter column score set not null;
4 alter table ttrss_user_entries alter column score set default 0;
5
6 update ttrss_version set schema_version = 36;