Cisco Systems Version 1.1 manual Not Null Primary KEY

AppendixB Data Schema

Configuration Data Schema

		)
);
CREATE TABLE TestRoutes (
TestKey	integer	NOT NULL PRIMARY KEY,
TestTime	time,
TestDate	date,
DatasetID	text	DEFAULT '_1' CONSTRAINT DatasetIDInvalid
		CHECK (
lower(DatasetID) = '_2'		lower(DatasetID) = '_1' OR
		),
ANI	varchar(64),
DNIS	varchar(64),
SrcCarrierID	varchar(64),
DstCarrierID	varchar(64),
RunMe	boolean	NOT NULL DEFAULT FALSE,
HomeCarrierID varchar(64),
ResultCode	text
);
CREATE TABLE TestOutputs (
TestKey	integer	NOT NULL,
SelectOrder	integer	NOT NULL,
DstCarrierID	varchar(64)	NOT NULL,
ListKey	integer	NOT NULL,
IsSelected	boolean	NOT NULL DEFAULT FALSE
);
CREATE TABLE LogEntries (
TestKey	integer	NOT NULL,
EntryOrder	integer	NOT NULL,
LogString	varchar(1024)NOT NULL
);
CREATE TABLE StringResources (
ResourceKey	integer	NOT NULL PRIMARY KEY,
ResourceStringtext		NOT NULL
);

Cisco Carrier Sensitive Routing User Guide

B-3