From 15c6788dc79e7f6d802f0217198e3af21dff4e57 Mon Sep 17 00:00:00 2001 From: lbsa71 Date: Wed, 13 Feb 2008 20:08:46 +0000 Subject: * Moved insertRegionRow into MSSQLGridData * Split table test and creation into table by table * Debugged table creation Sql * Added missing CreateUserFriendsTable.sql --- OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) (limited to 'OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql') diff --git a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql index b46da16..7875c50 100644 --- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql +++ b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql @@ -1,10 +1,10 @@ SET ANSI_NULLS ON -GO + SET QUOTED_IDENTIFIER ON -GO + SET ANSI_PADDING ON -GO -CREATE TABLE [db_owner].[regions]( + +CREATE TABLE [dbo].[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, @@ -37,5 +37,4 @@ PRIMARY KEY CLUSTERED )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] -GO SET ANSI_PADDING OFF -- cgit v1.1