oro_search_item FK constraint

Hi,

I am playing around with the platform and I noticed that every time I do

app/console doctrine:schema:update --dump-sql

1	app/console doctrine:schema:update --dump-sql

I get:

ALTER TABLE oro_search_index_text ADD CONSTRAINT FK_A0243539126F525E FOREIGN KEY (item_id) REFERENCES oro_search_item (id);

1	ALTER TABLE oro_search_index_text ADD CONSTRAINT FK_A0243539126F525E FOREIGN KEY (item_id) REFERENCES oro_search_item (id);

Even after –forcing it and updating my db schema (no errors) it continues coming back?

I don’t think I have tempered with SearchBundle’s entities.

any ideas?

---

oro/platform(1.6.2) + oro/doctrine-extensions(1.0.7) + symfony/symfony(v2.3.27)

Topic

[Alexandr SmagaParticipant]

Hi @jakabadambalazs!

Yes, this is correct behavior. Table oro_search_index_text uses MYISAM engine due to full text search, but this engine does not supports FKs and doctrine does not manage this and anyway tries to create it.

[jakabadambalazsParticipant]

thanks

---

oro/platform(1.6.2) + oro/doctrine-extensions(1.0.7) + symfony/symfony(v2.3.27)

[Author]

Replies