I thought this was that index index,sqlite_autoindex_ option4_name_1,option4_name,3,<NULL> but maybe that's the unique on name.
I see; I guess it is missing; indexes get created now more properly. I deleted it and recreated it, which created the indexes more properly. thanx, and sorry for the noise. On Mon, Jul 30, 2018 at 11:13 PM Clemens Ladisch <clem...@ladisch.de> wrote: > J Decker wrote: > > CREATE TABLE `option4_name` (`name_id` char(36) NOT NULL,`name` > > varchar(255) NOT NULL default '' CONSTRAINT `name` UNIQUE) > > > FOREIGN KEY (`name_id`) REFERENCES `option4_name`(`name_id`) > > > foreign key mismatch - "option4_map" referencing "option4_name" > > name_id must be the primary key, or at least have a unique > constraint/index. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users