CREATE TABLE accounts (
# Account identifier and type
uid int(6) not null auto_increment,
CREATE TABLE accounts (
# Account identifier and type
uid int(6) not null auto_increment,
# Access
password char(40) default null,
token varchar(32) default null,
# Access
password char(40) default null,
token varchar(32) default null,
full_name varchar(255) default null,
display_name varchar(255) default null,
sex enum('female', 'male') not null default 'male',
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',
- skin varchar(32) default null,
+ email_format enum('text', 'html') not null default 'html',
+ skin tinyint(1) unsigned default null,
+ last_version varchar(16) not null,
primary key uid (uid),
unique key hruid (hruid),
key full_name (full_name),
key state (state),
key type (type)
primary key uid (uid),
unique key hruid (hruid),
key full_name (full_name),
key state (state),
key type (type)
CREATE TABLE account_types (
type varchar(16) not null,
perms set('mail', 'groups', 'forums', 'list', 'search', 'portal') default '',
primary key type (type)
CREATE TABLE account_types (
type varchar(16) not null,
perms set('mail', 'groups', 'forums', 'list', 'search', 'portal') default '',
primary key type (type)