Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.18 » View Incident Report |
Minor |
Reported By: Roy Lambert [NLH Associates] Reported On: 1/18/2015 For: Version 2.18 Build 2 |
CREATE TABLE "EMails" ( "_fkMailBoxes" INTEGER, "_MsgNo" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL, "_MD5" VARCHAR(16) COLLATE "ANSI_CI", "_fkStaff" VARCHAR(5) COLLATE "ANSI_CI", "_Private" BOOLEAN DEFAULT FALSE, "_fkContacts" INTEGER, "_Comments" VARCHAR(100) COLLATE "ANSI_CI", "_Size" INTEGER, "_Subject" VARCHAR(100) COLLATE "ANSI_CI", "_Sender" VARCHAR(45) COLLATE "ANSI_CI", "_emSender" VARCHAR(60) COLLATE "ANSI_CI", "_Colour" INTEGER DEFAULT 0, "_Reply" CHAR(1) COLLATE "ANSI_CI", "_DisplayFormat" VARCHAR(4) COLLATE "ANSI_CI", "_Encoding" VARCHAR(5) COLLATE "ANSI_CI", "_TimeStamp" TIMESTAMP, "_Destination" VARCHAR(45) COLLATE "ANSI_CI", "_emDestination" VARCHAR(60) COLLATE "ANSI_CI", "_InOutInd" VARCHAR(2) COLLATE "ANSI_CI", "_aList" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Message" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Graphics" BLOB COMPRESSION 6, "_Recipients" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Flags" CLOB COLLATE "ANSI_CI" COMPRESSION 6, "_Encoded" CLOB COLLATE "ANSI_CI" COMPRESSION 6, CONSTRAINT "PK" PRIMARY KEY ("_MsgNo") ) VERSION 1.00 READWRITE ENCRYPTED INDEX PAGE SIZE 4096 BLOB BLOCK SIZE 4096 PUBLISH BLOCK SIZE 512 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 Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |