/data/sql/dbmigrate-22_to_23.sql

 1-- Script to migate from db version 22 to 23.
 2-- Only change in this version is that playlists gained a createdOn date.
 3-- Set all playlists to created to now.
 4--
 5-- Separate each command with %%
 6
 7ALTER TABLE playlist ADD COLUMN createdOn INTEGER NOT NULL DEFAULT 0;
 8
 9UPDATE playlist SET createdOn = strftime( '%s','now' );
10
11UPDATE settings SET v = '23' WHERE k == 'schema_version';