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

create table profiles (
  # Profile identifiers
  pid int(6) not null auto_increment,
  hrpid varchar(255) not null,

  # Who is this?
  xorg_id int(8) not null,
  ax_id varchar(8) default null,

  # Some singletons
  # birthdate and birthdate given by reference directory (library, school...)
  birthdate date default null,
  birthdate_ref date default null,
  deathdate date default null,

  primary key pid (pid),
  unique key hrpid (hrpid),
  unique key xorg_id (xorg_id),
  key ax_id (ax_id)
);

# vim:set syntax=mysql:
Commit	Line	Data
81ef0a18 FB	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,
cde4fb1d	14	deathdate date default null,
81ef0a18 FB	15
	16	primary key pid (pid),
	17	unique key hrpid (hrpid),
	18	unique key xorg_id (xorg_id),
	19	key ax_id (ax_id)
	20	);
	21
	22	# vim:set syntax=mysql: