/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. 

  2. -- Only change in this version is that playlists gained a createdOn date.
    3. 

  3. -- Set all playlists to created to now.
    4. 

  4. --
    5. 

  5. -- Separate each command with %%
    6. 

  6. 

  7. ALTER TABLE playlist ADD COLUMN createdOn INTEGER NOT NULL DEFAULT 0;
    8. 

  8. 

  9. UPDATE playlist SET createdOn = strftime( '%s','now' );
    10. 

  10. 

  11. UPDATE settings SET v = '23' WHERE k == 'schema_version';
    12.