Re: [Slashcode-development] Topics

[Eric D. <eri...@ja...>]

Multiple topics would be good. How about a story can have one main
topic, but have many related subtopics? That would make more sense.

Brian Aker wrote:

> So this is what is floating around in my head for
> changes to topics. These are the needs I see:
> * Stories need to be able to belong to multiple
>   topics
> * We still need a single topic for display
> * This still has to be fast
> * We need section topics
> * The topic list is to long in admin for large
>   sites
> * Keyword support for RSS and such would be nice
>
> To pull this off, the following changes are made:
> * Stories get a sequence (need this for other stuff too..)
> * Topics get a sequence and an optional section
> * Table is created that puts a story sequence with the
>   topic sequence.
>

Yeah, but aren't the sid's or whatever is used to identify them already
unique? Then you really don't need to create a sequence do you? The
table could just have the unique fields from the topics table and the
stories table.

>
> We can either assign all topics to sections, or
> topics without sections are global.
>
> Stories are still displayed with the topic used in
> the story table. We can use the use the multiple topics
> for places where we need keyword support today.
>
> This about a days worth of work and this would be
> for 2.2 (which should add the support newsforge needs).
>
>         -Brian