Difference between revisions of "Performance schema"

From SPGC Document Wiki
Jump to: navigation, search
Line 109: Line 109:
 
|varchar
 
|varchar
 
|255
 
|255
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
==pma_designer_coords==
 +
{| class="wikitable" \
 +
!colspan="7" |pma_designer_coords
 +
|-
 +
! 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
 +
|-
 +
|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==
 +
{| class="wikitable" \
 +
!colspan="7" |pma_history
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" |pma_history
 +
|-
 +
! style="text-align:left;" | 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
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|}
 
|}

Revision as of 10:30, 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_history
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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Performance_schema&oldid=2736"