Mercurial > hg > pnewss

diff database.mysql @ 2:40e545510a57

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added support for POSTing to the server, added readme and todo, added support for upstream synchronization using POST
author Ivo Smits <Ivo@UCIS.nl>
date Tue, 12 Apr 2011 00:29:41 +0200
parents 61fac319ca3e
children 0dcdb73cbcbf
line wrap: on
line diff
--- a/database.mysql	Mon Apr 11 23:17:27 2011 +0200
+++ b/database.mysql	Tue Apr 12 00:29:41 2011 +0200
@@ -3,7 +3,7 @@
 -- http://www.phpmyadmin.net
 --
 -- Machine: localhost
--- Genereertijd: 11 Apr 2011 om 23:15
+-- Genereertijd: 12 Apr 2011 om 00:18
 -- Serverversie: 5.0.51
 -- PHP-Versie: 5.3.3-7
 
@@ -78,6 +78,8 @@
 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;