path: root/schema/versions/mysql/36.sql

alter table ttrss_user_entries add column score integer;
update ttrss_user_entries set score = 0;
alter table ttrss_user_entries change score score integer not null;
alter table ttrss_user_entries alter column score set default 0;

update ttrss_version set schema_version = 36;