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
);
"Welcome to our mercurial repository"