Mercurial > hg > pnewss

comparison 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
comparison
equal deleted inserted replaced
1:61fac319ca3e 2:40e545510a57
1 -- phpMyAdmin SQL Dump 1 -- phpMyAdmin SQL Dump
2 -- version 3.3.9.2deb1 2 -- version 3.3.9.2deb1
3 -- http://www.phpmyadmin.net 3 -- http://www.phpmyadmin.net
4 -- 4 --
5 -- Machine: localhost 5 -- Machine: localhost
6 -- Genereertijd: 11 Apr 2011 om 23:15 6 -- Genereertijd: 12 Apr 2011 om 00:18
7 -- Serverversie: 5.0.51 7 -- Serverversie: 5.0.51
8 -- PHP-Versie: 5.3.3-7 8 -- PHP-Versie: 5.3.3-7
9 9
10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11 11
76 -- 76 --
77 77
78 CREATE TABLE IF NOT EXISTS `peers` ( 78 CREATE TABLE IF NOT EXISTS `peers` (
79 `id` int(10) unsigned NOT NULL auto_increment, 79 `id` int(10) unsigned NOT NULL auto_increment,
80 `address` varchar(255) collate utf8_unicode_ci NOT NULL, 80 `address` varchar(255) collate utf8_unicode_ci NOT NULL,
81 `post` tinyint(1) unsigned NOT NULL,
82 `lastposted` int(10) unsigned default NULL,
81 PRIMARY KEY (`id`) 83 PRIMARY KEY (`id`)
82 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 84 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
83 85