internal/store/sql/migrations/0003_create_albums_table_up.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 / 0003_create_albums_table_up.sql

at main 20 lines 603 B view raw

 1CREATE TABLE IF NOT EXISTS albums (
 2    id INTEGER PRIMARY KEY AUTOINCREMENT,
 3    title TEXT NOT NULL,
 4    artist TEXT NOT NULL,
 5    genre TEXT,
 6    release_year INTEGER,
 7    tracks TEXT, -- JSON array of track names
 8    duration_seconds INTEGER,
 9    album_art_path TEXT,
10    rating INTEGER CHECK (rating >= 1 AND rating <= 5),
11    created DATETIME DEFAULT CURRENT_TIMESTAMP,
12    modified DATETIME DEFAULT CURRENT_TIMESTAMP
13);
14
15CREATE TRIGGER update_albums_modified
16    AFTER UPDATE ON albums
17    FOR EACH ROW
18    BEGIN
19        UPDATE albums SET modified = CURRENT_TIMESTAMP WHERE id = NEW.id;
20    END;