/data/sql/dbmigrate-26_to_27.sql

http://github.com/tomahawk-player/tomahawk · SQL · 10 lines · 6 code · 2 blank · 2 comment · 1 complexity · ea37fe00ef5bc90151b38206de5475b0 MD5 · raw file 

    

  1. -- Script to migate from db version 26 to 27
    2. 

  2. -- Nothing to do
    3. 

  3. 

  4. CREATE TABLE IF NOT EXISTS collection_attributes (
    5. 

  5.     id INTEGER REFERENCES source(id) ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, -- source id, null for local source
    6. 

  6.     k TEXT NOT NULL,
    7. 

  7.     v TEXT NOT NULL
    8. 

  8. );
    9. 

  9. UPDATE settings SET v = '27' WHERE k == 'schema_version';
    10.