Difference between revisions of "Mysql"

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

Revision as of 09:16, 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
Select_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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mysql&oldid=2704"