e5f9cd126a0a2ec910068c938d3d4b415619a8ee
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,
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',
20 #
Last modification
date (for notifications
)
21 last_change
date not null,
23 primary key pid (pid
),
24 unique key hrpid (hrpid
),
25 unique key xorg_id (xorg_id
),
29 # vim
:set syntax
=mysql
: