* Moved insertRegionRow into MSSQLGridData

* Split table test and creation into table by table
* Debugged table creation Sql
* Added missing CreateUserFriendsTable.sql

2 files changed, 18 insertions, 5 deletions

diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql
new file mode 100644
index 0000000..9aebfa3
--- /dev/null
+++ b/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql
@@ -0,0 +1,14 @@
+SET ANSI_NULLS ON

+

+SET QUOTED_IDENTIFIER ON

+

+SET ANSI_PADDING ON

+

+CREATE TABLE [dbo].[userfriends](

+[ownerID] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,

+[friendID] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,

+[friendPerms] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

+[datetimestamp] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

+) ON [PRIMARY]

+

+SET ANSI_PADDING OFF

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