Page History

use qepAuditDB;
create table `QUERYQUERY_PROBLEM_DIGESTS`DIGESTS (`NETWORKQUERYID`NETWORKQUERYID BIGINT NOT NULL,`CODEC` CODEC TEXT NOT NULL,`STAMP` STAMP TEXT NOT NULL,`SUMMARY` SUMMARY TEXT NOT NULL,`DESCRIPTION` DESCRIPTION TEXT NOT NULL,`DETAILS` DETAILS TEXT NOT NULL,`CHANGEDATE` CHANGEDATE BIGINT NOT NULL);
create index queryProblemsNetworkIdIndex on QUERY_PROBLEM_DIGESTS(NETWORKQUERYID);

use qepAuditDB;
create table `RESULTSRESULTS_OBSERVED`OBSERVED (`NETWORKQUERYID`NETWORKQUERYID BIGINT NOT NULL,`CHECKSUM` CHECKSUM BIGINT NOT NULL,`OBSERVEDTIME` OBSERVEDTIME BIGINT NOT NULL);
create index resultsObservedQueryIdIndex on RESULTS_OBSERVED(NETWORKQUERYID);
create index resultsObservedChecksumIndex on RESULTS_OBSERVED(CHECKSUM);