1
ALTER TABLE playlist_items ADD COLUMN albumartist TEXT;
3
ALTER TABLE playlist_items ADD COLUMN composer TEXT;
5
ALTER TABLE playlist_items ADD COLUMN track INTEGER;
7
ALTER TABLE playlist_items ADD COLUMN disc INTEGER;
9
ALTER TABLE playlist_items ADD COLUMN bpm REAL;
11
ALTER TABLE playlist_items ADD COLUMN year INTEGER;
13
ALTER TABLE playlist_items ADD COLUMN genre TEXT;
15
ALTER TABLE playlist_items ADD COLUMN comment TEXT;
17
ALTER TABLE playlist_items ADD COLUMN compilation INTEGER;
19
ALTER TABLE playlist_items ADD COLUMN bitrate INTEGER;
21
ALTER TABLE playlist_items ADD COLUMN samplerate INTEGER;
23
ALTER TABLE playlist_items ADD COLUMN directory INTEGER;
25
ALTER TABLE playlist_items ADD COLUMN filename TEXT;
27
ALTER TABLE playlist_items ADD COLUMN mtime INTEGER;
29
ALTER TABLE playlist_items ADD COLUMN ctime INTEGER;
31
ALTER TABLE playlist_items ADD COLUMN filesize INTEGER;
33
ALTER TABLE playlist_items ADD COLUMN sampler INTEGER NOT NULL DEFAULT 0;
35
ALTER TABLE playlist_items ADD COLUMN art_automatic TEXT;
37
ALTER TABLE playlist_items ADD COLUMN art_manual TEXT;
39
ALTER TABLE playlist_items ADD COLUMN filetype INTEGER NOT NULL DEFAULT 0;
41
ALTER TABLE playlist_items ADD COLUMN playcount INTEGER NOT NULL DEFAULT 0;
43
ALTER TABLE playlist_items ADD COLUMN lastplayed INTEGER;
45
ALTER TABLE playlist_items ADD COLUMN rating INTEGER;
47
ALTER TABLE playlist_items ADD COLUMN forced_compilation_on INTEGER NOT NULL DEFAULT 0;
49
ALTER TABLE playlist_items ADD COLUMN forced_compilation_off INTEGER NOT NULL DEFAULT 0;
51
ALTER TABLE playlist_items ADD COLUMN effective_compilation NOT NULL DEFAULT 0;
53
ALTER TABLE playlist_items ADD COLUMN skipcount INTEGER NOT NULL DEFAULT 0;
55
ALTER TABLE playlist_items ADD COLUMN score INTEGER NOT NULL DEFAULT 0;
57
UPDATE playlist_items SET filename = url;
59
UPDATE schema_version SET version=29;