1CREATE TABLE IF NOT EXISTS tidal_artists_songs (
2
3  title TEXT,
4  album TEXT,
5  artist TEXT,
6  albumartist TEXT,
7  track INTEGER NOT NULL DEFAULT -1,
8  disc INTEGER NOT NULL DEFAULT -1,
9  year INTEGER NOT NULL DEFAULT -1,
10  originalyear INTEGER NOT NULL DEFAULT 0,
11  genre TEXT,
12  compilation INTEGER NOT NULL DEFAULT 0,
13  composer TEXT,
14  performer TEXT,
15  grouping TEXT,
16  comment TEXT,
17  lyrics TEXT,
18
19  artist_id TEXT,
20  album_id TEXT,
21  song_id TEXT,
22
23  beginning INTEGER NOT NULL DEFAULT 0,
24  length INTEGER NOT NULL DEFAULT 0,
25
26  bitrate INTEGER NOT NULL DEFAULT -1,
27  samplerate INTEGER NOT NULL DEFAULT -1,
28  bitdepth INTEGER NOT NULL DEFAULT -1,
29
30  source INTEGER NOT NULL DEFAULT 0,
31  directory_id INTEGER NOT NULL DEFAULT -1,
32  url TEXT NOT NULL,
33  filetype INTEGER NOT NULL DEFAULT 0,
34  filesize INTEGER NOT NULL DEFAULT -1,
35  mtime INTEGER NOT NULL DEFAULT -1,
36  ctime INTEGER NOT NULL DEFAULT -1,
37  unavailable INTEGER DEFAULT 0,
38
39  playcount INTEGER NOT NULL DEFAULT 0,
40  skipcount INTEGER NOT NULL DEFAULT 0,
41  lastplayed INTEGER NOT NULL DEFAULT -1,
42
43  compilation_detected INTEGER DEFAULT 0,
44  compilation_on INTEGER NOT NULL DEFAULT 0,
45  compilation_off INTEGER NOT NULL DEFAULT 0,
46  compilation_effective INTEGER NOT NULL DEFAULT 0,
47
48  art_automatic TEXT,
49  art_manual TEXT,
50
51  effective_albumartist TEXT,
52  effective_originalyear INTEGER NOT NULL DEFAULT 0,
53
54  cue_path TEXT
55
56);
57
58CREATE TABLE IF NOT EXISTS tidal_albums_songs (
59
60  title TEXT,
61  album TEXT,
62  artist TEXT,
63  albumartist TEXT,
64  track INTEGER NOT NULL DEFAULT -1,
65  disc INTEGER NOT NULL DEFAULT -1,
66  year INTEGER NOT NULL DEFAULT -1,
67  originalyear INTEGER NOT NULL DEFAULT 0,
68  genre TEXT,
69  compilation INTEGER NOT NULL DEFAULT 0,
70  composer TEXT,
71  performer TEXT,
72  grouping TEXT,
73  comment TEXT,
74  lyrics TEXT,
75
76  artist_id TEXT,
77  album_id TEXT,
78  song_id TEXT,
79
80  beginning INTEGER NOT NULL DEFAULT 0,
81  length INTEGER NOT NULL DEFAULT 0,
82
83  bitrate INTEGER NOT NULL DEFAULT -1,
84  samplerate INTEGER NOT NULL DEFAULT -1,
85  bitdepth INTEGER NOT NULL DEFAULT -1,
86
87  source INTEGER NOT NULL DEFAULT 0,
88  directory_id INTEGER NOT NULL DEFAULT -1,
89  url TEXT NOT NULL,
90  filetype INTEGER NOT NULL DEFAULT 0,
91  filesize INTEGER NOT NULL DEFAULT -1,
92  mtime INTEGER NOT NULL DEFAULT -1,
93  ctime INTEGER NOT NULL DEFAULT -1,
94  unavailable INTEGER DEFAULT 0,
95
96  playcount INTEGER NOT NULL DEFAULT 0,
97  skipcount INTEGER NOT NULL DEFAULT 0,
98  lastplayed INTEGER NOT NULL DEFAULT -1,
99
100  compilation_detected INTEGER DEFAULT 0,
101  compilation_on INTEGER NOT NULL DEFAULT 0,
102  compilation_off INTEGER NOT NULL DEFAULT 0,
103  compilation_effective INTEGER NOT NULL DEFAULT 0,
104
105  art_automatic TEXT,
106  art_manual TEXT,
107
108  effective_albumartist TEXT,
109  effective_originalyear INTEGER NOT NULL DEFAULT 0,
110
111  cue_path TEXT
112
113);
114
115CREATE TABLE IF NOT EXISTS tidal_songs (
116
117  title TEXT,
118  album TEXT,
119  artist TEXT,
120  albumartist TEXT,
121  track INTEGER NOT NULL DEFAULT -1,
122  disc INTEGER NOT NULL DEFAULT -1,
123  year INTEGER NOT NULL DEFAULT -1,
124  originalyear INTEGER NOT NULL DEFAULT 0,
125  genre TEXT,
126  compilation INTEGER NOT NULL DEFAULT 0,
127  composer TEXT,
128  performer TEXT,
129  grouping TEXT,
130  comment TEXT,
131  lyrics TEXT,
132
133  artist_id TEXT,
134  album_id TEXT,
135  song_id TEXT,
136
137  beginning INTEGER NOT NULL DEFAULT 0,
138  length INTEGER NOT NULL DEFAULT 0,
139
140  bitrate INTEGER NOT NULL DEFAULT -1,
141  samplerate INTEGER NOT NULL DEFAULT -1,
142  bitdepth INTEGER NOT NULL DEFAULT -1,
143
144  source INTEGER NOT NULL DEFAULT 0,
145  directory_id INTEGER NOT NULL DEFAULT -1,
146  url TEXT NOT NULL,
147  filetype INTEGER NOT NULL DEFAULT 0,
148  filesize INTEGER NOT NULL DEFAULT -1,
149  mtime INTEGER NOT NULL DEFAULT -1,
150  ctime INTEGER NOT NULL DEFAULT -1,
151  unavailable INTEGER DEFAULT 0,
152
153  playcount INTEGER NOT NULL DEFAULT 0,
154  skipcount INTEGER NOT NULL DEFAULT 0,
155  lastplayed INTEGER NOT NULL DEFAULT -1,
156
157  compilation_detected INTEGER DEFAULT 0,
158  compilation_on INTEGER NOT NULL DEFAULT 0,
159  compilation_off INTEGER NOT NULL DEFAULT 0,
160  compilation_effective INTEGER NOT NULL DEFAULT 0,
161
162  art_automatic TEXT,
163  art_manual TEXT,
164
165  effective_albumartist TEXT,
166  effective_originalyear INTEGER NOT NULL DEFAULT 0,
167
168  cue_path TEXT
169
170);
171
172CREATE VIRTUAL TABLE IF NOT EXISTS tidal_artists_songs_fts USING fts5(
173
174  ftstitle,
175  ftsalbum,
176  ftsartist,
177  ftsalbumartist,
178  ftscomposer,
179  ftsperformer,
180  ftsgrouping,
181  ftsgenre,
182  ftscomment,
183  tokenize = "unicode61 remove_diacritics 1"
184
185);
186
187CREATE VIRTUAL TABLE IF NOT EXISTS tidal_albums_songs_fts USING fts5(
188
189  ftstitle,
190  ftsalbum,
191  ftsartist,
192  ftsalbumartist,
193  ftscomposer,
194  ftsperformer,
195  ftsgrouping,
196  ftsgenre,
197  ftscomment,
198  tokenize = "unicode61 remove_diacritics 1"
199
200);
201
202CREATE VIRTUAL TABLE IF NOT EXISTS tidal_songs_fts USING fts5(
203
204  ftstitle,
205  ftsalbum,
206  ftsartist,
207  ftsalbumartist,
208  ftscomposer,
209  ftsperformer,
210  ftsgrouping,
211  ftsgenre,
212  ftscomment,
213  tokenize = "unicode61 remove_diacritics 1"
214
215);
216
217UPDATE schema_version SET version=12;
218