aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql
diff options
context:
space:
mode:
authorCharles Krinke2008-06-11 13:57:32 +0000
committerCharles Krinke2008-06-11 13:57:32 +0000
commitaba396cb329a359a0ff9d5e6596912079bfb3584 (patch)
tree8e8c98a60a73a896b5d43fbe2c9fd132ed32369b /OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql
parent* Drop periodic stats logging back down to 60 minutes to reduce console spam. (diff)
downloadopensim-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 'OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql')
-rw-r--r--OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql59
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
7SET ANSI_PADDING ON 7SET ANSI_PADDING ON
8 8
9CREATE TABLE [avatarappearance] ( 9CREATE 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