SQL schema for radcheck table

Matt Zagrabelny mzagrabe at d.umn.edu
Wed Jan 15 21:58:15 CET 2014


Greetings,

Looking at the file raddb/mods-config/sql/main/postgresql/schema.sql
in the git repo, I see:

CREATE TABLE radcheck (
    id          serial PRIMARY KEY,
    UserName        text NOT NULL DEFAULT '',
    Attribute       text NOT NULL DEFAULT '',
    op          VARCHAR(2) NOT NULL DEFAULT '==',
    Value           text NOT NULL DEFAULT ''
);

Is the "id" field used by FR? Or does it exist for administration of
the table in case someone enters two records with identical (UserName,
Attribute, op, Values) values?

Thanks,

-mz


More information about the Freeradius-Users mailing list