Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 1.05 » View Incident Report |
Minor |
Reported By: Michael Reisch Reported On: 9/25/2007 For: Version 1.05 Build 2 |
CREATE TABLE "Project" ( "GUID_ID" VARCHAR(48) COLLATE "ANSI", "GUID_Parent" VARCHAR(48) COLLATE "ANSI", "ObjType" INTEGER DEFAULT 1, "ProjectNo" VARCHAR(30) COLLATE "ANSI", "ProjectShort" VARCHAR(30) COLLATE "ANSI", "Description" VARCHAR(250) COLLATE "ANSI", "DescriptionLong" CLOB COLLATE "ANSI", "ImageIndex" INTEGER, "ProjectLeader" VARCHAR(48) COLLATE "ANSI", "Status" INTEGER, "Street" VARCHAR(100) COLLATE "ANSI", "Country" VARCHAR(10) COLLATE "ANSI", "PostalCode" VARCHAR(10) COLLATE "ANSI", "City" VARCHAR(100) COLLATE "ANSI", "Region" VARCHAR(100) COLLATE "ANSI", "CountryArea" VARCHAR(100) COLLATE "ANSI", "ProjectStart" DATE, "ProjectEnd" DATE, "ProjectYears" SMALLINT DEFAULT 0, "ProjectMonths" SMALLINT DEFAULT 0, "ProjectPath" VARCHAR(250) COLLATE "ANSI", "Source" VARCHAR(20) COLLATE "ANSI" DEFAULT 'GRIPS', "SourceID" VARCHAR(48) COLLATE "ANSI", "LastProtIdx" INTEGER DEFAULT 0, "CostInfo" CLOB COLLATE "ANSI", "CurrencyShort" VARCHAR(10) COLLATE "ANSI", "Costs" FLOAT, "ContractInfo" CLOB COLLATE "ANSI", "TechInfo" CLOB COLLATE "ANSI", "CreateDate" TIMESTAMP, "ModifyDate" TIMESTAMP, CONSTRAINT "PrimaryKey" PRIMARY KEY ("GUID_ID") ) DESCRIPTION 'allgemeine Projektdaten' VERSION 1,04 UNENCRYPTED INDEX PAGE SIZE 4096 BLOB BLOCK SIZE 512 MAX ROW BUFFER SIZE 32768 MAX INDEX BUFFER SIZE 65536 MAX BLOB 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 |