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

[Michael Bramer]

On 08/18/2011 09:37 PM, Martijn van O wrote:
> 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.

Ah, yes, a copy and past error

Thanks

Gruss
Grisu