diff --git a/qep/service/src/main/sql/mssql.ddl b/qep/service/src/main/sql/mssql.ddl index 3a36ccfbc..76ecce6bb 100644 --- a/qep/service/src/main/sql/mssql.ddl +++ b/qep/service/src/main/sql/mssql.ddl @@ -1,8 +1,8 @@ create database qepAuditDB; use qepAuditDB; create table "queriesSent" ("shrineNodeId" VARCHAR(MAX) NOT NULL,"userName" VARCHAR(MAX) NOT NULL,"networkQueryId" BIGINT NOT NULL,"queryName" VARCHAR(MAX) NOT NULL,"queryTopicId" VARCHAR(MAX),"queryTopicName" VARCHAR(MAX),"timeQuerySent" BIGINT NOT NULL); create table "previousQueries" ("networkId" BIGINT NOT NULL,"userName" VARCHAR(MAX) NOT NULL,"domain" VARCHAR(MAX) NOT NULL,"queryName" VARCHAR(MAX) NOT NULL,"expression" VARCHAR(MAX) NOT NULL,"dateCreated" BIGINT NOT NULL,"deleted" BIT NOT NULL,"queryXml" VARCHAR(MAX) NOT NULL,"changeDate" BIGINT NOT NULL); create table "queryFlags" ("networkId" BIGINT NOT NULL,"flagged" BIT NOT NULL,"flagMessage" VARCHAR(MAX) NOT NULL,"changeDate" BIGINT NOT NULL); -create table "queryResults" ("resultId" BIGINT NOT NULL,"networkQueryId" BIGINT NOT NULL,"instanceId" BIGINT NOT NULL,"adapterNode" VARCHAR(MAX) NOT NULL,"resultType" VARCHAR(MAX) NOT NULL,"size" BIGINT NOT NULL,"startDate" BIGINT,"endDate" BIGINT,"status" VARCHAR(MAX) NOT NULL,"statusMessage" VARCHAR(MAX),"changeDate" BIGINT NOT NULL); +create table "queryResults" ("resultId" BIGINT NOT NULL,"networkQueryId" BIGINT NOT NULL,"instanceId" BIGINT NOT NULL,"adapterNode" VARCHAR(MAX) NOT NULL,"resultType" VARCHAR(MAX),"size" BIGINT NOT NULL,"startDate" BIGINT,"endDate" BIGINT,"status" VARCHAR(MAX) NOT NULL,"statusMessage" VARCHAR(MAX),"changeDate" BIGINT NOT NULL); create table "queryBreakdownResults" ("networkQueryId" BIGINT NOT NULL,"adapterNode" VARCHAR(MAX) NOT NULL,"resultId" BIGINT NOT NULL,"resultType" VARCHAR(MAX) NOT NULL,"dataKey" VARCHAR(MAX) NOT NULL,"value" BIGINT NOT NULL,"changeDate" BIGINT NOT NULL); create table "queryResultProblemDigests" ("networkQueryId" BIGINT NOT NULL,"adapterNode" VARCHAR(MAX) NOT NULL,"codec" VARCHAR(MAX) NOT NULL,"stamp" VARCHAR(MAX) NOT NULL,"summary" VARCHAR(MAX) NOT NULL,"description" VARCHAR(MAX) NOT NULL,"details" VARCHAR(MAX) NOT NULL,"changeDate" BIGINT NOT NULL); \ No newline at end of file diff --git a/qep/service/src/main/sql/oracle.ddl b/qep/service/src/main/sql/oracle.ddl index 4140b7d72..61983e556 100644 --- a/qep/service/src/main/sql/oracle.ddl +++ b/qep/service/src/main/sql/oracle.ddl @@ -1,6 +1,6 @@ create table "queriesSent" ("shrineNodeId" VARCHAR2(256) NOT NULL,"userName" VARCHAR2(256) NOT NULL,"networkQueryId" NUMBER NOT NULL,"queryName" VARCHAR2(256) NOT NULL,"queryTopicId" VARCHAR2(256),"queryTopicName" VARCHAR2(256),"timeQuerySent" NUMBER NOT NULL); create table "previousQueries" ("networkId" NUMBER(19) NOT NULL,"userName" VARCHAR(256) NOT NULL,"domain" VARCHAR(256) NOT NULL,"queryName" VARCHAR(256) NOT NULL,"expression" CLOB NOT NULL,"dateCreated" NUMBER(19) NOT NULL,"deleted" CHAR NOT NULL check ("deleted" in ('1', '0')),"queryXml" CLOB NOT NULL,"changeDate" NUMBER(19) NOT NULL); create table "queryFlags" ("networkId" NUMBER(19) NOT NULL,"flagged" CHAR NOT NULL check ("flagged" in ('1', '0')),"flagMessage" CLOB,"changeDate" NUMBER(19) NOT NULL); -create table "queryResults" ("resultId" NUMBER(19) NOT NULL,"networkQueryId" NUMBER(19) NOT NULL,"instanceId" NUMBER(19) NOT NULL,"adapterNode" VARCHAR(256) NOT NULL,"resultType" VARCHAR(256) NOT NULL,"size" NUMBER(19) NOT NULL,"startDate" NUMBER(19),"endDate" NUMBER(19),"status" VARCHAR(256) NOT NULL,"statusMessage" VARCHAR(256),"changeDate" NUMBER(19) NOT NULL); +create table "queryResults" ("resultId" NUMBER(19) NOT NULL,"networkQueryId" NUMBER(19) NOT NULL,"instanceId" NUMBER(19) NOT NULL,"adapterNode" VARCHAR(256) NOT NULL,"resultType" VARCHAR(256),"size" NUMBER(19) NOT NULL,"startDate" NUMBER(19),"endDate" NUMBER(19),"status" VARCHAR(256) NOT NULL,"statusMessage" VARCHAR(256),"changeDate" NUMBER(19) NOT NULL); create table "queryBreakdownResults" ("networkQueryId" NUMBER(19) NOT NULL,"adapterNode" VARCHAR(256) NOT NULL,"resultId" NUMBER(19) NOT NULL,"resultType" VARCHAR(256) NOT NULL,"dataKey" VARCHAR(256) NOT NULL,"value" NUMBER(19) NOT NULL,"changeDate" NUMBER(19) NOT NULL); create table "queryResultProblemDigests" ("networkQueryId" NUMBER(19) NOT NULL,"adapterNode" VARCHAR(256) NOT NULL,"codec" VARCHAR(256) NOT NULL,"stamp" VARCHAR(256) NOT NULL,"summary" CLOB NOT NULL,"description" CLOB NOT NULL,"details" CLOB NOT NULL,"changeDate" NUMBER(19) NOT NULL); \ No newline at end of file