Difference between revisions of "Mysql"

From SPGC Document Wiki
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 1,431: Line 1,431:
 
|int
 
|int
 
|11
 
|11
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
==time_zone_name==
 +
{| class="wikitable" \
 +
!colspan="7" | time_zone_name
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|Name
 +
|char
 +
|64
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|Time_zone_id
 +
|int
 +
|10
 +
|No
 +
|Yes
 +
|Yes
 +
|}
 +
 +
==time_zone_transition==
 +
{| class="wikitable" \
 +
!colspan="7" | time_zone_transition
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|Time_zone_id
 +
|int
 +
|10
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|Transition_time
 +
|bigint
 +
|20
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|Transition_type_id
 +
|int
 +
|10
 +
|No
 +
|Yes
 +
|Yes
 +
|}
 +
 +
==time_zone_transition_type==
 +
{| class="wikitable" \
 +
!colspan="7" | time_zone_transition_type
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|Time_zone_id
 +
|int
 +
|10
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|Transition_type_id
 +
|int
 +
|10
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|Offset
 +
|int
 +
|11
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Is_DST
 +
|tinyint
 +
|3
 +
|No
 +
|Yes
 +
|Yes
 +
|-
 +
|Abbreviation
 +
|char
 +
|8
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
==users==
 +
{| class="wikitable" \
 +
!colspan="7" |users
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|Host
 +
|char
 +
|60
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|User
 +
|char
 +
|60
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|Password
 +
|char
 +
|41
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Select_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Insert_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Update_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Delete_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Create_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Drop_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Reload_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Shutdown_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Process_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|File_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Grant_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|References_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Index_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Alter_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Show_db_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Super_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Create_tmp_table_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Lock_tables_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Execute_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Repl_slave_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Repl_client_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Create_view_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Show_view_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Create_routine_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Alter_routine_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Create_user_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Event_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Trigger_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Create_tablespace_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|ssl_type
 +
|enum
 +
|ANY
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|ssl_cipher
 +
|blob
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|x509_issuer
 +
|blob
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|x509_subject
 +
|blob
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|max_questions
 +
|int
 +
|11
 +
|No
 +
|Yes
 +
|Yes
 +
|-
 +
|max_updates
 +
|int
 +
|11
 +
|No
 +
|Yes
 +
|Yes
 +
|-
 +
|max_connections
 +
|int
 +
|11
 +
|No
 +
|Yes
 +
|Yes
 +
|-
 +
|max_user_connections
 +
|int
 +
|11
 +
|No
 +
|Yes
 +
|Yes
 +
|-
 +
|plugin
 +
|text
 +
|60
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|authentication_string
 +
|text
 +
|0
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|}
 
|}

Latest revision as of 10:08, 9 August 2016

columns_priv

columns_priv
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Host char 60 Yes Yes No
Db char 64 Yes Yes No
User char 16 Yes Yes No
Table_name char 64 Yes Yes No
Column_name char 64 Yes Yes No
Timestamp timestamp 0 No Yes No
Column_priv set 0 No Yes No

db

db
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Host char 60 Yes Yes No
Db char 64 Yes Yes No
User char 16 Yes Yes No
Select_priv enum N,Y No Yes No
Insert_priv enum N,Y No Yes No
Update_priv enum N,Y No Yes No
Delete_priv enum N,Y No Yes No
Create_priv enum N,Y No Yes No
Drop_priv enum N,Y No Yes No
Grant_priv enum N,Y No Yes No
References_priv enum N,Y No Yes No
Index_priv enum N,Y No Yes No
Alter_priv enum N,Y No Yes No
Create_tmp_table_priv enum N,Y No Yes No
Lock_tables_priv enum N,Y No Yes No
Create_view_priv enum N,Y No Yes No
Show_view_priv enum N,Y No Yes No
Create_routine_priv enum N,Y No Yes No
Alter_routine_priv enum N,Y No Yes No
Execute_priv enum N,Y No Yes No
Event_priv enum N,Y No Yes No
Trigger_priv enum N,Y No Yes No

event

