CREATE TABLE authors (
  author_id int(11) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  email varchar(255) default NULL,
  PRIMARY KEY  (author_id)
) TYPE=MyISAM;

CREATE TABLE locations (
  location_id int(11) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  PRIMARY KEY  (location_id)
) TYPE=MyISAM;

CREATE TABLE posts (
  post_id int(11) NOT NULL auto_increment,
  author_id int(11) NOT NULL default '0',
  location_id int(11) default NULL,
  posted_date int(11) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  body text NOT NULL,
  body_readmore text NOT NULL,
  PRIMARY KEY  (post_id)
) TYPE=MyISAM;