diff options
| author | Melanie | 2009-12-28 19:12:33 +0000 |
|---|---|---|
| committer | Melanie | 2009-12-28 19:12:33 +0000 |
| commit | 2ed207509b0df83d1aaf49919df5978f6f70f934 (patch) | |
| tree | 6d3abbc9b80f5b982c500198ab9eb5bbca679eeb /OpenSim/Data/MySQL/Resources/002_Friends.sql | |
| parent | Merge branch 'presence-refactor' of ssh://diva@opensimulator.org/var/git/open... (diff) | |
| download | opensim-SC-2ed207509b0df83d1aaf49919df5978f6f70f934.zip opensim-SC-2ed207509b0df83d1aaf49919df5978f6f70f934.tar.gz opensim-SC-2ed207509b0df83d1aaf49919df5978f6f70f934.tar.bz2 opensim-SC-2ed207509b0df83d1aaf49919df5978f6f70f934.tar.xz | |
Add the second step of the friends migration to pull data from the old table into the new
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/002_Friends.sql')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/002_Friends.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/002_Friends.sql b/OpenSim/Data/MySQL/Resources/002_Friends.sql new file mode 100644 index 0000000..5ff6438 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/002_Friends.sql | |||
| @@ -0,0 +1,5 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | INSERT INTO Friends (PrincipalID, FriendID, Flags) SELECT ownerID, friendID, friendPerms FROM userfriends; | ||
| 4 | |||
| 5 | COMMIT; | ||