File: 19.sql

package info (click to toggle)
tt-rss 21~git20210204.b4cbc79%2Bdfsg-1.2
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 12,428 kB
  • sloc: php: 29,355; javascript: 13,884; sql: 2,341; sh: 315; makefile: 81; perl: 9
file content (11 lines) | stat: -rw-r--r-- 519 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_PREFS_PUBLISH_KEY', 2, '', '', 1);

alter table ttrss_user_entries add column published boolean;
update ttrss_user_entries set published = false;
alter table ttrss_user_entries alter column published set not null;
alter table ttrss_user_entries alter column published set default false;

insert into ttrss_filter_actions (id,name,description) values (5, 'publish', 
	'Publish article');

update ttrss_version set schema_version = 19;