diff options
| author | Justin Clark-Casey (justincc) | 2011-04-28 23:43:42 +0100 |
|---|---|---|
| committer | Justin Clark-Casey (justincc) | 2011-04-28 23:43:42 +0100 |
| commit | 5e578c97558c818a5d4738e140e9301dd2e86c44 (patch) | |
| tree | 4bf3535e10e6dbcb1e5660115fc4c7c274da0e8e /OpenSim/Data/MSSQL/Resources/FriendsStore.migrations | |
| parent | Stop CHANGED_INVENTORY firing twice if a notecard is edited in prim. (diff) | |
| parent | Added MrMonkE to the contributors. Fixed contributors. (diff) | |
| download | opensim-SC-5e578c97558c818a5d4738e140e9301dd2e86c44.zip opensim-SC-5e578c97558c818a5d4738e140e9301dd2e86c44.tar.gz opensim-SC-5e578c97558c818a5d4738e140e9301dd2e86c44.tar.bz2 opensim-SC-5e578c97558c818a5d4738e140e9301dd2e86c44.tar.xz | |
Merge branch 'master' of ssh://opensimulator.org/var/git/opensim
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/FriendsStore.migrations')
| -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 |