Database information_schema - table TRIGGERS

[ Browse ]    [ Select ]    [ Insert ]    [ Empty ]

Field Type Attributes Null Default Extra Action
TRIGGER_CATALOG  varchar(512)   Yes  NULL    Change Drop Primary Index Unique
TRIGGER_SCHEMA  varchar(64)   Yes      Change Drop Primary Index Unique
TRIGGER_NAME  varchar(64)   Yes      Change Drop Primary Index Unique
EVENT_MANIPULATION  varchar(6)   Yes      Change Drop Primary Index Unique
EVENT_OBJECT_CATALOG  varchar(512)   Yes  NULL    Change Drop Primary Index Unique
EVENT_OBJECT_SCHEMA  varchar(64)   Yes      Change Drop Primary Index Unique
EVENT_OBJECT_TABLE  varchar(64)   Yes      Change Drop Primary Index Unique
ACTION_ORDER  bigint(4)   Yes  0    Change Drop Primary Index Unique
ACTION_CONDITION  longtext   Yes  NULL    Change Drop Primary Index Unique
ACTION_STATEMENT  longtext   Yes      Change Drop Primary Index Unique
ACTION_ORIENTATION  varchar(9)   Yes      Change Drop Primary Index Unique
ACTION_TIMING  varchar(6)   Yes      Change Drop Primary Index Unique
ACTION_REFERENCE_OLD_TABLE  varchar(64)   Yes  NULL    Change Drop Primary Index Unique
ACTION_REFERENCE_NEW_TABLE  varchar(64)   Yes  NULL    Change Drop Primary Index Unique
ACTION_REFERENCE_OLD_ROW  varchar(3)   Yes      Change Drop Primary Index Unique
ACTION_REFERENCE_NEW_ROW  varchar(3)   Yes      Change Drop Primary Index Unique
CREATED  datetime   Yes  NULL    Change Drop Primary Index Unique
SQL_MODE  longtext   Yes      Change Drop Primary Index Unique
DEFINER  longtext   Yes      Change Drop Primary Index Unique