Re: pear weekly news
| From: | Martin Jansen | Date: | Sat, 06 Jul 2002 09:01:14 +0000 |
| Subject: | Re: pear weekly news | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-7507@lists.php.net to get a copy of this message | ||
On Sat Jul 06, 2002 at 10:1813AM +0200, Martin Jansen wrote:
> On Fri Jul 05, 2002 at 03:1832PM +0200, Tomas V.V.Cox wrote:
> > The solution is simple: if someone wants to take care on developing a
> > reduced news manager go for it, if not, use a static template included
> > from a PHP.
>
> I can do such a thingie.
To start a first discussion on how the dynamic solution for the weekly
news might look like, here is a suggestion for the table layout:
CREATE TABLE weeklynews (
id int(10) unsigned NOT NULL default '0',
year year(4) NOT NULL default '0000',
week tinyint(4) NOT NULL default '0',
report text NOT NULL,
language char(2) NOT NULL default '',
author int(11) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY week (week),
FULLTEXT KEY report (report)
);
Most things should be obvious here. The column "author" keeps a
foreign key to the table "users". Language is "en", "fr",
"de"
and so on.
Comments? Alan?
- Martin
--
Martin Jansen - mail@martin-jansen.de
http://martinjansen.com/