Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.24 » View Incident Report |
Serious |
Reported By: Roy Lambert Reported On: 7/15/2016 For: Version 2.24 Build 2 |
CREATE TABLE "QSC" ( "_ID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL, "_Name" VARCHAR(50) COLLATE "ANSI_CI" NOT NULL, "_Indicator" VARCHAR(10) COLLATE "ANSI_CI" DEFAULT 'Skill' NOT NULL DESCRIPTION 'Qualifier Skill Competency', "_Description" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Bands" INTEGER DEFAULT 4 NOT NULL, "_Questions" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Band0" VARCHAR(50) COLLATE "ANSI_CI", "_Band1" VARCHAR(50) COLLATE "ANSI_CI", "_Band2" VARCHAR(50) COLLATE "ANSI_CI", "_Band3" VARCHAR(50) COLLATE "ANSI_CI", "_Band4" VARCHAR(50) COLLATE "ANSI_CI", "_Guidance0" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Guidance1" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Guidance2" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Guidance3" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Guidance4" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Development0" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Development1" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Development2" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Development3" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Development4" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_xGlyph" INTEGER COMPUTED ALWAYS AS CASE WHEN _Indicator = 'Qualifier' THEN 0 WHEN _Indicator = 'Skill' THEN 1 WHEN _Indicator = 'Competency' THEN 2 WHEN _Indicator = 'Group' THEN 3 ELSE -1 END NOT NULL, "_xAllText" CLOB COLLATE "ANSI_CI" COMPRESSION 6 COMPUTED ALWAYS AS CAST( COALESCE(_Questions,'')+' '+COALESCE(_Name,'')+' '+ COALESCE(_Description,'')+' ' + COALESCE(_Band0,'')+' '+COALESCE(_Guidance0,'')+' '+COALESCE(_Development0,'')+' '+ COALESCE(_Band1,'')+' '+COALESCE(_Guidance1,'')+' '+COALESCE(_Development1,'')+' '+ COALESCE(_Band2,'')+' '+COALESCE(_Guidance2,'')+' '+COALESCE(_Development2,'')+' '+ COALESCE(_Band3,'')+' '+COALESCE(_Guidance3,'')+' '+COALESCE(_Development3,'')+' '+ COALESCE(_Band4,'')+' '+COALESCE(_Guidance4,'')+' '+COALESCE(_Development4,'') AS CLOB), "_xBand" CLOB COLLATE "ANSI_CI" COMPRESSION 6 COMPUTED ALWAYS AS CAST( COALESCE(_Band0,'')+' '+ COALESCE(_Band1,'')+' '+ COALESCE(_Band2,'')+' '+ COALESCE(_Band3,'')+' '+ COALESCE(_Band4,'') AS CLOB), "_xGuidance" CLOB COLLATE "ANSI_CI" COMPRESSION 6 COMPUTED ALWAYS AS CAST( COALESCE(_Guidance0,'')+' '+ COALESCE(_Guidance1,'')+' '+ COALESCE(_Guidance2,'')+' '+ COALESCE(_Guidance3,'')+' '+ COALESCE(_Guidance4,'') AS CLOB), "_xDevelopment" CLOB COLLATE "ANSI_CI" COMPRESSION 6 COMPUTED ALWAYS AS CAST( COALESCE(_Development0,'')+' '+ COALESCE(_Development1,'')+' '+ COALESCE(_Development2,'')+' '+ COALESCE(_Development3,'')+' '+ COALESCE(_Development4,'') AS CLOB), CONSTRAINT "PK" PRIMARY KEY ("_ID"), CONSTRAINT "MaxBands" CHECK ((_Bands >=1 AND _Bands <=4)) , CONSTRAINT "Names" UNIQUE ("_Name") ) VERSION 1.00 READWRITE UNENCRYPTED INDEX PAGE SIZE 8192 BLOB BLOCK SIZE 1024 PUBLISH BLOCK SIZE 1024 PUBLISH COMPRESSION 0 MAX ROW BUFFER SIZE 32768 MAX INDEX BUFFER SIZE 65536 MAX BLOB BUFFER SIZE 32768 MAX PUBLISH BUFFER SIZE 32768
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |