Debian Codegraph @

rc/sql/1.sql

raw
1
2 -- Media table
3
4 CREATE TABLE MediaTable (
5 id INTEGER PRIMARY KEY,
6 filename TEXT NOT NULL
7 );
8
9 -- Album table
10
11 CREATE TABLE AlbumTable (
12 id INTEGER PRIMARY KEY,
13 time_added INTEGER,
14 title TEXT NOT NULL,
15 subtitle TEXT NOT NULL
16 );
17
18 CREATE INDEX AlbumTableTimeAddedIndex ON AlbumTable(time_added);
19
20 -- Media/album relationship table
21
22 CREATE TABLE MediaAlbumTable (
23 media_id INTEGER REFERENCES MediaTable ON DELETE CASCADE,
24 album_id INTEGER REFERENCES AlbumTable ON DELETE CASCADE
25 );
26
27 CREATE INDEX MediaAlbumTableMediaIndex ON MediaAlbumTable(media_id);
28 CREATE INDEX MediaAlbumTableAlbumIndex ON MediaAlbumTable(album_id);