From fdce1be3db287bed901332b90ba57165e201d3fc Mon Sep 17 00:00:00 2001
From: John Hurliman
Date: Mon, 19 Oct 2009 16:52:27 -0700
Subject: * Removed OpenSim.Data.NHibernate * Replaced calls to
ThreadPool.QueueUserWorkItem() with ThreadPool.UnsafeQueueUserWorkItem()
since OpenSim does not use Code Access Security sandboxing
---
.../Data/NHibernate/Resources/AssetBase.hbm.xml | 14 --
.../NHibernate/Resources/EstateRegionLink.hbm.xml | 12 --
.../NHibernate/Resources/EstateSettings.hbm.xml | 68 ---------
.../Resources/InventoryFolderBase.hbm.xml | 13 --
.../NHibernate/Resources/InventoryItemBase.hbm.xml | 26 ----
.../Resources/MigrationSyntaxDifferences.txt | 14 --
.../Resources/MsSql2005Dialect/001_AssetStore.sql | 10 --
.../Resources/MsSql2005Dialect/001_EstateStore.sql | 72 ---------
.../Resources/MsSql2005Dialect/001_GridStore.sql | 35 -----
.../MsSql2005Dialect/001_InventoryStore.sql | 36 -----
.../Resources/MsSql2005Dialect/001_RegionStore.sql | 104 -------------
.../Resources/MsSql2005Dialect/001_UserStore.sql | 77 ----------
.../Resources/MsSql2005Dialect/002_RegionStore.sql | 51 -------
.../Resources/MsSql2005Dialect/002_UserStore.sql | 27 ----
.../Resources/MySQLDialect/001_AssetStore.sql | 10 --
.../Resources/MySQLDialect/001_EstateStore.sql | 71 ---------
.../Resources/MySQLDialect/001_GridStore.sql | 35 -----
.../Resources/MySQLDialect/001_InventoryStore.sql | 39 -----
.../Resources/MySQLDialect/001_RegionStore.sql | 169 ---------------------
.../Resources/MySQLDialect/001_UserStore.sql | 104 -------------
.../Resources/OpenSim.Data.NHibernate.addin.xml | 23 ---
.../Resources/PostgreSQLDialect/001_AssetStore.sql | 10 --
.../PostgreSQLDialect/001_EstateStore.sql | 72 ---------
.../Resources/PostgreSQLDialect/001_GridStore.sql | 35 -----
.../PostgreSQLDialect/001_InventoryStore.sql | 39 -----
.../PostgreSQLDialect/001_RegionStore.sql | 169 ---------------------
.../Resources/PostgreSQLDialect/001_UserStore.sql | 104 -------------
.../NHibernate/Resources/RegionProfileData.hbm.xml | 44 ------
.../NHibernate/Resources/RegionSettings.hbm.xml | 56 -------
.../Data/NHibernate/Resources/RegionStore.hbm.xml | 147 ------------------
.../Resources/SQLiteDialect/001_AssetStore.sql | 10 --
.../Resources/SQLiteDialect/001_EstateStore.sql | 71 ---------
.../Resources/SQLiteDialect/001_GridStore.sql | 35 -----
.../Resources/SQLiteDialect/001_InventoryStore.sql | 39 -----
.../Resources/SQLiteDialect/001_RegionStore.sql | 168 --------------------
.../Resources/SQLiteDialect/001_UserStore.sql | 104 -------------
.../NHibernate/Resources/UserAgentData.hbm.xml | 32 ----
.../NHibernate/Resources/UserAppearance.hbm.xml | 38 -----
.../Data/NHibernate/Resources/UserFriend.hbm.xml | 11 --
.../NHibernate/Resources/UserProfileData.hbm.xml | 38 -----
40 files changed, 2232 deletions(-)
delete mode 100644 OpenSim/Data/NHibernate/Resources/AssetBase.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/EstateRegionLink.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/EstateSettings.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/InventoryFolderBase.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/InventoryItemBase.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/MigrationSyntaxDifferences.txt
delete mode 100644 OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_AssetStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_UserStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_RegionStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_UserStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/OpenSim.Data.NHibernate.addin.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/RegionProfileData.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/RegionSettings.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql
delete mode 100644 OpenSim/Data/NHibernate/Resources/UserAgentData.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/UserAppearance.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/UserFriend.hbm.xml
delete mode 100644 OpenSim/Data/NHibernate/Resources/UserProfileData.hbm.xml
(limited to 'OpenSim/Data/NHibernate/Resources')
diff --git a/OpenSim/Data/NHibernate/Resources/AssetBase.hbm.xml b/OpenSim/Data/NHibernate/Resources/AssetBase.hbm.xml
deleted file mode 100644
index cb8b36d..0000000
--- a/OpenSim/Data/NHibernate/Resources/AssetBase.hbm.xml
+++ /dev/null
@@ -1,14 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/EstateRegionLink.hbm.xml b/OpenSim/Data/NHibernate/Resources/EstateRegionLink.hbm.xml
deleted file mode 100644
index fd66910..0000000
--- a/OpenSim/Data/NHibernate/Resources/EstateRegionLink.hbm.xml
+++ /dev/null
@@ -1,12 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/EstateSettings.hbm.xml b/OpenSim/Data/NHibernate/Resources/EstateSettings.hbm.xml
deleted file mode 100644
index d300b93..0000000
--- a/OpenSim/Data/NHibernate/Resources/EstateSettings.hbm.xml
+++ /dev/null
@@ -1,68 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/InventoryFolderBase.hbm.xml b/OpenSim/Data/NHibernate/Resources/InventoryFolderBase.hbm.xml
deleted file mode 100644
index c5f0115..0000000
--- a/OpenSim/Data/NHibernate/Resources/InventoryFolderBase.hbm.xml
+++ /dev/null
@@ -1,13 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/InventoryItemBase.hbm.xml b/OpenSim/Data/NHibernate/Resources/InventoryItemBase.hbm.xml
deleted file mode 100644
index ea6032a..0000000
--- a/OpenSim/Data/NHibernate/Resources/InventoryItemBase.hbm.xml
+++ /dev/null
@@ -1,26 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/MigrationSyntaxDifferences.txt b/OpenSim/Data/NHibernate/Resources/MigrationSyntaxDifferences.txt
deleted file mode 100644
index 1c89516..0000000
--- a/OpenSim/Data/NHibernate/Resources/MigrationSyntaxDifferences.txt
+++ /dev/null
@@ -1,14 +0,0 @@
-?This file describes the differences in schema creation and migration scripts.
-
-MySQL is used as reference script against which differences are listed.
-
-Generally MySQL create table options should be removed for other databases.
-
-_PostgreSQL_
-* DOUBLE->DOUBLE PRECISION
-* BIT->BOOLEAN
-
-_MsSql_
-* VARCHAR->NVARCHAR
-* Remove DEFAULT-keywords
-* DOUBLE->REAL
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_AssetStore.sql
deleted file mode 100644
index deee78b..0000000
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_AssetStore.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-create table Assets (
- ID NVARCHAR(36) not null,
- Type SMALLINT null,
- Name NVARCHAR(64) null,
- Description NVARCHAR(64) null,
- Local BIT null,
- Temporary BIT null,
- Data VARBINARY(max) null,
- primary key (ID)
-)
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
deleted file mode 100644
index dd579f9..0000000
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
+++ /dev/null
@@ -1,72 +0,0 @@
-CREATE TABLE EstateSettings (
- EstateID INT NOT NULL,
- ParentEstateID INT NULL,
- EstateOwnerID NVARCHAR(36) NULL,
- Name NVARCHAR(64) NULL,
- RedirectGridX INT NULL,
- RedirectGridY INT NULL,
- BillableFactor REAL NULL,
- PricePerMeter INT NULL,
- SunPosition FLOAT NULL,
-
- UseGlobalTime BIT NULL,
- FixedSun BIT NULL,
- AllowVoice BIT NULL,
- AllowDirectTeleport BIT NULL,
- ResetHomeOnTeleport BIT NULL,
- PublicAccess BIT NULL,
- DenyAnonymous BIT NULL,
- DenyIdentified BIT NULL,
- DenyTransacted BIT NULL,
- DenyMinors BIT NULL,
- BlockDwell BIT NULL,
- EstateSkipScripts BIT NULL,
- TaxFree BIT NULL,
- AbuseEmailToEstateOwner BIT NULL,
-
- AbuseEmail NVARCHAR(255) NULL,
-
- PRIMARY KEY (EstateID)
-);
-
-CREATE TABLE EstateRegionLink (
- EstateRegionLinkID NVARCHAR(36) NOT NULL,
- EstateID INT NULL,
- RegionID NVARCHAR(36) NULL,
- PRIMARY KEY (EstateRegionLinkID)
-);
-
-CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID);
-CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID);
-
-
-CREATE TABLE EstateManagers (
- EstateID INT NOT NULL,
- ManagerID NVARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
-
-CREATE TABLE EstateUsers (
- EstateID INT NOT NULL,
- UserID NVARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
-
-CREATE TABLE EstateGroups (
- EstateID INT NOT NULL,
- GroupID NVARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
-
-CREATE TABLE EstateBans (
- EstateID INT NOT NULL,
- ArrayIndex INT NOT NULL,
- BannedUserID NVARCHAR(36) NOT NULL,
- BannedHostAddress NVARCHAR(16) NOT NULL,
- BannedHostIPMask NVARCHAR(16) NOT NULL,
- BannedHostNameMask NVARCHAR(16) NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
\ No newline at end of file
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql
deleted file mode 100644
index e4ad525..0000000
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql
+++ /dev/null
@@ -1,35 +0,0 @@
-create table Regions (
- Uuid NVARCHAR(36) not null,
- RegionHandle BIGINT null,
- RegionName NVARCHAR(32) null,
- RegionRecvKey NVARCHAR(128) null,
- RegionSendKey NVARCHAR(128) null,
- RegionSecret NVARCHAR(128) null,
- RegionDataURI NVARCHAR(255) null,
- ServerIP NVARCHAR(64) null,
- ServerPort INT null,
- ServerURI NVARCHAR(255) null,
- RegionLocX INT null,
- RegionLocY INT null,
- RegionLocZ INT null,
- EastOverrideHandle BIGINT null,
- WestOverrideHandle BIGINT null,
- SouthOverrideHandle BIGINT null,
- NorthOverrideHandle BIGINT null,
- RegionAssetURI NVARCHAR(255) null,
- RegionAssetRecvKey NVARCHAR(128) null,
- RegionAssetSendKey NVARCHAR(128) null,
- RegionUserURI NVARCHAR(255) null,
- RegionUserRecvKey NVARCHAR(128) null,
- RegionUserSendKey NVARCHAR(128) null,
- ServerHttpPort INT null,
- ServerRemotingPort INT null,
- RegionMapTextureID NVARCHAR(36) null,
- Owner_uuid NVARCHAR(36) null,
- OriginUUID NVARCHAR(36) null,
- primary key (Uuid)
-)
-create index region_handle on Regions (RegionHandle)
-create index region_name on Regions (RegionName)
-create index overrideHandles on Regions (EastOverrideHandle, WestOverrideHandle, SouthOverrideHandle, NorthOverrideHandle)
-
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql
deleted file mode 100644
index 82936c4..0000000
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql
+++ /dev/null
@@ -1,36 +0,0 @@
-create table InventoryFolders (
- ID NVARCHAR(255) not null,
- Type SMALLINT null,
- Version INT null,
- ParentID NVARCHAR(255) null,
- Owner NVARCHAR(255) null,
- Name NVARCHAR(64) null,
- primary key (ID)
-)
-create table InventoryItems (
- ID NVARCHAR(255) not null,
- InvType INT null,
- AssetType INT null,
- AssetID NVARCHAR(255) null,
- Folder NVARCHAR(255) null,
- Owner NVARCHAR(255) null,
- Creator NVARCHAR(255) null,
- Name NVARCHAR(64) null,
- Description NVARCHAR(64) null,
- NextPermissions INT null,
- CurrentPermissions INT null,
- BasePermissions INT null,
- EveryOnePermissions INT null,
- GroupID NVARCHAR(255) null,
- GroupOwned BIT null,
- SalePrice INT null,
- SaleType TINYINT null,
- Flags INT null,
- CreationDate INT null,
- primary key (ID)
-)
-create index item_group_id on InventoryItems (GroupID)
-create index item_folder_id on InventoryItems (Folder)
-create index item_owner_id on InventoryItems (Owner)
-create index folder_owner_id on InventoryFolders (Owner)
-create index folder_parent_id on InventoryFolders (ParentID)
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql
deleted file mode 100644
index 181a74c..0000000
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql
+++ /dev/null
@@ -1,104 +0,0 @@
-create table Prims (
- UUID NVARCHAR(255) not null,
- ParentID INT null,
- ParentUUID NVARCHAR(255) null,
- RegionID NVARCHAR(255) null,
- CreationDate INT null,
- Name NVARCHAR(255) null,
- Text NVARCHAR(255) null,
- Description NVARCHAR(255) null,
- SitName NVARCHAR(255) null,
- TouchName NVARCHAR(255) null,
- ObjectFlags INT null,
- CreatorID NVARCHAR(255) null,
- OwnerID NVARCHAR(255) null,
- GroupID NVARCHAR(255) null,
- LastOwnerID NVARCHAR(255) null,
- OwnerMask INT null,
- NextOwnerMask INT null,
- GroupMask INT null,
- EveryoneMask INT null,
- BaseMask INT null,
- PositionX REAL null,
- PositionY REAL null,
- PositionZ REAL null,
- GroupPositionX REAL null,
- GroupPositionY REAL null,
- GroupPositionZ REAL null,
- VelocityX REAL null,
- VelocityY REAL null,
- VelocityZ REAL null,
- AngularVelocityX REAL null,
- AngularVelocityY REAL null,
- AngularVelocityZ REAL null,
- AccelerationX REAL null,
- AccelerationY REAL null,
- AccelerationZ REAL null,
- SitTargetOffsetX REAL null,
- SitTargetOffsetY REAL null,
- SitTargetOffsetZ REAL null,
- RotationX REAL null,
- RotationY REAL null,
- RotationZ REAL null,
- RotationW REAL null,
- SitTargetOrientX REAL null,
- SitTargetOrientY REAL null,
- SitTargetOrientZ REAL null,
- SitTargetOrientW REAL null,
- ScaleX REAL null,
- ScaleY REAL null,
- ScaleZ REAL null,
- PCode TINYINT null,
- PathBegin INT null,
- PathEnd INT null,
- PathScaleX TINYINT null,
- PathScaleY TINYINT null,
- PathShearX TINYINT null,
- PathShearY TINYINT null,
- PathSkew TINYINT null,
- PathCurve TINYINT null,
- PathRadiusOffset TINYINT null,
- PathRevolutions TINYINT null,
- PathTaperX TINYINT null,
- PathTaperY TINYINT null,
- PathTwist TINYINT null,
- ProfileBegin INT null,
- ProfileEnd INT null,
- ProfileCurve TINYINT null,
- ProfileHollow INT null,
- Texture VARBINARY(8000) null,
- ExtraParams VARBINARY(8000) null,
- State TINYINT null,
- primary key (UUID)
-)
-
-create table PrimItems (
- ItemID NVARCHAR(255) not null,
- PrimID NVARCHAR(255) null,
- AssetID NVARCHAR(255) null,
- ParentFolderID NVARCHAR(255) null,
- CreatorID NVARCHAR(255) null,
- OwnerID NVARCHAR(255) null,
- GroupID NVARCHAR(255) null,
- LastOwnerID NVARCHAR(255) null,
- CurrentPermissions INT null,
- BasePermissions INT null,
- EveryonePermissions INT null,
- GroupPermissions INT null,
- NextPermissions INT null,
- Name NVARCHAR(255) null,
- Description NVARCHAR(255) null,
- CreationDate INT null,
- Flags INT null,
- Type INT null,
- InvType INT null,
- primary key (ItemID)
-)
-
-create table Terrain (
- RegionID NVARCHAR(255) not null,
- MapData VARBINARY(max) null,
- primary key (RegionID)
-)
-
-
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 @@
-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)
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_RegionStore.sql
deleted file mode 100644
index dfaac6e..0000000
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_RegionStore.sql
+++ /dev/null
@@ -1,51 +0,0 @@
-ALTER TABLE Prims ADD LinkNum INT null;
-ALTER TABLE Prims ADD Material TINYINT null;
-ALTER TABLE Prims ADD ScriptAccessPin INT null;
-ALTER TABLE Prims ADD TextureAnimation VARBINARY(max) null;
-ALTER TABLE Prims ADD ParticleSystem VARBINARY(max) null;
-ALTER TABLE Prims ADD ClickAction TINYINT null;
-ALTER TABLE Prims ADD Color INT null;
-
-CREATE TABLE RegionSettings
-(
- RegionID NVARCHAR(255) NOT NULL,
- BlockTerraform bit NOT NULL,
- BlockFly bit NOT NULL,
- AllowDamage bit NOT NULL,
- RestrictPushing bit NOT NULL,
- AllowLandResell bit NOT NULL,
- AllowLandJoinDivide bit NOT NULL,
- BlockShowInSearch bit NOT NULL,
- AgentLimit int NOT NULL,
- ObjectBonus float(53) NOT NULL,
- Maturity int NOT NULL,
- DisableScripts bit NOT NULL,
- DisableCollisions bit NOT NULL,
- DisablePhysics bit NOT NULL,
- TerrainTexture1 NVARCHAR(36) NOT NULL,
- TerrainTexture2 NVARCHAR(36) NOT NULL,
- TerrainTexture3 NVARCHAR(36) NOT NULL,
- TerrainTexture4 NVARCHAR(36) NOT NULL,
- Elevation1NW float(53) NOT NULL,
- Elevation2NW float(53) NOT NULL,
- Elevation1NE float(53) NOT NULL,
- Elevation2NE float(53) NOT NULL,
- Elevation1SE float(53) NOT NULL,
- Elevation2SE float(53) NOT NULL,
- Elevation1SW float(53) NOT NULL,
- Elevation2SW float(53) NOT NULL,
- WaterHeight float(53) NOT NULL,
- TerrainRaiseLimit float(53) NOT NULL,
- TerrainLowerLimit float(53) NOT NULL,
- UseEstateSun bit NOT NULL,
- FixedSun bit NOT NULL,
- SunPosition float(53) NOT NULL,
- Covenant NVARCHAR(36) NULL DEFAULT (NULL),
- Sandbox bit NOT NULL,
- SunVectorX float(53) NOT NULL DEFAULT ((0)),
- SunVectorY float(53) NOT NULL DEFAULT ((0)),
- SunVectorZ float(53) NOT NULL DEFAULT ((0)),
-
- primary key (RegionID)
-)
-
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_UserStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_UserStore.sql
deleted file mode 100644
index f5e0c00..0000000
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/002_UserStore.sql
+++ /dev/null
@@ -1,27 +0,0 @@
-ALTER TABLE UserAgents ADD PositionX REAL null;
-ALTER TABLE UserAgents ADD PositionY REAL null;
-ALTER TABLE UserAgents ADD PositionZ REAL null;
-ALTER TABLE UserAgents ADD LookAtX REAL null;
-ALTER TABLE UserAgents ADD LookAtY REAL null;
-ALTER TABLE UserAgents ADD LookAtZ REAL null;
-
-ALTER TABLE UserProfiles ADD Email NVARCHAR(250) null;
-ALTER TABLE UserProfiles ADD HomeRegionID NVARCHAR(36) null;
-ALTER TABLE UserProfiles ADD CanDoMask INT null;
-ALTER TABLE UserProfiles ADD WantDoMask INT null;
-ALTER TABLE UserProfiles ADD UserFlags INT null;
-ALTER TABLE UserProfiles ADD GodLevel INT null;
-ALTER TABLE UserProfiles ADD CustomType NVARCHAR(32) null;
-ALTER TABLE UserProfiles ADD Partner NVARCHAR(36) null;
-
-ALTER TABLE UserAppearances ADD AvatarHeight FLOAT null;
-
-CREATE TABLE UserFriends (
- UserFriendID NVARCHAR(36) NOT NULL,
- OwnerID NVARCHAR(36) NULL,
- FriendID NVARCHAR(36) NULL,
- FriendPermissions INT NULL,
- PRIMARY KEY (UserFriendID)
-);
-
-CREATE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID);
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
deleted file mode 100644
index cd0958d..0000000
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-CREATE TABLE Assets (
- ID VARCHAR(36) NOT NULL,
- Type SMALLINT DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- Description VARCHAR(64) DEFAULT NULL,
- Local BIT DEFAULT NULL,
- Temporary BIT DEFAULT NULL,
- Data LONGBLOB,
- PRIMARY KEY (ID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql
deleted file mode 100644
index e9ae07e..0000000
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql
+++ /dev/null
@@ -1,71 +0,0 @@
-CREATE TABLE EstateSettings (
- EstateID INT NOT NULL,
- ParentEstateID INT DEFAULT NULL,
- EstateOwnerID VARCHAR(36) DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- RedirectGridX INT DEFAULT NULL,
- RedirectGridY INT DEFAULT NULL,
- BillableFactor DOUBLE DEFAULT NULL,
- PricePerMeter INT DEFAULT NULL,
- SunPosition DOUBLE DEFAULT NULL,
-
- UseGlobalTime BIT DEFAULT NULL,
- FixedSun BIT DEFAULT NULL,
- AllowVoice BIT DEFAULT NULL,
- AllowDirectTeleport BIT DEFAULT NULL,
- ResetHomeOnTeleport BIT DEFAULT NULL,
- PublicAccess BIT DEFAULT NULL,
- DenyAnonymous BIT DEFAULT NULL,
- DenyIdentified BIT DEFAULT NULL,
- DenyTransacted BIT DEFAULT NULL,
- DenyMinors BIT DEFAULT NULL,
- BlockDwell BIT DEFAULT NULL,
- EstateSkipScripts BIT DEFAULT NULL,
- TaxFree BIT DEFAULT NULL,
- AbuseEmailToEstateOwner BIT DEFAULT NULL,
-
- AbuseEmail VARCHAR(255) DEFAULT NULL,
-
- PRIMARY KEY (EstateID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE TABLE EstateRegionLink (
- EstateRegionLinkID VARCHAR(36) NOT NULL,
- EstateID INT DEFAULT NULL,
- RegionID VARCHAR(36) DEFAULT NULL,
- PRIMARY KEY (EstateRegionLinkID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID);
-CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID);
-
-CREATE TABLE EstateManagers (
- EstateID INT NOT NULL,
- ManagerID VARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE TABLE EstateUsers (
- EstateID INT NOT NULL,
- UserID VARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE TABLE EstateGroups (
- EstateID INT NOT NULL,
- GroupID VARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE TABLE EstateBans (
- EstateID INT NOT NULL,
- ArrayIndex INT NOT NULL,
- BannedUserID VARCHAR(36) NOT NULL,
- BannedHostAddress VARCHAR(16) NOT NULL,
- BannedHostIPMask VARCHAR(16) NOT NULL,
- BannedHostNameMask VARCHAR(16) NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql
deleted file mode 100644
index c6fe620..0000000
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql
+++ /dev/null
@@ -1,35 +0,0 @@
-CREATE TABLE Regions (
- RegionID VARCHAR(36) NOT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- OriginID VARCHAR(36) DEFAULT NULL,
- RegionHandle BIGINT DEFAULT NULL,
- RegionName VARCHAR(32) DEFAULT NULL,
- RegionRecvKey VARCHAR(128) DEFAULT NULL,
- RegionSendKey VARCHAR(128) DEFAULT NULL,
- RegionSecret VARCHAR(128) DEFAULT NULL,
- RegionDataURI VARCHAR(255) DEFAULT NULL,
- ServerIP VARCHAR(64) DEFAULT NULL,
- ServerPort INT DEFAULT NULL,
- ServerURI VARCHAR(255) DEFAULT NULL,
- RegionLocX INT DEFAULT NULL,
- RegionLocY INT DEFAULT NULL,
- RegionLocZ INT DEFAULT NULL,
- EastOverrideHandle BIGINT DEFAULT NULL,
- WestOverrideHandle BIGINT DEFAULT NULL,
- SouthOverrideHandle BIGINT DEFAULT NULL,
- NorthOverrideHandle BIGINT DEFAULT NULL,
- RegionAssetURI VARCHAR(255) DEFAULT NULL,
- RegionAssetRecvKey VARCHAR(128) DEFAULT NULL,
- RegionAssetSendKey VARCHAR(128) DEFAULT NULL,
- RegionUserURI VARCHAR(255) DEFAULT NULL,
- RegionUserRecvKey VARCHAR(128) DEFAULT NULL,
- RegionUserSendKey VARCHAR(128) DEFAULT NULL,
- RegionMapTextureId VARCHAR(36) DEFAULT NULL,
- ServerHttpPort INT DEFAULT NULL,
- ServerRemotingPort INT DEFAULT NULL,
- PRIMARY KEY (RegionID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE INDEX RegionNameIndex ON Regions (RegionName);
-CREATE INDEX RegionHandleIndex ON Regions (RegionHandle);
-CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle);
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
deleted file mode 100644
index 93d282b..0000000
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
+++ /dev/null
@@ -1,39 +0,0 @@
-CREATE TABLE InventoryFolders (
- ID VARCHAR(36) NOT NULL,
- Type SMALLINT DEFAULT NULL,
- Version INT DEFAULT NULL,
- ParentID VARCHAR(36) DEFAULT NULL,
- Owner VARCHAR(36) DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- PRIMARY KEY (ID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner);
-CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID);
-
-CREATE TABLE InventoryItems (
- ID VARCHAR(36) NOT NULL,
- InvType INT DEFAULT NULL,
- AssetType INT DEFAULT NULL,
- AssetID VARCHAR(36) DEFAULT NULL,
- Folder VARCHAR(36) DEFAULT NULL,
- Owner VARCHAR(36) DEFAULT NULL,
- Creator VARCHAR(36) DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- Description VARCHAR(64) DEFAULT NULL,
- NextPermissions INT DEFAULT NULL,
- CurrentPermissions INT DEFAULT NULL,
- BasePermissions INT DEFAULT NULL,
- EveryOnePermissions INT DEFAULT NULL,
- GroupID VARCHAR(36) DEFAULT NULL,
- GroupOwned BIT DEFAULT NULL,
- SalePrice INT DEFAULT NULL,
- SaleType TINYINT DEFAULT NULL,
- Flags INT DEFAULT NULL,
- CreationDate INT DEFAULT NULL,
- PRIMARY KEY (ID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID);
-CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner);
-CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder);
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
deleted file mode 100644
index eb1d8fe..0000000
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
+++ /dev/null
@@ -1,169 +0,0 @@
-CREATE TABLE Prims (
- UUID VARCHAR(36) NOT NULL,
- RegionID VARCHAR(36) DEFAULT NULL,
- GroupID VARCHAR(36) DEFAULT NULL,
- ParentID INT DEFAULT NULL,
- ParentUUID VARCHAR(36) DEFAULT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- LastOwnerID VARCHAR(36) DEFAULT NULL,
- CreatorID VARCHAR(36) DEFAULT NULL,
- CreationDate INT DEFAULT NULL,
- LinkNum INT DEFAULT NULL,
- Name VARCHAR(255) DEFAULT NULL,
- Text VARCHAR(255) DEFAULT NULL,
- Description VARCHAR(255) DEFAULT NULL,
- SitName VARCHAR(255) DEFAULT NULL,
- TouchName VARCHAR(255) DEFAULT NULL,
- ObjectFlags INT DEFAULT NULL,
- OwnerMask INT DEFAULT NULL,
- NextOwnerMask INT DEFAULT NULL,
- GroupMask INT DEFAULT NULL,
- EveryoneMask INT DEFAULT NULL,
- BaseMask INT DEFAULT NULL,
- Material TINYINT DEFAULT NULL,
- ScriptAccessPin INT DEFAULT NULL,
- TextureAnimation BLOB,
- ParticleSystem BLOB,
- ClickAction TINYINT DEFAULT NULL,
- Color INT DEFAULT NULL,
- PositionX DOUBLE DEFAULT NULL,
- PositionY DOUBLE DEFAULT NULL,
- PositionZ DOUBLE DEFAULT NULL,
- GroupPositionX DOUBLE DEFAULT NULL,
- GroupPositionY DOUBLE DEFAULT NULL,
- GroupPositionZ DOUBLE DEFAULT NULL,
- VelocityX DOUBLE DEFAULT NULL,
- VelocityY DOUBLE DEFAULT NULL,
- VelocityZ DOUBLE DEFAULT NULL,
- AngularVelocityX DOUBLE DEFAULT NULL,
- AngularVelocityY DOUBLE DEFAULT NULL,
- AngularVelocityZ DOUBLE DEFAULT NULL,
- AccelerationX DOUBLE DEFAULT NULL,
- AccelerationY DOUBLE DEFAULT NULL,
- AccelerationZ DOUBLE DEFAULT NULL,
- RotationX DOUBLE DEFAULT NULL,
- RotationY DOUBLE DEFAULT NULL,
- RotationZ DOUBLE DEFAULT NULL,
- RotationW DOUBLE DEFAULT NULL,
- SitTargetOffsetX DOUBLE DEFAULT NULL,
- SitTargetOffsetY DOUBLE DEFAULT NULL,
- SitTargetOffsetZ DOUBLE DEFAULT NULL,
- SitTargetOrientW DOUBLE DEFAULT NULL,
- SitTargetOrientX DOUBLE DEFAULT NULL,
- SitTargetOrientY DOUBLE DEFAULT NULL,
- SitTargetOrientZ DOUBLE DEFAULT NULL,
- -- this is the shape
- Shape INT DEFAULT NULL,
- ScaleX DOUBLE DEFAULT NULL,
- ScaleY DOUBLE DEFAULT NULL,
- ScaleZ DOUBLE DEFAULT NULL,
- PCode INT DEFAULT NULL,
- PathBegin INT DEFAULT NULL,
- PathEnd INT DEFAULT NULL,
- PathScaleX INT DEFAULT NULL,
- PathScaleY INT DEFAULT NULL,
- PathShearX INT DEFAULT NULL,
- PathShearY INT DEFAULT NULL,
- PathSkew INT DEFAULT NULL,
- PathCurve INT DEFAULT NULL,
- PathRadiusOffset INT DEFAULT NULL,
- PathRevolutions INT DEFAULT NULL,
- PathTaperX INT DEFAULT NULL,
- PathTaperY INT DEFAULT NULL,
- PathTwist INT DEFAULT NULL,
- ProfileBegin INT DEFAULT NULL,
- ProfileEnd INT DEFAULT NULL,
- ProfileCurve INT DEFAULT NULL,
- ProfileHollow INT DEFAULT NULL,
- State INT DEFAULT NULL,
- Texture LONGBLOB,
- ExtraParams LONGBLOB,
- PRIMARY KEY (UUID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID);
-CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID);
-
-CREATE TABLE Terrain (
- RegionID VARCHAR(36) not null,
- MapData LONGBLOB,
- PRIMARY KEY (RegionID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE TABLE PrimItems (
- ItemID VARCHAR(36) NOT NULL,
- GroupID VARCHAR(36) DEFAULT NULL,
- PrimID VARCHAR(36) DEFAULT NULL,
- ParentFolderID VARCHAR(36) DEFAULT NULL,
- AssetID VARCHAR(36) DEFAULT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- LastOwnerID VARCHAR(36) DEFAULT NULL,
- CreatorID VARCHAR(36) DEFAULT NULL,
- CreationDate BIGINT DEFAULT NULL,
- Type INT DEFAULT NULL,
- InvType INT DEFAULT NULL,
- Name VARCHAR(255) DEFAULT NULL,
- Description VARCHAR(255) DEFAULT NULL,
- NextPermissions INT DEFAULT NULL,
- CurrentPermissions INT DEFAULT NULL,
- BasePermissions INT DEFAULT NULL,
- EveryonePermissions INT DEFAULT NULL,
- GroupPermissions INT DEFAULT NULL,
- Flags INT DEFAULT NULL,
- PRIMARY KEY (ItemID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE INDEX PrimItemsPrimIdIndex ON PrimItems (PrimID);
-
-CREATE TABLE RegionSettings (
- RegionID VARCHAR(36) NOT NULL,
-
- BlockTerraform BIT DEFAULT NULL,
- BlockFly BIT DEFAULT NULL,
- AllowDamage BIT DEFAULT NULL,
- RestrictPushing BIT DEFAULT NULL,
- AllowLandResell BIT DEFAULT NULL,
- AllowLandJoinDivide BIT DEFAULT NULL,
- BlockShowInSearch BIT DEFAULT NULL,
-
- AgentLimit INT DEFAULT NULL,
- ObjectBonus DOUBLE DEFAULT NULL,
- Maturity INT DEFAULT NULL,
-
- DisableScripts BIT DEFAULT NULL,
- DisableCollisions BIT DEFAULT NULL,
- DisablePhysics BIT DEFAULT NULL,
-
- TerrainTexture1 VARCHAR(36) DEFAULT NULL,
- TerrainTexture2 VARCHAR(36) DEFAULT NULL,
- TerrainTexture3 VARCHAR(36) DEFAULT NULL,
- TerrainTexture4 VARCHAR(36) DEFAULT NULL,
-
- Elevation1NW DOUBLE DEFAULT NULL,
- Elevation2NW DOUBLE DEFAULT NULL,
- Elevation1NE DOUBLE DEFAULT NULL,
- Elevation2NE DOUBLE DEFAULT NULL,
- Elevation1SE DOUBLE DEFAULT NULL,
- Elevation2SE DOUBLE DEFAULT NULL,
- Elevation1SW DOUBLE DEFAULT NULL,
- Elevation2SW DOUBLE DEFAULT NULL,
-
- WaterHeight DOUBLE DEFAULT NULL,
- TerrainRaiseLimit DOUBLE DEFAULT NULL,
- TerrainLowerLimit DOUBLE DEFAULT NULL,
-
- UseEstateSun BIT DEFAULT NULL,
- Sandbox BIT DEFAULT NULL,
-
- SunVectorX DOUBLE DEFAULT NULL,
- SunVectorY DOUBLE DEFAULT NULL,
- SunVectorZ DOUBLE DEFAULT NULL,
-
- FixedSun BIT DEFAULT NULL,
- SunPosition DOUBLE DEFAULT NULL,
-
- Covenant VARCHAR(36) DEFAULT NULL,
-
- PRIMARY KEY (RegionID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql
deleted file mode 100644
index 140aea4..0000000
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_UserStore.sql
+++ /dev/null
@@ -1,104 +0,0 @@
-CREATE TABLE UserAgents (
- ProfileID VARCHAR(36) NOT NULL,
- AgentIP VARCHAR(24) DEFAULT NULL,
- AgentPort INT DEFAULT NULL,
- AgentOnline BIT DEFAULT NULL,
- SessionID VARCHAR(36) DEFAULT NULL,
- SecureSessionID VARCHAR(36) DEFAULT NULL,
- InitialRegion VARCHAR(255) DEFAULT NULL,
- Region VARCHAR(255) DEFAULT NULL,
- LoginTime INT DEFAULT NULL,
- LogoutTime INT DEFAULT NULL,
- Handle BIGINT DEFAULT NULL,
- PositionX DOUBLE DEFAULT NULL,
- PositionY DOUBLE DEFAULT NULL,
- PositionZ DOUBLE DEFAULT NULL,
- LookAtX DOUBLE DEFAULT NULL,
- LookAtY DOUBLE DEFAULT NULL,
- LookAtZ DOUBLE DEFAULT NULL,
- PRIMARY KEY (ProfileID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE TABLE UserProfiles (
- ID VARCHAR(36) NOT NULL,
- WebLoginKey VARCHAR(36) DEFAULT NULL,
- FirstName VARCHAR(32) DEFAULT NULL,
- SurName VARCHAR(32) DEFAULT NULL,
- Email VARCHAR(250) DEFAULT NULL,
- PasswordHash VARCHAR(32) DEFAULT NULL,
- PasswordSalt VARCHAR(32) DEFAULT NULL,
- HomeRegionID VARCHAR(36) DEFAULT NULL,
- HomeRegionX INT DEFAULT NULL,
- HomeRegionY INT DEFAULT NULL,
- HomeLocationX DOUBLE DEFAULT NULL,
- HomeLocationY DOUBLE DEFAULT NULL,
- HomeLocationZ DOUBLE DEFAULT NULL,
- HomeLookAtX DOUBLE DEFAULT NULL,
- HomeLookAtY DOUBLE DEFAULT NULL,
- HomeLookAtZ DOUBLE DEFAULT NULL,
- Created INT DEFAULT NULL,
- LastLogin INT DEFAULT NULL,
- UserInventoryURI VARCHAR(255) DEFAULT NULL,
- UserAssetURI VARCHAR(255) DEFAULT NULL,
- Image VARCHAR(36) DEFAULT NULL,
- FirstLifeImage VARCHAR(36) DEFAULT NULL,
- AboutText TEXT DEFAULT NULL,
- FirstLifeAboutText TEXT DEFAULT NULL,
- CanDoMask INT DEFAULT NULL,
- WantDoMask INT DEFAULT NULL,
- UserFlags INT DEFAULT NULL,
- GodLevel INT DEFAULT NULL,
- CustomType VARCHAR(32) DEFAULT NULL,
- Partner VARCHAR(36) DEFAULT NULL,
- RootInventoryFolderID VARCHAR(36) DEFAULT NULL,
- PRIMARY KEY (ID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE INDEX UserSurnameIndex ON UserProfiles (SurName);
-CREATE INDEX UserFirstNameIndex ON UserProfiles (FirstName);
-CREATE UNIQUE INDEX UserFullNameIndex ON UserProfiles (SurName,FirstName);
-
-CREATE TABLE UserAppearances (
- Owner VARCHAR(36) NOT NULL,
- BodyItem VARCHAR(36) DEFAULT NULL,
- BodyAsset VARCHAR(36) DEFAULT NULL,
- SkinItem VARCHAR(36) DEFAULT NULL,
- SkinAsset VARCHAR(36) DEFAULT NULL,
- HairItem VARCHAR(36) DEFAULT NULL,
- HairAsset VARCHAR(36) DEFAULT NULL,
- EyesItem VARCHAR(36) DEFAULT NULL,
- EyesAsset VARCHAR(36) DEFAULT NULL,
- ShirtItem VARCHAR(36) DEFAULT NULL,
- ShirtAsset VARCHAR(36) DEFAULT NULL,
- PantsItem VARCHAR(36) DEFAULT NULL,
- PantsAsset VARCHAR(36) DEFAULT NULL,
- ShoesItem VARCHAR(36) DEFAULT NULL,
- ShoesAsset VARCHAR(36) DEFAULT NULL,
- SocksItem VARCHAR(36) DEFAULT NULL,
- SocksAsset VARCHAR(36) DEFAULT NULL,
- JacketItem VARCHAR(36) DEFAULT NULL,
- JacketAsset VARCHAR(36) DEFAULT NULL,
- GlovesItem VARCHAR(36) DEFAULT NULL,
- GlovesAsset VARCHAR(36) DEFAULT NULL,
- UnderShirtItem VARCHAR(36) DEFAULT NULL,
- UnderShirtAsset VARCHAR(36) DEFAULT NULL,
- UnderPantsItem VARCHAR(36) DEFAULT NULL,
- UnderPantsAsset VARCHAR(36) DEFAULT NULL,
- SkirtItem VARCHAR(36) DEFAULT NULL,
- SkirtAsset VARCHAR(36) DEFAULT NULL,
- Texture LONGBLOB,
- VisualParams LONGBLOB,
- Serial INT DEFAULT NULL,
- AvatarHeight FLOAT DEFAULT NULL,
- PRIMARY KEY (Owner)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE TABLE UserFriends (
- UserFriendID VARCHAR(36) NOT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- FriendID VARCHAR(36) DEFAULT NULL,
- FriendPermissions INT DEFAULT NULL,
- PRIMARY KEY (UserFriendID)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
-
-CREATE UNIQUE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID);
diff --git a/OpenSim/Data/NHibernate/Resources/OpenSim.Data.NHibernate.addin.xml b/OpenSim/Data/NHibernate/Resources/OpenSim.Data.NHibernate.addin.xml
deleted file mode 100644
index 37b23cb..0000000
--- a/OpenSim/Data/NHibernate/Resources/OpenSim.Data.NHibernate.addin.xml
+++ /dev/null
@@ -1,23 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql
deleted file mode 100644
index 4753123..0000000
--- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-CREATE TABLE Assets (
- ID VARCHAR(36) NOT NULL,
- Type SMALLINT DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- Description VARCHAR(64) DEFAULT NULL,
- Local BOOLEAN DEFAULT NULL,
- Temporary BOOLEAN DEFAULT NULL,
- Data BYTEA,
- PRIMARY KEY (ID)
-);
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql
deleted file mode 100644
index 3f47930..0000000
--- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql
+++ /dev/null
@@ -1,72 +0,0 @@
-CREATE TABLE EstateSettings (
- EstateID INT NOT NULL,
- ParentEstateID INT DEFAULT NULL,
- EstateOwnerID VARCHAR(36) DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- RedirectGridX INT DEFAULT NULL,
- RedirectGridY INT DEFAULT NULL,
- BillableFactor DOUBLE PRECISION DEFAULT NULL,
- PricePerMeter INT DEFAULT NULL,
- SunPosition DOUBLE PRECISION DEFAULT NULL,
-
- UseGlobalTime BOOLEAN DEFAULT NULL,
- FixedSun BOOLEAN DEFAULT NULL,
- AllowVoice BOOLEAN DEFAULT NULL,
- AllowDirectTeleport BOOLEAN DEFAULT NULL,
- ResetHomeOnTeleport BOOLEAN DEFAULT NULL,
- PublicAccess BOOLEAN DEFAULT NULL,
- DenyAnonymous BOOLEAN DEFAULT NULL,
- DenyIdentified BOOLEAN DEFAULT NULL,
- DenyTransacted BOOLEAN DEFAULT NULL,
- DenyMinors BOOLEAN DEFAULT NULL,
- BlockDwell BOOLEAN DEFAULT NULL,
- EstateSkipScripts BOOLEAN DEFAULT NULL,
- TaxFree BOOLEAN DEFAULT NULL,
- AbuseEmailToEstateOwner BOOLEAN DEFAULT NULL,
-
- AbuseEmail VARCHAR(255) DEFAULT NULL,
-
- PRIMARY KEY (EstateID)
-);
-
-CREATE TABLE EstateRegionLink (
- EstateRegionLinkID VARCHAR(36) NOT NULL,
- EstateID INT DEFAULT NULL,
- RegionID VARCHAR(36) DEFAULT NULL,
- PRIMARY KEY (EstateRegionLinkID)
-);
-
-CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID);
-CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID);
-
-
-CREATE TABLE EstateManagers (
- EstateID INT NOT NULL,
- ManagerID VARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
-
-CREATE TABLE EstateUsers (
- EstateID INT NOT NULL,
- UserID VARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
-
-CREATE TABLE EstateGroups (
- EstateID INT NOT NULL,
- GroupID VARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
-
-CREATE TABLE EstateBans (
- EstateID INT NOT NULL,
- ArrayIndex INT NOT NULL,
- BannedUserID VARCHAR(36) NOT NULL,
- BannedHostAddress VARCHAR(16) NOT NULL,
- BannedHostIPMask VARCHAR(16) NOT NULL,
- BannedHostNameMask VARCHAR(16) NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
\ No newline at end of file
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql
deleted file mode 100644
index 4366c1e..0000000
--- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql
+++ /dev/null
@@ -1,35 +0,0 @@
-CREATE TABLE Regions (
- RegionID VARCHAR(36) NOT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- OriginID VARCHAR(36) DEFAULT NULL,
- RegionHandle BIGINT DEFAULT NULL,
- RegionName VARCHAR(32) DEFAULT NULL,
- RegionRecvKey VARCHAR(128) DEFAULT NULL,
- RegionSendKey VARCHAR(128) DEFAULT NULL,
- RegionSecret VARCHAR(128) DEFAULT NULL,
- RegionDataURI VARCHAR(255) DEFAULT NULL,
- ServerIP VARCHAR(64) DEFAULT NULL,
- ServerPort INT DEFAULT NULL,
- ServerURI VARCHAR(255) DEFAULT NULL,
- RegionLocX INT DEFAULT NULL,
- RegionLocY INT DEFAULT NULL,
- RegionLocZ INT DEFAULT NULL,
- EastOverrideHandle BIGINT DEFAULT NULL,
- WestOverrideHandle BIGINT DEFAULT NULL,
- SouthOverrideHandle BIGINT DEFAULT NULL,
- NorthOverrideHandle BIGINT DEFAULT NULL,
- RegionAssetURI VARCHAR(255) DEFAULT NULL,
- RegionAssetRecvKey VARCHAR(128) DEFAULT NULL,
- RegionAssetSendKey VARCHAR(128) DEFAULT NULL,
- RegionUserURI VARCHAR(255) DEFAULT NULL,
- RegionUserRecvKey VARCHAR(128) DEFAULT NULL,
- RegionUserSendKey VARCHAR(128) DEFAULT NULL,
- RegionMapTextureId VARCHAR(36) DEFAULT NULL,
- ServerHttpPort INT DEFAULT NULL,
- ServerRemotingPort INT DEFAULT NULL,
- PRIMARY KEY (RegionID)
-);
-
-CREATE INDEX RegionNameIndex ON Regions (RegionName);
-CREATE INDEX RegionHandleIndex ON Regions (RegionHandle);
-CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle);
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
deleted file mode 100644
index 42af659..0000000
--- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
+++ /dev/null
@@ -1,39 +0,0 @@
-CREATE TABLE InventoryFolders (
- ID VARCHAR(36) NOT NULL,
- Type SMALLINT DEFAULT NULL,
- Version INT DEFAULT NULL,
- ParentID VARCHAR(36) DEFAULT NULL,
- Owner VARCHAR(36) DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- PRIMARY KEY (ID)
-);
-
-CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner);
-CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID);
-
-CREATE TABLE InventoryItems (
- ID VARCHAR(36) NOT NULL,
- InvType INT DEFAULT NULL,
- AssetType INT DEFAULT NULL,
- AssetID VARCHAR(36) DEFAULT NULL,
- Folder VARCHAR(36) DEFAULT NULL,
- Owner VARCHAR(36) DEFAULT NULL,
- Creator VARCHAR(36) DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- Description VARCHAR(64) DEFAULT NULL,
- NextPermissions INT DEFAULT NULL,
- CurrentPermissions INT DEFAULT NULL,
- BasePermissions INT DEFAULT NULL,
- EveryOnePermissions INT DEFAULT NULL,
- GroupID VARCHAR(36) DEFAULT NULL,
- GroupOwned BOOLEAN DEFAULT NULL,
- SalePrice INT DEFAULT NULL,
- SaleType SMALLINT DEFAULT NULL,
- Flags INT DEFAULT NULL,
- CreationDate INT DEFAULT NULL,
- PRIMARY KEY (ID)
-);
-
-CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID);
-CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner);
-CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder);
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql
deleted file mode 100644
index f4a0e68..0000000
--- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql
+++ /dev/null
@@ -1,169 +0,0 @@
-CREATE TABLE Prims (
- UUID VARCHAR(36) NOT NULL,
- RegionID VARCHAR(36) DEFAULT NULL,
- GroupID VARCHAR(36) DEFAULT NULL,
- ParentID INT DEFAULT NULL,
- ParentUUID VARCHAR(36) DEFAULT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- LastOwnerID VARCHAR(36) DEFAULT NULL,
- CreatorID VARCHAR(36) DEFAULT NULL,
- CreationDate INT DEFAULT NULL,
- LinkNum INT DEFAULT NULL,
- Name VARCHAR(255) DEFAULT NULL,
- Text VARCHAR(255) DEFAULT NULL,
- Description VARCHAR(255) DEFAULT NULL,
- SitName VARCHAR(255) DEFAULT NULL,
- TouchName VARCHAR(255) DEFAULT NULL,
- ObjectFlags INT DEFAULT NULL,
- OwnerMask INT DEFAULT NULL,
- NextOwnerMask INT DEFAULT NULL,
- GroupMask INT DEFAULT NULL,
- EveryoneMask INT DEFAULT NULL,
- BaseMask INT DEFAULT NULL,
- Material SMALLINT DEFAULT NULL,
- ScriptAccessPin INT DEFAULT NULL,
- TextureAnimation BYTEA,
- ParticleSystem BYTEA,
- ClickAction SMALLINT DEFAULT NULL,
- Color INT DEFAULT NULL,
- PositionX DOUBLE PRECISION DEFAULT NULL,
- PositionY DOUBLE PRECISION DEFAULT NULL,
- PositionZ DOUBLE PRECISION DEFAULT NULL,
- GroupPositionX DOUBLE PRECISION DEFAULT NULL,
- GroupPositionY DOUBLE PRECISION DEFAULT NULL,
- GroupPositionZ DOUBLE PRECISION DEFAULT NULL,
- VelocityX DOUBLE PRECISION DEFAULT NULL,
- VelocityY DOUBLE PRECISION DEFAULT NULL,
- VelocityZ DOUBLE PRECISION DEFAULT NULL,
- AngularVelocityX DOUBLE PRECISION DEFAULT NULL,
- AngularVelocityY DOUBLE PRECISION DEFAULT NULL,
- AngularVelocityZ DOUBLE PRECISION DEFAULT NULL,
- AccelerationX DOUBLE PRECISION DEFAULT NULL,
- AccelerationY DOUBLE PRECISION DEFAULT NULL,
- AccelerationZ DOUBLE PRECISION DEFAULT NULL,
- RotationX DOUBLE PRECISION DEFAULT NULL,
- RotationY DOUBLE PRECISION DEFAULT NULL,
- RotationZ DOUBLE PRECISION DEFAULT NULL,
- RotationW DOUBLE PRECISION DEFAULT NULL,
- SitTargetOffsetX DOUBLE PRECISION DEFAULT NULL,
- SitTargetOffsetY DOUBLE PRECISION DEFAULT NULL,
- SitTargetOffsetZ DOUBLE PRECISION DEFAULT NULL,
- SitTargetOrientW DOUBLE PRECISION DEFAULT NULL,
- SitTargetOrientX DOUBLE PRECISION DEFAULT NULL,
- SitTargetOrientY DOUBLE PRECISION DEFAULT NULL,
- SitTargetOrientZ DOUBLE PRECISION DEFAULT NULL,
- -- this is the shape
- Shape INT DEFAULT NULL,
- ScaleX DOUBLE PRECISION DEFAULT NULL,
- ScaleY DOUBLE PRECISION DEFAULT NULL,
- ScaleZ DOUBLE PRECISION DEFAULT NULL,
- PCode INT DEFAULT NULL,
- PathBegin INT DEFAULT NULL,
- PathEnd INT DEFAULT NULL,
- PathScaleX INT DEFAULT NULL,
- PathScaleY INT DEFAULT NULL,
- PathShearX INT DEFAULT NULL,
- PathShearY INT DEFAULT NULL,
- PathSkew SMALLINT DEFAULT NULL,
- PathCurve INT DEFAULT NULL,
- PathRadiusOffset SMALLINT DEFAULT NULL,
- PathRevolutions INT DEFAULT NULL,
- PathTaperX SMALLINT DEFAULT NULL,
- PathTaperY SMALLINT DEFAULT NULL,
- PathTwist SMALLINT DEFAULT NULL,
- ProfileBegin INT DEFAULT NULL,
- ProfileEnd INT DEFAULT NULL,
- ProfileCurve INT DEFAULT NULL,
- ProfileHollow INT DEFAULT NULL,
- State INT DEFAULT NULL,
- Texture BYTEA,
- ExtraParams BYTEA,
- PRIMARY KEY (UUID)
-);
-
-CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID);
-CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID);
-
-CREATE TABLE Terrain (
- RegionID VARCHAR(36) not null,
- MapData BYTEA,
- PRIMARY KEY (RegionID)
-);
-
-CREATE TABLE PrimItems (
- ItemID VARCHAR(36) NOT NULL,
- GroupID VARCHAR(36) DEFAULT NULL,
- PrimID VARCHAR(36) DEFAULT NULL,
- ParentFolderID VARCHAR(36) DEFAULT NULL,
- AssetID VARCHAR(36) DEFAULT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- LastOwnerID VARCHAR(36) DEFAULT NULL,
- CreatorID VARCHAR(36) DEFAULT NULL,
- CreationDate INT DEFAULT NULL,
- Type INT DEFAULT NULL,
- InvType INT DEFAULT NULL,
- Name VARCHAR(255) DEFAULT NULL,
- Description VARCHAR(255) DEFAULT NULL,
- NextPermissions INT DEFAULT NULL,
- CurrentPermissions INT DEFAULT NULL,
- BasePermissions INT DEFAULT NULL,
- EveryonePermissions INT DEFAULT NULL,
- GroupPermissions INT DEFAULT NULL,
- Flags INT DEFAULT NULL,
- PRIMARY KEY (ItemID)
-);
-
-CREATE INDEX PrimItemsPrimIdIndex ON PrimItems (PrimID);
-
-CREATE TABLE RegionSettings (
- RegionID VARCHAR(36) NOT NULL,
-
- BlockTerraform BOOLEAN DEFAULT NULL,
- BlockFly BOOLEAN DEFAULT NULL,
- AllowDamage BOOLEAN DEFAULT NULL,
- RestrictPushing BOOLEAN DEFAULT NULL,
- AllowLandResell BOOLEAN DEFAULT NULL,
- AllowLandJoinDivide BOOLEAN DEFAULT NULL,
- BlockShowInSearch BOOLEAN DEFAULT NULL,
-
- AgentLimit INT DEFAULT NULL,
- ObjectBonus DOUBLE PRECISION DEFAULT NULL,
- Maturity INT DEFAULT NULL,
-
- DisableScripts BOOLEAN DEFAULT NULL,
- DisableCollisions BOOLEAN DEFAULT NULL,
- DisablePhysics BOOLEAN DEFAULT NULL,
-
- TerrainTexture1 VARCHAR(36) DEFAULT NULL,
- TerrainTexture2 VARCHAR(36) DEFAULT NULL,
- TerrainTexture3 VARCHAR(36) DEFAULT NULL,
- TerrainTexture4 VARCHAR(36) DEFAULT NULL,
-
- Elevation1NW DOUBLE PRECISION DEFAULT NULL,
- Elevation2NW DOUBLE PRECISION DEFAULT NULL,
- Elevation1NE DOUBLE PRECISION DEFAULT NULL,
- Elevation2NE DOUBLE PRECISION DEFAULT NULL,
- Elevation1SE DOUBLE PRECISION DEFAULT NULL,
- Elevation2SE DOUBLE PRECISION DEFAULT NULL,
- Elevation1SW DOUBLE PRECISION DEFAULT NULL,
- Elevation2SW DOUBLE PRECISION DEFAULT NULL,
-
- WaterHeight DOUBLE PRECISION DEFAULT NULL,
- TerrainRaiseLimit DOUBLE PRECISION DEFAULT NULL,
- TerrainLowerLimit DOUBLE PRECISION DEFAULT NULL,
-
- UseEstateSun BOOLEAN DEFAULT NULL,
- Sandbox BOOLEAN DEFAULT NULL,
-
- SunVectorX DOUBLE PRECISION DEFAULT NULL,
- SunVectorY DOUBLE PRECISION DEFAULT NULL,
- SunVectorZ DOUBLE PRECISION DEFAULT NULL,
-
- FixedSun BOOLEAN DEFAULT NULL,
- SunPosition DOUBLE PRECISION DEFAULT NULL,
-
- Covenant VARCHAR(36) DEFAULT NULL,
-
- PRIMARY KEY (RegionID)
-);
-
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql
deleted file mode 100644
index b3c7ef1..0000000
--- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql
+++ /dev/null
@@ -1,104 +0,0 @@
-CREATE TABLE UserAgents (
- ProfileID VARCHAR(36) NOT NULL,
- AgentIP VARCHAR(24) DEFAULT NULL,
- AgentPort INT DEFAULT NULL,
- AgentOnline BOOLEAN DEFAULT NULL,
- SessionID VARCHAR(36) DEFAULT NULL,
- SecureSessionID VARCHAR(36) DEFAULT NULL,
- InitialRegion VARCHAR(255) DEFAULT NULL,
- Region VARCHAR(255) DEFAULT NULL,
- LoginTime INT DEFAULT NULL,
- LogoutTime INT DEFAULT NULL,
- Handle BIGINT DEFAULT NULL,
- PositionX DOUBLE PRECISION DEFAULT NULL,
- PositionY DOUBLE PRECISION DEFAULT NULL,
- PositionZ DOUBLE PRECISION DEFAULT NULL,
- LookAtX DOUBLE PRECISION DEFAULT NULL,
- LookAtY DOUBLE PRECISION DEFAULT NULL,
- LookAtZ DOUBLE PRECISION DEFAULT NULL,
- PRIMARY KEY (ProfileID)
-);
-
-CREATE TABLE UserProfiles (
- ID VARCHAR(36) NOT NULL,
- WebLoginKey VARCHAR(36) DEFAULT NULL,
- FirstName VARCHAR(32) DEFAULT NULL,
- SurName VARCHAR(32) DEFAULT NULL,
- Email VARCHAR(250) DEFAULT NULL,
- PasswordHash VARCHAR(32) DEFAULT NULL,
- PasswordSalt VARCHAR(32) DEFAULT NULL,
- HomeRegionID VARCHAR(36) DEFAULT NULL,
- HomeRegionX INT DEFAULT NULL,
- HomeRegionY INT DEFAULT NULL,
- HomeLocationX DOUBLE PRECISION DEFAULT NULL,
- HomeLocationY DOUBLE PRECISION DEFAULT NULL,
- HomeLocationZ DOUBLE PRECISION DEFAULT NULL,
- HomeLookAtX DOUBLE PRECISION DEFAULT NULL,
- HomeLookAtY DOUBLE PRECISION DEFAULT NULL,
- HomeLookAtZ DOUBLE PRECISION DEFAULT NULL,
- Created INT DEFAULT NULL,
- LastLogin INT DEFAULT NULL,
- UserInventoryURI VARCHAR(255) DEFAULT NULL,
- UserAssetURI VARCHAR(255) DEFAULT NULL,
- Image VARCHAR(36) DEFAULT NULL,
- FirstLifeImage VARCHAR(36) DEFAULT NULL,
- AboutText TEXT DEFAULT NULL,
- FirstLifeAboutText TEXT DEFAULT NULL,
- CanDoMask INT DEFAULT NULL,
- WantDoMask INT DEFAULT NULL,
- UserFlags INT DEFAULT NULL,
- GodLevel INT DEFAULT NULL,
- CustomType VARCHAR(32) DEFAULT NULL,
- Partner VARCHAR(36) DEFAULT NULL,
- RootInventoryFolderID VARCHAR(36) DEFAULT NULL,
- PRIMARY KEY (ID)
-);
-
-CREATE INDEX UserSurnameIndex ON UserProfiles (SurName);
-CREATE INDEX UserFirstNameIndex ON UserProfiles (FirstName);
-CREATE UNIQUE INDEX UserFullNameIndex ON UserProfiles (SurName,FirstName);
-
-CREATE TABLE UserAppearances (
- Owner VARCHAR(36) NOT NULL,
- BodyItem VARCHAR(36) DEFAULT NULL,
- BodyAsset VARCHAR(36) DEFAULT NULL,
- SkinItem VARCHAR(36) DEFAULT NULL,
- SkinAsset VARCHAR(36) DEFAULT NULL,
- HairItem VARCHAR(36) DEFAULT NULL,
- HairAsset VARCHAR(36) DEFAULT NULL,
- EyesItem VARCHAR(36) DEFAULT NULL,
- EyesAsset VARCHAR(36) DEFAULT NULL,
- ShirtItem VARCHAR(36) DEFAULT NULL,
- ShirtAsset VARCHAR(36) DEFAULT NULL,
- PantsItem VARCHAR(36) DEFAULT NULL,
- PantsAsset VARCHAR(36) DEFAULT NULL,
- ShoesItem VARCHAR(36) DEFAULT NULL,
- ShoesAsset VARCHAR(36) DEFAULT NULL,
- SocksItem VARCHAR(36) DEFAULT NULL,
- SocksAsset VARCHAR(36) DEFAULT NULL,
- JacketItem VARCHAR(36) DEFAULT NULL,
- JacketAsset VARCHAR(36) DEFAULT NULL,
- GlovesItem VARCHAR(36) DEFAULT NULL,
- GlovesAsset VARCHAR(36) DEFAULT NULL,
- UnderShirtItem VARCHAR(36) DEFAULT NULL,
- UnderShirtAsset VARCHAR(36) DEFAULT NULL,
- UnderPantsItem VARCHAR(36) DEFAULT NULL,
- UnderPantsAsset VARCHAR(36) DEFAULT NULL,
- SkirtItem VARCHAR(36) DEFAULT NULL,
- SkirtAsset VARCHAR(36) DEFAULT NULL,
- Texture BYTEA,
- VisualParams BYTEA,
- Serial INT DEFAULT NULL,
- AvatarHeight FLOAT DEFAULT NULL,
- PRIMARY KEY (Owner)
-);
-
-CREATE TABLE UserFriends (
- UserFriendID VARCHAR(36) NOT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- FriendID VARCHAR(36) DEFAULT NULL,
- FriendPermissions INT DEFAULT NULL,
- PRIMARY KEY (UserFriendID)
-);
-
-CREATE UNIQUE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID);
diff --git a/OpenSim/Data/NHibernate/Resources/RegionProfileData.hbm.xml b/OpenSim/Data/NHibernate/Resources/RegionProfileData.hbm.xml
deleted file mode 100644
index 5ff37d8..0000000
--- a/OpenSim/Data/NHibernate/Resources/RegionProfileData.hbm.xml
+++ /dev/null
@@ -1,44 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/RegionSettings.hbm.xml b/OpenSim/Data/NHibernate/Resources/RegionSettings.hbm.xml
deleted file mode 100644
index 3843a8d..0000000
--- a/OpenSim/Data/NHibernate/Resources/RegionSettings.hbm.xml
+++ /dev/null
@@ -1,56 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml b/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml
deleted file mode 100644
index 98c648b..0000000
--- a/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml
+++ /dev/null
@@ -1,147 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql
deleted file mode 100644
index aedf764..0000000
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-CREATE TABLE Assets (
- ID VARCHAR(36) NOT NULL,
- Type SMALLINT DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- Description VARCHAR(64) DEFAULT NULL,
- Local BIT DEFAULT NULL,
- Temporary BIT DEFAULT NULL,
- Data BLOB,
- PRIMARY KEY (ID)
-);
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql
deleted file mode 100644
index afe702f..0000000
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql
+++ /dev/null
@@ -1,71 +0,0 @@
-CREATE TABLE EstateSettings (
- EstateID INT NOT NULL,
- ParentEstateID INT DEFAULT NULL,
- EstateOwnerID VARCHAR(36) DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- RedirectGridX INT DEFAULT NULL,
- RedirectGridY INT DEFAULT NULL,
- BillableFactor DOUBLE DEFAULT NULL,
- PricePerMeter INT DEFAULT NULL,
- SunPosition DOUBLE DEFAULT NULL,
-
- UseGlobalTime BIT DEFAULT NULL,
- FixedSun BIT DEFAULT NULL,
- AllowVoice BIT DEFAULT NULL,
- AllowDirectTeleport BIT DEFAULT NULL,
- ResetHomeOnTeleport BIT DEFAULT NULL,
- PublicAccess BIT DEFAULT NULL,
- DenyAnonymous BIT DEFAULT NULL,
- DenyIdentified BIT DEFAULT NULL,
- DenyTransacted BIT DEFAULT NULL,
- DenyMinors BIT DEFAULT NULL,
- BlockDwell BIT DEFAULT NULL,
- EstateSkipScripts BIT DEFAULT NULL,
- TaxFree BIT DEFAULT NULL,
- AbuseEmailToEstateOwner BIT DEFAULT NULL,
-
- AbuseEmail VARCHAR(255) DEFAULT NULL,
-
- PRIMARY KEY (EstateID)
-);
-
-CREATE TABLE EstateRegionLink (
- EstateRegionLinkID VARCHAR(36) NOT NULL,
- EstateID INT DEFAULT NULL,
- RegionID VARCHAR(36) DEFAULT NULL,
- PRIMARY KEY (EstateRegionLinkID)
-);
-
-CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID);
-CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID);
-
-CREATE TABLE EstateManagers (
- EstateID INT NOT NULL,
- ManagerID VARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
-
-CREATE TABLE EstateUsers (
- EstateID INT NOT NULL,
- UserID VARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
-
-CREATE TABLE EstateGroups (
- EstateID INT NOT NULL,
- GroupID VARCHAR(36) NOT NULL,
- ArrayIndex INT NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
-
-CREATE TABLE EstateBans (
- EstateID INT NOT NULL,
- ArrayIndex INT NOT NULL,
- BannedUserID VARCHAR(36) NOT NULL,
- BannedHostAddress VARCHAR(16) NOT NULL,
- BannedHostIPMask VARCHAR(16) NOT NULL,
- BannedHostNameMask VARCHAR(16) NOT NULL,
- PRIMARY KEY (EstateID,ArrayIndex)
-);
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
deleted file mode 100644
index 4f09848..0000000
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
+++ /dev/null
@@ -1,35 +0,0 @@
-CREATE TABLE Regions (
- RegionId VARCHAR(36) NOT NULL,
- RegionHandle BIGINT UNSIGNED NOT NULL,
- RegionName VARCHAR(32) DEFAULT NULL,
- RegionRecvKey VARCHAR(128) DEFAULT NULL,
- RegionSendKey VARCHAR(128) DEFAULT NULL,
- RegionSecret VARCHAR(128) DEFAULT NULL,
- RegionDataURI VARCHAR(255) DEFAULT NULL,
- ServerIP VARCHAR(64) DEFAULT NULL,
- ServerPort INT UNSIGNED DEFAULT NULL,
- ServerURI VARCHAR(255) DEFAULT NULL,
- RegionLocX INT UNSIGNED DEFAULT NULL,
- RegionLocY INT UNSIGNED DEFAULT NULL,
- RegionLocZ INT UNSIGNED DEFAULT NULL,
- EastOverrideHandle BIGINT UNSIGNED DEFAULT NULL,
- WestOverrideHandle BIGINT UNSIGNED DEFAULT NULL,
- SouthOverrideHandle BIGINT UNSIGNED DEFAULT NULL,
- NorthOverrideHandle BIGINT UNSIGNED DEFAULT NULL,
- RegionAssetURI VARCHAR(255) DEFAULT NULL,
- RegionAssetRecvKey VARCHAR(128) DEFAULT NULL,
- RegionAssetSendKey VARCHAR(128) DEFAULT NULL,
- RegionUserURI VARCHAR(255) DEFAULT NULL,
- RegionUserRecvKey VARCHAR(128) DEFAULT NULL,
- RegionUserSendKey VARCHAR(128) DEFAULT NULL,
- RegionMapTextureId VARCHAR(36) DEFAULT NULL,
- ServerHttpPort INT DEFAULT NULL,
- ServerRemotingPort INT DEFAULT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- OriginID VARCHAR(36) DEFAULT NULL,
- PRIMARY KEY (RegionId)
-);
-
-CREATE INDEX RegionNameIndex ON Regions (RegionName);
-CREATE INDEX RegionHandleIndex ON Regions (RegionHandle);
-CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle);
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql
deleted file mode 100644
index 38978ee..0000000
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql
+++ /dev/null
@@ -1,39 +0,0 @@
-CREATE TABLE InventoryFolders (
- ID VARCHAR(36) NOT NULL,
- Type SMALLINT DEFAULT NULL,
- Version INT DEFAULT NULL,
- ParentID VARCHAR(36) DEFAULT NULL,
- Owner VARCHAR(36) DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- PRIMARY KEY (ID)
-);
-
-CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner);
-CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID);
-
-CREATE TABLE InventoryItems (
- ID VARCHAR(36) NOT NULL,
- InvType INT DEFAULT NULL,
- AssetType INT DEFAULT NULL,
- AssetID VARCHAR(36) DEFAULT NULL,
- Folder VARCHAR(36) DEFAULT NULL,
- Owner VARCHAR(36) DEFAULT NULL,
- Creator VARCHAR(36) DEFAULT NULL,
- Name VARCHAR(64) DEFAULT NULL,
- Description VARCHAR(64) DEFAULT NULL,
- NextPermissions INT DEFAULT NULL,
- CurrentPermissions INT DEFAULT NULL,
- BasePermissions INT DEFAULT NULL,
- EveryOnePermissions INT DEFAULT NULL,
- GroupID VARCHAR(36) DEFAULT NULL,
- GroupOwned BIT DEFAULT NULL,
- SalePrice INT DEFAULT NULL,
- SaleType TINYINT DEFAULT NULL,
- Flags INT DEFAULT NULL,
- CreationDate INT DEFAULT NULL,
- PRIMARY KEY (ID)
-);
-
-CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID);
-CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner);
-CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder);
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
deleted file mode 100644
index 2b8e62a..0000000
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
+++ /dev/null
@@ -1,168 +0,0 @@
-CREATE TABLE Prims (
- UUID VARCHAR(36) NOT NULL,
- RegionID VARCHAR(36) DEFAULT NULL,
- GroupID VARCHAR(36) DEFAULT NULL,
- ParentID INT DEFAULT NULL,
- ParentUUID VARCHAR(36) DEFAULT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- LastOwnerID VARCHAR(36) DEFAULT NULL,
- CreatorID VARCHAR(36) DEFAULT NULL,
- CreationDate INT DEFAULT NULL,
- LinkNum INT DEFAULT NULL,
- Name VARCHAR(255) DEFAULT NULL,
- Text VARCHAR(255) DEFAULT NULL,
- Description VARCHAR(255) DEFAULT NULL,
- SitName VARCHAR(255) DEFAULT NULL,
- TouchName VARCHAR(255) DEFAULT NULL,
- ObjectFlags INT DEFAULT NULL,
- OwnerMask INT DEFAULT NULL,
- NextOwnerMask INT DEFAULT NULL,
- GroupMask INT DEFAULT NULL,
- EveryoneMask INT DEFAULT NULL,
- BaseMask INT DEFAULT NULL,
- Material TINYINT DEFAULT NULL,
- ScriptAccessPin INT DEFAULT NULL,
- TextureAnimation BLOB,
- ParticleSystem BLOB,
- ClickAction TINYINT DEFAULT NULL,
- Color INT DEFAULT NULL,
- PositionX DOUBLE DEFAULT NULL,
- PositionY DOUBLE DEFAULT NULL,
- PositionZ DOUBLE DEFAULT NULL,
- GroupPositionX DOUBLE DEFAULT NULL,
- GroupPositionY DOUBLE DEFAULT NULL,
- GroupPositionZ DOUBLE DEFAULT NULL,
- VelocityX DOUBLE DEFAULT NULL,
- VelocityY DOUBLE DEFAULT NULL,
- VelocityZ DOUBLE DEFAULT NULL,
- AngularVelocityX DOUBLE DEFAULT NULL,
- AngularVelocityY DOUBLE DEFAULT NULL,
- AngularVelocityZ DOUBLE DEFAULT NULL,
- AccelerationX DOUBLE DEFAULT NULL,
- AccelerationY DOUBLE DEFAULT NULL,
- AccelerationZ DOUBLE DEFAULT NULL,
- RotationX DOUBLE DEFAULT NULL,
- RotationY DOUBLE DEFAULT NULL,
- RotationZ DOUBLE DEFAULT NULL,
- RotationW DOUBLE DEFAULT NULL,
- SitTargetOffsetX DOUBLE DEFAULT NULL,
- SitTargetOffsetY DOUBLE DEFAULT NULL,
- SitTargetOffsetZ DOUBLE DEFAULT NULL,
- SitTargetOrientW DOUBLE DEFAULT NULL,
- SitTargetOrientX DOUBLE DEFAULT NULL,
- SitTargetOrientY DOUBLE DEFAULT NULL,
- SitTargetOrientZ DOUBLE DEFAULT NULL,
- -- this is the shape
- Shape INT DEFAULT NULL,
- ScaleX DOUBLE DEFAULT NULL,
- ScaleY DOUBLE DEFAULT NULL,
- ScaleZ DOUBLE DEFAULT NULL,
- PCode INT DEFAULT NULL,
- PathBegin INT DEFAULT NULL,
- PathEnd INT DEFAULT NULL,
- PathScaleX INT DEFAULT NULL,
- PathScaleY INT DEFAULT NULL,
- PathShearX INT DEFAULT NULL,
- PathShearY INT DEFAULT NULL,
- PathSkew INT DEFAULT NULL,
- PathCurve INT DEFAULT NULL,
- PathRadiusOffset INT DEFAULT NULL,
- PathRevolutions INT DEFAULT NULL,
- PathTaperX INT DEFAULT NULL,
- PathTaperY INT DEFAULT NULL,
- PathTwist INT DEFAULT NULL,
- ProfileBegin INT DEFAULT NULL,
- ProfileEnd INT DEFAULT NULL,
- ProfileCurve INT DEFAULT NULL,
- ProfileHollow INT DEFAULT NULL,
- State INT DEFAULT NULL,
- Texture BLOB,
- ExtraParams BLOB,
- PRIMARY KEY (UUID)
-);
-
-CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID);
-CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID);
-
-CREATE TABLE Terrain (
- RegionID VARCHAR(36) NOT NULL,
- MapData BLOB,
- PRIMARY KEY (RegionID)
-);
-
-CREATE TABLE PrimItems (
- ItemID VARCHAR(36) NOT NULL,
- GroupID VARCHAR(36) DEFAULT NULL,
- PrimID VARCHAR(36) DEFAULT NULL,
- ParentFolderID VARCHAR(36) DEFAULT NULL,
- AssetID VARCHAR(36) DEFAULT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- LastOwnerID VARCHAR(36) DEFAULT NULL,
- CreatorID VARCHAR(36) DEFAULT NULL,
- CreationDate BIGINT DEFAULT NULL,
- Type INT DEFAULT NULL,
- InvType INT DEFAULT NULL,
- Name VARCHAR(255) DEFAULT NULL,
- Description VARCHAR(255) DEFAULT NULL,
- NextPermissions INT DEFAULT NULL,
- CurrentPermissions INT DEFAULT NULL,
- BasePermissions INT DEFAULT NULL,
- EveryonePermissions INT DEFAULT NULL,
- GroupPermissions INT DEFAULT NULL,
- Flags INT DEFAULT NULL,
- PRIMARY KEY (ItemID)
-);
-
-CREATE INDEX PrimItemsPrimIdIndex ON PrimItems (PrimID);
-
-CREATE TABLE RegionSettings (
- RegionID VARCHAR(36) NOT NULL,
-
- BlockTerraform BIT DEFAULT NULL,
- BlockFly BIT DEFAULT NULL,
- AllowDamage BIT DEFAULT NULL,
- RestrictPushing BIT DEFAULT NULL,
- AllowLandResell BIT DEFAULT NULL,
- AllowLandJoinDivide BIT DEFAULT NULL,
- BlockShowInSearch BIT DEFAULT NULL,
-
- AgentLimit INT DEFAULT NULL,
- ObjectBonus DOUBLE DEFAULT NULL,
- Maturity INT DEFAULT NULL,
-
- DisableScripts BIT DEFAULT NULL,
- DisableCollisions BIT DEFAULT NULL,
- DisablePhysics BIT DEFAULT NULL,
-
- TerrainTexture1 VARCHAR(36) DEFAULT NULL,
- TerrainTexture2 VARCHAR(36) DEFAULT NULL,
- TerrainTexture3 VARCHAR(36) DEFAULT NULL,
- TerrainTexture4 VARCHAR(36) DEFAULT NULL,
-
- Elevation1NW DOUBLE DEFAULT NULL,
- Elevation2NW DOUBLE DEFAULT NULL,
- Elevation1NE DOUBLE DEFAULT NULL,
- Elevation2NE DOUBLE DEFAULT NULL,
- Elevation1SE DOUBLE DEFAULT NULL,
- Elevation2SE DOUBLE DEFAULT NULL,
- Elevation1SW DOUBLE DEFAULT NULL,
- Elevation2SW DOUBLE DEFAULT NULL,
-
- WaterHeight DOUBLE DEFAULT NULL,
- TerrainRaiseLimit DOUBLE DEFAULT NULL,
- TerrainLowerLimit DOUBLE DEFAULT NULL,
-
- UseEstateSun BIT DEFAULT NULL,
- Sandbox BIT DEFAULT NULL,
-
- SunVectorX DOUBLE DEFAULT NULL,
- SunVectorY DOUBLE DEFAULT NULL,
- SunVectorZ DOUBLE DEFAULT NULL,
-
- FixedSun BIT DEFAULT NULL,
- SunPosition DOUBLE DEFAULT NULL,
-
- Covenant VARCHAR(36) DEFAULT NULL,
-
- PRIMARY KEY (RegionID)
-);
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql
deleted file mode 100644
index 6084886..0000000
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql
+++ /dev/null
@@ -1,104 +0,0 @@
-CREATE TABLE UserAgents (
- ProfileID VARCHAR(36) NOT NULL,
- AgentIP VARCHAR(24) DEFAULT NULL,
- AgentPort INT DEFAULT NULL,
- AgentOnline BIT DEFAULT NULL,
- SessionID VARCHAR(36) DEFAULT NULL,
- SecureSessionID VARCHAR(36) DEFAULT NULL,
- InitialRegion VARCHAR(255) DEFAULT NULL,
- Region VARCHAR(255) DEFAULT NULL,
- LoginTime INT DEFAULT NULL,
- LogoutTime INT DEFAULT NULL,
- Handle BIGINT DEFAULT NULL,
- PositionX DOUBLE DEFAULT NULL,
- PositionY DOUBLE DEFAULT NULL,
- PositionZ DOUBLE DEFAULT NULL,
- LookAtX DOUBLE DEFAULT NULL,
- LookAtY DOUBLE DEFAULT NULL,
- LookAtZ DOUBLE DEFAULT NULL,
- PRIMARY KEY (ProfileID)
-);
-
-CREATE TABLE UserProfiles (
- ID VARCHAR(36) NOT NULL,
- WebLoginKey VARCHAR(36) DEFAULT NULL,
- FirstName VARCHAR(32) DEFAULT NULL,
- SurName VARCHAR(32) DEFAULT NULL,
- Email VARCHAR(250) DEFAULT NULL,
- PasswordHash VARCHAR(32) DEFAULT NULL,
- PasswordSalt VARCHAR(32) DEFAULT NULL,
- HomeRegionID VARCHAR(36) DEFAULT NULL,
- HomeRegionX INT DEFAULT NULL,
- HomeRegionY INT DEFAULT NULL,
- HomeLocationX DOUBLE DEFAULT NULL,
- HomeLocationY DOUBLE DEFAULT NULL,
- HomeLocationZ DOUBLE DEFAULT NULL,
- HomeLookAtX DOUBLE DEFAULT NULL,
- HomeLookAtY DOUBLE DEFAULT NULL,
- HomeLookAtZ DOUBLE DEFAULT NULL,
- Created INT DEFAULT NULL,
- LastLogin INT DEFAULT NULL,
- UserInventoryURI VARCHAR(255) DEFAULT NULL,
- UserAssetURI VARCHAR(255) DEFAULT NULL,
- Image VARCHAR(36) DEFAULT NULL,
- FirstLifeImage VARCHAR(36) DEFAULT NULL,
- AboutText TEXT DEFAULT NULL,
- FirstLifeAboutText TEXT DEFAULT NULL,
- CanDoMask INT DEFAULT NULL,
- WantDoMask INT DEFAULT NULL,
- UserFlags INT DEFAULT NULL,
- GodLevel INT DEFAULT NULL,
- CustomType VARCHAR(32) DEFAULT NULL,
- Partner VARCHAR(36) DEFAULT NULL,
- RootInventoryFolderID VARCHAR(36) DEFAULT NULL,
- PRIMARY KEY (ID)
-);
-
-CREATE INDEX UserSurnameIndex ON UserProfiles (SurName);
-CREATE INDEX UserFirstNameIndex ON UserProfiles (FirstName);
-CREATE UNIQUE INDEX UserFullNameIndex ON UserProfiles (SurName,FirstName);
-
-CREATE TABLE UserAppearances (
- Owner VARCHAR(36) NOT NULL,
- BodyItem VARCHAR(36) DEFAULT NULL,
- BodyAsset VARCHAR(36) DEFAULT NULL,
- SkinItem VARCHAR(36) DEFAULT NULL,
- SkinAsset VARCHAR(36) DEFAULT NULL,
- HairItem VARCHAR(36) DEFAULT NULL,
- HairAsset VARCHAR(36) DEFAULT NULL,
- EyesItem VARCHAR(36) DEFAULT NULL,
- EyesAsset VARCHAR(36) DEFAULT NULL,
- ShirtItem VARCHAR(36) DEFAULT NULL,
- ShirtAsset VARCHAR(36) DEFAULT NULL,
- PantsItem VARCHAR(36) DEFAULT NULL,
- PantsAsset VARCHAR(36) DEFAULT NULL,
- ShoesItem VARCHAR(36) DEFAULT NULL,
- ShoesAsset VARCHAR(36) DEFAULT NULL,
- SocksItem VARCHAR(36) DEFAULT NULL,
- SocksAsset VARCHAR(36) DEFAULT NULL,
- JacketItem VARCHAR(36) DEFAULT NULL,
- JacketAsset VARCHAR(36) DEFAULT NULL,
- GlovesItem VARCHAR(36) DEFAULT NULL,
- GlovesAsset VARCHAR(36) DEFAULT NULL,
- UnderShirtItem VARCHAR(36) DEFAULT NULL,
- UnderShirtAsset VARCHAR(36) DEFAULT NULL,
- UnderPantsItem VARCHAR(36) DEFAULT NULL,
- UnderPantsAsset VARCHAR(36) DEFAULT NULL,
- SkirtItem VARCHAR(36) DEFAULT NULL,
- SkirtAsset VARCHAR(36) DEFAULT NULL,
- Texture BLOB,
- VisualParams BLOB,
- Serial INT DEFAULT NULL,
- AvatarHeight FLOAT DEFAULT NULL,
- PRIMARY KEY (Owner)
-);
-
-CREATE TABLE UserFriends (
- UserFriendID VARCHAR(36) NOT NULL,
- OwnerID VARCHAR(36) DEFAULT NULL,
- FriendID VARCHAR(36) DEFAULT NULL,
- FriendPermissions INT DEFAULT NULL,
- PRIMARY KEY (UserFriendID)
-);
-
-CREATE UNIQUE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID);
diff --git a/OpenSim/Data/NHibernate/Resources/UserAgentData.hbm.xml b/OpenSim/Data/NHibernate/Resources/UserAgentData.hbm.xml
deleted file mode 100644
index 70b6998..0000000
--- a/OpenSim/Data/NHibernate/Resources/UserAgentData.hbm.xml
+++ /dev/null
@@ -1,32 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/UserAppearance.hbm.xml b/OpenSim/Data/NHibernate/Resources/UserAppearance.hbm.xml
deleted file mode 100644
index 21e547f..0000000
--- a/OpenSim/Data/NHibernate/Resources/UserAppearance.hbm.xml
+++ /dev/null
@@ -1,38 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/UserFriend.hbm.xml b/OpenSim/Data/NHibernate/Resources/UserFriend.hbm.xml
deleted file mode 100644
index cb23858..0000000
--- a/OpenSim/Data/NHibernate/Resources/UserFriend.hbm.xml
+++ /dev/null
@@ -1,11 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
diff --git a/OpenSim/Data/NHibernate/Resources/UserProfileData.hbm.xml b/OpenSim/Data/NHibernate/Resources/UserProfileData.hbm.xml
deleted file mode 100644
index 5b1f9b0..0000000
--- a/OpenSim/Data/NHibernate/Resources/UserProfileData.hbm.xml
+++ /dev/null
@@ -1,38 +0,0 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
--
cgit v1.1