EVENTS

mmt
FieldTypeNullKeyDefaultExtra
EVENT_CATALOG varchar(64) NO
EVENT_SCHEMA varchar(64) NO
EVENT_NAME varchar(64) NO
DEFINER varchar(93) NO
TIME_ZONE varchar(64) NO
EVENT_BODY varchar(3) NO
EVENT_DEFINITION longtext NO
EVENT_TYPE varchar(9) NO
EXECUTE_AT datetime YES
INTERVAL_VALUE int(11) YES
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') YES
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','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','TIME_TRUNCATE_FRACTIONAL') NO
STARTS datetime YES
ENDS datetime YES
STATUS enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NO
ON_COMPLETION varchar(12) NO
CREATED timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
LAST_ALTERED timestamp NO CURRENT_TIMESTAMP
LAST_EXECUTED datetime YES
EVENT_COMMENT varchar(2048) NO
ORIGINATOR int(10) unsigned NO
CHARACTER_SET_CLIENT varchar(64) NO
COLLATION_CONNECTION varchar(64) NO
DATABASE_COLLATION varchar(64) NO

[ START ][ Connect ] [ create table form ]

MySQL Nippon Association