Difference between revisions of "Performance schema"

From SPGC Document Wiki
Jump to: navigation, search
(→‎pma_pdf_pages)
Line 465: Line 465:
 
|Yes
 
|Yes
 
|No
 
|No
 +
|}
 +
==pma_table_uiprefs==
 +
{| class="wikitable" \
 +
!colspan="7" |pma_table_uiprefs
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|db_name
 +
|varchar
 +
|64
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|table_name
 +
|varchar
 +
|64
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|version
 +
|int
 +
|10
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|date_created
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|date_updated
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|schema_snapshot
 +
|text
 +
|64
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|schema_sql
 +
|text
 +
|64
 +
|No
 +
|No
 +
|No
 +
|-
 +
|data_sql
 +
|longtext
 +
|64
 +
|No
 +
|No
 +
|No
 +
|-
 +
|tracking
 +
|set
 +
|UPDATE
 +
|No
 +
|No
 +
|No
 +
|-
 +
|tracking_active
 +
|int
 +
|1
 +
|No
 +
|Yes
 +
|Yes
 
|}
 
|}

Revision as of 10:44, 9 August 2016

pma_bookmark

pma_bookmark
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes No
dbase varchar 255 No Yes No
user varchar 255 No Yes No
label varchar 255 No Yes No
query text 0 No Yes No

pma_column_info

pma_column_info
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 5 Yes Yes Yes
db_name varchar 64 No Yes No
table_name varchar 64 No Yes No
column_name varchar 64 No Yes No
comment varchar 255 No Yes No
mimetype varchar 255 No Yes No
transformation varchar 255 No Yes No
transformation_options varchar 255 No Yes No

pma_designer_coords

pma_designer_coords
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
db_name varchar 64 Yes Yes No
table_name varchar 64 Yes Yes No
x int 11 No No No
y int 11 No No No
v tinyint 4 No No No
h tinyint 4 No No No


pma_history

pma_history
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id bigint 20 Yes Yes Yes
username varchar 64 No Yes No
db varchar 64 No Yes No
table varchar 64 No Yes No
timevalue timestamp 0 No Yes No
sqlquery text 0 No Yes No

pma_pdf_pages

pma_pdf_pages
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
db_name varchar 64 No Yes No
page_nr int 10 Yes Yes Yes
page_descr varchar 50 No Yes No

pma_recent

pma_recent
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
username varchar 64 Yes Yes No
tables text 0 No Yes No


pma_relation

pma_relation
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
master_db varchar 64 Yes Yes No
master_table varchar 64 Yes Yes No
master_field varchar 64 Yes Yes No
foreign_db varchar 64 No Yes No
foreign_table varchar 64 No Yes No
foreign_field varchar 64 No Yes No


pma_table_coords

pma_table_coords
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
db_name varchar 64 Yes Yes No
table_name varchar 64 Yes Yes No
pdf_page_number int 11 Yes Yes No
x float unsigned 0 No Yes Yes
y float unsigned 0 No Yes Yes


pma_table_info

pma_table_info
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
db_name varchar 64 Yes Yes No
table_name varchar 64 Yes Yes No
display_field varchar 64 No Yes No


pma_table_uiprefs

pma_table_uiprefs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
username varchar 64 Yes Yes No
db_name varchar 64 Yes Yes No
table_name varchar 64 Yes Yes No
prefs text 0 No Yes No
last_update timestamp 0 No Yes No

pma_table_uiprefs

pma_table_uiprefs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
db_name varchar 64 Yes Yes No
table_name varchar 64 Yes Yes No
version int 10 Yes Yes Yes
date_created datetime 0 No Yes No
date_updated datetime 0 No Yes No
schema_snapshot text 64 No Yes No
schema_sql text 64 No No No
data_sql longtext 64 No No No
tracking set UPDATE No No No
tracking_active int 1 No Yes Yes
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Performance_schema&oldid=2742"