Tables/session: Difference between revisions
From Joomla! Documentation
< Tables
< Tables
class="wikitable" |
m categorisation |
||
| Line 1: | Line 1: | ||
== Usage | == Usage == | ||
* Since: | * Since: | ||
== Description | == Description == | ||
{| class="wikitable" border="1" | {| class="wikitable" border="1" | ||
| Line 41: | Line 41: | ||
* Default character set: '''utf8''' | * Default character set: '''utf8''' | ||
<noinclude>[[Category:Database]]</noinclude> | |||
Latest revision as of 15:38, 16 March 2013
Usage
- Since:
Description
| Field | Type | Nullable | Default | Key | Extra | Comments |
| session_id | varchar(32) | NOT NULL | PK | |||
| client_id | tinyint(3) unsigned | NOT NULL | 0 | |||
| guest | tinyint(4) unsigned | 1 | ||||
| time | varchar(14) | |||||
| data | varchar(20480) | NULL | ||||
| userid | int(11) | 0 | ||||
| username | varchar(150) | |||||
| usertype | varchar(50) |
Notes
| Index Name | Column(s) | Unique? |
| whosonline | guest, usertype | No |
| userid | userid | No |
| time | time | No |
- Default character set: utf8