Hi! I have a problem with creating tables: CREATE TABLE BOX (BID int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, Groesse int, Einstreu varchar(50), Ort varchar(50), Fenster boolean, Preis int, Bild varchar(50));
CREATE TABLE RESERVIERUNG (RID int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, KID int FOREIGN KEY REFERENCES KUNDE(KID) , BID int FOREIGN KEY REFERENCES BOX(BID), Anfang date, Ende date, Pferd varchar(50), ); CREATE TABLE Kunde (KID int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, Name varchar(50), HatKundenKarte boolean, ); When I execute this sql statement I cant create the table 'reservierung' . There seems to be a problem with the 'foreign key references' command. I used this code with HSQLDB a while ago and it worked. Does anyone know what is wrong with the code? -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
