Table: s9yentries - Why "author" in every entry?

[WATCHDOG]

Hi, well I am trying to understand, why you put "author" into the s9yentries table? So author is in every single row for an entry. What is the sense of not normalizing this? There must be a reason, but I do not get it from the sources right now...

Also I found author is not changed in the existing s9yentries, when author changes its username in "Personal Settings". That means the information is not valid anymore and the whole data is inconsistent.

Also this way it is not possible to have multiple authors on one article?

What if username != author? I will need custom_entryproperties then?

Just trying to understand, whats going on behind the scenes.

Thanks!

[garvinhicking]

Hi!

This is because of old compatibility, when multiple authors were not yet supported. Plus, we kept it because when you delete an author accuont, you can still keep the old entries of him and know what his name was.

However, the name of an author should be reflected in the default entry display. At least it seems to work for me here, because the authorid is actually used.

Also this way it is not possible to have multiple authors on one article?

That is true, this is not supported. But for entry permissions we use usergroups, so it should never be required to have multiple author ownership.

HTH,
Garvin

[WATCHDOG]

oh my god.

sorry for asking