Mercurial > hg > pnewss
view database.mysql @ 12:7917bd536187 draft
Added hook for new articles, detect send/write failures, fixed handling of multiline headers, add Date header if it doesn't exist, add option to disable peers, fixes for synchronization with INN, added streaming mode support, small fixes
author | Ivo Smits <Ivo@UCIS.nl> |
---|---|
date | Wed, 12 Jun 2013 22:22:07 +0200 |
parents | 0dcdb73cbcbf |
children | 372f4e195986 |
line wrap: on
line source
-- 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, `enabled` tinyiny(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;