event
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
db char 64 Yes Yes No
name char 64 Yes Yes No
body longblob 0 No Yes No
definer char 77 No Yes No
execute_at datetime 0 No No No
interval_value int 11 No No No
interval_field 0 64 No No No
created timestamp 0 No Yes No
modified timestamp 0 No Yes No
last_executed datetime 0 No No No
starts datetime 0 No No No
ends datetime 0 No No No
status enum 0 No Yes No
on_completion enum 0 No Yes No
sql_mode set 0 No Yes No
comment char 64 No Yes No
originator int 10 No Yes Yes
time_zone char 64 No Yes No
character_set_client char 32 No No No
collation_connection char 32 No No No
db_collation char 32 No No No
body_utf8 longblob 0 No No No

func

func
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
name binary 64 Yes Yes No
ret tinyint 1 No Yes No
dl char 128 No Yes No
type enum 0 No Yes No

general_log

general_log
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
event_time timestamp 0 No Yes No
user_host mediumtext 0 No Yes No
thread_id int 11 No Yes No
server_id int 10 No Yes Yes
command_type varchar 64 No Yes No
argument mediumtext 0 No Yes No


help_category

help_category
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
help_category_id smallint 5 Yes Yes Yes
name varchar 64 No Yes No
parent_category_id smallint 5 No No Yes
url varchar 128 No Yes No

help_keyword

help_keyword
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
help_keyword_id int 10 Yes Yes Yes
name varchar 64 No Yes No

help_relation

help_relation
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
help_topic_id int 10 Yes Yes Yes
help_keyword_id int 10 Yes Yes Yes

help_topic

help_topic
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
help_topic_id int 10 Yes Yes Yes
name varchar 64 No Yes No
help_category_id smallint 5 No Yes Yes
description text 0 No Yes No
example text 0 No Yes No
url varchar 128 No Yes No

host

host
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Host char 60 Yes Yes No
Db char 64 Yes Yes No
Select_priv enum N,Y No Yes No
Insert_priv enum N,Y No Yes No
Update_priv enum N,Y No Yes No
Delete_priv enum N,Y No Yes No
Create_priv enum N,Y No Yes No
Drop_priv enum N,Y No Yes No
Grant_priv enum N,Y No Yes No
References_priv enum N,Y No Yes No
Index_priv enum N,Y No Yes No
Alter_priv enum N,Y No Yes No
Create_tmp_table_priv enum N,Y No Yes No
Lock_tables_priv enum N,Y No Yes No
Create_view_priv enum N,Y No Yes No
Show_view_priv enum N,Y No Yes No
Create_routine_priv enum N,Y No Yes No
Alter_routine_priv enum N,Y No Yes No
Execute_priv enum N,Y No Yes No
Trigger_priv enum N,Y No Yes No

ndb_binlog_index

ndb_binlog_index
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Position bigint 20 No Yes Yes
File varchar 255 No Yes No
epoch bigint 20 Yes Yes Yes
inserts bigint 20 No Yes Yes
updates bigint 20 No Yes Yes
deletes bigint 20 No Yes Yes
schemaops bigint 20 No Yes Yes

plugin

plugin
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
name varchar 64 Yes Yes No
dl varchar 128 No Yes No

proc

proc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
db char 64 Yes Yes No
name char 64 Yes Yes No
type enum 0 Yes Yes No
specific_name char 64 No Yes No
language enum 0 No Yes No
sql_data_access enum 0 No Yes No
is_deterministic enum 0 No Yes No
security_type enum 0 No Yes No
param_list blob 0 No Yes No
returns longblob 0 No Yes No
body longblob 0 No Yes No
definer char 77 No Yes No
created timestamp 0 No Yes No
modified timestamp 0 No Yes No
sql_mode set 0 No Yes No
comment text 0 No Yes No
character_set_client char 32 No No No
collation_connection char 32 No No No
db_collation char 32 No No No
body_utf8 longblob 0 No No No

procs_priv

procs_priv
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Host char 60 Yes Yes No
Db char 64 Yes Yes No
User char 16 Yes Yes No
Routine_name char 64 Yes Yes No
Routine_type enum 0 Yes Yes No
enum char 77 No Yes No
Proc_priv set 0 No Yes No
Timestamp timestamp 0 No Yes No

proxies_priv

