diff options
author | Homer Horwitz | 2008-11-15 21:27:10 +0000 |
---|---|---|
committer | Homer Horwitz | 2008-11-15 21:27:10 +0000 |
commit | 9a6cdf662b60e7d6f6843826da6a84637d4798b9 (patch) | |
tree | 0ac44924346d5c94b355844ccee83612a3c96ad2 /OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql | |
parent | - Change llSetRot behavior so it matches the SL behavior (in particular, the (diff) | |
download | opensim-SC_OLD-9a6cdf662b60e7d6f6843826da6a84637d4798b9.zip opensim-SC_OLD-9a6cdf662b60e7d6f6843826da6a84637d4798b9.tar.gz opensim-SC_OLD-9a6cdf662b60e7d6f6843826da6a84637d4798b9.tar.bz2 opensim-SC_OLD-9a6cdf662b60e7d6f6843826da6a84637d4798b9.tar.xz |
Mantis#2626: Thank you Ruud Lathrop, for a patch that cleans up MSSQL code.
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql | 47 |
1 files changed, 0 insertions, 47 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql b/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql index 1639f56..e69de29 100644 --- a/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql +++ b/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql | |||
@@ -1,47 +0,0 @@ | |||
1 | -- | ||
2 | -- Create schema avatar_appearance | ||
3 | -- | ||
4 | |||
5 | SET ANSI_NULLS ON | ||
6 | SET QUOTED_IDENTIFIER ON | ||
7 | SET ANSI_PADDING ON | ||
8 | |||
9 | CREATE TABLE [avatarappearance] ( | ||
10 | [Owner] [varchar](36) NOT NULL, | ||
11 | [Serial] int NOT NULL, | ||
12 | [Visual_Params] [image] NOT NULL, | ||
13 | [Texture] [image] NOT NULL, | ||
14 | [Avatar_Height] float NOT NULL, | ||
15 | [Body_Item] [varchar](36) NOT NULL, | ||
16 | [Body_Asset] [varchar](36) NOT NULL, | ||
17 | [Skin_Item] [varchar](36) NOT NULL, | ||
18 | [Skin_Asset] [varchar](36) NOT NULL, | ||
19 | [Hair_Item] [varchar](36) NOT NULL, | ||
20 | [Hair_Asset] [varchar](36) NOT NULL, | ||
21 | [Eyes_Item] [varchar](36) NOT NULL, | ||
22 | [Eyes_Asset] [varchar](36) NOT NULL, | ||
23 | [Shirt_Item] [varchar](36) NOT NULL, | ||
24 | [Shirt_Asset] [varchar](36) NOT NULL, | ||
25 | [Pants_Item] [varchar](36) NOT NULL, | ||
26 | [Pants_Asset] [varchar](36) NOT NULL, | ||
27 | [Shoes_Item] [varchar](36) NOT NULL, | ||
28 | [Shoes_Asset] [varchar](36) NOT NULL, | ||
29 | [Socks_Item] [varchar](36) NOT NULL, | ||
30 | [Socks_Asset] [varchar](36) NOT NULL, | ||
31 | [Jacket_Item] [varchar](36) NOT NULL, | ||
32 | [Jacket_Asset] [varchar](36) NOT NULL, | ||
33 | [Gloves_Item] [varchar](36) NOT NULL, | ||
34 | [Gloves_Asset] [varchar](36) NOT NULL, | ||
35 | [Undershirt_Item] [varchar](36) NOT NULL, | ||
36 | [Undershirt_Asset] [varchar](36) NOT NULL, | ||
37 | [Underpants_Item] [varchar](36) NOT NULL, | ||
38 | [Underpants_Asset] [varchar](36) NOT NULL, | ||
39 | [Skirt_Item] [varchar](36) NOT NULL, | ||
40 | [Skirt_Asset] [varchar](36) NOT NULL, | ||
41 | |||
42 | PRIMARY KEY CLUSTERED ( | ||
43 | [Owner] | ||
44 | ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | ||
45 | ) ON [PRIMARY] | ||
46 | |||
47 | SET ANSI_PADDING OFF | ||