4 update on *.* to user identified by 'user';
6 CREATE DATABASE IF NOT EXISTS webchat;
8 DROP TABLE IF EXISTS list;
9 CREATE TABLE list(name VARCHAR(64) NOT NULL,
10 age SMALLINT UNSIGNED DEFAULT 0,
11 height SMALLINT UNSIGNED DEFAULT 0,
12 weight SMALLINT UNSIGNED DEFAULT 0,
16 lastmodified DATETIME,
19 CREATE DATABASE IF NOT EXISTS configure;
20 DROP TABLE IF EXISTS ipbanlist;
21 CREATE TABLE ipbanlist(ip VARCHAR(64) NOT NULL,
23 DROP TABLE IF EXISTS rooms;
24 CREATE TABLE rooms(number SMALLINT UNSIGNED NOT NULL,