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