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,
state enum('pending', 'active', 'disabled') not null default 'pending',
# Access
password char(40) default null,
state enum('pending', 'active', 'disabled') not null default 'pending',
# Access
password char(40) default null,
- name varchar(255) default null,
+ email varchar(255) default null,
+ full_name varchar(255) default null,
+ display_name varchar(255) default null,
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)