upgrade/account/01_profiles.sql

   1 create table profiles (
   2   # Profile identifiers
   3   pid int(6) not null auto_increment,
   4   hrpid varchar(255) not null,
   5
   6   # Who is this?
   7   xorg_id int(8) not null,
   8   ax_id varchar(8) default null,
   9
  10   # Some singletons
  11   # birthdate and birthdate given by reference directory (library, school...)
  12   birthdate date default null,
  13   birthdate_ref date default null,
  14   deathdate date default null,
  15
  16   # Last modification date (for notifications)
  17   last_change date not null,
  18
  19   primary key pid (pid),
  20   unique key hrpid (hrpid),
  21   unique key xorg_id (xorg_id),
  22   key ax_id (ax_id)
  23 );
  24
  25 # vim:set syntax=mysql: