/data/sql/dbmigrate-23_to_24.sql
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';