forked from Unity-Technologies/UnityDataTools
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathAudioClip.sql
More file actions
53 lines (48 loc) · 949 Bytes
/
Copy pathAudioClip.sql
File metadata and controls
53 lines (48 loc) · 949 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
CREATE TABLE audio_load_types(
id INTEGER,
name TEXT,
PRIMARY KEY (id)
);
CREATE TABLE audio_formats(
id INTEGER,
name TEXT,
PRIMARY KEY (id)
);
CREATE TABLE audio_clips(
id INTEGER,
bits_per_sample INTEGER,
frequency INTEGER,
channels INTEGER,
load_type INTEGER,
format INTEGER,
PRIMARY KEY (id)
);
CREATE VIEW audio_clip_view AS
SELECT
o.*,
a.bits_per_sample,
a.frequency,
a.channels,
l.name AS load_type,
f.name AS format
FROM object_view o
INNER JOIN audio_clips a ON o.id = a.id
LEFT JOIN audio_load_types l ON a.load_type = l.id
LEFT JOIN audio_formats f ON a.format = f.id;
INSERT INTO audio_load_types (id, name)
VALUES
(0, 'Decompress on Load'),
(1, 'Compressed in Memory'),
(2, 'Streaming');
INSERT INTO audio_formats (id, name)
VALUES
(0, 'PCM'),
(1, 'Vorbis'),
(2, 'ADPCM'),
(3, 'MP3'),
(4, 'PSMVAG'),
(5, 'HEVAG'),
(6, 'XMA'),
(7, 'AAC'),
(8, 'GCADPCM'),
(9, 'ATRAC9');