proxies_priv
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Host char 60 Yes Yes No
User char 16 Yes Yes No
Proxied_host char 60 Yes Yes No
Proxied_user char 16 Yes Yes No
With_grant tinyint 1 No Yes No
Grantor char 77 No Yes No
Timestamp timestamp 0 No Yes No

servers

servers
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Server_name char 64 Yes Yes No
Host char 64 No Yes No
Db char 64 No Yes No
Username char 64 No Yes No
Password char 64 No Yes No
Port int 4 No Yes No
Socket char 64 No Yes No
Wrapper char 64 No Yes No
Owner char 64 No Yes No

slow_log

slow_log
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
start_time timestamp 0 No Yes No
user_host mediumtext 0 No Yes No
query_time time 0 No Yes No
lock_time time 0 No Yes No
rows_sent int 11 No Yes No
rows_examined int 11 No Yes No
db varchar 512 No Yes No
last_insert_id int 11 No Yes No
insert_id int 11 No Yes No
server_id int 10 No Yes Yes
sql_text mediumtext 0 No Yes No

tables_priv

tables_priv
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Host char 60 Yes Yes No
Db char 64 Yes Yes No
User char 16 Yes Yes No
Table_name char 64 Yes Yes No
Grantor char 77 No Yes No
Timestamp timestamp 0 No Yes No
Table_priv set 0 No Yes No
Column_priv set 0 No Yes No

time_zone

time_zone
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Time_zone_id int 10 Yes Yes Yes
Use_leap_seconds enum Y,N No Yes No

time_zone_leap_second

time_zone_leap_second
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Transition_time bigint 20 Yes Yes No
Correction int 11 No Yes No

time_zone_name

time_zone_name
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Name char 64 Yes Yes No
Time_zone_id int 10 No Yes Yes

time_zone_transition

time_zone_transition
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Time_zone_id int 10 Yes Yes No
Transition_time bigint 20 Yes Yes No
Transition_type_id int 10 No Yes Yes

time_zone_transition_type

time_zone_transition_type
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Time_zone_id int 10 Yes Yes Yes
Transition_type_id int 10 Yes Yes Yes
Offset int 11 No Yes No
Is_DST tinyint 3 No Yes Yes
Abbreviation char 8 No Yes No

users

users
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Host char 60 Yes Yes No
User char 60 Yes Yes No
Password char 41 No Yes No
Select_priv enum N,Y No Yes No
Insert_priv enum N,Y No Yes No
Update_priv enum N,Y No Yes No
Delete_priv enum N,Y No Yes No
Create_priv enum N,Y No Yes No
Drop_priv enum N,Y No Yes No
Reload_priv enum N,Y No Yes No
Shutdown_priv enum N,Y No Yes No
Process_priv enum N,Y No Yes No
File_priv enum N,Y No Yes No
Grant_priv enum N,Y No Yes No
References_priv enum N,Y No Yes No
Index_priv enum N,Y No Yes No
Alter_priv enum N,Y No Yes No
Show_db_priv enum N,Y No Yes No
Super_priv enum N,Y No Yes No
Create_tmp_table_priv enum N,Y No Yes No
Lock_tables_priv enum N,Y No Yes No
Execute_priv enum N,Y No Yes No
Repl_slave_priv enum N,Y No Yes No
Repl_client_priv enum N,Y No Yes No
Create_view_priv enum N,Y No Yes No
Show_view_priv enum N,Y No Yes No
Create_routine_priv enum N,Y No Yes No
Alter_routine_priv enum N,Y No Yes No
Create_user_priv enum N,Y No Yes No
Event_priv enum N,Y No Yes No
Trigger_priv enum N,Y No Yes No
Create_tablespace_priv enum N,Y No Yes No
ssl_type enum ANY No Yes No
ssl_cipher blob 0 No Yes No
x509_issuer blob 0 No Yes No
x509_subject blob 0 No Yes No
max_questions int 11 No Yes Yes
max_updates int 11 No Yes Yes
max_connections int 11 No Yes Yes
max_user_connections int 11 No Yes Yes
plugin text 60 No Yes No
authentication_string text 0 No Yes No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mysql&oldid=2730"