SQL schema for radcheck table
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
On 15 Jan 2014, at 20:58, Matt Zagrabelny <mzagrabe@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. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
On Wed, Jan 15, 2014 at 3:11 PM, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:
On 15 Jan 2014, at 20:58, Matt Zagrabelny <mzagrabe@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
participants (2)
-
Arran Cudbard-Bell -
Matt Zagrabelny