diff options
author | lbsa71 | 2008-02-13 20:08:46 +0000 |
---|---|---|
committer | lbsa71 | 2008-02-13 20:08:46 +0000 |
commit | 15c6788dc79e7f6d802f0217198e3af21dff4e57 (patch) | |
tree | ba6f22296ef68226725ecf224bf0e32dd4a1607b /OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql | |
parent | *fixed varchar size typo in createuserfriendstable.sql (diff) | |
download | opensim-SC-15c6788dc79e7f6d802f0217198e3af21dff4e57.zip opensim-SC-15c6788dc79e7f6d802f0217198e3af21dff4e57.tar.gz opensim-SC-15c6788dc79e7f6d802f0217198e3af21dff4e57.tar.bz2 opensim-SC-15c6788dc79e7f6d802f0217198e3af21dff4e57.tar.xz |
* Moved insertRegionRow into MSSQLGridData
* Split table test and creation into table by table
* Debugged table creation Sql
* Added missing CreateUserFriendsTable.sql
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql | 14 |
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 @@ | |||
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 | ||