aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql')
-rw-r--r--OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql42
1 files changed, 0 insertions, 42 deletions
diff --git a/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql b/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql
deleted file mode 100644
index 475c933..0000000
--- a/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql
+++ /dev/null
@@ -1,42 +0,0 @@
1--
2-- Create schema avatar_appearance
3--
4
5DROP TABLE IF EXISTS `avatarappearance`;
6CREATE TABLE `avatarappearance` (
7 Owner char(36) NOT NULL,
8 Serial int(10) unsigned NOT NULL,
9 Visual_Params blob NOT NULL,
10 Texture blob NOT NULL,
11 Avatar_Height float NOT NULL,
12 Body_Item char(36) NOT NULL,
13 Body_Asset char(36) NOT NULL,
14 Skin_Item char(36) NOT NULL,
15 Skin_Asset char(36) NOT NULL,
16 Hair_Item char(36) NOT NULL,
17 Hair_Asset char(36) NOT NULL,
18 Eyes_Item char(36) NOT NULL,
19 Eyes_Asset char(36) NOT NULL,
20 Shirt_Item char(36) NOT NULL,
21 Shirt_Asset char(36) NOT NULL,
22 Pants_Item char(36) NOT NULL,
23 Pants_Asset char(36) NOT NULL,
24 Shoes_Item char(36) NOT NULL,
25 Shoes_Asset char(36) NOT NULL,
26 Socks_Item char(36) NOT NULL,
27 Socks_Asset char(36) NOT NULL,
28 Jacket_Item char(36) NOT NULL,
29 Jacket_Asset char(36) NOT NULL,
30 Gloves_Item char(36) NOT NULL,
31 Gloves_Asset char(36) NOT NULL,
32 Undershirt_Item char(36) NOT NULL,
33 Undershirt_Asset 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,
38
39
40 PRIMARY KEY (`Owner`)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.2';
42