File: schema-7.sql

package info (click to toggle)
clementine 1.2.3%2Bdfsg-2
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 24,792 kB
  • ctags: 20,160
  • sloc: cpp: 111,170; xml: 4,413; python: 2,687; ansic: 984; sql: 753; sh: 66; makefile: 25
file content (26 lines) | stat: -rw-r--r-- 415 bytes parent folder | download | duplicates (8) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 
CREATE TABLE playlists (
  name TEXT NOT NULL
);

CREATE TABLE playlist_items (
  playlist INTEGER NOT NULL,
  type TEXT NOT NULL, /* Library, Stream, File, or Radio */

  /* Library */
  library_id INTEGER,

  /* Stream, File or Radio */
  url TEXT,

  /* Stream or Radio */
  title TEXT,
  artist TEXT,
  album TEXT,
  length INTEGER,

  /* Radio */
  radio_service TEXT
);

UPDATE schema_version SET version=7;