internal/store/sql/migrations/0001_create_all_tables_down.sql at main · desertthunder.dev/noteleaf

cli + tui to publish to leaflet (wip) & manage tasks, notes & watch/read lists 🍃

charm leaflet readability golang

noteleaf / internal / store / sql / migrations / 0001_create_all_tables_down.sql

at main 23 lines 730 B view raw

 1-- Drop books table and indexes
 2DROP INDEX IF EXISTS idx_books_title;
 3DROP INDEX IF EXISTS idx_books_author;
 4DROP INDEX IF EXISTS idx_books_status;
 5DROP TABLE IF EXISTS books;
 6
 7-- Drop TV shows table and indexes
 8DROP INDEX IF EXISTS idx_tv_shows_season_episode;
 9DROP INDEX IF EXISTS idx_tv_shows_title;
10DROP INDEX IF EXISTS idx_tv_shows_status;
11DROP TABLE IF EXISTS tv_shows;
12
13-- Drop movies table and indexes
14DROP INDEX IF EXISTS idx_movies_title;
15DROP INDEX IF EXISTS idx_movies_status;
16DROP TABLE IF EXISTS movies;
17
18-- Drop tasks table and indexes
19DROP INDEX IF EXISTS idx_tasks_uuid;
20DROP INDEX IF EXISTS idx_tasks_due;
21DROP INDEX IF EXISTS idx_tasks_project;
22DROP INDEX IF EXISTS idx_tasks_status;
23DROP TABLE IF EXISTS tasks;