[Debian-l10n-devel] Proposel for the new message system in DDTSS

[Martijn van O]

On 18 August 2011 09:58, Michael Bramer <grisu at debian.org> wrote:
> add a new row 'description_id' and use the message system for the
> comments of the Translation/Review Process. With this we had:
>  - no problemes with one user override the message a other reviewer
>   (no locking in the review process)
>  - everey message has a Timestamp and a author
>  - the comment is 'fixed' at the description. If a translation changes
>   and must a second time to the review process, we don't lost the old
>   comments
>  - We can support reply to a comment.
>   (one reviewer add a comment with a question: ex: 'Spelling XXX
>   right?'
>   The next reviewer can write a reply to this message, and:
>   the first reviewer _and_ the description get a new message

These all sound good.

> CREATE TABLE messages_tb (
>    message_id integer NOT NULL,
>    language character varying,
>    to_user character varying,
>    description_id nteger NOT NULL,
>    from_user character varying NOT NULL,
>    "timestamp" integer NOT NULL,
>    message character varying NOT NULL
> );

description_id can be NULL, but other than that it looks fine.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/