Commit Graph

13 Commits

Author SHA1 Message Date
Emilien Devos
1e6a035109 limit feeds and delete materialized views 2023-07-26 15:58:35 +02:00
Andre Borie
ffa9e5dfab Make migrations (mostly) idempotent. 2021-01-17 14:20:34 +00:00
Omar Roth
64464f23ae
Add 'views' to channel_videos 2019-05-30 18:59:13 -05:00
Omar Roth
42dd6326d5 Remove unnecessary index 2019-04-28 14:11:23 -05:00
Omar Roth
fd26f9f34e Add support for premieres to search and feed 2019-03-22 14:54:35 -05:00
Omar Roth
52cad8d6da Update change index for channel_videos and add index for nonces 2019-02-11 10:59:17 -06:00
Omar Roth
19632511d5 Update SQL 2018-11-02 09:46:45 -05:00
Omar Roth
c55c553725 Fix channel_videos schema 2018-10-30 10:50:27 -05:00
Omar Roth
8794e26e67 Add length_seconds to channel_videos 2018-10-30 09:20:51 -05:00
Omar Roth
51d00b16c3 Use hash instead of btree for channel_videos_ucid_idx 2018-09-21 08:52:27 -05:00
Omar Roth
b13b91e2bf Add ucid index for channel_videos 2018-07-27 17:38:47 -05:00
Omar Roth
6c4cfbe39d Add users table 2018-03-29 21:41:05 -05:00
Omar Roth
239a6c892c Use seperate table for videos pulled from RSS 2018-03-28 22:29:54 -05:00