event

Table comments: Events

Column	Type	Null	Default	Comments
db	char(64)	No
name	char(64)	No
body	longblob	No
definer	char(77)	No
execute_at	datetime	Yes	NULL
interval_value	int(11)	Yes	NULL
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	NULL
created	timestamp	No	CURRENT_TIMESTAMP
modified	timestamp	No	0000-00-00 00:00:00
last_executed	datetime	Yes	NULL
starts	datetime	Yes	NULL
ends	datetime	Yes	NULL
status	enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')	No	ENABLED
on_completion	enum('DROP', 'PRESERVE')	No	DROP
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')	No
comment	char(64)	No
originator	int(10)	No
time_zone	char(64)	No	SYSTEM
character_set_client	char(32)	Yes	NULL
collation_connection	char(32)	Yes	NULL
db_collation	char(32)	Yes	NULL
body_utf8	longblob	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	db		A	No
				name	0	A	No

Space usage: Data 0 B Index 2,048 B Total 2,048 B

Row Statistics: Format dynamic Rows 0 Creation Mar 14, 2014 at 01:30 PM Last update May 01, 2014 at 09:06 AM