+DROP TABLE IF EXISTS accounts;
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',
- skin varchar(32) default null,
+ skin tinyint(1) unsigned default null,
last_version varchar(16) not null,
primary key uid (uid),
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: