** Description changed: languages are saved in site_languages field in aiki_sites they should be in separated table connected aiki_sites and aiki_dictionaries together ____________original_language__________ / \ 1 1 aiki_sites 1----N aiki_site_languages N-------1 aiki_language - 1 - | - N + 1 1 + | |- - - - - from + N 1 aiki_dictionaries aiki_dictionaries should have Foreign key References aiki_languages(id) instead of string like "zh". The reason why you put them into different table is becasue database will guard integrity of data right now you can add trasnaltion to lanaguage that don't exists (like by mistake).
-- You received this bug notification because you are a member of Aiki Framework Developers, which is subscribed to aikiframework. https://bugs.launchpad.net/bugs/965042 Title: Languages should be saved in separate table Status in Aiki Framework: New Bug description: languages are saved in site_languages field in aiki_sites they should be in separated table connected aiki_sites and aiki_dictionaries together ____________original_language__________ / \ 1 1 aiki_sites 1----N aiki_site_languages N-------1 aiki_language 1 1 | |- - - - - from N 1 aiki_dictionaries aiki_dictionaries should have Foreign key References aiki_languages(id) instead of string like "zh". The reason why you put them into different table is becasue database will guard integrity of data right now you can add trasnaltion to lanaguage that don't exists (like by mistake). To manage notifications about this bug go to: https://bugs.launchpad.net/aikiframework/+bug/965042/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~aikiframework-devel Post to : [email protected] Unsubscribe : https://launchpad.net/~aikiframework-devel More help : https://help.launchpad.net/ListHelp
