# 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,
registration_date datetime not null,
# Administrative tools
comment varchar(255) default null,
# User settings
- name 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,
primary key uid (uid),
unique key hruid (hruid),
- key name (name),
+ key full_name (full_name),
key state (state),
key type (type)
);
CREATE TABLE account_profiles (
uid int(6) not null,
pid int(6) not null,
+ perms set('owner') not null default '',
primary key id (uid, pid),
key uid (uid),