EVENT_CATALOG |
varchar(64)
|
utf8_bin
|
|
|
EVENT_SCHEMA |
varchar(64)
|
utf8_bin
|
|
|
EVENT_NAME |
varchar(64)
|
utf8_general_ci
|
|
|
DEFINER |
varchar(288)
|
utf8_bin
|
|
|
TIME_ZONE |
varchar(64)
|
utf8_bin
|
|
|
EVENT_BODY |
varchar(3)
|
utf8_general_ci
|
|
|
EVENT_DEFINITION |
longtext
|
utf8_bin
|
|
|
EVENT_TYPE |
varchar(9)
|
utf8_general_ci
|
|
|
EXECUTE_AT |
datetime
|
|
|
|
INTERVAL_VALUE |
varchar(256)
|
utf8_general_ci
|
|
|
INTERVAL_FIELD |
enum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND')
|
utf8_bin
|
|
|
SQL_MODE |
set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'NOT_USED_9', 'NOT_USED_10', 'NOT_USED_11', 'NOT_USED_12', 'NOT_USED_13', 'NOT_USED_14', 'NOT_USED_15', 'NOT_USED_16', 'NOT_USED_17', 'NOT_USED_18', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ALLOW_INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NOT_USED_29', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'TIME_TRUNCATE_FRACTIONAL')
|
utf8_bin
|
|
|
STARTS |
datetime
|
|
|
|
ENDS |
datetime
|
|
|
|
STATUS |
enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')
|
utf8_bin
|
|
|
ON_COMPLETION |
varchar(12)
|
utf8_general_ci
|
|
|
CREATED |
timestamp
|
|
|
|
LAST_ALTERED |
timestamp
|
|
|
|
LAST_EXECUTED |
datetime
|
|
|
|
EVENT_COMMENT |
varchar(2048)
|
utf8_bin
|
|
|
ORIGINATOR |
int(10)
|
|
|
|
CHARACTER_SET_CLIENT |
varchar(64)
|
utf8_general_ci
|
|
|
COLLATION_CONNECTION |
varchar(64)
|
utf8_general_ci
|
|
Browse foreign values
|
DATABASE_COLLATION |
varchar(64)
|
utf8_general_ci
|
|
Browse foreign values
|