CREATE COLUMN TABLE "IMCYC"."ES_QUERY_TEMPLATE" ("ID" INTEGER CS_INT, "TNAME" NVARCHAR(128) NOT NULL , "UNAME" NVARCHAR(128) NOT NULL , "KEYWORD" NVARCHAR(512), "TYPE" INTEGER CS_INT NOT NULL , "SCOPE" VARCHAR(1024) NOT NULL , "CREATETIME" SECONDDATE CS_SECONDDATE NOT NULL , "UPDATETIME" SECONDDATE CS_SECONDDATE NOT NULL , "OFFSET" INTEGER CS_INT DEFAULT 0, "SEARCHLIMIT" INTEGER CS_INT DEFAULT 20, "NARROWDOWN" NCLOB MEMORY THRESHOLD 1000, "DESC" NVARCHAR(512), PRIMARY KEY ("ID"), UNIQUE ("TNAME", "UNAME")) UNLOAD PRIORITY 5  AUTO MERGE ;
ALTER TABLE "IMCYC"."ES_QUERY_TEMPLATE" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('ALLOW_NULL_AS_COMPONENT=YES', '$uc__SYS_TREE_CS_#275643_#0_#0$','TNAME','UNAME'))