22 Nov
2007
22 Nov
'07
8:48 p.m.
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.