Bug in DDL generating

[VaS]

I have found a bug in DDL generating.

There's simple data model consists 3 tables (http://www.opcsoft.ru/download/123.zip).

EA can't generate right DDL from it.

It produces:  

ALTER TABLE "HDA_FOLDERS" ADD CONSTRAINT "PK_HDA_STRUCTURE"
PRIMARY KEY ("I)

instead:

ALTER TABLE "HDA_FOLDERS" ADD CONSTRAINT "PK_HDA_STRUCTURE"
PRIMARY KEY ("ID")

You may try to have the same wonderful result using the file I mentioned above.

[thomaskilian]

Code: [Select]

CREATE TABLE DB_VERSIONS (
ID int identity(0,1)  NOT NULL,
PRODUCT_ID smallint DEFAULT -1 NOT NULL,
VERSION int DEFAULT -1 NOT NULL,
STAMP datetime DEFAULT 0 NOT NULL
)
;

CREATE TABLE HDA_FOLDERS (
ID int identity(0,1)  NOT NULL,
PARENT_ID int DEFAULT -1 NOT NULL,
NAME varchar(200) DEFAULT 'HDA Group' NOT NULL,
DESCRIPTION varchar(1000),
IS_LOG_GROUP smallint DEFAULT 0 NOT NULL,
MSTAMP datetime DEFAULT 0 NOT NULL
)
;

CREATE TABLE HDA_ITEMS (
ID int identity(0,1)  NOT NULL,
HDA_FOLDERS_ID int DEFAULT -1 NOT NULL,
NAME varchar(200) DEFAULT 'HDA Item' NOT NULL,
DESCRIPTION varchar(1000),
MSTAMP datetime DEFAULT 0 NOT NULL,
DA_ITEMID varchar(500) NOT NULL
)
;

I'm using the latest 5.0 beta

[VaS]

You didn't generate primary keys. The errors are there.

I'll try to use 5 beta immediately....

[VaS]

Where could I get the latest beta of EA? Unfortunately, I can't find it over the site.

[thomaskilian]

You will find it on the registered users download area.