Re: [Pan-devel] ancient DB schema

[Calin A. Culianu]

Well again I must repeat myself.. this is a nice db idea but I just to get
article loading to work better with 2 million headers.. that's all. In
fact.. I will leave the current flat files format for this stuff in tact.. 
I am possibly going to finish my db changes at some point, and they will 
only change the way article headers are stored/loaded/sorted/threaded.

-Calin


On Sat, 5 Jun 2004, K. Haley wrote:

> After looking at the source again I realized that there are some fileds 
> missing from the Server table.  So here is an update to it.  I still 
> don't know how filters would be handled for the groups.
> 
> 
> * primary key
> ! indexed
> 
> SERVER
> A NNTP news server.
> Rank will be used to tell which servers to hit first for a body.
> Unresolved: should we handle multiple hostname+port pairs?
> (just remember to seperate servers that handle different groups.)
> 
>   ! name              (string NOT NULL)
>     hostname          (string NOT NULL)
>     need_auth         (bool)
>     newsrc            (bool)
>     max_conn          (int)
>     username          (string)
>     password          (string)
>     port              (unsigned int=)
>     rank              (unsigned int=0)
>   * id                (integer primary key)
> 
>