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   freetext mediumtext default null,
  16   freetext_pub enum('private', 'public') not null default 'private',
  17   medals_pub enum('private', 'public') not null default 'private',
  18   alias_pub enum('private', 'public') not null default 'private',
  19
  20   # Last modification date (for notifications)
  21   last_change date not null,
  22
  23   primary key pid (pid),
  24   unique key hrpid (hrpid),
  25   unique key xorg_id (xorg_id),
  26   key ax_id (ax_id)
  27 );
  28
  29 # vim:set syntax=mysql: