--
-- @RRL:8-MAR-2000
--
-- Create an example database & table for keep RADIUS ACCOUNTING data is
-- loaded from RADIUS_ACCOUNTING file.

--	Loading:
--
--	$sql$ @radius_accounting.rdb_sql <CR>
--	$rmu /load /rec=(file=radius_accounting.rrd,except=radacct.bad) -
--		radacct_dir:radius_accounting.rdb -
--		radacct -
--		radius_accounting.dat<CR>
--	
--	Investigation the rejected records:
--	$accounting radacct.bad /full<CR>
--
--
set	verify

create	database	filename        'radacct_dir:radius_accounting'
	create	storage area	radacct_idx filename 'radacct_dir:radius_accounting_idx'
		page format is mixed;

attach	'filename radacct_dir:radius_accounting';

create	table	radacct
	(
	end_time	timestamp,
        sess_id		integer,
        uicgroup	smallint,
        uicmember	smallint,
	port_num	integer,
	username	varchar(12),
        account		varchar(8),
        port_type	varchar(8),
        protocol	varchar(16),
        client		varchar(32),
	frammed_ip	varchar(128),
	start_time	timestamp,
        status		integer,
        speed		integer,
        inp_octs	integer,
        out_octs	integer,
	elapsed_time	computed by (end_time - start_time) day to second
	);

create	unique index radacct_nodups
	on radacct (sess_id,port_num,username,client,frammed_ip, status)
	type is hashed ordered
	store in radacct_idx;

commit;