Userfriends
From OpenSimulator
(Difference between revisions)
m (Robot: Cosmetic changes) |
|||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
| − | {{ | + | {{Quicklinks}} |
<br /> | <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 17: | 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> | + | (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 20: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)
