Posted by
Bugzilla from me@alessandrorossini.org on
May 16, 2010; 8:16pm
URL: http://digikam.185.s1.nabble.com/Bug-237878-New-Add-foreign-keys-to-the-database-schema-tp2218853.html
https://bugs.kde.org/show_bug.cgi?id=237878 Summary: Add foreign keys to the database schema
Product: digikam
Version: unspecified
Platform: Ubuntu Packages
OS/Version: unspecified
Status: UNCONFIRMED
Severity: wishlist
Priority: NOR
Component: general
AssignedTo:
[hidden email]
ReportedBy:
[hidden email]
Version: (using KDE 4.4.3)
Installed from: Ubuntu Packages
I think that adding foreign keys would avoid many of the current triggers in
the database schema, and I guess that the database would be more efficient.
I have added foreign keys to the current database schema (see attachment). I
have not added a foreign key from the icon column of the Albums table to the id
column of the Images table since this would introduce a circular dependency
between the Albums and Images tables. However, this would be easily solved by
adding a new AlbumIcon table or similar. Note that SQLite version 3.6.19+ is
needed to execute these statements (see
http://www.sqlite.org/foreignkeys.html).
I have migrated my current database to the updated schema and it seems to work
without problems with Digikam 1.2.0.
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