diff options
author | Diva Canto | 2011-04-28 07:28:29 -0700 |
---|---|---|
committer | Diva Canto | 2011-04-28 07:28:29 -0700 |
commit | 7ecf6895842eff93155e49d2f7fa4cd833510726 (patch) | |
tree | 76caa8db816b9b6d83dc945135e2a7f16c740d48 /OpenSim/Data/MSSQL/Resources/FriendsStore.migrations | |
parent | Fix a bug where physical objects rezzed with an initial velocity by script do... (diff) | |
download | opensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.zip opensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.tar.gz opensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.tar.bz2 opensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.tar.xz |
Thank you MrMonkE for a patch that seems to bring the MSSQL data layer up to speed with 0.7.x.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/FriendsStore.migrations | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations b/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations index f981a91..4d8ab0f 100644 --- a/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations +++ b/OpenSim/Data/MSSQL/Resources/FriendsStore.migrations | |||
@@ -15,6 +15,8 @@ COMMIT | |||
15 | 15 | ||
16 | BEGIN TRANSACTION | 16 | BEGIN TRANSACTION |
17 | 17 | ||
18 | INSERT INTO Friends (PrincipalID, Friend, Flags, Offered) SELECT [ownerID], [friendID], [friendPerms], 0 FROM userfriends; | 18 | IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[userfriends]') AND type in (N'U')) |
19 | INSERT INTO Friends (PrincipalID, Friend, Flags, Offered) | ||
20 | SELECT [ownerID], [friendID], [friendPerms], 0 FROM userfriends; | ||
19 | 21 | ||
20 | COMMIT \ No newline at end of file | 22 | COMMIT \ No newline at end of file |