Re: [Postfixadmin-devel] Database scheme and upgrade

[Christian B. <pos...@cb...>]

Hello,

Am Donnerstag, 11. Oktober 2007 schrieb Christian Boltz:
> Using InnoDB seems to cause some technical problems [...]

There's also another issue: DELETE CASCADE requires that both tables -=20
vacation and vacation_notification are in InnoDB format.
If the vacation table is still a MyISAM table, the CREATE TABLE=20
vacation_notification will fail with error #1005/errno 150.

We also have to ensure that the corresponding columns in both tables=20
have the same type, length, charset etc. (Using an ID column would make=20
this a bit easier.)

Note to myself:=20
    ALTER TABLE vacation ENGINE =3D InnoDB;
should work.


Regards,

Christian Boltz
=2D-=20
> [KDE-Update] Also meine Uhr sieht exakt so aus wie vorher
> (ohne da=DF ich an den Einstellungen was gemacht h=E4tte)
Meine Uhr sieht st=E4ndig anders aus. Dauernd andere Zahlen.
[> Christoph Maurer und Bernd Brodesser in suse-linux]