diff options
| author | Melanie | 2010-02-05 12:31:29 +0000 |
|---|---|---|
| committer | Melanie | 2010-02-05 12:31:29 +0000 |
| commit | b92cb6126d8ca59121468fce44dc7b4c3b805181 (patch) | |
| tree | 616a8da65aa49fe2821b9b1c4898ff3ada87f565 /OpenSim/Data/MySQL/Resources | |
| parent | Finally cutting the gordian knot. Friends needs to be both a module and a (diff) | |
| download | opensim-SC_OLD-b92cb6126d8ca59121468fce44dc7b4c3b805181.zip opensim-SC_OLD-b92cb6126d8ca59121468fce44dc7b4c3b805181.tar.gz opensim-SC_OLD-b92cb6126d8ca59121468fce44dc7b4c3b805181.tar.bz2 opensim-SC_OLD-b92cb6126d8ca59121468fce44dc7b4c3b805181.tar.xz | |
Implement the friends data adaptor
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; | ||