X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F03_emails.sql;h=dc7eea3caae57ddff03928f22139ed80e36f2ea1;hb=950bf4f677e923c34f7d1523215f06876e338717;hp=6ad3c7f752e6e99bde9a08fa9c246d623ad7631a;hpb=96d80a35f4abef2b94d2f2b8f5442230141398d1;p=platal.git diff --git a/upgrade/newdirectory-0.0.1/03_emails.sql b/upgrade/newdirectory-0.0.1/03_emails.sql index 6ad3c7f..dc7eea3 100644 --- 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');