File: 49.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 (9 lines) | stat: -rw-r--r-- 244 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
 
begin;

alter table ttrss_counters_cache add column updated timestamp;
update ttrss_counters_cache set updated = NOW();
alter table ttrss_counters_cache alter column updated set not null;

update ttrss_version set schema_version = 49;

commit;