]>
Commit | Line | Data |
---|---|---|
37d379de AD |
1 | begin; |
2 | ||
4e31590e | 3 | alter table ttrss_feeds add column last_error text; |
44e7753a | 4 | alter table ttrss_feeds add column site_url varchar(250); |
559ccbf3 | 5 | alter table ttrss_feeds add column update_interval integer; |
4e31590e | 6 | |
83318815 | 7 | update ttrss_feeds set last_error = ''; |
37d379de | 8 | update ttrss_feeds set site_url = ''; |
559ccbf3 | 9 | update ttrss_feeds set update_interval = 0; |
4e31590e AD |
10 | |
11 | alter table ttrss_feeds alter column last_error set not null; | |
12 | alter table ttrss_feeds alter column last_error set default ''; | |
13 | ||
37d379de AD |
14 | alter table ttrss_feeds alter column site_url set not null; |
15 | alter table ttrss_feeds alter column site_url set default ''; | |
16 | ||
559ccbf3 AD |
17 | alter table ttrss_feeds alter column update_interval set not null; |
18 | alter table ttrss_feeds alter column update_interval set default 0; | |
19 | ||
5f171894 AD |
20 | create table ttrss_version (schema_version int not null); |
21 | ||
22 | insert into ttrss_version values (1); | |
23 | ||
37d379de | 24 | commit; |