aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
-rw-r--r--OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql63
1 files changed, 33 insertions, 30 deletions
diff --git a/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql b/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql
index 0deb099..475c933 100644
--- a/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql
+++ b/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql
@@ -4,36 +4,39 @@
4 4
5DROP TABLE IF EXISTS `avatarappearance`; 5DROP TABLE IF EXISTS `avatarappearance`;
6CREATE TABLE `avatarappearance` ( 6CREATE TABLE `avatarappearance` (
7 `UUID` char(36) NOT NULL, 7 Owner char(36) NOT NULL,
8 `Serial` int(10) unsigned NOT NULL, 8 Serial int(10) unsigned NOT NULL,
9 `WearableItem0` char(36) NOT NULL, 9 Visual_Params blob NOT NULL,
10 `WearableAsset0` char(36) NOT NULL, 10 Texture blob NOT NULL,
11 `WearableItem1` char(36) NOT NULL, 11 Avatar_Height float NOT NULL,
12 `WearableAsset1` char(36) NOT NULL, 12 Body_Item char(36) NOT NULL,
13 `WearableItem2` char(36) NOT NULL, 13 Body_Asset char(36) NOT NULL,
14 `WearableAsset2` char(36) NOT NULL, 14 Skin_Item char(36) NOT NULL,
15 `WearableItem3` char(36) NOT NULL, 15 Skin_Asset char(36) NOT NULL,
16 `WearableAsset3` char(36) NOT NULL, 16 Hair_Item char(36) NOT NULL,
17 `WearableItem4` char(36) NOT NULL, 17 Hair_Asset char(36) NOT NULL,
18 `WearableAsset4` char(36) NOT NULL, 18 Eyes_Item char(36) NOT NULL,
19 `WearableItem5` char(36) NOT NULL, 19 Eyes_Asset char(36) NOT NULL,
20 `WearableAsset5` char(36) NOT NULL, 20 Shirt_Item char(36) NOT NULL,
21 `WearableItem6` char(36) NOT NULL, 21 Shirt_Asset char(36) NOT NULL,
22 `WearableAsset6` char(36) NOT NULL, 22 Pants_Item char(36) NOT NULL,
23 `WearableItem7` char(36) NOT NULL, 23 Pants_Asset char(36) NOT NULL,
24 `WearableAsset7` char(36) NOT NULL, 24 Shoes_Item char(36) NOT NULL,
25 `WearableItem8` char(36) NOT NULL, 25 Shoes_Asset char(36) NOT NULL,
26 `WearableAsset8` char(36) NOT NULL, 26 Socks_Item char(36) NOT NULL,
27 `WearableItem9` char(36) NOT NULL, 27 Socks_Asset char(36) NOT NULL,
28 `WearableAsset9` char(36) NOT NULL, 28 Jacket_Item char(36) NOT NULL,
29 `WearableItem10` char(36) NOT NULL, 29 Jacket_Asset char(36) NOT NULL,
30 `WearableAsset10` char(36) NOT NULL, 30 Gloves_Item char(36) NOT NULL,
31 `WearableItem11` char(36) NOT NULL, 31 Gloves_Asset char(36) NOT NULL,
32 `WearableAsset11` char(36) NOT NULL, 32 Undershirt_Item char(36) NOT NULL,
33 `WearableItem12` char(36) NOT NULL, 33 Undershirt_Asset char(36) NOT NULL,
34 `WearableAsset12` char(36) NOT NULL, 34 Underpants_Item char(36) NOT NULL,
35 Underpants_Asset char(36) NOT NULL,
36 Skirt_Item char(36) NOT NULL,
37 Skirt_Asset char(36) NOT NULL,
35 38
36 39
37 PRIMARY KEY (`UUID`) 40 PRIMARY KEY (`Owner`)
38) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.1'; 41) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.2';
39 42