From b6bb5f944f19b330656105ff79cd5ca3f2d5c242 Mon Sep 17 00:00:00 2001
From: Melanie Thielker
Date: Mon, 1 Sep 2008 17:10:01 +0000
Subject: Mantis #2095 Thank you, RuudL, for a complete adaptation of migration
 and estate data to MSSQL, and the updating of the RegionData handling in
 MSSQL.

---
 OpenSim/Data/MSSQL/Resources/001_EstateStore.sql | 85 ++++++++++++++++++++++++
 1 file changed, 85 insertions(+)
 create mode 100644 OpenSim/Data/MSSQL/Resources/001_EstateStore.sql

(limited to 'OpenSim/Data/MSSQL/Resources/001_EstateStore.sql')

diff --git a/OpenSim/Data/MSSQL/Resources/001_EstateStore.sql b/OpenSim/Data/MSSQL/Resources/001_EstateStore.sql
new file mode 100644
index 0000000..9bb2f75
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/001_EstateStore.sql
@@ -0,0 +1,85 @@
+BEGIN TRANSACTION
+
+CREATE TABLE [dbo].[estate_managers](
+	[EstateID] [int] NOT NULL,
+	[uuid] [varchar](36) NOT NULL,
+ CONSTRAINT [PK_estate_managers] PRIMARY KEY CLUSTERED 
+(
+	[EstateID] ASC
+)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
+) ON [PRIMARY];
+
+CREATE TABLE [dbo].[estate_groups](
+	[EstateID] [int] NOT NULL,
+	[uuid] [varchar](36) NOT NULL,
+ CONSTRAINT [PK_estate_groups] PRIMARY KEY CLUSTERED 
+(
+	[EstateID] ASC
+)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
+) ON [PRIMARY];
+
+
+CREATE TABLE [dbo].[estate_users](
+	[EstateID] [int] NOT NULL,
+	[uuid] [varchar](36) NOT NULL,
+ CONSTRAINT [PK_estate_users] PRIMARY KEY CLUSTERED 
+(
+	[EstateID] ASC
+)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
+) ON [PRIMARY];
+
+
+CREATE TABLE [dbo].[estateban](
+	[EstateID] [int] NOT NULL,
+	[bannedUUID] [varchar](36) NOT NULL,
+	[bannedIp] [varchar](16) NOT NULL,
+	[bannedIpHostMask] [varchar](16) NOT NULL,
+	[bannedNameMask] [varchar](64) NULL DEFAULT (NULL),
+ CONSTRAINT [PK_estateban] PRIMARY KEY CLUSTERED 
+(
+	[EstateID] ASC
+)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
+) ON [PRIMARY];
+
+CREATE TABLE [dbo].[estate_settings](
+	[EstateID] [int] IDENTITY(1,100) NOT NULL,
+	[EstateName] [varchar](64) NULL DEFAULT (NULL),
+	[AbuseEmailToEstateOwner] [bit] NOT NULL,
+	[DenyAnonymous] [bit] NOT NULL,
+	[ResetHomeOnTeleport] [bit] NOT NULL,
+	[FixedSun] [bit] NOT NULL,
+	[DenyTransacted] [bit] NOT NULL,
+	[BlockDwell] [bit] NOT NULL,
+	[DenyIdentified] [bit] NOT NULL,
+	[AllowVoice] [bit] NOT NULL,
+	[UseGlobalTime] [bit] NOT NULL,
+	[PricePerMeter] [int] NOT NULL,
+	[TaxFree] [bit] NOT NULL,
+	[AllowDirectTeleport] [bit] NOT NULL,
+	[RedirectGridX] [int] NOT NULL,
+	[RedirectGridY] [int] NOT NULL,
+	[ParentEstateID] [int] NOT NULL,
+	[SunPosition] [float] NOT NULL,
+	[EstateSkipScripts] [bit] NOT NULL,
+	[BillableFactor] [float] NOT NULL,
+	[PublicAccess] [bit] NOT NULL,
+	[AbuseEmail] [varchar](255) NOT NULL,
+	[EstateOwner] [varchar](36) NOT NULL,
+	[DenyMinors] [bit] NOT NULL,
+ CONSTRAINT [PK_estate_settings] PRIMARY KEY CLUSTERED 
+(
+	[EstateID] ASC
+)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
+) ON [PRIMARY];
+
+
+CREATE TABLE [dbo].[estate_map](
+	[RegionID] [varchar](36) NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'),
+	[EstateID] [int] NOT NULL,
+ CONSTRAINT [PK_estate_map] PRIMARY KEY CLUSTERED 
+(
+	[RegionID] ASC
+)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
+) ON [PRIMARY];
+
+COMMIT
\ No newline at end of file
-- 
cgit v1.1

