Mercurial > hg > pnewss

comparison database.mysql @ 3:0dcdb73cbcbf

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Increased article body length to 16MB in database scheme, cleaned up the code, added a script to forcefully reload an individual article
author Ivo Smits <Ivo@UCIS.nl>
date Tue, 12 Apr 2011 01:47:09 +0200
parents 40e545510a57
children 7917bd536187
comparison
equal deleted inserted replaced
2:40e545510a57 3:0dcdb73cbcbf
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: 12 Apr 2011 om 00:18 6 -- Genereertijd: 12 Apr 2011 om 01:45
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
48 48
49 CREATE TABLE IF NOT EXISTS `messages` ( 49 CREATE TABLE IF NOT EXISTS `messages` (
50 `id` int(10) unsigned NOT NULL auto_increment, 50 `id` int(10) unsigned NOT NULL auto_increment,
51 `messageid` varchar(255) character set ascii NOT NULL, 51 `messageid` varchar(255) character set ascii NOT NULL,
52 `header` text character set ascii NOT NULL, 52 `header` text character set ascii NOT NULL,
53 `body` text character set ascii NOT NULL, 53 `body` mediumtext character set ascii NOT NULL,
54 PRIMARY KEY (`id`), 54 PRIMARY KEY (`id`),
55 UNIQUE KEY `messageid` (`messageid`) 55 UNIQUE KEY `messageid` (`messageid`)
56 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 56 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
57 57
58 -- -------------------------------------------------------- 58 -- --------------------------------------------------------