| db |
char(64)
|
utf8_bin
|
|
|
| name |
char(64)
|
utf8_general_ci
|
|
|
| body |
longblob
|
|
|
|
| definer |
char(141)
|
utf8_bin
|
|
|
| execute_at |
datetime
|
|
|
|
| interval_value |
int(11)
|
|
|
|
| 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_general_ci
|
|
|
| created |
timestamp
|
|
|
|
| modified |
timestamp
|
|
|
|
| last_executed |
datetime
|
|
|
|
| starts |
datetime
|
|
|
|
| ends |
datetime
|
|
|
|
| status |
enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')
|
utf8_general_ci
|
|
|
| on_completion |
enum('DROP', 'PRESERVE')
|
utf8_general_ci
|
|
|
| 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 |
char(64)
|
utf8_bin
|
|
|
| originator |
int(10)
|
|
|
|
| time_zone |
char(64)
|
latin1_swedish_ci
|
|
|
| character_set_client |
char(32)
|
utf8_bin
|
|
|
| collation_connection |
char(32)
|
utf8_bin
|
|
 参照されている値を表示する
|
| db_collation |
char(32)
|
utf8_bin
|
|
参照されている値を表示する
|
| body_utf8 |
longblob
|
|
|
|
