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