/data/sql/dbmigrate-23_to_24.sql

 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';