Cisco Systems PXM Version 1.1 Betriebsanweisung Seite 94

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 110
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 93
B-4
Cisco Carrier Sensitive Routing User Guide
AppendixB Data Schema
Configuration Data Schema
CREATE TABLE Filters (
FilterKey integer NOT NULL PRIMARY KEY,
GKID varchar(64) NOT NULL,
MsgType text NOT NULL CONSTRAINT MsgTypeInvalid
CHECK (
lower(MsgType) = 'arq' OR
lower(MsgType) = 'lrq' OR
lower(MsgType) = 'rrq' OR
lower(MsgType) = 'urq' OR
lower(MsgType) = 'lcf' OR
lower(MsgType) = 'lrj' OR
lower(MsgType) = 'drq' OR
lower(MsgType) = 'brq' OR
lower(MsgType) = 'irr' OR
lower(MsgType) = 'rai'
),
FilterType text NOT NULL CONSTRAINT FilterTypeInvalid
CHECK (
lower(FilterType) = 'endpoint'OR
lower(FilterType) = 'supportedprefix'OR
lower(FilterType) =
'destinationinformation' OR
lower(FilterType) =
'remoteextensionaddress' OR
lower(FilterType) = 'redirectreason'OR
lower(FilterType) = 'answercall'OR
lower(FilterType) = 'notificationonly'
),
Value text NOT NULL
);
ALTER TABLE TestOutputs ADD FOREIGN KEY (TestKey) REFERENCES TestRoutes
(TestKey) DEFERRABLE;
ALTER TABLE LogEntries ADD FOREIGN KEY (TestKey) REFERENCES TestRoutes
(TestKey) DEFERRABLE;
ALTER TABLE Filters ADD FOREIGN KEY (GKID) REFERENCES GateKeepers
(GKID) DEFERRABLE;
COMMIT;
Seitenansicht 93
1 2 ... 89 90 91 92 93 94 95 96 97 98 99 ... 109 110

Kommentare zu diesen Handbüchern

Keine Kommentare