Userfriends
From OpenSimulator
(Difference between revisions)
(New page: Category:Database '''Userfriends''' ''Records user friendship relationship details '' (back to Database Documentation) <br><br> The current stru...) |
m (Robot: Cosmetic changes) |
||
| (3 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | __NOTOC__ | |
| + | {{Quicklinks}} | ||
| + | <br /> | ||
'''Userfriends''' ''Records user friendship relationship details '' (back to [[Database Documentation]]) | '''Userfriends''' ''Records user friendship relationship details '' (back to [[Database Documentation]]) | ||
| − | <br><br> | + | <br /><br /> |
| − | The current structure of the Userfriends table is as follows:<br> | + | The current structure of the Userfriends table is as follows:<br /> |
| − | <br> | + | <br /> |
<table> | <table> | ||
| − | <tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr> | + | <tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr> |
<tr><td> </td></tr> | <tr><td> </td></tr> | ||
<tr><td>ownerID</td><td>varchar(37)</td><td>NO</td><td>PRI</td><td></td><td></td></tr> | <tr><td>ownerID</td><td>varchar(37)</td><td>NO</td><td>PRI</td><td></td><td></td></tr> | ||
| Line 13: | Line 15: | ||
<tr><td>datetimestamp</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td><td></td><tr> | <tr><td>datetimestamp</td><td>int(11)</td><td>NO</td><td></td><td></td><td></td><td></td><tr> | ||
</table> | </table> | ||
| − | <br> | + | <br /> |
| − | < | + | (back to [[Database Documentation]])<br /> |
| + | ---- | ||
'''ownerID''' | '''ownerID''' | ||
| − | <br> | + | <br /> |
The UUID of the user who offered the friendship. | The UUID of the user who offered the friendship. | ||
| − | <br> | + | <br /> |
| − | <br> | + | <br /> |
'''friendID''' | '''friendID''' | ||
| − | <br> | + | <br /> |
The UUID of the user who accepted the offer of friendship. | The UUID of the user who accepted the offer of friendship. | ||
| − | <br> | + | <br /> |
| − | <br> | + | <br /> |
'''friendperms''' | '''friendperms''' | ||
| − | <br> | + | <br /> |
The permissions the "friendID" has in this friendship. | The permissions the "friendID" has in this friendship. | ||
| − | <br> | + | <br /> |
| − | <br> | + | <br /> |
'''datetimestamp''' | '''datetimestamp''' | ||
| − | <br> | + | <br /> |
The date and time the friendship was created. | The date and time the friendship was created. | ||
| − | <br> | + | <br /> |
| − | <br> | + | <br /> |
| − | + | ---- | |
| − | (back to [[Database Documentation]])<br> | + | (back to [[Database Documentation]])<br /> |
| + | |||
| + | [[Category:Database]] | ||
[[Category:Database]] | [[Category:Database]] | ||
Latest revision as of 21:18, 3 March 2012
 |
Languages: |
|
Userfriends Records user friendship relationship details (back to Database Documentation)
The current structure of the Userfriends table is as follows:
| Field | Type | Null | Key | Default | Extra | |
| ownerID | varchar(37) | NO | PRI | |||
| friendID | varchar(37) | NO | PRI | |||
| friendPerms | int(11) | NO | ||||
| datetimestamp | int(11) | NO | ||||
(back to Database Documentation)
ownerID
The UUID of the user who offered the friendship.
friendID
The UUID of the user who accepted the offer of friendship.
friendperms
The permissions the "friendID" has in this friendship.
datetimestamp
The date and time the friendship was created.
(back to Database Documentation)
