File: schema-27.sql

package info (click to toggle)
clementine 1.3.1%2Bgit276-g3485bbe43%2Bdfsg-1
  • links: PTS
  • area: main
  • in suites: stretch
  • size: 26,544 kB
  • sloc: cpp: 114,212; xml: 5,193; python: 3,704; sql: 858; ansic: 123; sh: 71; makefile: 29
file content (12 lines) | stat: -rw-r--r-- 318 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
 
CREATE INDEX idx_title ON songs (title);

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 != '' 
 group by artist, album , title 
having count(*) > 1;

UPDATE schema_version SET version=27;