Support User Manuals

Cisco Systems Version 1.1 Network Router User Manual

Open as PDF

of 110

B-10

Cisco Carrier Sensitive Routing User Guide

AppendixB Data Schema

Dataset Schema

CREATE TABLE QoS (

IngressCarrierKeyinteger NOT NULL,

EgressCarrierKeyinteger NOT NULL,

RouteKey integer NOT NULL,

RelativeQoS integer NOT NULL CONSTRAINT RelativeQoSInvalid

CHECK (RelativeQoS >= 1 AND RelativeQoS <=

9)

);

CREATE TABLE QoS_1 () INHERITS (QoS);

CREATE TABLE QoS_2 () INHERITS (QoS);

CREATE TABLE RouteParent (

RouteKey integer NOT NULL,

AttributeKey integer NOT NULL

);

CREATE TABLE IngressRoutes_1 () INHERITS (RouteParent);

CREATE TABLE IngressRoutes_2 () INHERITS (RouteParent);

CREATE TABLE EgressRoutes_1 () INHERITS (RouteParent);

CREATE TABLE EgressRoutes_2 () INHERITS (RouteParent);

COMMIT;

BEGIN WORK;

CREATE UNIQUE INDEX Carriers_1_PKey ON Carriers_1 (CarrierKey);

CREATE UNIQUE INDEX Carriers_2_PKey ON Carriers_2 (CarrierKey);

CREATE UNIQUE INDEX Carriers_1_ID ON Carriers_1 (CarrierID);

CREATE UNIQUE INDEX Carriers_2_ID ON Carriers_2 (CarrierID);

CREATE UNIQUE INDEX Patterns_1_PKey ON MatchPatterns_1 (PatternKey);

CREATE UNIQUE INDEX Patterns_2_PKey ON MatchPatterns_2 (PatternKey);

CREATE UNIQUE INDEX Routes_1_PKey ON Routes_1 (RouteKey);

CREATE UNIQUE INDEX Routes_2_PKey ON Routes_2 (RouteKey);

CREATE UNIQUE INDEX Rules_1_PKey ON Rules_1 (RuleKey);

CREATE UNIQUE INDEX Rules_2_PKey ON Rules_2 (RuleKey);

previous next