PageRenderTime 151ms CodeModel.GetById 61ms app.highlight 1ms RepoModel.GetById 44ms app.codeStats 1ms

/data/sql/dbmigrate-22_to_23.sql

http://github.com/tomahawk-player/tomahawk
SQL | 11 lines | 3 code | 3 blank | 5 comment | 1 complexity | 44972921760da4b3e7be85f93634e3ff MD5 | raw file
 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';