pma__bookmark

Table comments: Bookmarks

ColumnTypeNullDefault Links to Comments MIME
id (Primary)int(11)No
dbasevarchar(255)No
uservarchar(255)No
labelvarchar(255)No
querytextNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

pma__central_columns

Table comments: Central list of columns

ColumnTypeNullDefault Links to Comments MIME
db_name (Primary)varchar(64)No
col_name (Primary)varchar(64)No
col_typevarchar(64)No
col_lengthtextYesNULL
col_collationvarchar(64)No
col_isNulltinyint(1)No
col_extravarchar(255)Yes
col_defaulttextYesNULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodb_name0ANo
col_name0ANo

pma__column_info

Table comments: Column information for phpMyAdmin

ColumnTypeNullDefault Links to Comments MIME
id (Primary)int(5)No
db_namevarchar(64)No
table_namevarchar(64)No
column_namevarchar(64)No
commentvarchar(255)No
mimetypevarchar(255)No
transformationvarchar(255)No
transformation_optionsvarchar(255)No
input_transformationvarchar(255)No
input_transformation_optionsvarchar(255)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
db_nameBTREEYesNodb_name0ANo
table_name0ANo
column_name0ANo

pma__designer_settings

Table comments: Settings related to Designer

ColumnTypeNullDefault Links to Comments MIME
username (Primary)varchar(64)No
settings_datatextNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNousername0ANo

pma__export_templates

Table comments: Saved export templates

ColumnTypeNullDefault Links to Comments MIME
id (Primary)int(5)No
usernamevarchar(64)No
export_typevarchar(10)No
template_namevarchar(64)No
template_datatextNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
u_user_type_templateBTREEYesNousername0ANo
export_type0ANo
template_name0ANo

pma__favorite

Table comments: Favorite tables

ColumnTypeNullDefault Links to Comments MIME
username (Primary)varchar(64)No
tablestextNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNousername0ANo

pma__history

Table comments: SQL history for phpMyAdmin

ColumnTypeNullDefault Links to Comments MIME
id (Primary)bigint(20)No
usernamevarchar(64)No
dbvarchar(64)No
tablevarchar(64)No
timevaluetimestampNoCURRENT_TIMESTAMP
sqlquerytextNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
usernameBTREENoNousername0ANo
db0ANo
table0ANo
timevalue0ANo

pma__navigationhiding

Table comments: Hidden items of navigation tree

ColumnTypeNullDefault Links to Comments MIME
username (Primary)varchar(64)No
item_name (Primary)varchar(64)No
item_type (Primary)varchar(64)No
db_name (Primary)varchar(64)No
table_name (Primary)varchar(64)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNousername0ANo
item_name0ANo
item_type0ANo
db_name0ANo
table_name0ANo

pma__pdf_pages

Table comments: PDF relation pages for phpMyAdmin

ColumnTypeNullDefault Links to Comments MIME
db_namevarchar(64)No
page_nr (Primary)int(10)No
page_descrvarchar(50)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNopage_nr0ANo
db_nameBTREENoNodb_name0ANo

pma__recent

Table comments: Recently accessed tables

ColumnTypeNullDefault Links to Comments MIME
username (Primary)varchar(64)No
tablestextNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNousername0ANo

pma__relation

Table comments: Relation table

ColumnTypeNullDefault Links to Comments MIME
master_db (Primary)varchar(64)No
master_table (Primary)varchar(64)No
master_field (Primary)varchar(64)No
foreign_dbvarchar(64)No
foreign_tablevarchar(64)No
foreign_fieldvarchar(64)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNomaster_db0ANo
master_table0ANo
master_field0ANo
foreign_fieldBTREENoNoforeign_db0ANo
foreign_table0ANo

pma__savedsearches

Table comments: Saved searches

ColumnTypeNullDefault Links to Comments MIME
id (Primary)int(5)No
usernamevarchar(64)No
db_namevarchar(64)No
search_namevarchar(64)No
search_datatextNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
u_savedsearches_username_dbnameBTREEYesNousername0ANo
db_name0ANo
search_name0ANo

pma__table_coords

Table comments: Table coordinates for phpMyAdmin PDF output

ColumnTypeNullDefault Links to Comments MIME
db_name (Primary)varchar(64)No
table_name (Primary)varchar(64)No
pdf_page_number (Primary)int(11)No0
xfloatNo0
yfloatNo0

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodb_name0ANo
table_name0ANo
pdf_page_number0ANo

pma__table_info

Table comments: Table information for phpMyAdmin

ColumnTypeNullDefault Links to Comments MIME
db_name (Primary)varchar(64)No
table_name (Primary)varchar(64)No
display_fieldvarchar(64)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodb_name0ANo
table_name0ANo

pma__table_uiprefs

Table comments: Tables' UI preferences

ColumnTypeNullDefault Links to Comments MIME
username (Primary)varchar(64)No
db_name (Primary)varchar(64)No
table_name (Primary)varchar(64)No
prefstextNo
last_updatetimestampNoCURRENT_TIMESTAMP

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNousername2ANo
db_name5ANo
table_name10ANo

pma__tracking

Table comments: Database changes tracking for phpMyAdmin

ColumnTypeNullDefault Links to Comments MIME
db_name (Primary)varchar(64)No
table_name (Primary)varchar(64)No
version (Primary)int(10)No
date_createddatetimeNo
date_updateddatetimeNo
schema_snapshottextNo
schema_sqltextYesNULL
data_sqllongtextYesNULL
trackingset('UPDATE', 'REPLACE', 'INSERT', 'DELETE', 'TRUNCATE', 'CREATE DATABASE', 'ALTER DATABASE', 'DROP DATABASE', 'CREATE TABLE', 'ALTER TABLE', 'RENAME TABLE', 'DROP TABLE', 'CREATE INDEX', 'DROP INDEX', 'CREATE VIEW', 'ALTER VIEW', 'DROP VIEW')YesNULL
tracking_activeint(1)No1

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodb_name0ANo
table_name0ANo
version0ANo

pma__userconfig

Table comments: User preferences storage for phpMyAdmin

ColumnTypeNullDefault Links to Comments MIME
username (Primary)varchar(64)No
timevaluetimestampNoCURRENT_TIMESTAMP
config_datatextNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNousername0ANo

pma__usergroups

Table comments: User groups with configured menu items

ColumnTypeNullDefault Links to Comments MIME
usergroup (Primary)varchar(64)No
tab (Primary)varchar(64)No
allowed (Primary)enum('Y', 'N')NoN

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNousergroup0ANo
tab0ANo
allowed0ANo

pma__users

Table comments: Users and their assignments to user groups

ColumnTypeNullDefault Links to Comments MIME
username (Primary)varchar(64)No
usergroup (Primary)varchar(64)No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNousername0ANo
usergroup0ANo