Mysql
From SPGC Document Wiki
Contents
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 |