aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql
diff options
context:
space:
mode:
authorSean Dague2009-02-17 19:06:23 +0000
committerSean Dague2009-02-17 19:06:23 +0000
commitc417a5b619eb85706a1782c5b0943cb8b28bd7a1 (patch)
treef14981b650694cfc4271f84368a27f63979ff35e /OpenSim/Data/MySQL/Resources/CreateAvatarAppearance.sql
parent* Allow inventory archives to be saved from the 'root' inventory directory (diff)
downloadopensim-SC_OLD-c417a5b619eb85706a1782c5b0943cb8b28bd7a1.zip
opensim-SC_OLD-c417a5b619eb85706a1782c5b0943cb8b28bd7a1.tar.gz
opensim-SC_OLD-c417a5b619eb85706a1782c5b0943cb8b28bd7a1.tar.bz2
opensim-SC_OLD-c417a5b619eb85706a1782c5b0943cb8b28bd7a1.tar.xz
remove all the very old create and upgrade sql files, these were
outdated by migrations 6 months ago.
Diffstat (limited to '')
-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