Mysql

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