CREATE TABLE IF NOT EXISTS `blacklist` (
  `messageid` varchar(255) character set ascii NOT NULL,
  PRIMARY KEY  (`messageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `groupmessages` (
  `group` int(10) unsigned NOT NULL,
  `message` int(10) unsigned default NULL,
  `number` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`group`,`number`),
  KEY `message` (`message`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) character set ascii NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `messageid` varchar(255) character set ascii NOT NULL,
  `header` text character set latin1 collate latin1_bin NOT NULL,
  `body` mediumtext character set latin1 collate latin1_bin NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `messageid` (`messageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `peergroups` (
  `peer` int(10) unsigned NOT NULL,
  `group` int(10) unsigned NOT NULL,
  `low` int(10) unsigned default NULL,
  `high` int(10) unsigned default NULL,
  PRIMARY KEY  (`peer`,`group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `peers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `address` varchar(255) collate utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) unsigned NOT NULL default '1',
  `post` tinyint(1) unsigned NOT NULL,
  `lastposted` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;