Hi,
The following works in 1.4.200, but gives the following error in
1.4.201 :
Any ideas ?
Kind regards
Willy
Constraint "PRIMARY KEY | UNIQUE (TYPES)" not found; SQL statement:
CREATE TABLE FCOUNTS( ID IDENTITY primary key , NR VARCHAR,
NAME VARCHAR, TYPES VARCHAR, TAG VARCHAR, Foreign key(types)
references ftypes(types), Foreign key(tag) references ftags(tag) )
Code :
create table ftypes(
ID IDENTITY primary key ,
types VARCHAR
);
create unique index ftype_idx on ftypes(types);
create table ftags(
ID IDENTITY primary key ,
tag VARCHAR
);
create unique index ftag_idx on fintags(tag);
CREATE TABLE FCOUNTS(
ID IDENTITY primary key ,
NR VARCHAR,
NAME VARCHAR,
TYPES VARCHAR,
TAG VARCHAR,
Foreign key(types) references ftypes(types),
Foreign key(tag) references ftags(tag)
);
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/4cb16203-7ada-0f4c-99e1-cda1d7126ee2%40telenet.be.
