Re: FR, SQL backend and Foreign keys

Fabien COMBERNOUS wrote:

In the samples schema.sql proposed for SQL backend, no foreign keys are used. Any reason ?

The schema is designed to be simple. What foreign keys would you propose it use?

With ON DELETE CASCADE or ON UPDATE CASCADE constraint it should be easier to manage updates or deletetion of records ?

How? Please explain using the existing schema.

Am i missing something ?

Propose a new schema which is (a) compatible with the existing usage, and (b) has the features you want. Alan DeKok.