[Bug 237878] Add foreign keys to the database schema

Posted by on May 21, 2010; 10:52am
URL: http://digikam.185.s1.nabble.com/Bug-237878-New-Add-foreign-keys-to-the-database-schema-tp2218853p2225971.html

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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel