Update import scripts: create table using InnoDB engine.

[platal.git] / upgrade / newdirectory-0.0.1 / 03_emails.sql

diff --git a/upgrade/newdirectory-0.0.1/03_emails.sql b/upgrade/newdirectory-0.0.1/03_emails.sql
index 6ad3c7f..dc7eea3 100644 (file)
--- a/upgrade/newdirectory-0.0.1/03_emails.sql
+++ b/upgrade/newdirectory-0.0.1/03_emails.sql
@@ -2,6 +2,6 @@ CREATE TABLE IF NOT EXISTS profile_directory (
     uid INT NOT NULL,
     email_directory VARCHAR(255) DEFAULT NULL,
     PRIMARY KEY (uid)
-) CHARSET=utf8;
+) ENGINE=InnoDB, CHARSET=utf8;
 
 ALTER TABLE register_marketing MODIFY COLUMN type ENUM('user', 'staff', 'ax');