X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2F01_profiles.sql;h=040e3ee153dc7b4241c75dd8ca12faac9972966e;hb=148af7a9ef164291a44262de6a07285b1ab152f6;hp=96c0f857180e2ed3934e5b646365fcffa48b1144;hpb=950bf4f677e923c34f7d1523215f06876e338717;p=platal.git

diff --git a/upgrade/account/01_profiles.sql b/upgrade/account/01_profiles.sql
index 96c0f85..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,
@@ -27,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,