Login  Register

[digikam] [Bug 237878] MySQL : Add foreign keys to the database schema [patch]

Posted by Gilles Caulier-4 on Aug 08, 2014; 8:12am
URL: http://digikam.185.s1.nabble.com/Bug-237878-New-Add-foreign-keys-to-the-database-schema-tp2218853p4671133.html

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

--- Comment #8 from Gilles Caulier <[hidden email]> ---
Marcel,

I look if we can include foreign keys in database schema

- SQlite3 support it since 3.6.19 :

http://www.sqlite.org/foreignkeys.html

Sqlite current version is 3.8.5

- Mysql support it since 5.5 :

http://dev.mysql.com/doc/refman/5.1/en/create-table-foreign-keys.html

Mysql current version is 5.6.20

- MariaDb support it but i cannot see since which version exactly ?

- Postgresql support it too

Gilles

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