Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: jos_sessionjos_session

jos_session

Field Type Null Default
username  varchar(150) Yes   
time  varchar(14) Yes   
session_id  varchar(200) No 
guest  tinyint(4) Yes 
userid  int(11) Yes 
usertype  varchar(50) Yes   
gid  tinyint(3) No 
client_id  tinyint(3) No 
data  longtext Yes  NULL 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 1 session_id 64
session_id_2 UNIQUE 1 session_id
client_id_3 UNIQUE 1 client_id
gid_3 UNIQUE 1 gid
session_id_5 UNIQUE 1 session_id
gid_4 UNIQUE 1 gid
session_id_9 UNIQUE 1 session_id
client_id_5 UNIQUE 1 client_id
time_3 UNIQUE None time
userid_3 UNIQUE None userid
guest_3 UNIQUE None guest
usertype_5 UNIQUE None usertype
username_4 UNIQUE None username
time_7 UNIQUE None time
username_7 UNIQUE None username
usertype_6 UNIQUE None usertype
time_9 UNIQUE None time
guest_4 UNIQUE None guest
userid_6 UNIQUE None userid
userid_7 UNIQUE None userid
whosonline INDEX None guest
usertype
userid INDEX None userid
time INDEX None time
username INDEX None username
time_2 INDEX None time
session_id INDEX None session_id
guest INDEX None guest
userid_2 INDEX None userid
usertype INDEX None usertype
gid INDEX None gid
client_id INDEX None client_id
client_id_2 INDEX None client_id
guest_2 INDEX None guest
gid_2 INDEX None gid
usertype_4 INDEX None usertype
session_id_4 INDEX None session_id
username_3 INDEX None username
time_5 INDEX None time
userid_4 INDEX None userid
username_6 INDEX None username
client_id_4 INDEX None client_id
userid_5 INDEX None userid
gid_5 INDEX None gid
usertype_7 INDEX None usertype
time_8 INDEX None time
session_id_8 INDEX None session_id
guest_5 INDEX None guest
username_9 INDEX None username
client_id_6 INDEX None client_id
username_2 INDEX None username
time_4 INDEX None time
session_id_3 INDEX None session_id
usertype_2 INDEX None usertype
data INDEX None data
usertype_3 INDEX None usertype
username_5 INDEX None username
time_6 INDEX None time
session_id_6 INDEX None session_id
data_2 INDEX None data
session_id_7 INDEX None session_id
usertype_8 INDEX None usertype
username_8 INDEX None username
time_10 INDEX None time
data_3 INDEX None data


 Space usage :
Type Usage
Data 7,352 Bytes
Index 4,096 Bytes
Overhead 6,152 Bytes
Effective 5,296 Bytes
Total 11,448 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 1
Row length ø 1,200
Row size  ø 11,448 Bytes
Creation Dec 11, 2017 at 08:04 PM
Last update Apr 24, 2018 at 01:23 AM
Last check Apr 19, 2018 at 05:19 PM