#Sql120640_3

create table user (
uid integer auto_increment primary key, 
name varchar(20), 
last timestamp, 
rid integer, 
pass varchar(64));

create table room (
rid integer auto_increment primary key, 
name varchar(20), 
descript varchar(255), 
typ varchar(1),
adminid integer);

create table message (
time timestamp,
rid integer,
send_id integer,
rcpt_id integer,
message text);

create table session (
uid integer,
time timestamp,
skey varchar(64),
ip varchar(16));