Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.16 » View Incident Report |
Serious |
Reported By: Adam Brett [Tropical Wholefoods] Reported On: 3/20/2014 For: Version 2.16 Build 1 |
CREATE TABLE "Forecasts" ( "ID" INTEGER DEFAULT UID NOT NULL, "LinkTable" VARCHAR(40) COLLATE "ANSI", "Name" VARCHAR(100) COLLATE "ANSI", "PeriodTypeID" INTEGER, "DateTarget" DATE, "ValueTarget" FLOAT DEFAULT NOT NULL, "AcceptableVariance" FLOAT DEFAULT NOT NULL, "AuthorID" INTEGER, "DateCreated" TIMESTAMP DEFAULT Current_Timesta, "Complete" BOOLEAN DEFAULT fal, CONSTRAINT "PK_Forecasts" PRIMARY KEY ("ID"), CONSTRAINT "PeriodTypeID" FOREIGN KEY ("PeriodTypeID") REFERENCES "Types" ("ID") ON UPDATE NO ACTION ON DELETE NO ACTION ) when it should look like this: CREATE TABLE "Forecasts" ( "ID" INTEGER DEFAULT UID() NOT NULL, "LinkTable" VARCHAR(40) COLLATE "ANSI", "Name" VARCHAR(100) COLLATE "ANSI", "PeriodTypeID" INTEGER, "DateTarget" DATE, "ValueTarget" FLOAT DEFAULT 0 NOT NULL, "AcceptableVariance" FLOAT DEFAULT 0 NOT NULL, "AuthorID" INTEGER, "DateCreated" TIMESTAMP DEFAULT Current_Timestamp, "Complete" BOOLEAN DEFAULT false, CONSTRAINT "PK_Forecasts" PRIMARY KEY ("ID"), CONSTRAINT "PeriodTypeID" FOREIGN KEY ("PeriodTypeID") REFERENCES "Types" ("ID") ON UPDATE NO ACTION ON DELETE NO ACTION )
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 |