query exec_ CREATE TABLE IF NOT EXISTS artists id INTEGER NOT NULL PRI

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
query.exec_("""CREATE TABLE IF NOT EXISTS artists
(
id INTEGER NOT NULL PRIMARY KEY,
name TEXT UNIQUE COLLATE NOCASE
)""")
query.exec_("""CREATE TABLE IF NOT EXISTS albums
(
id INTEGER NOT NULL PRIMARY KEY,
artist INTEGER,
title TEXT,
year INTEGER
)""")
query.exec_("""CREATE TABLE IF NOT EXISTS tracks
(
id INTEGER NOT NULL PRIMARY KEY,
artist INTEGER,
album INTEGER,
title TEXT,
year INTEGER,
url TEXT,
length INTEGER,
trackno INTEGER
)""")