Database:Agents
From OpenSimulator
(Difference between revisions)
| Line 3: | Line 3: | ||
The current structure of the agents table is as follows:<br> | The current structure of the agents 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> | ||
| Line 19: | Line 18: | ||
<tr><td>currentPos</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><br> | <tr><td>currentPos</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><br> | ||
</table> | </table> | ||
| − | |||
<br> | <br> | ||
Revision as of 11:50, 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 |
