Database changes

DB changes relative to a default SMF 2.0 database

New tables:

CREATE TABLE {$db_prefix}messages_cache (
  id_msg int(10) unsigned NOT NULL default '0',
  body mediumtext NOT NULL,
  style tinyint(2) NOT NULL default '0',
  lang  tinyint(2) NOT NULL default '0',
  updated int(4) NOT NULL default '0',
  PRIMARY KEY (id_msg, style, lang),
  KEY updated (updated)
) ENGINE=MyISAM;

#
# Table structure for table `likes`
#

CREATE TABLE {$db_prefix}likes (
  id_msg int(10) unsigned NOT NULL default '0',
  id_user mediumint(8) unsigned NOT NULL default '0',
  id_receiver mediumint(8) unsigned NOT NULL default '0',
  updated int(4) unsigned NOT NULL default '0',
  UNIQUE liked (id_msg, id_user),
  KEY id_msg (id_msg),
  KEY id_user (id_user),
  KEY id_receiver (id_receiver),
  KEY ordering (id_msg, updated)
) ENGINE=MyISAM;

#
# Table structure for table `like_cache`
#

CREATE TABLE {$db_prefix}like_cache (
  id_msg int(10) unsigned NOT NULL default '0',
  likes_count int(4) NOT NULL default '0',
  like_status varchar(150) NOT NULL default '',
  updated int(4) NOT NULL default '0',
  PRIMARY KEY (id_msg)
) ENGINE=MyISAM;

#
# Table structure for table `prefixes`
#

CREATE TABLE {$db_prefix}prefixes (
  id_prefix smallint(5) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  boards varchar(200) NOT NULL default '',
      groups varchar(100) NOT NULL default '',
  PRIMARY KEY (id_prefix)
) ENGINE=MyISAM;

# table changes for members:
likes_received int(4) unsigned NOT NULL default '0'
likes_given int(4) unsigned NOT NULL default '0'

# table changes for messages:
has_img tinyint(3) NOT NULL default '0'  (if != it stops a post from being cached AT ALL
                                          unused at the moment but might be useful for a permission based [hide] tag

# table changes for boards
allow_topics tinyint(4) NOT NULL default '1'   (if 0, board acts as a subcat and cannot have topics).
automerge mediumint(4) unsigned NOT NULL default '0',   (automatically merge posts at the end of a thread, time in minutes)


# table changes for topics
id_prefix smallint(5) unsigned NOT NULL default '0'   (topic prefix, 0 means no prefix).
id_layout tinyint(2) NOT NULL default '0',            (sticky first post and alternative layout)