Plume/migrations/sqlite/2019-12-10-104935_fill_timelines/down.sql

9 lines
296 B
MySQL
Raw Permalink Normal View History

DELETE FROM timeline WHERE id IN
(
SELECT timeline.id FROM timeline
INNER JOIN timeline_definition ON timeline.timeline_id = timeline_definition.id
WHERE timeline_definition.query LIKE 'followed or [%]' OR
timeline_definition.query = 'local' OR
timeline_definition.query = 'all'
);