pma_bookmark

Table comments: Bookmarks

Column	Type	Null	Default	Comments	MIME
id	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_column_info

Table comments: Column information for phpMyAdmin

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

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

pma_designer_coords

Table comments: Table coordinates for Designer

Column	Type	Null	Default	Comments	MIME
db_name	varchar(64)	No
table_name	varchar(64)	No
x	int(11)	Yes	NULL
y	int(11)	Yes	NULL
v	tinyint(4)	Yes	NULL
h	tinyint(4)	Yes	NULL

Indexes

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

pma_history

Table comments: SQL history for phpMyAdmin

Column	Type	Null	Default	Comments	MIME
id	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		A	No
				db		A	No
				table		A	No
				timevalue		A	No

pma_navigationhiding

Table comments: Hidden items of navigation tree

Column	Type	Null	Default	Comments	MIME
username	varchar(64)	No
item_name	varchar(64)	No
item_type	varchar(64)	No
db_name	varchar(64)	No
table_name	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	Comments	MIME
db_name	varchar(64)	No
page_nr	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		A	No

pma_recent

Table comments: Recently accessed tables

Column	Type	Null	Default	Comments	MIME
username	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_relation

Table comments: Relation table

Column	Type	Null	Default	Comments	MIME
master_db	varchar(64)	No
master_table	varchar(64)	No
master_field	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		A	No
				master_table		A	No
				master_field	0	A	No
foreign_field	BTREE	No	No	foreign_db		A	No
				foreign_table		A	No

pma_savedsearches

Table comments: Saved searches

Column	Type	Null	Default	Comments	MIME
id	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	Comments	MIME
db_name	varchar(64)	No
table_name	varchar(64)	No
pdf_page_number	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		A	No
				table_name		A	No
				pdf_page_number	0	A	No

pma_table_info

Table comments: Table information for phpMyAdmin

Column	Type	Null	Default	Comments	MIME
db_name	varchar(64)	No
table_name	varchar(64)	No
display_field	varchar(64)	No

Indexes

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

pma_table_uiprefs

Table comments: Tables' UI preferences

Column	Type	Null	Default	Comments	MIME
username	varchar(64)	No
db_name	varchar(64)	No
table_name	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		A	No
				db_name		A	No
				table_name	1	A	No

pma_tracking

Table comments: Database changes tracking for phpMyAdmin

Column	Type	Null	Default	Comments	MIME
db_name	varchar(64)	No
table_name	varchar(64)	No
version	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		A	No
				table_name		A	No
				version	0	A	No

pma_userconfig

Table comments: User preferences storage for phpMyAdmin

Column	Type	Null	Default	Comments	MIME
username	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	1	A	No

pma_usergroups

Table comments: User groups with configured menu items

Column	Type	Null	Default	Comments	MIME
usergroup	varchar(64)	No
tab	varchar(64)	No
allowed	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	Comments	MIME
username	varchar(64)	No
usergroup	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