From af0fcb96a43137bfd1de0c8cca190522a549e492 Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Mon, 12 Jan 2009 17:51:43 +0000
Subject: * Apply http://opensimulator.org/mantis/view.php?id=2965 * Adds first
 version of MsSql2005Dialect support for NHibernate * Thanks mpallari

---
 .../Resources/MsSql2005Dialect/001_UserStore.sql   | 77 ++++++++++++++++++++++
 1 file changed, 77 insertions(+)
 create mode 100644 OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql

(limited to 'OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql')

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 @@
+create table UserAgents (
+  ProfileID NVARCHAR(255) not null,
+   AgentIP NVARCHAR(24) null,
+   AgentPort INT null,
+   AgentOnline BIT null,
+   SessionID NVARCHAR(255) null,
+   SecureSessionID NVARCHAR(255) null,
+   InitialRegion NVARCHAR(255) null,
+   Region NVARCHAR(255) null,
+   LoginTime INT null,
+   LogoutTime INT null,
+   Handle BIGINT null,
+   primary key (ProfileID)
+)
+
+create table UserProfiles (
+  ID NVARCHAR(255) not null,
+   FirstName NVARCHAR(32) null,
+   SurName NVARCHAR(32) null,
+   PasswordHash NVARCHAR(32) null,
+   PasswordSalt NVARCHAR(32) null,
+   WebLoginKey NVARCHAR(255) null,
+   HomeRegionX INT null,
+   HomeRegionY INT null,
+   HomeLocationX REAL null,
+   HomeLocationY REAL null,
+   HomeLocationZ REAL null,
+   HomeLookAtX REAL null,
+   HomeLookAtY REAL null,
+   HomeLookAtZ REAL null,
+   Created INT null,
+   LastLogin INT null,
+   RootInventoryFolderID NVARCHAR(255) null,
+   UserInventoryURI NVARCHAR(255) null,
+   UserAssetURI NVARCHAR(255) null,
+   Image NVARCHAR(255) null,
+   FirstLifeImage NVARCHAR(255) null,
+   AboutText NVARCHAR(255) null,
+   FirstLifeAboutText NVARCHAR(255) null,
+   primary key (ID)
+)
+create table UserAppearances (
+  Owner NVARCHAR(255) not null,
+   BodyItem NVARCHAR(255) null,
+   BodyAsset NVARCHAR(255) null,
+   SkinItem NVARCHAR(255) null,
+   SkinAsset NVARCHAR(255) null,
+   HairItem NVARCHAR(255) null,
+   HairAsset NVARCHAR(255) null,
+   EyesItem NVARCHAR(255) null,
+   EyesAsset NVARCHAR(255) null,
+   ShirtItem NVARCHAR(255) null,
+   ShirtAsset NVARCHAR(255) null,
+   PantsItem NVARCHAR(255) null,
+   PantsAsset NVARCHAR(255) null,
+   ShoesItem NVARCHAR(255) null,
+   ShoesAsset NVARCHAR(255) null,
+   SocksItem NVARCHAR(255) null,
+   SocksAsset NVARCHAR(255) null,
+   JacketItem NVARCHAR(255) null,
+   JacketAsset NVARCHAR(255) null,
+   GlovesItem NVARCHAR(255) null,
+   GlovesAsset NVARCHAR(255) null,
+   UnderShirtItem NVARCHAR(255) null,
+   UnderShirtAsset NVARCHAR(255) null,
+   UnderPantsItem NVARCHAR(255) null,
+   UnderPantsAsset NVARCHAR(255) null,
+   SkirtItem NVARCHAR(255) null,
+   SkirtAsset NVARCHAR(255) null,
+   Texture VARBINARY(8000) null,
+   VisualParams VARBINARY(8000) null,
+   Serial INT null,
+   primary key (Owner)
+)
+
+create index user_surname on UserProfiles (SurName)
+create index user_firstname on UserProfiles (FirstName)
-- 
cgit v1.1

