PageRenderTime 101ms CodeModel.GetById 60ms app.highlight 2ms RepoModel.GetById 38ms app.codeStats 0ms

/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-- Nothing to do
 3
 4CREATE TABLE IF NOT EXISTS collection_attributes (
 5    id INTEGER REFERENCES source(id) ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, -- source id, null for local source
 6    k TEXT NOT NULL,
 7    v TEXT NOT NULL
 8);
 9UPDATE settings SET v = '27' WHERE k == 'schema_version';
10