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 'OpenSim/Framework/Data.MSSQL/Resources/CreateUserFriendsTable.sql')
| -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 | ||