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,
display_name varchar(255) default null,
sex enum('female', 'male') not null default 'male',
email_format enum('text', 'html') not null default 'html',
display_name varchar(255) default null,
sex enum('female', 'male') not null default 'male',
email_format enum('text', 'html') not null default 'html',
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)