/[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 1161 - (show annotations) (download)
Mon Apr 16 15:51:18 2007 UTC (16 years, 11 months ago) by iliev
File size: 1082 byte(s)
* Implemented instruments database

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, 0, "/");
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