diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql | 77 |
1 files changed, 0 insertions, 77 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql deleted file mode 100644 index c9c6c89..0000000 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql +++ /dev/null | |||
@@ -1,77 +0,0 @@ | |||
1 | create table UserAgents ( | ||
2 | ProfileID NVARCHAR(255) not null, | ||
3 | AgentIP NVARCHAR(24) null, | ||
4 | AgentPort INT null, | ||
5 | AgentOnline BIT null, | ||
6 | SessionID NVARCHAR(255) null, | ||
7 | SecureSessionID NVARCHAR(255) null, | ||
8 | InitialRegion NVARCHAR(255) null, | ||
9 | Region NVARCHAR(255) null, | ||
10 | LoginTime INT null, | ||
11 | LogoutTime INT null, | ||
12 | Handle BIGINT null, | ||
13 | primary key (ProfileID) | ||
14 | ) | ||
15 | |||
16 | create table UserProfiles ( | ||
17 | ID NVARCHAR(255) not null, | ||
18 | FirstName NVARCHAR(32) null, | ||
19 | SurName NVARCHAR(32) null, | ||
20 | PasswordHash NVARCHAR(32) null, | ||
21 | PasswordSalt NVARCHAR(32) null, | ||
22 | WebLoginKey NVARCHAR(255) null, | ||
23 | HomeRegionX INT null, | ||
24 | HomeRegionY INT null, | ||
25 | HomeLocationX REAL null, | ||
26 | HomeLocationY REAL null, | ||
27 | HomeLocationZ REAL null, | ||
28 | HomeLookAtX REAL null, | ||
29 | HomeLookAtY REAL null, | ||
30 | HomeLookAtZ REAL null, | ||
31 | Created INT null, | ||
32 | LastLogin INT null, | ||
33 | RootInventoryFolderID NVARCHAR(255) null, | ||
34 | UserInventoryURI NVARCHAR(255) null, | ||
35 | UserAssetURI NVARCHAR(255) null, | ||
36 | Image NVARCHAR(255) null, | ||
37 | FirstLifeImage NVARCHAR(255) null, | ||
38 | AboutText NVARCHAR(255) null, | ||
39 | FirstLifeAboutText NVARCHAR(255) null, | ||
40 | primary key (ID) | ||
41 | ) | ||
42 | create table UserAppearances ( | ||
43 | Owner NVARCHAR(255) not null, | ||
44 | BodyItem NVARCHAR(255) null, | ||
45 | BodyAsset NVARCHAR(255) null, | ||
46 | SkinItem NVARCHAR(255) null, | ||
47 | SkinAsset NVARCHAR(255) null, | ||
48 | HairItem NVARCHAR(255) null, | ||
49 | HairAsset NVARCHAR(255) null, | ||
50 | EyesItem NVARCHAR(255) null, | ||
51 | EyesAsset NVARCHAR(255) null, | ||
52 | ShirtItem NVARCHAR(255) null, | ||
53 | ShirtAsset NVARCHAR(255) null, | ||
54 | PantsItem NVARCHAR(255) null, | ||
55 | PantsAsset NVARCHAR(255) null, | ||
56 | ShoesItem NVARCHAR(255) null, | ||
57 | ShoesAsset NVARCHAR(255) null, | ||
58 | SocksItem NVARCHAR(255) null, | ||
59 | SocksAsset NVARCHAR(255) null, | ||
60 | JacketItem NVARCHAR(255) null, | ||
61 | JacketAsset NVARCHAR(255) null, | ||
62 | GlovesItem NVARCHAR(255) null, | ||
63 | GlovesAsset NVARCHAR(255) null, | ||
64 | UnderShirtItem NVARCHAR(255) null, | ||
65 | UnderShirtAsset NVARCHAR(255) null, | ||
66 | UnderPantsItem NVARCHAR(255) null, | ||
67 | UnderPantsAsset NVARCHAR(255) null, | ||
68 | SkirtItem NVARCHAR(255) null, | ||
69 | SkirtAsset NVARCHAR(255) null, | ||
70 | Texture VARBINARY(8000) null, | ||
71 | VisualParams VARBINARY(8000) null, | ||
72 | Serial INT null, | ||
73 | primary key (Owner) | ||
74 | ) | ||
75 | |||
76 | create index user_surname on UserProfiles (SurName) | ||
77 | create index user_firstname on UserProfiles (FirstName) | ||