- Cisco Sensitive Routing User Guide

B-2
Cisco Carrier Sensitive Routing User Guide
AppendixB Data Schema
Configuration Data Schema
ListenPort integer CONSTRAINT CSRListenPortInvalid
CHECK (ListenPort > 0 AND ListenPort <=
32767),
ThreadCount integer NOT NULL DEFAULT 10,
MaxSizeOfQueue integer NOT NULL DEFAULT 5000,
TestRoutesAccountingEnabledboolean NOT NULL DEFAULT FALSE,
RejectSrcCarrierInactive boolean NOT NULL DEFAULT FALSE,
RejectNullSrcCarrier boolean NOT NULL DEFAULT FALSE,
RejectSrcCarrierUnknown boolean NOT NULL DEFAULT FALSE,
RejectDestinationUnknown boolean NOT NULL DEFAULT FALSE,
RejectSrcPercentage boolean NOT NULL DEFAULT FALSE,
RejectSrcUnits boolean NOT NULL DEFAULT FALSE,
RejectNoDstCarrier boolean NOT NULL DEFAULT FALSE
);
CREATE TABLE GateKeepers (
GKKey integer NOT NULL PRIMARY KEY,
GKID varchar(64) NOT NULL UNIQUE,
GK_IP inet NOT NULL,
GK_Port integer NOT NULL CONSTRAINT GK_PortInvalid
CHECK (GK_Port > 0 AND GK_Port <= 32767),
ListenARQ boolean NOT NULL DEFAULT FALSE,
ListenLRQ boolean NOT NULL DEFAULT FALSE,
ListenIRR boolean NOT NULL DEFAULT FALSE,
ListenDRQ boolean NOT NULL DEFAULT FALSE,
ListenRRQ boolean NOT NULL DEFAULT FALSE,
ListenURQ boolean NOT NULL DEFAULT FALSE,
ListenLCF boolean NOT NULL DEFAULT FALSE,
ListenLRJ boolean NOT NULL DEFAULT FALSE,
ListenRAI boolean NOT NULL DEFAULT FALSE,
ListenBRQ boolean NOT NULL DEFAULT FALSE,
ConnectionStatetext NOT NULL CONSTRAINT
ConnectionStateInvalid
CHECK (
lower(ConnectionState) = 'connect' OR
lower(ConnectionState) = 'disconnect'