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 @@
 DROP TABLE IF EXISTS `avatarappearance`;
 CREATE TABLE `avatarappearance` (
-  `UUID` char(36) NOT NULL,
+  Owner char(36) NOT NULL,
-  `Serial` int(10) unsigned NOT NULL,
+  Serial int(10) unsigned NOT NULL,
-  `WearableItem0` char(36) NOT NULL,
+  Visual_Params blob NOT NULL,
-  `WearableAsset0` char(36) NOT NULL,
+  Texture blob NOT NULL,
-  `WearableItem1` char(36) NOT NULL,
+  Avatar_Height float NOT NULL,
-  `WearableAsset1` char(36) NOT NULL,
+  Body_Item char(36) NOT NULL,
-  `WearableItem2` char(36) NOT NULL,
+  Body_Asset char(36) NOT NULL,
-  `WearableAsset2` char(36) NOT NULL,
+  Skin_Item char(36) NOT NULL,
-  `WearableItem3` char(36) NOT NULL,
+  Skin_Asset char(36) NOT NULL,
-  `WearableAsset3` char(36) NOT NULL,
+  Hair_Item char(36) NOT NULL,
-  `WearableItem4` char(36) NOT NULL,
+  Hair_Asset char(36) NOT NULL,
-  `WearableAsset4` char(36) NOT NULL,
+  Eyes_Item char(36) NOT NULL,
-  `WearableItem5` char(36) NOT NULL,
+  Eyes_Asset char(36) NOT NULL,
-  `WearableAsset5` char(36) NOT NULL,
+  Shirt_Item char(36) NOT NULL,
-  `WearableItem6` char(36) NOT NULL,
+  Shirt_Asset char(36) NOT NULL,
-  `WearableAsset6` char(36) NOT NULL,
+  Pants_Item char(36) NOT NULL,
-  `WearableItem7` char(36) NOT NULL,
+  Pants_Asset char(36) NOT NULL,
-  `WearableAsset7` char(36) NOT NULL,
+  Shoes_Item char(36) NOT NULL,
-  `WearableItem8` char(36) NOT NULL,
+  Shoes_Asset char(36) NOT NULL,
-  `WearableAsset8` char(36) NOT NULL,
+  Socks_Item char(36) NOT NULL,
-  `WearableItem9` char(36) NOT NULL,
+  Socks_Asset char(36) NOT NULL,
-  `WearableAsset9` char(36) NOT NULL,
+  Jacket_Item char(36) NOT NULL,
-  `WearableItem10` char(36) NOT NULL,
+  Jacket_Asset char(36) NOT NULL,
-  `WearableAsset10` char(36) NOT NULL,
+  Gloves_Item char(36) NOT NULL,
-  `WearableItem11` char(36) NOT NULL,
+  Gloves_Asset char(36) NOT NULL,
-  `WearableAsset11` char(36) NOT NULL,
+  Undershirt_Item char(36) NOT NULL,
-  `WearableItem12` char(36) NOT NULL,
+  Undershirt_Asset char(36) NOT NULL,
-  `WearableAsset12` char(36) NOT NULL,
+  Underpants_Item char(36) NOT NULL,
+  Underpants_Asset char(36) NOT NULL,
+  Skirt_Item char(36) NOT NULL,
+  Skirt_Asset char(36) NOT NULL,
-  PRIMARY KEY  (`UUID`)
+  PRIMARY KEY  (`Owner`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.1';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.2';

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
5	DROP TABLE IF EXISTS `avatarappearance`;	5	DROP TABLE IF EXISTS `avatarappearance`;
6	CREATE TABLE `avatarappearance` (	6	CREATE 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