niota

This table is used to save the logs in case logging to db is turned on.

etx_useraction.sql

CREATE TABLE `etx_useraction` (
  `id_log` BIGINT NOT NULL AUTO_INCREMENT,
  `ts_log` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `id_session` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `db_name` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `object` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `catalog_id` INT NOT NULL,
  `instance_name` VARCHAR(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `action` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `username` VARCHAR(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `command` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id_log`)
) ENGINE=InnoDB AUTO_INCREMENT=761 DEFAULT CHARSET=utf8mb3;