diff options
| author | John Hurliman | 2010-02-05 17:46:37 -0800 |
|---|---|---|
| committer | John Hurliman | 2010-02-05 17:46:37 -0800 |
| commit | e251f4244388363e2f6fca11edd2efe133324057 (patch) | |
| tree | 15634544372d8481e7ba6e9b7f651b930ea7bc32 /OpenSim/Data/MySQL/Resources | |
| parent | Fixing an incorrect logging message in insertUserRow (diff) | |
| parent | Clarify some names (diff) | |
| download | opensim-SC-e251f4244388363e2f6fca11edd2efe133324057.zip opensim-SC-e251f4244388363e2f6fca11edd2efe133324057.tar.gz opensim-SC-e251f4244388363e2f6fca11edd2efe133324057.tar.bz2 opensim-SC-e251f4244388363e2f6fca11edd2efe133324057.tar.xz | |
Merge branch 'presence-refactor' of ssh://opensimulator.org/var/git/opensim into presence-refactor
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/001_FriendsStore.sql | 5 | ||||
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/002_FriendsStore.sql | 5 |
2 files changed, 10 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_FriendsStore.sql b/OpenSim/Data/MySQL/Resources/001_FriendsStore.sql new file mode 100644 index 0000000..da2c59c --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/001_FriendsStore.sql | |||
| @@ -0,0 +1,5 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | CREATE TABLE `Friends` (`PrincipalID` CHAR(36) NOT NULL, `Friend` VARCHAR(255) NOT NULL, `Flags` VARCHAR(16) NOT NULL DEFAULT 0, `Offered` VARCHAR(32) NOT NULL DEFAULT 0, PRIMARY KEY(`PrincipalID`, `Friend`), KEY(`PrincipalID`)); | ||
| 4 | |||
| 5 | COMMIT; | ||
diff --git a/OpenSim/Data/MySQL/Resources/002_FriendsStore.sql b/OpenSim/Data/MySQL/Resources/002_FriendsStore.sql new file mode 100644 index 0000000..a363867 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/002_FriendsStore.sql | |||
| @@ -0,0 +1,5 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | INSERT INTO `Friends` SELECT `ownerID`, `friendID`, `friendPerms`, 0 FROM `userfriends`; | ||
| 4 | |||
| 5 | COMMIT; | ||