ALTER TABLE users_address ADD CONSTRAINT fk_lvuad_pid FOREIGN KEY (parentid) REFERENCES users (id) ON UPDATE CASCADE ON

How to configure and adapt Aimeos based shops as developer
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
chinar08
Posts: 7
Joined: 22 Dec 2021, 07:13

Re: ALTER TABLE users_address ADD CONSTRAINT fk_lvuad_pid FOREIGN KEY (parentid) REFERENCES users (id) ON UPDATE CASCADE

Post by chinar08 » 22 Dec 2021, 13:41

what to do with engines its by default created from aimeos larvael vendor folder

User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: ALTER TABLE users_address ADD CONSTRAINT fk_lvuad_pid FOREIGN KEY (parentid) REFERENCES users (id) ON UPDATE CASCADE

Post by aimeos » 22 Dec 2021, 15:07

Change your default storage engine in your MySQL configuration file to "InnoDB":
https://dev.mysql.com/doc/refman/5.7/en ... age_engine
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply