1 |
CREATE TABLE instr_dirs ( |
2 |
dir_id INTEGER PRIMARY KEY AUTOINCREMENT, |
3 |
parent_dir_id INTEGER DEFAULT 0, |
4 |
dir_name TEXT, |
5 |
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP, |
6 |
modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP, |
7 |
description TEXT, |
8 |
FOREIGN KEY(parent_dir_id) REFERENCES instr_dirs(dir_id), |
9 |
UNIQUE (parent_dir_id,dir_name) |
10 |
); |
11 |
|
12 |
INSERT INTO instr_dirs (dir_id, parent_dir_id, dir_name) VALUES (0, -2, "/"); |
13 |
|
14 |
CREATE TABLE instruments ( |
15 |
instr_id INTEGER PRIMARY KEY AUTOINCREMENT, |
16 |
dir_id INTEGER DEFAULT 0, |
17 |
instr_name TEXT, |
18 |
instr_file TEXT, |
19 |
instr_nr INTEGER, |
20 |
format_family TEXT, |
21 |
format_version TEXT, |
22 |
instr_size INTEGER, |
23 |
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP, |
24 |
modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP, |
25 |
description TEXT, |
26 |
is_drum INTEGER(1), |
27 |
product TEXT, |
28 |
artists TEXT, |
29 |
keywords TEXT, |
30 |
FOREIGN KEY(dir_id) REFERENCES instr_dirs(dir_id), |
31 |
UNIQUE (dir_id,instr_name) |
32 |
); |