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 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql

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

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

