--- a/database.mysql	Thu Jul 10 22:26:45 2014 +0200
+++ b/database.mysql	Thu Jul 17 23:24:17 2014 +0200
@@ -1,66 +1,28 @@
--- phpMyAdmin SQL Dump
--- version 3.3.9.2deb1
--- http://www.phpmyadmin.net
---
--- Machine: localhost
--- Genereertijd: 12 Apr 2011 om 01:45
--- Serverversie: 5.0.51
--- PHP-Versie: 5.3.3-7
-
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-
---
--- Database: `ivo_pnewss`
---
-
--- --------------------------------------------------------
-
---
--- Tabelstructuur voor tabel `groupmessages`
---
-
+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 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;
-
--- --------------------------------------------------------
-
---
--- Tabelstructuur voor tabel `groups`
---
-
 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;
-
--- --------------------------------------------------------
-
---
--- Tabelstructuur voor tabel `messages`
---
-
+) 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 ascii NOT NULL,
-  `body` mediumtext 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;
-
--- --------------------------------------------------------
-
---
--- Tabelstructuur voor tabel `peergroups`
---
-
+) 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,
@@ -68,19 +30,12 @@
   `high` int(10) unsigned default NULL,
   PRIMARY KEY  (`peer`,`group`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
--- --------------------------------------------------------
-
---
--- Tabelstructuur voor tabel `peers`
---
-
 CREATE TABLE IF NOT EXISTS `peers` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `address` varchar(255) collate utf8_unicode_ci NOT NULL,
-  `enabled` tinyiny(1) unsigned NOT NULL DEFAULT '1',
+  `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;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;