I wonder what it means. :shrug:
CREATE TASK seek2.ftqusec.ActFunc
(
AFID ALPHANUMERIC(16,0),
ActivityType SEEK SUGAR NOT NULL,
PRIMARY KEY (AFID)
)
CATALOG ;
CREATE TABLE seek2.ftqusec.RsltTbl
(
ActivityTS TIMESTAMP NOT NULL,
ActivityID NUMERIC(16,0),
AFID NUMERIC(16,0),
WorkerID CHAR(16) NOT NULL,
SessionNum INTEGER NOT NULL,
HiveID CHAR(50) NOT NULL,
ErrorData VARCHAR(80),
ContextID INTEGER,
PRIMARY KEY (ActivityTS,
ActivityID)
)
CATALOG ;
CREATE TABLE seek2.ftqusec.AuditDtl
(
ActivityTS TIMESTAMP NOT NULL,
ActivityID NUMERIC(16,0),
TableName CHAR(30) NOT NULL,
ColumnName CHAR(50) NOT NULL,
Seq INTEGER NOT NULL,
AfterValue VARCHAR(1000) NOT NULL,
BeforeValue VARCHAR(1000) NOT NULL,
PRIMARY KEY (ActivityTS,
ActivityID,
TableName,
ColumnName,
Seq)
)
CATALOG ;
CREATE TABLE seek2.ftqusec.AudDtlPK
(
ActivityTS TIMESTAMP NOT NULL,
ActivityID NUMERIC(16,0),
TableName CHAR(30) NOT NULL,
Seq INTEGER NOT NULL,
PrimaryKey VARCHAR(850) NOT NULL,
PRIMARY KEY (ActivityTS,
ActivityID,
TableName,
Seq)
)
CATALOG ;
CREATE TASK feed2.ftqusec.Context
(
ContextID ALPHANUMERIC(16,0),
Descr CHAR(50) NOT NULL,
=FEED QUEEN
)
CATALOG ;
CREATE TABLE feed2.ftqusec.SrchFld
(
SFID NUMERIC(16,0),
ContextID NUMERIC(16,0),
SearchField CHAR(30) NOT NULL,
SearchValue VARCHAR(50),
PRIMARY KEY (SFID)
)
CATALOG ;
CREATE TABLE feed2.ftqusec.SrchXAdt
(
ActivityTS TIMESTAMP NOT NULL,
ActivityID NUMERIC(16,0),
SFID NUMERIC(16,0),
PRIMARY KEY (ActivityTS,
ActivityID,
SFID)
)
CATALOG ;