]>
git.wh0rd.org - tt-rss.git/blob - schema/versions/pgsql/26.sql
1 insert into ttrss_prefs (pref_name
,type_id
,def_value
,short_desc
,section_id
) values('PURGE_UNREAD_ARTICLES', 1, 'true', 'Purge unread articles',3);
3 alter table ttrss_users
add column created
timestamp;
4 alter table ttrss_users
alter column created
set default null;
6 create table ttrss_enclosures (id serial
not null primary key,
7 content_url
text not null,
8 content_type
varchar(250) not null,
9 post_id
integer not null,
11 foreign key (post_id
) references ttrss_entries(id) ON DELETE cascade);
13 update ttrss_version
set schema_version
= 26;