Hi Sergiu, On Tuesday 20 November 2007 01:58:07 Sergiu Dumitriu wrote:
We can't make only xwd_fullname unique, as the same document can have more than one translation, so we need to put a unique constraint on the (xwd_fullname, xwd_language) pair.
that's what I meant. I will set the constraint on our staging area and test how the wiki behaves.
A flaw in the initial design... xwd_translation isn't really needed, but we need a way to specify the default language. There is an idea to store this not in the document table, but in a document index table, so that changing the default language will be easier, among other things. But that is for another version of XWiki, and then indeed it will be enough to have only xwd_fullname and xwd_language.
Because at first there was only xwd_web and xwd_name, and xwd_fullname was added only for making shorter queries. We still need xwd_web in many queries, and computing the space name out of xwd_fullname in SQL is not such a valid option (due to performance).
Thanks for the information and thanks for your response! -- Best regards, Fabian.