Commit | Line | Data |
---|---|---|
d0293d9b | 1 | DROP TABLE IF EXISTS accounts; |
0eeb71ec FB |
2 | CREATE TABLE accounts ( |
3 | # Account identifier and type | |
4 | uid int(6) not null auto_increment, | |
5 | hruid varchar(255) not NULL, | |
6 | ||
7 | # Account type and state | |
8 | type varchar(16) default null, | |
791a11c8 | 9 | is_admin bool default false, |
0eeb71ec FB |
10 | state enum('pending', 'active', 'disabled') not null default 'pending', |
11 | ||
12 | # Access | |
13 | password char(40) default null, | |
c67ba12a | 14 | token varchar(32) default null, |
0511895d | 15 | weak_password varchar(256) default null, |
0eeb71ec FB |
16 | registration_date datetime not null, |
17 | ||
18 | # Administrative tools | |
19 | flags set('watch') not null default '', | |
20 | comment varchar(255) default null, | |
21 | ||
22 | # User settings | |
cb8a8977 | 23 | email varchar(255) default null, |
6457ddb4 FB |
24 | full_name varchar(255) default null, |
25 | display_name varchar(255) default null, | |
0eeb71ec | 26 | sex enum('female', 'male') not null default 'male', |
0907974b | 27 | email_format enum('text', 'html') not null default 'html', |
7cfaf494 | 28 | skin tinyint(1) unsigned default null, |
0511895d | 29 | last_version varchar(16) not null, |
0eeb71ec FB |
30 | |
31 | primary key uid (uid), | |
32 | unique key hruid (hruid), | |
c67ba12a | 33 | key full_name (full_name), |
0eeb71ec FB |
34 | key state (state), |
35 | key type (type) | |
950bf4f6 | 36 | ) ENGINE=InnoDB, CHARSET=utf8; |
0eeb71ec | 37 | |
d0293d9b | 38 | DROP TABLE IF EXISTS account_types; |
0eeb71ec FB |
39 | CREATE TABLE account_types ( |
40 | type varchar(16) not null, | |
41 | perms set('mail', 'groups', 'forums', 'list', 'search', 'portal') default '', | |
42 | ||
43 | primary key type (type) | |
950bf4f6 | 44 | ) ENGINE=InnoDB, CHARSET=utf8; |
0eeb71ec | 45 | |
d0293d9b | 46 | DROP TABLE IF EXISTS account_profiles; |
0eeb71ec FB |
47 | CREATE TABLE account_profiles ( |
48 | uid int(6) not null, | |
49 | pid int(6) not null, | |
147310cf | 50 | perms set('owner') not null default '', |
0eeb71ec FB |
51 | |
52 | primary key id (uid, pid), | |
53 | key uid (uid), | |
54 | key pid (pid) | |
950bf4f6 | 55 | ) ENGINE=InnoDB, CHARSET=utf8; |
0eeb71ec FB |
56 | |
57 | # vim:set syntax=mysql: |