pma__bookmark

Table comments: Bookmarks

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	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	MIME
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	MIME
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	MIME
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	MIME
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	MIME
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__history

Table comments: SQL history for phpMyAdmin

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

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	MIME
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	MIME
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	MIME
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	MIME
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	MIME
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	MIME
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	MIME
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	0	A	No
				db_name	0	A	No
				table_name	0	A	No

pma__tracking

Table comments: Database changes tracking for phpMyAdmin

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