X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2F01_profiles.sql;h=040e3ee153dc7b4241c75dd8ca12faac9972966e;hb=cf92ff48fd2036b42b3e7434e7081a85a9e2c9f5;hp=dc67a498e2ad5b43e3c06d45a2ead78047a6e574;hpb=81ef0a18752dcc5a4ebd58713e6044b47d7a2a7d;p=platal.git

diff --git a/upgrade/account/01_profiles.sql b/upgrade/account/01_profiles.sql
index dc67a49..040e3ee 100644
--- a/upgrade/account/01_profiles.sql
+++ b/upgrade/account/01_profiles.sql
@@ -1,3 +1,4 @@
+drop table if exists profiles;
 create table profiles (
   # Profile identifiers
   pid int(6) not null auto_increment,
@@ -11,11 +12,35 @@ create table profiles (
   # 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,
+  freetext_pub enum('private', 'public') not null default 'private',
+  medals_pub enum('private', 'public') not null default 'private',
+  alias_pub enum('private', 'public') not null default 'private',
+
+  nationality1 char(2) 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,
 
   primary key pid (pid),
   unique key hrpid (hrpid),
   unique key xorg_id (xorg_id),
-  key ax_id (ax_id)
-);
+  key ax_id (ax_id),
+  key nationality1 (nationality1),
+  key nationality2 (nationality2),
+  key nationality3 (nationality3)
+) ENGINE=InnoDB, CHARSET=utf8;
 
 # vim:set syntax=mysql: