diff options
author | Charles Krinke | 2008-06-11 13:57:32 +0000 |
---|---|---|
committer | Charles Krinke | 2008-06-11 13:57:32 +0000 |
commit | aba396cb329a359a0ff9d5e6596912079bfb3584 (patch) | |
tree | 8e8c98a60a73a896b5d43fbe2c9fd132ed32369b /OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql | |
parent | * Drop periodic stats logging back down to 60 minutes to reduce console spam. (diff) | |
download | opensim-SC_OLD-aba396cb329a359a0ff9d5e6596912079bfb3584.zip opensim-SC_OLD-aba396cb329a359a0ff9d5e6596912079bfb3584.tar.gz opensim-SC_OLD-aba396cb329a359a0ff9d5e6596912079bfb3584.tar.bz2 opensim-SC_OLD-aba396cb329a359a0ff9d5e6596912079bfb3584.tar.xz |
Mantis#1528. Thank you kindly, Boscata for:
MSSQL Avatar appearance solved.
Appearance functions and modified table.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql | 59 |
1 files changed, 31 insertions, 28 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql b/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql index f396005..1639f56 100644 --- a/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql +++ b/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql | |||
@@ -7,37 +7,40 @@ SET QUOTED_IDENTIFIER ON | |||
7 | SET ANSI_PADDING ON | 7 | SET ANSI_PADDING ON |
8 | 8 | ||
9 | CREATE TABLE [avatarappearance] ( | 9 | CREATE TABLE [avatarappearance] ( |
10 | [UUID] uniqueidentifier NOT NULL, | 10 | [Owner] [varchar](36) NOT NULL, |
11 | [Serial] int NOT NULL, | 11 | [Serial] int NOT NULL, |
12 | [WearableItem0] uniqueidentifier NOT NULL, | 12 | [Visual_Params] [image] NOT NULL, |
13 | [WearableAsset0] uniqueidentifier NOT NULL, | 13 | [Texture] [image] NOT NULL, |
14 | [WearableItem1] uniqueidentifier NOT NULL, | 14 | [Avatar_Height] float NOT NULL, |
15 | [WearableAsset1] uniqueidentifier NOT NULL, | 15 | [Body_Item] [varchar](36) NOT NULL, |
16 | [WearableItem2] uniqueidentifier NOT NULL, | 16 | [Body_Asset] [varchar](36) NOT NULL, |
17 | [WearableAsset2] uniqueidentifier NOT NULL, | 17 | [Skin_Item] [varchar](36) NOT NULL, |
18 | [WearableItem3] uniqueidentifier NOT NULL, | 18 | [Skin_Asset] [varchar](36) NOT NULL, |
19 | [WearableAsset3] uniqueidentifier NOT NULL, | 19 | [Hair_Item] [varchar](36) NOT NULL, |
20 | [WearableItem4] uniqueidentifier NOT NULL, | 20 | [Hair_Asset] [varchar](36) NOT NULL, |
21 | [WearableAsset4] uniqueidentifier NOT NULL, | 21 | [Eyes_Item] [varchar](36) NOT NULL, |
22 | [WearableItem5] uniqueidentifier NOT NULL, | 22 | [Eyes_Asset] [varchar](36) NOT NULL, |
23 | [WearableAsset5] uniqueidentifier NOT NULL, | 23 | [Shirt_Item] [varchar](36) NOT NULL, |
24 | [WearableItem6] uniqueidentifier NOT NULL, | 24 | [Shirt_Asset] [varchar](36) NOT NULL, |
25 | [WearableAsset6] uniqueidentifier NOT NULL, | 25 | [Pants_Item] [varchar](36) NOT NULL, |
26 | [WearableItem7] uniqueidentifier NOT NULL, | 26 | [Pants_Asset] [varchar](36) NOT NULL, |
27 | [WearableAsset7] uniqueidentifier NOT NULL, | 27 | [Shoes_Item] [varchar](36) NOT NULL, |
28 | [WearableItem8] uniqueidentifier NOT NULL, | 28 | [Shoes_Asset] [varchar](36) NOT NULL, |
29 | [WearableAsset8] uniqueidentifier NOT NULL, | 29 | [Socks_Item] [varchar](36) NOT NULL, |
30 | [WearableItem9] uniqueidentifier NOT NULL, | 30 | [Socks_Asset] [varchar](36) NOT NULL, |
31 | [WearableAsset9] uniqueidentifier NOT NULL, | 31 | [Jacket_Item] [varchar](36) NOT NULL, |
32 | [WearableItem10] uniqueidentifier NOT NULL, | 32 | [Jacket_Asset] [varchar](36) NOT NULL, |
33 | [WearableAsset10] uniqueidentifier NOT NULL, | 33 | [Gloves_Item] [varchar](36) NOT NULL, |
34 | [WearableItem11] uniqueidentifier NOT NULL, | 34 | [Gloves_Asset] [varchar](36) NOT NULL, |
35 | [WearableAsset11] uniqueidentifier NOT NULL, | 35 | [Undershirt_Item] [varchar](36) NOT NULL, |
36 | [WearableItem12] uniqueidentifier NOT NULL, | 36 | [Undershirt_Asset] [varchar](36) NOT NULL, |
37 | [WearableAsset12] uniqueidentifier 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, | ||
38 | 41 | ||
39 | PRIMARY KEY CLUSTERED ( | 42 | PRIMARY KEY CLUSTERED ( |
40 | [UUID] | 43 | [Owner] |
41 | ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | 44 | ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
42 | ) ON [PRIMARY] | 45 | ) ON [PRIMARY] |
43 | 46 | ||