"New fields in Authors:
- language_id
- biography (text)
- skype
- jabber
- aim"
As I see in this screen the author can write in multiple languages:
http://forum.sourcefabric.org/index.php/fa/6/

The language identifier should be in a separate table. It also make sense to
have the biography in multiple languages.

Please also use the fk_ prefix wherever you use any foreign key. E.g.:
fk_language_id instead of language_id

I see no reason to have two tables for author aliases:
author2author_alias
- fk_author_id
- fk_language_id
- fk_author_alias_id

author_alias
- id
- language_id
- name

It's over-engineered, makes the queries slower and has no advantage over
using a single table:
author_aliases
- fk_author_id
- fk_language_id
- alias or alias_name

Mugur Rus
Senior Software Developer, Sourcefabric
mugur.rus@sourcefabric.org[/email]

Cluj-Napoca, Romania
+40 (0)720 528408
Skype: mugur_rus

http://www.sourcefabric.org
http://www.twitter.com/Sourcefabric


On Tue, May 18, 2010 at 12:18 PM, Alexander Kovel <
campsite-dev@lists.sourcefabric.org[/email]> wrote:

> Hi guys!
>
> Sava asked me to prepare implementation plan where I should describe GUI
> solutions, code design, database changes. So, you can see it's below.
>
> GUI solutions
> Here http://forum.sourcefabric.org/index.php/t/2956/ are mockups which
> were
> prepared to describe all logical screen which should be implemented for
> this
> solution. For implementing all templates I want to use base Campsite
> stylesheets.
> YUI compoments which I want to try: TabView (to organize manage author
> fieldset), AutoComplete (for author field in article). Other: tinymce (for
> author's biography), jscalendar (for dates). Can I use prototype for basic
> DOM manipulations (I saw it in repository)?
>
> Code design
> I create directory "admin-files/authors" and put there next files (like I
> saw it in topics):
> - do_del.php (it should provide ability to removing authors)
> - do_edit.php (AJAX action for applying of changes)
> - do_add.php (creating new authors)
> - index.php (list of authors and tabbed edit list)
> - authors_common.php (initialization)
> I not sure, but possible I need to prepare separately actions for biography
> and change photo.
> In Authors class I'll introduce necessary setters & getters methods.
>
>
> Database changes
>
> New fields in Authors:
> - language_id
> - biography (text)
> - skype
> - jabber
> - aim
>
> author2author_alias
> - fk_author_id
> - fk_language_id
> - fk_author_alias_id
>
> author_alias
> - id
> - language_id
> - name
>
> author2author_type
> - fk_author_id
> - fk_language_id
> - fk_author_type_id
>
> author_type
> - id
> - language_id
> - name
>
> author_social_network
> - id
> - author_id
> - network
> - account
>
> --
> Best Regards, Alexander Kovel
>
>
>