forked from Unity-Technologies/UnityDataTools
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathTexture2D.sql
More file actions
94 lines (91 loc) · 1.65 KB
/
Copy pathTexture2D.sql
File metadata and controls
94 lines (91 loc) · 1.65 KB
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
CREATE TABLE texture_formats
(
id INTEGER,
name TEXT,
PRIMARY KEY (id)
);
CREATE TABLE textures
(
id INTEGER,
width INTEGER,
height INTEGER,
format INTEGER,
mip_count INTEGER,
rw_enabled INTEGER,
PRIMARY KEY (id)
);
CREATE VIEW texture_view AS
SELECT
o.*,
t.width,
t.height,
f.name AS format,
t.mip_count,
t.rw_enabled
FROM object_view o
INNER JOIN textures t ON o.id = t.id
LEFT JOIN texture_formats f ON t.format = f.id;
INSERT INTO texture_formats (id, name)
VALUES
(0, 'None'),
(1, 'Alpha8'),
(2, 'ARGB4444'),
(3, 'RGB24'),
(4, 'RGBA32'),
(5, 'ARGB32'),
(6, 'ARGBFloat'),
(7, 'RGB565'),
(8, 'BGR24'),
(9, 'AlphaLum16'),
(10, 'DXT1'),
(11, 'DXT3'),
(12, 'DXT5'),
(13, 'RGBA4444'),
(14, 'BGRA32'),
(15, 'RHalf'),
(16, 'RGHalf'),
(17, 'RGBAHalf'),
(18, 'RFloat'),
(19, 'RGFloat'),
(20, 'RGBAFloat'),
(21, 'YUY2'),
(22, 'RGB9e5Float'),
(23, 'RGBFloat'),
(24, 'BC6H'),
(25, 'BC7'),
(26, 'BC4'),
(27, 'BC5'),
(28, 'DXT1Crunched'),
(29, 'DXT5Crunched'),
(30, 'PVRTC_RGB2'),
(31, 'PVRTC_RGBA2'),
(32, 'PVRTC_RGB4'),
(33, 'PVRTC_RGBA4'),
(34, 'ETC_RGB4'),
(35, 'ATC_RGB4'),
(36, 'ATC_RGBA8'),
(41, 'EAC_R'),
(42, 'EAC_R_SIGNED'),
(43, 'EAC_RG'),
(44, 'EAC_RG_SIGNED'),
(45, 'ETC2_RGB'),
(46, 'ETC2_RGBA1'),
(47, 'ETC2_RGBA8'),
(48, 'ASTC_RGB_4x4'),
(49, 'ASTC_RGB_5x5'),
(50, 'ASTC_RGB_6x6'),
(51, 'ASTC_RGB_8x8'),
(52, 'ASTC_RGB_10x10'),
(53, 'ASTC_RGB_12x12'),
(54, 'ASTC_RGBA_4x4'),
(55, 'ASTC_RGBA_5x5'),
(56, 'ASTC_RGBA_6x6'),
(57, 'ASTC_RGBA_8x8'),
(58, 'ASTC_RGBA_10x10'),
(59, 'ASTC_RGBA_12x12'),
(60, 'ETC_RGB4_3DS'),
(61, 'ETC_RGBA8_3DS'),
(62, 'RG16'),
(63, 'R8'),
(64, 'ETC_RGB4Crunched'),
(65, 'ETC2_RGBA8Crunched');