diff options
Diffstat (limited to 'OpenSim/Framework/Data.MSSQL/Resources')
-rw-r--r-- | OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql | 28 | ||||
-rw-r--r-- | OpenSim/Framework/Data.MSSQL/Resources/Mssql-regions.sql | 80 |
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 @@ | |||
1 | SET ANSI_NULLS ON | 1 | SET ANSI_NULLS ON |
2 | 2 | ||
3 | SET QUOTED_IDENTIFIER ON | 3 | SET QUOTED_IDENTIFIER ON |
4 | 4 | ||
5 | SET ANSI_PADDING ON | 5 | SET ANSI_PADDING ON |
6 | 6 | ||
7 | CREATE TABLE [dbo].[userfriends]( | 7 | CREATE TABLE [dbo].[userfriends]( |
8 | [ownerID] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL, | 8 | [ownerID] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL, |
9 | [friendID] [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, | 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 | 11 | [datetimestamp] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL |
12 | ) ON [PRIMARY] | 12 | ) ON [PRIMARY] |
13 | 13 | ||
14 | SET ANSI_PADDING OFF | 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 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 @@ | |||
1 | SET ANSI_NULLS ON | 1 | SET ANSI_NULLS ON |
2 | 2 | ||
3 | SET QUOTED_IDENTIFIER ON | 3 | SET QUOTED_IDENTIFIER ON |
4 | 4 | ||
5 | SET ANSI_PADDING ON | 5 | SET ANSI_PADDING ON |
6 | 6 | ||
7 | CREATE TABLE [dbo].[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, |
11 | [regionRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 11 | [regionRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
12 | [regionSecret] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 12 | [regionSecret] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
13 | [regionSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 13 | [regionSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
14 | [regionDataURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 14 | [regionDataURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
15 | [serverIP] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 15 | [serverIP] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
16 | [serverPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 16 | [serverPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
17 | [serverURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 17 | [serverURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
18 | [locX] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 18 | [locX] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
19 | [locY] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 19 | [locY] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
20 | [locZ] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 20 | [locZ] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
21 | [eastOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 21 | [eastOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
22 | [westOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 22 | [westOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
23 | [southOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 23 | [southOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
24 | [northOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 24 | [northOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
25 | [regionAssetURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 25 | [regionAssetURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
26 | [regionAssetRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 26 | [regionAssetRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
27 | [regionAssetSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 27 | [regionAssetSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
28 | [regionUserURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 28 | [regionUserURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
29 | [regionUserRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 29 | [regionUserRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
30 | [regionUserSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 30 | [regionUserSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
31 | [regionMapTexture] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 31 | [regionMapTexture] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
32 | [serverHttpPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 32 | [serverHttpPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
33 | [serverRemotingPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL, | 33 | [serverRemotingPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL, |
34 | PRIMARY KEY CLUSTERED | 34 | PRIMARY KEY CLUSTERED |
35 | ( | 35 | ( |
36 | [uuid] ASC | 36 | [uuid] ASC |
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 | SET ANSI_PADDING OFF | 40 | SET ANSI_PADDING OFF |