Reimer

Any news on this? Maybe a RSS-Feed might help you.

Thanks a lot. Here are the important tables of the database. I didn’t add all, because the others are not important.
<pre>
CREATE TABLE articles (
id int(10) unsigned NOT NULL auto_increment,
title varchar(255) NOT NULL default ”,
lead text NOT NULL,
article text NOT NULL,
linebreaks enum(‘1′,’0’) NOT NULL default ‘1’,
convert enum(‘1′,’0’) NOT NULL default ‘0’,
display enum(‘1′,’0’) NOT NULL default ‘1’,
comments enum(‘1′,’0’) NOT NULL default ‘1’,
amount_c int(10) unsigned NOT NULL default ‘0’,
author int(10) unsigned NOT NULL default ‘0’,
timestamp datetime default NULL,
PRIMARY KEY (id),
KEY display (display),
KEY timestamp (timestamp),
KEY author (author),
FULLTEXT KEY admin_search (title,lead,article)
) TYPE=MyISAM;
# ——————————————————–
#
# Tabellenstruktur für Tabelle authors
#
CREATE TABLE authors (
id int(10) unsigned NOT NULL auto_increment,
name varchar(255) NOT NULL default ”,
email varchar(255) NOT NULL default ”,
homepage varchar(255) NOT NULL default ”,
pwd varchar(32) NOT NULL default ”,
rights char(1) NOT NULL default ”,
PRIMARY KEY (id),
KEY pw_check (name,pwd)
) TYPE=MyISAM;
# ——————————————————–
#
# Tabellenstruktur für Tabelle categories
#
CREATE TABLE categories (
id int(10) unsigned NOT NULL auto_increment,
lft int(10) unsigned NOT NULL default ‘0’,
rgt int(10) unsigned NOT NULL default ‘0’,
root_node int(10) unsigned NOT NULL default ‘0’,
level int(10) unsigned NOT NULL default ‘0’,
title varchar(255) NOT NULL default ”,
optional_1 varchar(255) NOT NULL default ”,
optional_2 varchar(255) NOT NULL default ”,
optional_3 text NOT NULL,
display enum(‘1′,’0’) NOT NULL default ‘1’,
PRIMARY KEY (id),
KEY display (display)
) TYPE=MyISAM;
</pre>