Mercurial > hg > fD-testbed
view conf/backend.eap.testbed.aaa/freeDiameter/app_acct.sql @ 0:9e5a3c884de6
Initial import of the virtual testbed.
author | Sebastien Decugis <sdecugis@nict.go.jp> |
---|---|
date | Thu, 17 Jun 2010 11:00:32 +0900 |
parents | |
children |
line wrap: on
line source
CREATE TABLE app_acct ( "Origin-Host" bytea NOT NULL, "Origin-Realm" bytea NOT NULL, "Destination-Realm" bytea, "Destination-Host" bytea, "Session-Id" bytea NOT NULL, "Origin-State-Id" integer, "Accounting-Record-Type" integer NOT NULL, "Accounting-Record-Number" integer NOT NULL, "User-Name" bytea, "Event-Timestamp" bytea, "Acct-Application-Id" integer, "Accounting-Sub-Session-Id" bigint, "Acct-Session-Id" bytea, "Acct-Multi-Session-Id" bytea, "Origin-AAA-Protocol" integer, "Acct-Delay-Time" integer, "NAS-Identifier" bytea, "NAS-IP-Address" bytea, "NAS-IPv6-Address" bytea, "NAS-Port" integer, "NAS-Port-Id" bytea, "NAS-Port-Type" integer, "Service-Type" integer, "Termination-Cause" integer, "Accounting-Input-Octets" bigint, "Accounting-Input-Packets" bigint, "Accounting-Output-Octets" bigint, "Accounting-Output-Packets" bigint, "Acct-Authentic" integer, "Acct-Link-Count" integer, "Acct-Session-Time" integer, "Acct-Tunnel-Connection" bytea, "Acct-Tunnel-Packets-Lost" integer, "Callback-Id" bytea, "Callback-Number" bytea, "Called-Station-Id" bytea, "Calling-Station-Id" bytea, "Connect-Info" bytea, "Originating-Line-Info" bytea, "Authorization-Lifetime" integer, "Session-Timeout" integer, "Idle-Timeout" integer, "Port-Limit" integer, "Accounting-Realtime-Required" integer, "Acct-Interim-Interval" integer, "Filter-Id" bytea, "NAS-Filter-Rule" bytea, "QoS-Filter-Rule" bytea, "Login-IP-Host" bytea, "Login-IPv6-Host" bytea, "Login-LAT-Group" bytea, "Login-LAT-Node" bytea, "Login-LAT-Port" bytea, "Login-LAT-Service" bytea, "Login-Service" integer, "Login-TCP-Port" integer, "Route-Record1" bytea, "Route-Record2" bytea, "Route-Record3" bytea, "Route-Record4" bytea, "Route-Record5" bytea, recorded_on timestamp with time zone NOT NULL );