1
0
mirror of https://github.com/clementine-player/Clementine synced 2024-12-13 09:56:31 +01:00
Clementine-audio-player-Mac.../data/schema/schema-34.sql

16 lines
392 B
SQL

ALTER TABLE %allsongstables ADD COLUMN unavailable INTEGER DEFAULT 0;
DROP VIEW duplicated_songs;
CREATE VIEW duplicated_songs as
select artist dup_artist, album dup_album, title dup_title
from songs as inner_songs
where artist != ''
and album != ''
and title != ''
and unavailable = 0
group by artist, album , title
having count(*) > 1;
UPDATE schema_version SET version=34;