diff options
author | Justin Clarke Casey | 2009-01-12 17:51:43 +0000 |
---|---|---|
committer | Justin Clarke Casey | 2009-01-12 17:51:43 +0000 |
commit | af0fcb96a43137bfd1de0c8cca190522a549e492 (patch) | |
tree | fa28d846c81c21b7c0c6274eeb372ff57048b6dd /OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql | |
parent | * Apply http://opensimulator.org/mantis/view.php?id=2980 (diff) | |
download | opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.zip opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.gz opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.bz2 opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.xz |
* Apply http://opensimulator.org/mantis/view.php?id=2965
* Adds first version of MsSql2005Dialect support for NHibernate
* Thanks mpallari
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, 77 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql new file mode 100644 index 0000000..c9c6c89 --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql | |||
@@ -0,0 +1,77 @@ | |||
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) | ||