From 133dacf4770c4a77c68caa7a994c76bc2f09c08b Mon Sep 17 00:00:00 2001 From: Akshay Nair Date: Tue, 9 Jun 2026 16:48:46 +0530 Subject: Add audio generation + mario theme --- setup.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'setup.sql') diff --git a/setup.sql b/setup.sql index 0a56f55..18e34d7 100644 --- a/setup.sql +++ b/setup.sql @@ -29,6 +29,18 @@ CREATE TABLE pixels ( UNIQUE(image_id, x, y) ); +CREATE TABLE audio_tracks ( + id TEXT PRIMARY KEY, + sample_rate INTEGER NOT NULL, + format TEXT NOT NULL +); +CREATE TABLE audio_track_samples ( + value INTEGER NOT NULL, + position INTEGER NOT NULL, + audio_track_id TEXT, + FOREIGN KEY(audio_track_id) REFERENCES audio_tracks(id) ON DELETE CASCADE +); + CREATE TRIGGER delete_pixels_when_image_reinserted_because_i_said_so_and_to_make_rerunning_easier BEFORE INSERT ON images BEGIN @@ -40,3 +52,10 @@ BEFORE INSERT ON videos BEGIN DELETE FROM images WHERE video_id = NEW.id; END; + +CREATE TRIGGER delete_samples_when_track_reinserted_because_i_said_so_and_to_make_rerunning_easier +BEFORE INSERT ON audio_tracks +BEGIN + DELETE FROM audio_track_samples WHERE audio_track_id = NEW.id; +END; + -- cgit v1.3.1