From bdee86563cfce5211f182b78e64503a05fc7ffa1 Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Thu, 4 Dec 2008 20:48:08 +0000
Subject: * Check in another patch from
 http://opensimulator.org/mantis/view.php?id=2710 * This allows removal of the
 old NHiberate.Mapping.Attributes.dll * Also add in the files I forgot about
 last time.  Doh!

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

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

diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql
new file mode 100644
index 0000000..8d1ba5c
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql
@@ -0,0 +1,79 @@
+BEGIN TRANSACTION;
+
+create table UserAgents (
+  ProfileID TEXT not null,
+   AgentIP TEXT,
+   AgentPort INTEGER,
+   AgentOnline INTEGER,
+   SessionID TEXT,
+   SecureSessionID TEXT,
+   InitialRegion TEXT,
+   Region TEXT,
+   LoginTime INTEGER,
+   LogoutTime INTEGER,
+   Handle INTEGER,
+   primary key (ProfileID)
+);
+create table UserProfiles (
+  ID TEXT not null,
+   FirstName TEXT,
+   SurName TEXT,
+   PasswordHash TEXT,
+   PasswordSalt TEXT,
+   WebLoginKey TEXT,
+   HomeRegionX INTEGER,
+   HomeRegionY INTEGER,
+   HomeLocationX NUMERIC,
+   HomeLocationY NUMERIC,
+   HomeLocationZ NUMERIC,
+   HomeLookAtX NUMERIC,
+   HomeLookAtY NUMERIC,
+   HomeLookAtZ NUMERIC,
+   Created INTEGER,
+   LastLogin INTEGER,
+   RootInventoryFolderID TEXT,
+   UserInventoryURI TEXT,
+   UserAssetURI TEXT,
+   Image TEXT,
+   FirstLifeImage TEXT,
+   AboutText TEXT,
+   FirstLifeAboutText TEXT,
+   primary key (ID)
+);
+create table UserAppearances (
+  Owner TEXT not null,
+   BodyItem TEXT,
+   BodyAsset TEXT,
+   SkinItem TEXT,
+   SkinAsset TEXT,
+   HairItem TEXT,
+   HairAsset TEXT,
+   EyesItem TEXT,
+   EyesAsset TEXT,
+   ShirtItem TEXT,
+   ShirtAsset TEXT,
+   PantsItem TEXT,
+   PantsAsset TEXT,
+   ShoesItem TEXT,
+   ShoesAsset TEXT,
+   SocksItem TEXT,
+   SocksAsset TEXT,
+   JacketItem TEXT,
+   JacketAsset TEXT,
+   GlovesItem TEXT,
+   GlovesAsset TEXT,
+   UnderShirtItem TEXT,
+   UnderShirtAsset TEXT,
+   UnderPantsItem TEXT,
+   UnderPantsAsset TEXT,
+   SkirtItem TEXT,
+   SkirtAsset TEXT,
+   Texture BLOB,
+   VisualParams BLOB,
+   Serial INTEGER,
+   primary key (Owner)
+);
+create index user_firstname on UserProfiles (FirstName);
+create index user_surname on UserProfiles (SurName);
+
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1

