1 create table profiles (
3 pid
int(6) not null auto_increment
,
4 hrpid
varchar(255) not null,
7 xorg_id
int(8) not null,
8 ax_id
varchar(8) default null,
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,
16 sex
enum('female', 'male') not null default 'male',
17 section tinyint(2) unsigned
default null,
19 freetext mediumtext
default null,
20 freetext_pub
enum('private', 'public') not null default 'private',
21 medals_pub
enum('private', 'public') not null default 'private',
22 alias_pub
enum('private', 'public') not null default 'private',
24 nationality1
char(2) default null,
25 nationality2
char(2) default null,
26 nationality3
char(2) default null,
28 #
Last modification
date (for notifications
)
29 last_change
date not null,
31 primary key pid (pid
),
32 unique key hrpid (hrpid
),
33 unique key xorg_id (xorg_id
),
35 key nationality1 (nationality1
),
36 key nationality2 (nationality2
),
37 key nationality3 (nationality3
)
40 # vim
:set syntax
=mysql
: