|
db
|
char(64)
|
utf8_bin
|
|
|
|
name
|
char(64)
|
utf8_general_ci
|
|
|
|
type
|
enum('FUNCTION', 'PROCEDURE', 'PACKAGE', 'PACKAGE BODY')
|
utf8_general_ci
|
|
|
|
specific_name
|
char(64)
|
utf8_general_ci
|
|
|
|
language
|
enum('SQL')
|
utf8_general_ci
|
|
|
|
sql_data_access
|
enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')
|
utf8_general_ci
|
|
|
|
is_deterministic
|
enum('YES', 'NO')
|
utf8_general_ci
|
|
|
|
security_type
|
enum('INVOKER', 'DEFINER')
|
utf8_general_ci
|
|
|
|
param_list
|
blob
|
|
|
|
|
returns
|
longblob
|
|
|
|
|
body
|
longblob
|
|
|
|
|
definer
|
char(141)
|
utf8_bin
|
|
|
|
created
|
timestamp
|
|
|
|
|
modified
|
timestamp
|
|
|
|
|
sql_mode
|
set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'EMPTY_STRING_IS_NULL', 'SIMULTANEOUS_ASSIGNMENT', 'TIME_ROUND_FRACTIONAL')
|
utf8_general_ci
|
|
|
|
comment
|
text
|
utf8_bin
|
|
|
|
character_set_client
|
char(32)
|
utf8_bin
|
|
|
|
collation_connection
|
char(32)
|
utf8_bin
|
|
 Browse foreign values
|
|
db_collation
|
char(32)
|
utf8_bin
|
|
Browse foreign values
|
|
body_utf8
|
longblob
|
|
|
|
|
aggregate
|
enum('NONE', 'GROUP')
|
utf8_general_ci
|
|
|
