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, | |
14 | ||
15 | primary key pid (pid), | |
16 | unique key hrpid (hrpid), | |
17 | unique key xorg_id (xorg_id), | |
18 | key ax_id (ax_id) | |
19 | ); | |
20 | ||
21 | # vim:set syntax=mysql: |