No Typo3like Database definition
Posted: 23 Oct 2017, 05:58
Hello guys
just one hint: in Typo3 you have to declare ALL tables in the SQL File (aimeos/ext_tables.sql). If you don't do that the Installtool will delete the whole tables on next DB-compare.
Here are some examples from my DB-Compare:
ALTER TABLE mshop_attribute RENAME zzz_deleted_mshop_attribute;
Records in table: 14
ALTER TABLE mshop_attribute_list RENAME zzz_deleted_mshop_attribute_list;
Records in table: 57
ALTER TABLE mshop_attribute_list_type RENAME zzz_deleted_mshop_attribute_list_type;
Records in table: 8
(First rename - next step will be delete)
Comparing is needed if someone adds a new field on some extensions or make a typo3-major update so i think it will be better to update this things.
just one hint: in Typo3 you have to declare ALL tables in the SQL File (aimeos/ext_tables.sql). If you don't do that the Installtool will delete the whole tables on next DB-compare.
Here are some examples from my DB-Compare:
ALTER TABLE mshop_attribute RENAME zzz_deleted_mshop_attribute;
Records in table: 14
ALTER TABLE mshop_attribute_list RENAME zzz_deleted_mshop_attribute_list;
Records in table: 57
ALTER TABLE mshop_attribute_list_type RENAME zzz_deleted_mshop_attribute_list_type;
Records in table: 8
(First rename - next step will be delete)
Comparing is needed if someone adds a new field on some extensions or make a typo3-major update so i think it will be better to update this things.