]>
git.wh0rd.org - tt-rss.git/blob - schema/upgrade-1.0.6-1.0.7-pgsql.sql
3048eb91cf1f026a6682a3dfa4065689bd4a4b03
3 alter table ttrss_feeds
add column last_error
text;
4 alter table ttrss_feeds
add column site_url
varchar(250);
6 update ttrss_feeds
set last_error
= '';
7 update ttrss_feeds
set site_url
= '';
9 alter table ttrss_feeds
alter column last_error
set not null;
10 alter table ttrss_feeds
alter column last_error
set default '';
12 alter table ttrss_feeds
alter column site_url
set not null;
13 alter table ttrss_feeds
alter column site_url
set default '';
15 create table ttrss_version (schema_version
int not null);
17 insert into ttrss_version
values (1);