aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql')
-rw-r--r--OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql47
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
5SET ANSI_NULLS ON
6SET QUOTED_IDENTIFIER ON
7SET ANSI_PADDING ON
8
9CREATE 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
47SET ANSI_PADDING OFF