* Split out MSSQLManager Test/Init into each provider.

* Made regions table name configurable (MSSQL only)
* Added a note in ini.example pointing out that the sql resources have to change if you change table names
* Removed duplicate picker method from GridData interface
[Provided by openlifegrid.com]

1 files changed, 41 insertions, 0 deletions

diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql
new file mode 100644
index 0000000..b46da16
--- /dev/null
+++ b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql
@@ -0,0 +1,41 @@
+SET ANSI_NULLS ON

+GO

+SET QUOTED_IDENTIFIER ON

+GO

+SET ANSI_PADDING ON

+GO

+CREATE TABLE [db_owner].[regions](

+ [regionHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionName] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [uuid] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,

+ [regionRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionSecret] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionDataURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [serverIP] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [serverPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [serverURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [locX] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [locY] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [locZ] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [eastOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [westOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [southOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [northOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionAssetURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionAssetRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionAssetSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionUserURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionUserRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionUserSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [regionMapTexture] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [serverHttpPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+ [serverRemotingPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

+PRIMARY KEY CLUSTERED 

+(

+ [uuid] ASC

+)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]

+) ON [PRIMARY]

+

+GO

+SET ANSI_PADDING OFF