blob: 58f11126b41fec0291809515f4ffc8e70ef4ab88 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
CREATE TABLE artists (
id INTEGER PRIMARY KEY,
name VARCHAR);
CREATE TABLE albums (
id INTEGER PRIMARY KEY,
artist_id INTEGER,
name VARCHAR,
tracks INTEGER);
CREATE TABLE tracks (
id INTEGER PRIMARY KEY,
artist_id INTEGER,
album_id INTEGER,
name VARCHAR,
length INTEGER,
num INTEGER,
file_name VARCHAR,
file_index INTEGER);
|
