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

   Field  Type Collation Attributes Null Default Extra Action
   varchar(150) utf8_general_ci   Yes      Change Drop Primary Index Unique Fulltext
   varchar(14) utf8_general_ci   Yes      Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   No    Change Drop Primary Index Unique Fulltext
   tinyint(4)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   Yes      Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   longtext utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop session_id 64
session_id_2 UNIQUE Edit Drop session_id
client_id_3 UNIQUE Edit Drop client_id
gid_3 UNIQUE Edit Drop gid
session_id_5 UNIQUE Edit Drop session_id
gid_4 UNIQUE Edit Drop gid
session_id_9 UNIQUE Edit Drop session_id
client_id_5 UNIQUE Edit Drop client_id
time_3 UNIQUE None  Edit Drop time
userid_3 UNIQUE None  Edit Drop userid
guest_3 UNIQUE None  Edit Drop guest
usertype_5 UNIQUE None  Edit Drop usertype
username_4 UNIQUE None  Edit Drop username
time_7 UNIQUE None  Edit Drop time
username_7 UNIQUE None  Edit Drop username
usertype_6 UNIQUE None  Edit Drop usertype
time_9 UNIQUE None  Edit Drop time
guest_4 UNIQUE None  Edit Drop guest
userid_6 UNIQUE None  Edit Drop userid
userid_7 UNIQUE None  Edit Drop userid
whosonline INDEX None  Edit Drop guest
usertype
userid INDEX None  Edit Drop userid
time INDEX None  Edit Drop time
username INDEX None  Edit Drop username
time_2 INDEX None  Edit Drop time
session_id INDEX None  Edit Drop session_id
guest INDEX None  Edit Drop guest
userid_2 INDEX None  Edit Drop userid
usertype INDEX None  Edit Drop usertype
gid INDEX None  Edit Drop gid
client_id INDEX None  Edit Drop client_id
client_id_2 INDEX None  Edit Drop client_id
guest_2 INDEX None  Edit Drop guest
gid_2 INDEX None  Edit Drop gid
usertype_4 INDEX None  Edit Drop usertype
session_id_4 INDEX None  Edit Drop session_id
username_3 INDEX None  Edit Drop username
time_5 INDEX None  Edit Drop time
userid_4 INDEX None  Edit Drop userid
username_6 INDEX None  Edit Drop username
client_id_4 INDEX None  Edit Drop client_id
userid_5 INDEX None  Edit Drop userid
gid_5 INDEX None  Edit Drop gid
usertype_7 INDEX None  Edit Drop usertype
time_8 INDEX None  Edit Drop time
session_id_8 INDEX None  Edit Drop session_id
guest_5 INDEX None  Edit Drop guest
username_9 INDEX None  Edit Drop username
client_id_6 INDEX None  Edit Drop client_id
username_2 FULLTEXT None  Edit Drop username
time_4 FULLTEXT None  Edit Drop time
session_id_3 FULLTEXT None  Edit Drop session_id
usertype_2 FULLTEXT None  Edit Drop usertype
data FULLTEXT None  Edit Drop data
usertype_3 FULLTEXT None  Edit Drop usertype
username_5 FULLTEXT None  Edit Drop username
time_6 FULLTEXT None  Edit Drop time
session_id_6 FULLTEXT None  Edit Drop session_id
data_2 FULLTEXT None  Edit Drop data
session_id_7 FULLTEXT None  Edit Drop session_id
usertype_8 FULLTEXT None  Edit Drop usertype
username_8 FULLTEXT None  Edit Drop username
time_10 FULLTEXT None  Edit Drop time
data_3 FULLTEXT None  Edit Drop data
Create an index on  columns  
 
Space usage: 
Type Usage
Data 65,260 Bytes
Index 4,096 Bytes
Overhead 55,652 Bytes
Effective 13,704 Bytes
Total 69,356 Bytes
Optimize tableOptimize table
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 8
Row length ø 1,201
Row size  ø 8,670 Bytes
Creation Dec 11, 2017 at 08:04 PM
Last update May 22, 2018 at 07:08 AM
Last check Apr 19, 2018 at 05:19 PM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: