/etc/freeradius/3.0/mods-config/sql/moonshot-targeted-ids/postgresql/schema.sql is in freeradius-config 3.0.16+dfsg-1ubuntu3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 | CREATE TABLE moonshot_targeted_ids (
gss_acceptor varchar(254) NOT NULL DEFAULT '',
namespace varchar(36) NOT NULL DEFAULT '',
username varchar(64) NOT NULL DEFAULT '',
targeted_id varchar(128) NOT NULL DEFAULT '',
creationdate TIMESTAMP with time zone NOT NULL default 'now()',
PRIMARY KEY (username, gss_acceptor, namespace)
);
|