pma__bookmark
Tabellenkommentar: Bookmarks
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| id (Primärschlüssel) | int(10) | Nein | | |
|
|
| dbase | varchar(255) | Nein | | |
|
|
| user | varchar(255) | Nein | | |
|
|
| label | varchar(255) | Nein | | |
|
|
| query | text | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | id | 0 | A | Nein | |
pma__central_columns
Tabellenkommentar: Central list of columns
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| db_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| col_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| col_type | varchar(64) | Nein | | |
|
|
| col_length | text | Ja | NULL | |
|
|
| col_collation | varchar(64) | Nein | | |
|
|
| col_isNull | tinyint(1) | Nein | | |
|
|
| col_extra | varchar(255) | Ja | | |
|
|
| col_default | text | Ja | NULL | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | db_name | 0 | A | Nein | |
| col_name | 0 | A | Nein |
pma__column_info
Tabellenkommentar: Column information for phpMyAdmin
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| id (Primärschlüssel) | int(5) | Nein | | |
|
|
| db_name | varchar(64) | Nein | | |
|
|
| table_name | varchar(64) | Nein | | |
|
|
| column_name | varchar(64) | Nein | | |
|
|
| comment | varchar(255) | Nein | | |
|
|
| mimetype | varchar(255) | Nein | | |
|
|
| transformation | varchar(255) | Nein | | |
|
|
| transformation_options | varchar(255) | Nein | | |
|
|
| input_transformation | varchar(255) | Nein | | |
|
|
| input_transformation_options | varchar(255) | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | id | 0 | A | Nein | |
| db_name | BTREE | Ja | Nein | db_name | 0 | A | Nein | |
| table_name | 0 | A | Nein |
| column_name | 0 | A | Nein |
pma__designer_settings
Tabellenkommentar: Settings related to Designer
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| username (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| settings_data | text | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | username | 0 | A | Nein | |
pma__export_templates
Tabellenkommentar: Saved export templates
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| id (Primärschlüssel) | int(5) | Nein | | |
|
|
| username | varchar(64) | Nein | | |
|
|
| export_type | varchar(10) | Nein | | |
|
|
| template_name | varchar(64) | Nein | | |
|
|
| template_data | text | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | id | 0 | A | Nein | |
| u_user_type_template | BTREE | Ja | Nein | username | 0 | A | Nein | |
| export_type | 0 | A | Nein |
| template_name | 0 | A | Nein |
pma__favorite
Tabellenkommentar: Favorite tables
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| username (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| tables | text | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | username | 0 | A | Nein | |
pma__history
Tabellenkommentar: SQL history for phpMyAdmin
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| id (Primärschlüssel) | bigint(20) | Nein | | |
|
|
| username | varchar(64) | Nein | | |
|
|
| db | varchar(64) | Nein | | |
|
|
| table | varchar(64) | Nein | | |
|
|
| timevalue | timestamp | Nein | current_timestamp() | |
|
|
| sqlquery | text | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | id | 0 | A | Nein | |
| username | BTREE | Nein | Nein | username | 0 | A | Nein | |
| db | 0 | A | Nein |
| table | 0 | A | Nein |
| timevalue | 0 | A | Nein |
pma__navigationhiding
Tabellenkommentar: Hidden items of navigation tree
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| username (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| item_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| item_type (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| db_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| table_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | username | 0 | A | Nein | |
| item_name | 0 | A | Nein |
| item_type | 0 | A | Nein |
| db_name | 0 | A | Nein |
| table_name | 0 | A | Nein |
pma__pdf_pages
Tabellenkommentar: PDF relation pages for phpMyAdmin
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| db_name | varchar(64) | Nein | | |
|
|
| page_nr (Primärschlüssel) | int(10) | Nein | | |
|
|
| page_descr | varchar(50) | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | page_nr | 0 | A | Nein | |
| db_name | BTREE | Nein | Nein | db_name | 0 | A | Nein | |
pma__recent
Tabellenkommentar: Recently accessed tables
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| username (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| tables | text | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | username | 0 | A | Nein | |
pma__relation
Tabellenkommentar: Relation table
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| master_db (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| master_table (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| master_field (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| foreign_db | varchar(64) | Nein | | |
|
|
| foreign_table | varchar(64) | Nein | | |
|
|
| foreign_field | varchar(64) | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | master_db | 0 | A | Nein | |
| master_table | 0 | A | Nein |
| master_field | 0 | A | Nein |
| foreign_field | BTREE | Nein | Nein | foreign_db | 0 | A | Nein | |
| foreign_table | 0 | A | Nein |
pma__savedsearches
Tabellenkommentar: Saved searches
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| id (Primärschlüssel) | int(5) | Nein | | |
|
|
| username | varchar(64) | Nein | | |
|
|
| db_name | varchar(64) | Nein | | |
|
|
| search_name | varchar(64) | Nein | | |
|
|
| search_data | text | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | id | 0 | A | Nein | |
| u_savedsearches_username_dbname | BTREE | Ja | Nein | username | 0 | A | Nein | |
| db_name | 0 | A | Nein |
| search_name | 0 | A | Nein |
pma__table_coords
Tabellenkommentar: Table coordinates for phpMyAdmin PDF output
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| db_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| table_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| pdf_page_number (Primärschlüssel) | int(11) | Nein | 0 | |
|
|
| x | float | Nein | 0 | |
|
|
| y | float | Nein | 0 | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | db_name | 0 | A | Nein | |
| table_name | 0 | A | Nein |
| pdf_page_number | 0 | A | Nein |
pma__table_info
Tabellenkommentar: Table information for phpMyAdmin
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| db_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| table_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| display_field | varchar(64) | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | db_name | 0 | A | Nein | |
| table_name | 0 | A | Nein |
pma__table_uiprefs
Tabellenkommentar: Tables' UI preferences
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| username (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| db_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| table_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| prefs | text | Nein | | |
|
|
| last_update | timestamp | Nein | current_timestamp() | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | username | 0 | A | Nein | |
| db_name | 0 | A | Nein |
| table_name | 0 | A | Nein |
pma__tracking
Tabellenkommentar: Database changes tracking for phpMyAdmin
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| db_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| table_name (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| version (Primärschlüssel) | int(10) | Nein | | |
|
|
| date_created | datetime | Nein | | |
|
|
| date_updated | datetime | Nein | | |
|
|
| schema_snapshot | text | Nein | | |
|
|
| schema_sql | text | Ja | NULL | |
|
|
| data_sql | longtext | Ja | 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') | Ja | NULL | |
|
|
| tracking_active | int(1) | Nein | 1 | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | db_name | 0 | A | Nein | |
| table_name | 0 | A | Nein |
| version | 0 | A | Nein |
pma__userconfig
Tabellenkommentar: User preferences storage for phpMyAdmin
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| username (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| timevalue | timestamp | Nein | current_timestamp() | |
|
|
| config_data | text | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | username | 3 | A | Nein | |
pma__usergroups
Tabellenkommentar: User groups with configured menu items
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| usergroup (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| tab (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| allowed (Primärschlüssel) | enum('Y', 'N') | Nein | N | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | usergroup | 0 | A | Nein | |
| tab | 0 | A | Nein |
| allowed | 0 | A | Nein |
pma__users
Tabellenkommentar: Users and their assignments to user groups
| Spalte | Typ | Null | Standard | Verweise |
Kommentare |
MIME |
|---|
| username (Primärschlüssel) | varchar(64) | Nein | | |
|
|
| usergroup (Primärschlüssel) | varchar(64) | Nein | | |
|
|
Indizes
Kein Index definiert!
| Schlüsselname | Typ | Unique | Gepackt | Spalte | Kardinalität | Kollation | Null | Kommentar |
|---|
| PRIMARY | BTREE | Ja | Nein | username | 0 | A | Nein | |
| usergroup | 0 | A | Nein |