Support User Manuals

Cisco Systems Version 1.1 Network Router User Manual

Open as PDF

of 110

B-11

Cisco Carrier Sensitive Routing User Guide

AppendixB Data Schema

Dataset Schema

CREATE UNIQUE INDEX Contacts_1_PKey ON Contacts_1 (ContactKey);

CREATE UNIQUE INDEX Contacts_2_PKey ON Contacts_2 (ContactKey);

CREATE UNIQUE INDEX Lists_1_PKey ON Lists_1 (ListKey);

CREATE UNIQUE INDEX Lists_2_PKey ON Lists_2 (ListKey);

CREATE UNIQUE INDEX Match_1_Pattern ON MatchPatterns_1(Pattern);

CREATE UNIQUE INDEX Match_2_Pattern ON MatchPatterns_2(Pattern);

CREATE UNIQUE INDEX IRA_1_PKey ON IngressRouteAttributes_1

(AttributeKey);

CREATE UNIQUE INDEX IRA_2_PKey ON IngressRouteAttributes_2

(AttributeKey);

CREATE UNIQUE INDEX ECA_1_PKey ON EgressRouteAttributes_1

(AttributeKey);

CREATE UNIQUE INDEX ECA_2_PKey ON EgressRouteAttributes_2

(AttributeKey);

CREATE UNIQUE INDEX ContactLists_1_Key ON ContactLists_1 (ListKey,

ContactKey);

CREATE UNIQUE INDEX ContactLists_2_Key ON ContactLists_2 (ListKey,

ContactKey);

CREATE UNIQUE INDEX QoS_1_Key ON QoS_1 (IngressCarrierKey,

EgressCarrierKey, RouteKey);

CREATE UNIQUE INDEX QoS_2_Key ON QoS_2 (IngressCarrierKey,

EgressCarrierKey, RouteKey);

CREATE UNIQUE INDEX IngressRoutes_1_Key ON IngressRoutes_1 (RouteKey,

AttributeKey);

CREATE UNIQUE INDEX IngressRoutes_2_Key ON IngressRoutes_2 (RouteKey,

AttributeKey);

CREATE UNIQUE INDEX EgressRoutes_1_Key ON EgressRoutes_1 (RouteKey,

AttributeKey);

CREATE UNIQUE INDEX EgressRoutes_2_Key ON EgressRoutes_2 (RouteKey,

AttributeKey);

COMMIT;

BEGIN WORK;

previous next