/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
- -- Script to migate from db version 23 to 24.
- -- Added the social_attributes table.
- --
- -- Separate each command with %%
- CREATE TABLE IF NOT EXISTS social_attributes (
- id INTEGER REFERENCES track(id) ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, -- track id
- source INTEGER REFERENCES source(id) ON DELETE CASCADE ON UPDATE CASCADE, -- DEFERRABLE INITIALLY DEFERRED,
- k TEXT NOT NULL,
- v TEXT NOT NULL,
- timestamp INTEGER NOT NULL DEFAULT 0
- );
- CREATE INDEX social_attrib_id ON social_attributes(id);
- CREATE INDEX social_attrib_source ON social_attributes(source);
- CREATE INDEX social_attrib_k ON social_attributes(k);
- CREATE INDEX social_attrib_timestamp ON social_attributes(timestamp);
- UPDATE settings SET v = '24' WHERE k == 'schema_version';