From 020f38774fbe8e0f53b0cb28ab49b378b9dcd325 Mon Sep 17 00:00:00 2001
From: AlexRa
Date: Thu, 6 May 2010 23:16:36 +0300
Subject: MS SQL migrations converted to the new format

---
 OpenSim/Data/MSSQL/Resources/001_EstateStore.sql | 85 ------------------------
 1 file changed, 85 deletions(-)
 delete 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
deleted file mode 100644
index 9bb2f75..0000000
--- a/OpenSim/Data/MSSQL/Resources/001_EstateStore.sql
+++ /dev/null
@@ -1,85 +0,0 @@
-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