]> git.wh0rd.org - tt-rss.git/blob - schema/upgrade-1.1.3-1.1.4-pgsql.sql
add author column to ttrss_entries, add upgrade script for 1.1.4, bump schema version
[tt-rss.git] / schema / upgrade-1.1.3-1.1.4-pgsql.sql
1 begin;
2
3 alter table ttrss_entries add column author varchar(250);
4
5 update ttrss_entries set author = '';
6
7 alter table ttrss_entries alter column author set not null;
8 alter table ttrss_entries alter column author set default '';
9
10 update ttrss_version set schema_version = 6;
11
12 commit;