X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2F01_profiles.sql;h=040e3ee153dc7b4241c75dd8ca12faac9972966e;hb=843a2191e4c76f0beb00c754f06974de76791238;hp=4ecb6b7ecce6c4db2a769d4a4c6623cb1f6c83c4;hpb=1ebf2b93bef5ab13342293a34041b9a68ed31f03;p=platal.git

diff --git a/upgrade/account/01_profiles.sql b/upgrade/account/01_profiles.sql
index 4ecb6b7..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,7 +12,9 @@ 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,
@@ -25,6 +28,9 @@ create table profiles (
   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,
 
@@ -35,6 +41,6 @@ create table profiles (
   key nationality1 (nationality1),
   key nationality2 (nationality2),
   key nationality3 (nationality3)
-);
+) ENGINE=InnoDB, CHARSET=utf8;
 
 # vim:set syntax=mysql: