Cisco Systems PXM Version 1.1 Guía de usuario Pagina 94

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 110
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 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;
Vista de pagina 93
1 2 ... 89 90 91 92 93 94 95 96 97 98 99 ... 109 110

Comentarios a estos manuales

Sin comentarios