]>
git.wh0rd.org - tt-rss.git/blob - schema/obsolete/upgrade-1.0.6-1.0.7-pgsql.sql
3 alter table ttrss_feeds
add column last_error
text;
4 alter table ttrss_feeds
add column site_url
varchar(250);
5 alter table ttrss_feeds
add column update_interval
integer;
7 update ttrss_feeds
set last_error
= '';
8 update ttrss_feeds
set site_url
= '';
9 update ttrss_feeds
set update_interval
= 0;
11 alter table ttrss_feeds
alter column last_error
set not null;
12 alter table ttrss_feeds
alter column last_error
set default '';
14 alter table ttrss_feeds
alter column site_url
set not null;
15 alter table ttrss_feeds
alter column site_url
set default '';
17 alter table ttrss_feeds
alter column update_interval
set not null;
18 alter table ttrss_feeds
alter column update_interval
set default 0;
20 create table ttrss_version (schema_version
int not null);
22 insert into ttrss_version
values (1);