pma__bookmark
Table comments: Bookmarks
| Column |
Type |
Null |
Default |
Links to |
Comments |
Media (MIME) type |
|
id
(Primary)
|
int(10)
|
No |
|
|
|
|
|
dbase
|
varchar(255)
|
No |
|
|
|
|
|
user
|
varchar(255)
|
No |
|
|
|
|
|
label
|
varchar(255)
|
No |
|
|
|
|
|
query
|
text
|
No |
|
|
|
|
Indexes
No index defined!
| 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 (MIME) 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
No index defined!
| 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 (MIME) 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
No index defined!
| 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 (MIME) type |
|
username
(Primary)
|
varchar(64)
|
No |
|
|
|
|
|
settings_data
|
text
|
No |
|
|
|
|
Indexes
No index defined!
| 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 (MIME) 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
No index defined!
| 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 (MIME) type |
|
username
(Primary)
|
varchar(64)
|
No |
|
|
|
|
|
tables
|
text
|
No |
|
|
|
|
Indexes
No index defined!
| 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 |
Media (MIME) 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
No index defined!
| 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 (MIME) 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
No index defined!
| 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 (MIME) type |
|
db_name
|
varchar(64)
|
No |
|
|
|
|
|
page_nr
(Primary)
|
int(10)
|
No |
|
|
|
|
|
page_descr
|
varchar(50)
|
No |
|
|
|
|
Indexes
No index defined!
| 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 (MIME) type |
|
username
(Primary)
|
varchar(64)
|
No |
|
|
|
|
|
tables
|
text
|
No |
|
|
|
|
Indexes
No index defined!
| 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 (MIME) 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
No index defined!
| 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 (MIME) 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
No index defined!
| 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 (MIME) 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
No index defined!
| 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 (MIME) type |
|
db_name
(Primary)
|
varchar(64)
|
No |
|
|
|
|
|
table_name
(Primary)
|
varchar(64)
|
No |
|
|
|
|
|
display_field
|
varchar(64)
|
No |
|
|
|
|
Indexes
No index defined!
| 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 (MIME) 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
No index defined!
| 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 |
Media (MIME) 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
No index defined!
| 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 (MIME) type |
|
username
(Primary)
|
varchar(64)
|
No |
|
|
|
|
|
timevalue
|
timestamp
|
No |
current_timestamp()
|
|
|
|
|
config_data
|
text
|
No |
|
|
|
|
Indexes
No index defined!
| 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 (MIME) type |
|
usergroup
(Primary)
|
varchar(64)
|
No |
|
|
|
|
|
tab
(Primary)
|
varchar(64)
|
No |
|
|
|
|
|
allowed
(Primary)
|
enum('Y', 'N')
|
No |
N
|
|
|
|
Indexes
No index defined!
| 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 (MIME) type |
|
username
(Primary)
|
varchar(64)
|
No |
|
|
|
|
|
usergroup
(Primary)
|
varchar(64)
|
No |
|
|
|
|
Indexes
No index defined!
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|
| PRIMARY | BTREE | Yes | No | username | 0 | A | No | |
| usergroup | 0 | A | No |