Only uses autoload to require validation classes.

[platal.git] / upgrade / account / 01_profiles.sql

diff --git a/upgrade/account/01_profiles.sql b/upgrade/account/01_profiles.sql
index e8eb099..040e3ee 100644 (file)
--- 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,
 create table profiles (
   # Profile identifiers
   pid int(6) not null auto_increment,


@@ -11,8 +12,11 @@ create table profiles (
   # birthdate and birthdate given by reference directory (library, school...)
   birthdate date default null,
   birthdate_ref date default null,
   # 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 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,
   section tinyint(2) unsigned default null,
   cv text default null,
   freetext mediumtext default null,


@@ -24,6 +28,9 @@ create table profiles (
   nationality2 char(2) default null,
   nationality3 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,
 
   # Last modification date (for notifications)
   last_change date not null,
 


@@ -34,6 +41,6 @@ create table profiles (
   key nationality1 (nationality1),
   key nationality2 (nationality2),
   key nationality3 (nationality3)
   key nationality1 (nationality1),
   key nationality2 (nationality2),
   key nationality3 (nationality3)

-);
+) ENGINE=InnoDB, CHARSET=utf8;

 
 # vim:set syntax=mysql:
 
 # vim:set syntax=mysql: