# Account type and state
type varchar(16) default null,
- is_admim bool default false,
+ is_admin bool default false,
state enum('pending', 'active', 'disabled') not null default 'pending',
# Access
password char(40) default null,
token varchar(32) default null,
+ weak_password varchar(256) default null,
registration_date datetime not null,
# Administrative tools
comment varchar(255) default null,
# User settings
+ email varchar(255) default null,
full_name varchar(255) default null,
display_name varchar(255) default null,
sex enum('female', 'male') not null default 'male',
- mail_format enum('plain', 'html') not null default 'html',
+ email_format enum('text', 'html') not null default 'html',
skin varchar(32) default null,
+ last_version varchar(16) not null,
primary key uid (uid),
unique key hruid (hruid),