innoDB

[Dnj1964]

Where in the sql statement can one add

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;

I realize it would need to be added to every table

Thanks,

[ecartz]

Put

Code: Select all

SET default_storage_engine=InnoDB;

before any of the other statements in the file.

Or edit each table declaration to end:

Code: Select all

) ENGINE InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;