+DROP TABLE IF EXISTS accounts;
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,
+ 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',
- 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)
-);
+) ENGINE=InnoDB, CHARSET=utf8;
+DROP TABLE IF EXISTS account_types;
CREATE TABLE account_types (
type varchar(16) not null,
perms set('mail', 'groups', 'forums', 'list', 'search', 'portal') default '',
primary key type (type)
-);
+) ENGINE=InnoDB, CHARSET=utf8;
+DROP TABLE IF EXISTS account_profiles;
CREATE TABLE account_profiles (
uid int(6) not null,
pid int(6) not null,
primary key id (uid, pid),
key uid (uid),
key pid (pid)
-);
+) ENGINE=InnoDB, CHARSET=utf8;
# vim:set syntax=mysql: