-CREATE DATABASE IF NOT EXISTS profile;
grant select,
insert,
delete,
- update,
- create,
- drop,
- file,
- alter,
- index on *.* to user identified by 'user';
+ update on *.* to user identified by 'user';
flush privileges;
-use profile;
-create table list(name VARCHAR(64) NOT NULL,
- age INT,
- height INT,
- weight INT,
+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,
+ gender VARCHAR(8),
race VARCHAR(64),
- look TEXT,
password VARCHAR(16),
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);