@Jean-YvesPochez @James D : why does the track table have a primary key in dbschema, and no pk in dave's and my app ?.
The DDL for that table has no PK defined
CREATE TABLE track ( ID integer NOT NULL,
name text NOT NULL,
composer text,
milliseconds integer,
bytes integer,
unit_price text NOT NULL,
album_id integer NOT NULL,
media_type_id integer NOT NULL,
genre_id integer NOT NULL,
version integer NOT NULL DEFAULT 1,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY ( album_id) REFERENCES album ( ID) ,
FOREIGN KEY ( media_type_id) REFERENCES media_type ( ID) ,
FOREIGN KEY ( genre_id) REFERENCES genre ( ID) )