set_charset("utf8");
$sql = " create table user(
id tinyint unsigned not null,
name varchar(16) not null,
mail varchar(32) not null,
pass varchar(16) not null,
crkey varchar(256) not null
)";
if(!$res=$db->query($sql)) die($db->error);
if( 0 == $db->errno ) $ret .= "Tabelle user angelegt
";
$sql = "create table hosts(
id tinyint not null,
host varchar(32) not null,
seit timestamp default current_timestamp,
session varchar(32)
)";
if(!$res=$db->query($sql)) die($db->error);
if( 0 == $db->errno ) $ret .= "Tabelle user angelegt
";
$sql = "create table thread(
nr tinyint not null,
user tinyint not null,
title varchar(64) not null,
date timestamp default current_timestamp
)";
if(!$res=$db->query($sql)) die($db->error);
if( 0 == $db->errno ) $ret .= "Tabelle user angelegt
";
$sql = "create table post(
thread tinyint not null,
user tinyint not null,
post varchar(256) not null,
date timestamp default current_timestamp
)";
if(!$res=$db->query($sql)) die($db->error);
if( 0 == $db->errno ) $ret .= "Tabelle user angelegt
";
$sql = "insert user values(1,\"Admin\",\"vbmattes@gmx.de\",\"geheim\",\"noch geheimer\")";
if( 0 == $db->errno ) $ret .= "user Admin angelegt";
echo $ret;
?>