+drop table if exists profiles;
create table profiles (
# Profile identifiers
pid int(6) not null auto_increment,
nationality2 char(2) default null,
nationality3 char(2) default null,
+ # Directory informations
+ email_directory varchar(255) default null,
+
# Last modification date (for notifications)
last_change date not null,
key nationality1 (nationality1),
key nationality2 (nationality2),
key nationality3 (nationality3)
-);
+) ENGINE=InnoDB, CHARSET=utf8;
# vim:set syntax=mysql: