/************************************************************
*
* ElevateDB Reverse-Engineered script for the
* Faktur_Bieber database
*
* Generated on 15.02.2011 10:13:57
* By the user Administrator
*
************************************************************/

SCRIPT
BEGIN

/************************************************************
* Tables
************************************************************/

EXECUTE IMMEDIATE 'CREATE TEMPORARY TABLE "BaugrMBeleg"
(
"TB_ID" BIGINT,
"BelegID" BIGINT,
"ArtikelnummerID" BIGINT,
"BelegNr" INTEGER NOT NULL,
"Position" INTEGER NOT NULL,
"UP" SMALLINT NOT NULL,
"PKZ" VARCHAR(1) COLLATE "DEU",
"PAKZ" VARCHAR(1) COLLATE "DEU",
"Katalog" VARCHAR(3) COLLATE "DEU",
"Artikelnummer" VARCHAR(15) COLLATE "DEU",
"Bezeichnung" CLOB COLLATE "DEU" COMPRESSION 6,
"Seriennummer" VARCHAR(25) COLLATE "DEU",
"Hersteller" VARCHAR(30) COLLATE "DEU",
"Herstellernummer" VARCHAR(30) COLLATE "DEU",
"Menge" FLOAT,
"ME" VARCHAR(4) COLLATE "DEU",
"EK_Preis" FLOAT,
"EK_Preis_FKT" FLOAT DEFAULT 0,
"PreisKZ" VARCHAR(1) COLLATE "DEU",
"PreisKZArtikelkatalog" VARCHAR(1) COLLATE "DEU",
"VK_Preis" FLOAT,
"VK_PreisRabatt" FLOAT,
"VK_PreisKorrektur" FLOAT,
"G_VK_Preis" FLOAT,
"MwSt" SMALLINT,
"Gewicht" FLOAT,
"Kostenart" SMALLINT,
"Bild" BLOB,
"TB_Version" SMALLINT
)
VERSION 0
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';


/************************************************************
* Table Rows
************************************************************/


/************************************************************
* Table triggers, indexes, and constraints
************************************************************/

-- Creating indexes for Baugr table

EXECUTE IMMEDIATE 'CREATE INDEX "KATALOGARTIKELNUMMER" ON "BaugrMBeleg" ("Katalog" COLLATE "DEU_CI", "Artikelnummer" COLLATE "DEU_CI")';

EXECUTE IMMEDIATE 'CREATE INDEX "ARTIKELNUMMERID" ON "BaugrMBeleg" ("ArtikelnummerID")';

EXECUTE IMMEDIATE 'CREATE INDEX "BELEGIDPOSITIONUP" ON "BaugrMBeleg" ("BelegID", "Position", "UP")';

-- Creating non-foreign key constraints for Baugr table

EXECUTE IMMEDIATE 'ALTER TABLE "BaugrMBeleg"
ADD CONSTRAINT "PrimaryKey" PRIMARY KEY ("BelegNr", "Position", "UP"),
ADD CONSTRAINT "TB_ID" UNIQUE ("TB_ID")';

END

/************************************************************
* End of generated SQL
************************************************************/

---

 Comments and Workarounds

---

The workaround is to add all necessary columns and constraints in the original CREATE TEMPORARY TABLE statement.

---

 Resolution

---

Fixed Problem on 2/17/2011 in version 2.05 build 4

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial