2 files changed, 54 insertions, 54 deletions

diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql
index 9aebfa3..6f5885e 100644
--- a/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql
+++ b/OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql
@@ -1,14 +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

+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 7875c50..c5d8329 100644
--- a/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql
+++ b/OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql
@@ -1,40 +1,40 @@
-SET ANSI_NULLS ON

-

-SET QUOTED_IDENTIFIER ON

-

-SET ANSI_PADDING ON

-

-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,

- [regionRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [regionSecret] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [regionSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [regionDataURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [serverIP] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [serverPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [serverURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [locX] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [locY] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [locZ] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [eastOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [westOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [southOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [northOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [regionAssetURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [regionAssetRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [regionAssetSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [regionUserURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [regionUserRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [regionUserSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [regionMapTexture] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [serverHttpPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

- [serverRemotingPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,

-PRIMARY KEY CLUSTERED 

-(

- [uuid] ASC

-)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]

-) ON [PRIMARY]

-

-SET ANSI_PADDING OFF

+SET ANSI_NULLS ON
+
+SET QUOTED_IDENTIFIER ON
+
+SET ANSI_PADDING ON
+
+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,
+ [regionRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [regionSecret] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [regionSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [regionDataURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [serverIP] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [serverPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [serverURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [locX] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [locY] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [locZ] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [eastOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [westOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [southOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [northOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [regionAssetURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [regionAssetRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [regionAssetSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [regionUserURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [regionUserRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [regionUserSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [regionMapTexture] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [serverHttpPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+ [serverRemotingPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
+PRIMARY KEY CLUSTERED 
+(
+ [uuid] ASC
+)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_PADDING OFF