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

---
 .../Data.MSSQL/Resources/CreateUserFriendsTable.sql        | 14 ++++++++++++++
 OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql   |  9 ++++-----
 2 files changed, 18 insertions(+), 5 deletions(-)
 create mode 100644 OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql

(limited to 'OpenSim/Framework/Data.MSSQL/Resources')

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
-- 
cgit v1.1