/data/sql/dbmigrate-24_to_25.sql

 1-- Script to migate from db version 24 to 25.
 2-- Added the social_attributes table.
 3--
 4
 5ALTER TABLE dynamic_playlist RENAME TO tmp_dynamic_playlist;
 6
 7CREATE TABLE IF NOT EXISTS dynamic_playlist (
 8    guid TEXT NOT NULL REFERENCES playlist(guid) ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED,
 9    pltype TEXT, -- the generator type
10    plmode INTEGER -- the mode of this playlist
11);
12
13INSERT INTO dynamic_playlist( guid, pltype, plmode ) SELECT guid, pltype, plmode FROM tmp_dynamic_playlist;
14
15DROP TABLE tmp_dynamic_playlist;
16
17UPDATE settings SET v = '25' WHERE k == 'schema_version';