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(name VARCHAR(64) NOT NULL,
	age SMALLINT  UNSIGNED DEFAULT 0,
	height SMALLINT  UNSIGNED DEFAULT 0,
	weight SMALLINT  UNSIGNED DEFAULT 0,
	gender VARCHAR(8),
	race VARCHAR(64),
	password VARCHAR(16),
	lastmodified DATETIME,
	etc TEXT,
	PRIMARY KEY(name));
CREATE DATABASE IF NOT EXISTS configure;
CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,
	type CHAR(1));
CREATE TABLE rooms(number SMALLINT UNSIGNED NOT NULL,
	password VARCHAR(16),
	hiddenlog BOOL);
