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