* Moved insertRegionRow into MSSQLGridData

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

1 files changed, 14 insertions, 0 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