grant select,
insert,
delete,
+ create,
+ drop,
update on *.* to user identified by 'user';
flush privileges;
-CREATE DATABASE IF NOT EXISTS profile;
-use profile;
-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,
- gender VARCHAR(8),
- race VARCHAR(64),
- password VARCHAR(16),
- lastmodified DATETIME,
- 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));
-DROP TABLE IF EXISTS rooms;
-CREATE TABLE rooms(number SMALLINT UNSIGNED NOT NULL,
- password VARCHAR(16),
- hiddenlog BOOL);
+CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;