-CREATE DATABASE IF NOT EXISTS profile;
grant select,
insert,
delete,
update on *.* to user identified by 'user';
flush privileges;
-use profile;
-drop table list;
-create table list(name VARCHAR(64) NOT NULL,
+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,
height SMALLINT UNSIGNED DEFAULT 0,
weight SMALLINT UNSIGNED DEFAULT 0,
lastmodified DATETIME,
etc TEXT,
PRIMARY KEY(name));
+CREATE DATABASE IF NOT EXISTS configure;
+DROP TABLE IF EXISTS ipbanlist;
+CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,
+ type CHAR(1));
+DROP TABLE IF EXISTS rooms;
+CREATE TABLE rooms(number SMALLINT UNSIGNED NOT NULL,
+ password VARCHAR(16),
+ hiddenlog BOOL);