delete,
update on *.* to user identified by 'user';
flush privileges;
-CREATE DATABASE IF NOT EXISTS profile;
-use profile;
+CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;
+use webchat;
DROP TABLE IF EXISTS list;
CREATE TABLE list(name VARCHAR(64) NOT NULL,
age SMALLINT UNSIGNED DEFAULT 0,
etc TEXT,
PRIMARY KEY(name));
CREATE DATABASE IF NOT EXISTS configure;
-use configure;
DROP TABLE IF EXISTS ipbanlist;
CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,
type CHAR(1));