[Digikam-devel] [Bug 237878] Add foreign keys to the database schema

[Alessandro Rossini]

https://bugs.kde.org/show_bug.cgi?id=237878





--- Comment #4 from Alessandro Rossini <me alessandrorossini org>  2010-05-21 12:52:01 ---
(In reply to comment #2)
> digiKam 1.3.0 will support MySQL too. SQlite still supported of course. In
> settings panel, you can choose the DB backend.
> 
> Your DB schema with foreign keys will be fine with MySQL ?

MySQL has supported foreign keys since version 3.23.44:
http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html
With some minor changes to the syntax, my database schema should work fine with
MySQL.

> Note : later, PostgreSQL will be supported too...

As far as I remember, PostgreSQL has always supported foreign keys:
http://www.postgresql.org/docs/8.4/static/ddl-constraints.html#DDL-CONSTRAINTS-FK
Also in this case, my database schema should work fine with PostgreSQL.

If you can post or send me the current database schema proposed by Holger, I
can define and test database schemata on SQLite, MySQL and PostgreSQL.

Best regards.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.