> Clemens wrote: > > > > CREATE TABLE track (artist, > > FOREIGN KEY (artist) REFERENCES artist(id) ON DELETE CASCADE > > FOREIGN KEY (artist) REFERENCES artist(id) ON DELETE RESTRICT); > > SQLite allows pretty much anything inside a CREATE TABLE statement, and > ignores anything it doesn't recognize. > > This particular statement creates a table with a single foreign key > constraint. Table constraints must be separated with commas.
Just separated the constraints with comma instead of new line. No test changed it's behaviour. -- kind regards - Roland Wilczek Certified ScrumMaster (CSM) Nachtigallenstraße 11 53179 Bonn Tel.: 0228 / 336 70 40 9 Mobil: 0171 / 72 36 849 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
