diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql | 14 | ||||
-rw-r--r-- | OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql | 9 |
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 @@ | |||
1 | SET ANSI_NULLS ON | ||
2 | |||
3 | SET QUOTED_IDENTIFIER ON | ||
4 | |||
5 | SET ANSI_PADDING ON | ||
6 | |||
7 | CREATE TABLE [dbo].[userfriends]( | ||
8 | [ownerID] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL, | ||
9 | [friendID] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL, | ||
10 | [friendPerms] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, | ||
11 | [datetimestamp] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL | ||
12 | ) ON [PRIMARY] | ||
13 | |||
14 | 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 @@ | |||
1 | SET ANSI_NULLS ON | 1 | SET ANSI_NULLS ON |
2 | GO | 2 | |
3 | SET QUOTED_IDENTIFIER ON | 3 | SET QUOTED_IDENTIFIER ON |
4 | GO | 4 | |
5 | SET ANSI_PADDING ON | 5 | SET ANSI_PADDING ON |
6 | GO | 6 | |
7 | CREATE TABLE [db_owner].[regions]( | 7 | CREATE TABLE [dbo].[regions]( |
8 | [regionHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 8 | [regionHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
9 | [regionName] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 9 | [regionName] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
10 | [uuid] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL, | 10 | [uuid] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL, |
@@ -37,5 +37,4 @@ PRIMARY KEY CLUSTERED | |||
37 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | 37 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] |
38 | ) ON [PRIMARY] | 38 | ) ON [PRIMARY] |
39 | 39 | ||
40 | GO | ||
41 | SET ANSI_PADDING OFF | 40 | SET ANSI_PADDING OFF |