FR, SQL backend and Foreign keys

Alan DeKok aland at deployingradius.com
Tue Sep 27 11:25:37 CEST 2011


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.



More information about the Freeradius-Users mailing list