AFAIK the midgard article-topic-author table structure is fixed and the Midgard API relies on this structure. See http://www.midgard-project.org/manual/en/part.concepts.topicarticle.php If you want to change the model in the sense that you want (for example) to allow more than one author for an article, you'll have use your own database and implement your model in your own database scheme without being able to use the midgard functions related to articles and topics. Midgard does allow for some extension though by the ability to link parameters to any object, but this has the disadvantage of not being easily queryable.
pascal (cc to the midgard mailing list) --- "K.H. Tan" <[EMAIL PROTECTED]> wrote: > Dear all, > > I have a Midgard project ongoing, and I wonder > whether it is possible to expect Midgard to handle > relatively complex table structures. > > For example, for Author Name, I want Midgard to > look-up a list of acceptable Authors, and there may > be one or more than one author for a given article. > I would also want to have a "related articles" table > where every article has any number of related > article ids. To my mind this means that the SQL > tables would require a great deal of careful > structuring with intricate r'ships defined from the > word "go". > > Just having a pre-designated list of approved > content for the Authors scenario would not work, > because then I would not be able to easily change > all occurrences of "John Doe" to "John X. Doe" if I > ever need to do so. With a neat and well > thought-out set of tables, John Doe would be author > # 123 and a separate table will correlate author > #123 with John Doe and I can easily change that > definition to John X. Doe if I ever need to do so. > > I picked up a lot of thoughts from Daniel > Appelquist's book, XML and SQL, and wonder if they > are implementable using Midgard. > > I would be grateful for any and all assistance and > guidance on this. > > Thanks much. > > K.H. Tan > > __________________________________________________ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
