Database:Agents
From OpenSimulator
(Difference between revisions)
(New page: '''agents''' ''Records agent (Avatar/User) login details'' <br> The current structure of the agents table is as follows:<br> <br> <code> <table> <tr><td>Field<br></td><td>Type</td><td>Null...) |
|||
| Line 1: | Line 1: | ||
'''agents''' ''Records agent (Avatar/User) login details'' | '''agents''' ''Records agent (Avatar/User) login details'' | ||
| − | <br> | + | <br><br> |
The current structure of the agents table is as follows:<br> | The current structure of the agents table is as follows:<br> | ||
<br> | <br> | ||
| Line 16: | Line 16: | ||
<tr><td>logoutTime</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr> | <tr><td>logoutTime</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr> | ||
<tr><td>currentRegion</td><td>varchar(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr> | <tr><td>currentRegion</td><td>varchar(36)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr> | ||
| − | <tr><td>currentHandle | + | <tr><td>currentHandle</td><td>bigint(20) unsigned</td><td>NO</td><td></td><td>NULL</td><td></td></tr> |
| − | <tr><td>currentPos | + | <tr><td>currentPos</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><br> |
</table> | </table> | ||
</code> | </code> | ||
<br> | <br> | ||
Revision as of 10:49, 21 July 2008
agents Records agent (Avatar/User) login details
The current structure of the agents table is as follows:
| Field | Type | Null | Key | Default | Extra | |
| UUID | varchar(36) | NO | PRI | NULL | ||
| sessionID | varchar(36) | NO | UNI | NULL | ||
| secureSessionID | varchar(36) | NO | UNI | NULL | ||
| agentIP | varchar(16) | NO | NULL | |||
| agentPort | int(11) | NO | NULL | |||
| agentOnline | tinyint(4) | NO | NULL | |||
| loginTime | int(11) | NO | NULL | |||
| logoutTime | int(11) | NO | NULL | |||
| currentRegion | varchar(36) | NO | NULL | |||
| currentHandle | bigint(20) unsigned | NO | NULL | |||
| currentPos | varchar(64) | NO | NULL |
</code>
