PageRenderTime 142ms CodeModel.GetById 70ms app.highlight 3ms RepoModel.GetById 68ms app.codeStats 0ms

/data/sql/dbmigrate-23_to_24.sql

http://github.com/tomahawk-player/tomahawk
SQL | 22 lines | 12 code | 6 blank | 4 comment | 1 complexity | 2e4e1375cbfd729d12bfad8c2a6d8e8f MD5 | raw file
 1-- Script to migate from db version 23 to 24.
 2-- Added the social_attributes table.
 3--
 4-- Separate each command with %%
 5
 6CREATE TABLE IF NOT EXISTS social_attributes (
 7    id INTEGER REFERENCES track(id) ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED,   -- track id
 8    source INTEGER REFERENCES source(id) ON DELETE CASCADE ON UPDATE CASCADE, -- DEFERRABLE INITIALLY DEFERRED,
 9    k TEXT NOT NULL,
10    v TEXT NOT NULL,
11    timestamp INTEGER NOT NULL DEFAULT 0
12);
13
14CREATE INDEX social_attrib_id        ON social_attributes(id);
15
16CREATE INDEX social_attrib_source    ON social_attributes(source);
17
18CREATE INDEX social_attrib_k         ON social_attributes(k);
19
20CREATE INDEX social_attrib_timestamp ON social_attributes(timestamp);
21
22UPDATE settings SET v = '24' WHERE k == 'schema_version';