SQL schema for radcheck table

[Matt Zagrabelny]

On Wed, Jan 15, 2014 at 3:11 PM, Arran Cudbard-Bell
<a.cudbardb at freeradius.org> wrote:
>
> On 15 Jan 2014, at 20:58, Matt Zagrabelny <mzagrabe at d.umn.edu> wrote:
>
>> 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?
>
> Administration. Some tools (like pgAdmin) won't operate on a table unless there's a primary key.
>
> Primary key could be UserName, Attribute, Op, Value, but there are some cases (using -=, or += for example) where two or more identical rows could exist.

Thanks for the timely and informative reply, Arran!

Cheers,

-mz