File: 105.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-- 355 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
 
begin;

alter table ttrss_user_entries add column last_marked timestamp;
alter table ttrss_user_entries add column last_published timestamp;

update ttrss_user_entries set last_published = last_read where published = true;
update ttrss_user_entries set last_marked = last_read where marked = true;

update ttrss_version set schema_version = 105;

commit;