/[svn]/linuxsampler/trunk/scripts/create_instr_db.sql
ViewVC logotype

Contents of /linuxsampler/trunk/scripts/create_instr_db.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1350 - (show annotations) (download)
Sun Sep 16 23:06:10 2007 UTC (12 years, 6 months ago) by iliev
File size: 1083 byte(s)
* instruments db: slashes-in-names are now escaped with \x2f

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 );

  ViewVC Help
Powered by ViewVC