schema/upgrade-1.1-1.1.1-mysql.sql


1
2
3
4
5
6
7
8
9
10

begin;

alter table ttrss_entries add column num_comments integer;

update ttrss_entries set num_comments = 0;

alter table ttrss_entries change num_comments num_comments integer not null;
alter table ttrss_entries alter column num_comments set default 0;

commit;