[Bug 237878] Add foreign keys to the database schema

Posted by on Jul 04, 2011; 2:54pm
URL: http://digikam.185.s1.nabble.com/Bug-237878-New-Add-foreign-keys-to-the-database-schema-tp2218853p3643811.html

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





--- Comment #7 from Alessandro Rossini <me alessandrorossini org>  2011-07-04 14:54:17 ---
(In reply to comment #6)
> Note:
> Mysql does not support foreign keys with myisam tables only with innodb ones

That is correct, but InnoDB is the default storage engine starting in MySQL
5.5:
http://dev.mysql.com/tech-resources/articles/introduction-to-mysql-55.html

Again, considering that the upcoming releases of the major distributions will
all ship MySQL 5.5 as default, there should be no issue in including foreign
keys in the database schema.

Best regards,
Alessandro Rossini

--
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