File: schema-13.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 (22 lines) | stat: -rw-r--r-- 825 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
CREATE VIRTUAL TABLE songs_fts USING fts3(
  ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, ftsgenre, ftscomment,
  tokenize=unicode
);

CREATE VIRTUAL TABLE magnatune_songs_fts USING fts3(
  ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, ftsgenre, ftscomment,
  tokenize=unicode
);

INSERT INTO songs_fts (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, ftsgenre, ftscomment)
    SELECT ROWID, title, album, artist, albumartist, composer, genre, comment
    FROM songs;

INSERT INTO magnatune_songs_fts (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, ftsgenre, ftscomment)
    SELECT ROWID, title, album, artist, albumartist, composer, genre, comment
    FROM magnatune_songs;

CREATE INDEX idx_album ON songs (album);

UPDATE schema_version SET version=13;