![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.16 » View Incident Report |
![]() |
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, February 8, 2023 at 07:22 AM | Privacy Policy![]() © 2023 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |