Nachtrag: CREATE Statements für die Beispiel Datenbank

[Stefan]

Host: MySQLSERV01

Database: test

Table: 'posts'

CREATE TABLE posts (
  id int(11) NOT NULL auto_increment,
  boardid int(11) NOT NULL default '0',
  threadid int(11) NOT NULL default '0',
  posx int(4) unsigned NOT NULL default '0',
  posy int(4) unsigned NOT NULL default '0',
  topic varchar(100) NOT NULL default '',
  time datetime NOT NULL default '0000-00-00 00:00:00',
  username varchar(20) NOT NULL default '',
  PRIMARY KEY  (id),
  FULLTEXT KEY SECONDARY (username)
  KEY TOPICSORT (topic,posy),
  KEY BOARDSORT (boardid),
  KEY THERADSORT (threadid),
  KEY TIMESORT (time),
) TYPE=MyISAM;

Table: 'postviews'

CREATE TABLE postviews (
  postid int(4) NOT NULL default '0',
  username varchar(20) NOT NULL default '',
  time datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (postid,username)
) TYPE=MyISAM;

Table: 'users'

CREATE TABLE users (
  username varchar(20) NOT NULL default '',
  name varchar(100) NOT NULL default '',
  vorname varchar(100) NOT NULL default '',
  PRIMARY KEY  (username)
) TYPE=MyISAM;