[OpenSER-Devel] Defining MySQL foreign key constraint

[Henning Westerholt]

On Friday 13 July 2007, you wrote:
> Hello,
>
> Thanks for the answers.
>
> I've discovered one more thing while creating my tables, that we could
> also need TIMESTAMP column types besides DATETIME (in MySQL at least, I
> don't know the correspondence for the other database engines.) One
> advantage of TIMESTAMP
> (http://dev.mysql.com/doc/refman/5.0/en/timestamp.html) is for example
> that you can specify |both DEFAULT CURRENT_TIMESTAMP| and |ON UPDATE
> CURRENT_TIMESTAMP| clauses, and so the column will automatically updated
> to the current timestamp (this is useful in 'last_modified' columns).

Hello Mircea,

i've changed the mysql engine specification according your suggestions.

Regarding the TIMESTAMP:
AFAIK postgres don't provide the ON UPDATE clause. You could work around this 
with a trigger, but for dbtext this is not possible. So i guess this is the 
reason that the logic to update the timestamp is located in openser, and not 
in the database.

Cheers,

Henning