Forum OpenACS Q&A: Response to CMS on 3.2.5

Collapse
8: Response to CMS on 3.2.5 (response to 1)
Posted by Luke Pond on
I made a mistake with the tarball I uploaded, which is probably making you feel very confused!  The "cm.sql" file I included is *not* the correct data model file.  I have just uploaded a new version of the code that contains the correct data model file, which is called "upo-topics.sql".

As you can see if you look at the data model, it's very simple and allows you to create topics that contain pages or other topics.  The mapping between topics and pages is many-to-many; i.e. the same page can be referenced by more than one topic.  So it seems very likely to me that you can use this topics system instead of your existing categories table.

The data model allows as many levels of nesting as you want; however, the registered procedure that serves /topics/* only handles two levels (topic/subtopic/page), since that's all the client needed.  It would be easy enough to rewrite that part to remove that limitation.