1 CREATE TABLE accounts (
2 # Account identifier
and type
3 uid
int(6) not null auto_increment
,
4 hruid
varchar(255) not NULL,
6 # Account
type and state
7 type varchar(16) default null,
8 is_admin bool
default false,
9 state enum('pending', 'active', 'disabled') not null default 'pending',
12 password char(40) default null,
13 token varchar(32) default null,
14 weak_password
varchar(256) default null,
15 registration_date datetime
not null,
17 # Administrative tools
18 flags
set('watch') not null default '',
19 comment varchar(255) default null,
22 email
varchar(255) default null,
23 full_name
varchar(255) default null,
24 display_name
varchar(255) default null,
25 sex
enum('female', 'male') not null default 'male',
26 email_format
enum('text', 'html') not null default 'html',
27 skin
varchar(32) default null,
28 last_version
varchar(16) not null,
30 primary key uid (uid
),
31 unique key hruid (hruid
),
32 key full_name (full_name
),
37 CREATE TABLE account_types (
38 type varchar(16) not null,
39 perms
set('mail', 'groups', 'forums', 'list', 'search', 'portal') default '',
41 primary key type (type)
44 CREATE TABLE account_profiles (
47 perms
set('owner') not null default '',
49 primary key id (uid
, pid
),
54 # vim
:set syntax
=mysql
: