CREATE TABLE chaos_gaestebuch (
   id int(10) NOT NULL auto_increment,
   name varchar(100) NOT NULL,
   email varchar(100) NOT NULL,
   wohnort varchar(100) NOT NULL,
   datum int(11) DEFAULT '0' NOT NULL,
   ip varchar(60) NOT NULL,
   host varchar(60) NOT NULL,
   homepage varchar(100) NOT NULL,
   eintrag text NOT NULL,
   geschlecht tinyint(2) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);


CREATE TABLE chaos_gaeste_kommentar (
   id int(10) NOT NULL auto_increment,
   eintragid int(10) DEFAULT '0' NOT NULL,
   name varchar(100) NOT NULL,
   email varchar(100) NOT NULL,
   wohnort varchar(100) NOT NULL,
   datum int(11) DEFAULT '0' NOT NULL,
   ip varchar(60) NOT NULL,
   host varchar(60) NOT NULL,
   homepage varchar(100) NOT NULL,
   eintrag text NOT NULL,
   geschlecht tinyint(2) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY eintragid (eintragid)
);

