schema_optimize.sql

--
-- Recreate the contributor_album table to ensure it is accurate (bug 4882).
-- This is done here as it is faster to do in sql than in the server.
--

DELETE FROM scanned_pics;

-- XXX This appears to not be needed anymore as contributors are properly
-- removed by the new scanner

--DELETE FROM contributor_album;

--INSERT INTO contributor_album (role,contributor,album) SELECT DISTINCT role,contributor,album FROM contributor_track,tracks where tracks.id=contributor_track.track;

-- Analyze is slow but very necessary for SQLite to choose correct indices for queries, especially
-- on the tracks table which has a ton of them.
ANALYZE;