J Decker wrote: > foreign key mismatch - "option4_map" referencing "option4_name" > > create table `option4_name` (`name_id` char(36) NOT NULL, > ... > create table `option4_map` (... > FOREIGN KEY (`name_id`) REFERENCES `option4_name`(`name_id`)
name_id in the parent table must be the primary key (or at least be unique). Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users