CREATE TABLE diary (
  diary_key int(11) NOT NULL auto_increment,
  diary_date date NOT NULL default '0000-00-00',
  diary_title varchar(255) default NULL,
  diary_entry longtext,
  fk_user_key int(8) NOT NULL default '0',
  PRIMARY KEY  (diary_key),
  KEY diary_ndx (diary_key,fk_user_key)
) TYPE=MyISAM;