|
TRIGGER_CATALOG
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
TRIGGER_SCHEMA
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
TRIGGER_NAME
|
varchar(64)
|
utf8mb3_general_ci
|
|
|
|
EVENT_MANIPULATION
|
enum('INSERT', 'UPDATE', 'DELETE')
|
utf8mb3_bin
|
|
|
|
EVENT_OBJECT_CATALOG
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
EVENT_OBJECT_SCHEMA
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
EVENT_OBJECT_TABLE
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
ACTION_ORDER
|
int
|
|
|
|
|
ACTION_CONDITION
|
binary(0)
|
|
|
|
|
ACTION_STATEMENT
|
longtext
|
utf8mb3_bin
|
|
|
|
ACTION_ORIENTATION
|
varchar(3)
|
utf8mb3_general_ci
|
|
|
|
ACTION_TIMING
|
enum('BEFORE', 'AFTER')
|
utf8mb3_bin
|
|
|
|
ACTION_REFERENCE_OLD_TABLE
|
binary(0)
|
|
|
|
|
ACTION_REFERENCE_NEW_TABLE
|
binary(0)
|
|
|
|
|
ACTION_REFERENCE_OLD_ROW
|
varchar(3)
|
utf8mb3_general_ci
|
|
|
|
ACTION_REFERENCE_NEW_ROW
|
varchar(3)
|
utf8mb3_general_ci
|
|
|
|
CREATED
|
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', 'NOT_USED_9', 'NOT_USED_10', 'NOT_USED_11', 'NOT_USED_12', 'NOT_USED_13', 'NOT_USED_14', 'NOT_USED_15', 'NOT_USED_16', 'NOT_USED_17', 'NOT_USED_18', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ALLOW_INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NOT_USED_29', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'TIME_TRUNCATE_FRACTIONAL')
|
utf8mb3_bin
|
|
|
|
DEFINER
|
varchar(288)
|
utf8mb3_bin
|
|
|
|
CHARACTER_SET_CLIENT
|
varchar(64)
|
utf8mb3_general_ci
|
|
|
|
COLLATION_CONNECTION
|
varchar(64)
|
utf8mb3_general_ci
|
|
Visualizar valores estrangeiros
|
|
DATABASE_COLLATION
|
varchar(64)
|
utf8mb3_general_ci
|
|
Visualizar valores estrangeiros
|