mirror of
https://github.com/stashapp/stash.git
synced 2025-12-08 17:35:40 +01:00
0664c5b974
* track watchtime and view time * add view count sorting, added continue position filter * display metrics in file info * add toggle for tracking activity * save activity every 10 seconds * reset resume when video is nearly complete * start from beginning when playing scene in queue Co-authored-by: WithoutPants <53250216+WithoutPants@users.noreply.github.com>
4 lines
No EOL
290 B
SQL
4 lines
No EOL
290 B
SQL
ALTER TABLE `scenes` ADD COLUMN `resume_time` float not null default 0;
|
|
ALTER TABLE `scenes` ADD COLUMN `last_played_at` datetime default null;
|
|
ALTER TABLE `scenes` ADD COLUMN `play_count` tinyint not null default 0;
|
|
ALTER TABLE `scenes` ADD COLUMN `play_duration` float not null default 0; |