/etc/freeradius/sql/mysql/wimax.sql is in freeradius-mysql 2.1.12+dfsg-1.2ubuntu8.
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 9 10 11 12 13 14 15 16 | #
# WiMAX Table structure for table 'wimax',
# which replaces the "radpostauth" table.
#
CREATE TABLE wimax (
id int(11) NOT NULL auto_increment,
username varchar(64) NOT NULL default '',
authdate timestamp NOT NULL,
spi varchar(16) NOT NULL default '',
mipkey varchar(400) NOT NULL default '',
lifetime int(12) default NULL,
PRIMARY KEY (id),
KEY username (username),
KEY spi (spi)
) ;
|