4 update on *.* to user identified by 'user';
6 CREATE DATABASE IF NOT EXISTS webchat DEFAULT CHARSET=utf8;
8 DROP TABLE IF EXISTS list;
12 name_hash INT UNSIGNED NOT NULL,
13 name VARCHAR(64) NOT NULL,
14 lastmodified DATETIME,
18 age SMALLINT UNSIGNED DEFAULT 0,
19 height SMALLINT UNSIGNED DEFAULT 0,
20 weight SMALLINT UNSIGNED DEFAULT 0,
26 PRIMARY KEY(name_hash));
29 DROP TABLE IF EXISTS ipbanlist;
30 CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,
33 DROP TABLE IF EXISTS rooms;
34 CREATE TABLE rooms(number SMALLINT UNSIGNED NOT NULL,