mytool

TRIGGERS

Field	Type	Null	Default	Extra
TRIGGER_CATALOG	varchar(64)	NO
TRIGGER_SCHEMA	varchar(64)	NO
TRIGGER_NAME	varchar(64)	NO
EVENT_MANIPULATION	enum('INSERT','UPDATE','DELETE')	NO
EVENT_OBJECT_CATALOG	varchar(64)	NO
EVENT_OBJECT_SCHEMA	varchar(64)	NO
EVENT_OBJECT_TABLE	varchar(64)	NO
ACTION_ORDER	int(10) unsigned	NO
ACTION_CONDITION	binary(0)	YES
ACTION_STATEMENT	longtext	NO
ACTION_ORIENTATION	varchar(3)	NO
ACTION_TIMING	enum('BEFORE','AFTER')	NO
ACTION_REFERENCE_OLD_TABLE	binary(0)	YES
ACTION_REFERENCE_NEW_TABLE	binary(0)	YES
ACTION_REFERENCE_OLD_ROW	varchar(3)	NO
ACTION_REFERENCE_NEW_ROW	varchar(3)	NO
CREATED	timestamp(2)	NO	CURRENT_TIMESTAMP(2)	on update CURRENT_TIMESTAMP(2)
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
DEFINER	varchar(93)	NO
CHARACTER_SET_CLIENT	varchar(64)	NO
COLLATION_CONNECTION	varchar(64)	NO
DATABASE_COLLATION	varchar(64)	NO