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 | |
| parent | * Drop periodic stats logging back down to 60 minutes to reduce console spam. (diff) | |
| download | opensim-SC-aba396cb329a359a0ff9d5e6596912079bfb3584.zip opensim-SC-aba396cb329a359a0ff9d5e6596912079bfb3584.tar.gz opensim-SC-aba396cb329a359a0ff9d5e6596912079bfb3584.tar.bz2 opensim-SC-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')
| -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 | ||