Sample01.sql
CREATE TABLE artists(
id INTEGER PRIMARY key
,name TEXT
,created_at TIMESTAMP DEFAULT (DATETIME('now','localtime'))
,updated_at TIMESTAMP DEFAULT (DATETIME('now','localtime'))
);
CREATE TABLE albums(
id INTEGER PRIMARY key
,release_name TEXT
,year INTEGER
,created_at TIMESTAMP DEFAULT (DATETIME('now','localtime'))
,updated_at TIMESTAMP DEFAULT (DATETIME('now','localtime'))
,artist_id INTEGER
);
CREATE TABLE IF NOT EXISTS songs (
id INTEGER PRIMARY key
,title TEXT
,length REAL
,created_at TIMESTAMP DEFAULT (DATETIME('now','localtime'))
,updated_at TIMESTAMP DEFAULT (DATETIME('now','localtime'))
,artist_id INTEGER
,album_id INTEGER
);