diff options
Diffstat (limited to 'OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql')
-rw-r--r-- | OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql | 28 |
1 files changed, 14 insertions, 14 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 |