diff options
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 | ||