mirror of
https://github.com/dnote/dnote
synced 2026-03-16 07:25:49 +01:00
91414da0ac* Implement operations * Implement digest endpoints * Implement digests reducer and basic page * Make note component reusable * Implement digest page * Add license * Fix style and accessbility * Fix loading * Fix query * Test * Remove debug
15 lines
332 B
SQL
15 lines
332 B
SQL
-- delete-outdated-digests.sql deletes digests that do not belong to any repetition rules,
|
|
-- along with digest_notes associations.
|
|
|
|
-- +migrate Up
|
|
DELETE
|
|
FROM digest_notes
|
|
USING digests
|
|
WHERE
|
|
digests.rule_id IS NULL AND
|
|
digests.id = digest_notes.digest_id;
|
|
|
|
DELETE FROM digests
|
|
WHERE digests.rule_id IS NULL;
|
|
|
|
-- +migrate Down
|