grant select,
	insert,
	delete,
	update on *.* to user identified by 'user';
flush privileges;
CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;
use webchat;
CREATE TABLE list(
# does not edit
# from
	name_hash INT UNSIGNED NOT NULL,
	name VARCHAR(64) NOT NULL,
	lastmodified DATETIME,
	password VARCHAR(32),
# to
	mailto VARCHAR(255),
	age SMALLINT  UNSIGNED DEFAULT 0,
	height SMALLINT  UNSIGNED DEFAULT 0,
	weight SMALLINT  UNSIGNED DEFAULT 0,
	gender VARCHAR(8),
	race VARCHAR(64),
	etc TEXT,
# does not edit
# from
	PRIMARY KEY(name_hash));
# to

CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,
	type CHAR(1));

CREATE TABLE rooms(number SMALLINT UNSIGNED NOT NULL,
	password VARCHAR(16),
	hiddenlog BOOL);
