-- 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 `groupmessages` (
  `group` int(10) unsigned NOT NULL,
  `message` int(10) unsigned NOT 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`
--

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,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `messageid` (`messageid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `peergroups`
--

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;

-- --------------------------------------------------------

--
-- 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,
  `post` tinyint(1) unsigned NOT NULL,
  `lastposted` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;