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

[Alessandro Rossini]

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: digikam-devel at kde.org
        ReportedBy: me at alessandrorossini.org


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.