innoDB
Posted: Wed Jun 23, 2021 4:15 pm
Where in the sql statement can one add
I realize it would need to be added to every table
Thanks,
SET default_storage_engine=InnoDB;
Code: Select all
DROP TABLE IF EXISTS action_recorder;
CREATE TABLE action_recorder (
id int NOT NULL auto_increment,
module varchar(255) NOT NULL,
user_id int,
user_name varchar(255),
identifier varchar(255) NOT NULL,
success char(1),
date_added datetime NOT NULL,
PRIMARY KEY (id),
KEY idx_action_recorder_module_date (module, date_added),
KEY idx_action_recorder_user_id (user_id)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;Thanks,