phpmyadmin

pma__bookmark

Table comments: Bookmarks

Column Type Null Default Links to Comments Media type
id (Primary) int(10) No
dbase varchar(255) No
user varchar(255) No
label varchar(255) No
query text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 0 A No

pma__central_columns

Table comments: Central list of columns

Column Type Null Default Links to Comments Media type
db_name (Primary) varchar(64) No
col_name (Primary) varchar(64) No
col_type varchar(64) No
col_length text Yes NULL
col_collation varchar(64) No
col_isNull tinyint(1) No
col_extra varchar(255) Yes
col_default text Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No db_name 0 A No
col_name 0 A No

pma__column_info

Table comments: Column information for phpMyAdmin

Column Type Null Default Links to Comments Media type
id (Primary) int(5) No
db_name varchar(64) No
table_name varchar(64) No
column_name varchar(64) No
comment varchar(255) No
mimetype varchar(255) No
transformation varchar(255) No
transformation_options varchar(255) No
input_transformation varchar(255) No
input_transformation_options varchar(255) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 0 A No
db_name BTREE Yes No db_name 0 A No
table_name 0 A No
column_name 0 A No

pma__designer_settings

Table comments: Settings related to Designer

Column Type Null Default Links to Comments Media type
username (Primary) varchar(64) No
settings_data text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No username 0 A No

pma__export_templates

Table comments: Saved export templates

Column Type Null Default Links to Comments Media type
id (Primary) int(5) No
username varchar(64) No
export_type varchar(10) No
template_name varchar(64) No
template_data text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 0 A No
u_user_type_template BTREE Yes No username 0 A No
export_type 0 A No
template_name 0 A No

pma__favorite

Table comments: Favorite tables

Column Type Null Default Links to Comments Media type
username (Primary) varchar(64) No
tables text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No username 1 A No

pma__history

Table comments: SQL history for phpMyAdmin

Column Type Null Default Links to Comments Media type
id (Primary) bigint(20) No
username varchar(64) No
db varchar(64) No
table varchar(64) No
timevalue timestamp No current_timestamp()
sqlquery text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 0 A No
username BTREE No No username 0 A No
db 0 A No
table 0 A No
timevalue 0 A No

pma__navigationhiding

Table comments: Hidden items of navigation tree

Column Type Null Default Links to Comments Media type
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

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No username 0 A No
item_name 0 A No
item_type 0 A No
db_name 0 A No
table_name 0 A No

pma__pdf_pages

Table comments: PDF relation pages for phpMyAdmin

Column Type Null Default Links to Comments Media type
db_name varchar(64) No
page_nr (Primary) int(10) No
page_descr varchar(50) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No page_nr 0 A No
db_name BTREE No No db_name 0 A No

pma__recent

Table comments: Recently accessed tables

Column Type Null Default Links to Comments Media type
username (Primary) varchar(64) No
tables text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No username 0 A No

pma__relation

Table comments: Relation table

Column Type Null Default Links to Comments Media type
master_db (Primary) varchar(64) No
master_table (Primary) varchar(64) No
master_field (Primary) varchar(64) No
foreign_db varchar(64) No
foreign_table varchar(64) No
foreign_field varchar(64) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No master_db 0 A No
master_table 0 A No
master_field 0 A No
foreign_field BTREE No No foreign_db 0 A No
foreign_table 0 A No

pma__savedsearches

Table comments: Saved searches

Column Type Null Default Links to Comments Media type
id (Primary) int(5) No
username varchar(64) No
db_name varchar(64) No
search_name varchar(64) No
search_data text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 0 A No
u_savedsearches_username_dbname BTREE Yes No username 0 A No
db_name 0 A No
search_name 0 A No

pma__table_coords

Table comments: Table coordinates for phpMyAdmin PDF output

Column Type Null Default Links to Comments Media type
db_name (Primary) varchar(64) No
table_name (Primary) varchar(64) No
pdf_page_number (Primary) int(11) No 0
x float No 0
y float No 0

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No db_name 0 A No
table_name 0 A No
pdf_page_number 0 A No

pma__table_info

Table comments: Table information for phpMyAdmin

Column Type Null Default Links to Comments Media type
db_name (Primary) varchar(64) No
table_name (Primary) varchar(64) No
display_field varchar(64) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No db_name 0 A No
table_name 0 A No

pma__table_uiprefs

Table comments: Tables' UI preferences

Column Type Null Default Links to Comments Media type
username (Primary) varchar(64) No
db_name (Primary) varchar(64) No
table_name (Primary) varchar(64) No
prefs text No
last_update timestamp No current_timestamp()

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No username 1 A No
db_name 1 A No
table_name 1 A No

pma__tracking

Table comments: Database changes tracking for phpMyAdmin

Column Type Null Default Links to Comments Media type
db_name (Primary) varchar(64) No
table_name (Primary) varchar(64) No
version (Primary) int(10) No
date_created datetime No
date_updated datetime No
schema_snapshot text No
schema_sql text Yes NULL
data_sql longtext Yes NULL
tracking set('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') Yes NULL
tracking_active int(1) No 1

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No db_name 0 A No
table_name 0 A No
version 0 A No

pma__userconfig

Table comments: User preferences storage for phpMyAdmin

Column Type Null Default Links to Comments Media type
username (Primary) varchar(64) No
timevalue timestamp No current_timestamp()
config_data text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No username 0 A No

pma__usergroups

Table comments: User groups with configured menu items

Column Type Null Default Links to Comments Media type
usergroup (Primary) varchar(64) No
tab (Primary) varchar(64) No
allowed (Primary) enum('Y', 'N') No N

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No usergroup 0 A No
tab 0 A No
allowed 0 A No

pma__users

Table comments: Users and their assignments to user groups

Column Type Null Default Links to Comments Media type
username (Primary) varchar(64) No
usergroup (Primary) varchar(64) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No username 0 A No
usergroup 0 A No