techouse / mysql-to-sqlite3

Transfer data from MySQL to SQLite
https://techouse.github.io/mysql-to-sqlite3/
MIT License
217 stars 31 forks source link

Foreign key contraints multiple times in table definition after conversion #5

Closed webnautics closed 4 years ago

webnautics commented 4 years ago

Hi! Appreciate your work!

from the source database, this is the table I refer to:

Bildschirmfoto 2020-02-06 um 15 33 46

After I called mysql2sqlite -f ./test.sqlite -d mydb -u myusername -p mypassword -l ./log.txt -V converting was successful.

Though with sqlite> .schema glossar I got this result:

CREATE TABLE IF NOT EXISTS "glossar" ( "id" INTEGER NOT NULL, "glossar_key" VARCHAR(255) NOT NULL, "translation_id" INTEGER NOT NULL, "translation_id_for_key" INTEGER NOT NULL, PRIMARY KEY ("id"), FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("translation_id_for_key") REFERENCES "translations_de" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION );

techouse commented 4 years ago

Hmm ... I think I might have a hunch of what's causing the issue. Would you please be so kind and provide me with the table DDL (or even better the DDL of the whole database, that is the table definitions only, not the data itself) so I can test against it?

webnautics commented 4 years ago

I cleaned the database to the two necessary tables, problem is still there. Here is the DDL. Thanks for your effort!

-- phpMyAdmin SQL Dump -- version 4.9.0.1 -- https://www.phpmyadmin.net/

-- Host: localhost:3306 -- Generation Time: Feb 10, 2020 at 09:08 AM -- Server version: 5.7.26 -- PHP Version: 7.2.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";

-- -- Database: mysql2sqlite_test


-- -- Table structure for table glossar

CREATE TABLE glossar ( id int(11) NOT NULL, glossar_key varchar(255) NOT NULL COMMENT 'Key zum Verlinken in Content-HTML eines Assets.; Aufbau: GLOSSAR_TERM', translation_id int(11) NOT NULL, translation_id_for_key int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- -- Table structure for table translations_de

CREATE TABLE translations_de ( id int(11) NOT NULL, source_table varchar(255) NOT NULL COMMENT 'taxon, categories, attributes, characteristics, assets', content mediumtext, file varchar(255) DEFAULT NULL, file_blob blob, original_filename varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='deutsch';

-- -- Indexes for dumped tables

-- -- Indexes for table glossar

ALTER TABLE glossar ADD PRIMARY KEY (id), ADD KEY translations_de_id (translation_id) USING BTREE, ADD KEY translations_de_id_for_key (translation_id_for_key) USING BTREE;

-- -- Indexes for table translations_de

ALTER TABLE translations_de ADD PRIMARY KEY (id);

-- -- AUTO_INCREMENT for dumped tables

-- -- AUTO_INCREMENT for table glossar

ALTER TABLE glossar MODIFY id int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=282;

-- -- AUTO_INCREMENT for table translations_de

ALTER TABLE translations_de MODIFY id int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31041;

-- -- Constraints for dumped tables

-- -- Constraints for table glossar

ALTER TABLE glossar ADD CONSTRAINT glossar_ibfk_1 FOREIGN KEY (translation_id) REFERENCES translations_de (id) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT glossar_ibfk_2 FOREIGN KEY (translation_id_for_key) REFERENCES translations_de (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

techouse commented 4 years ago

@webnautics Please try the same again with v1.2.11

webnautics commented 4 years ago

Great, thanks a lot!

techouse commented 4 years ago

Great, thanks a lot!

If you are still experiencing issues, please send me the complete database DDL.