lacemi_v32/data/sql/clear_db_log.sql

DROP TABLE IF EXISTS `t_log_edit`;
CREATE TABLE IF NOT EXISTS `t_log_edit`  (
`log_edit_id` int(11) NOT NULL AUTO_INCREMENT,
`log_company_id` int(11) NULL DEFAULT NULL,
`log_user_id` int(11) NULL DEFAULT NULL,
`log_edit_clazz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`log_edit_oldvalue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
`log_edit_newvalue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
`log_action` tinyint(1) NULL DEFAULT NULL,
`ctime` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`log_edit_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;