+drop table if exists profiles;
create table profiles (
# Profile identifiers
pid int(6) not null auto_increment,
# birthdate and birthdate given by reference directory (library, school...)
birthdate date default null,
birthdate_ref date default null,
+ next_birthday date default null,
deathdate date default null,
+ deathdate_rec date default null,
+ sex enum('female', 'male') not null default 'male',
section tinyint(2) unsigned default null,
cv text default null,
freetext mediumtext default null,
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: