-CREATE DATABASE IF NOT EXISTS profile;
grant select,
insert,
delete,
+ create,
+ drop,
update on *.* to user identified by 'user';
flush privileges;
-use profile;
-drop table 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 webchat DEFAULT CHARSET=utf8;