Public bug reported:
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
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).
** Affects: aikiframework
Importance: High
Assignee: Jakub Jankiewicz (jcubic)
Status: New
** 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_languages
-
1
-
|
-
N
-
aiki_dictionaries
+ ____________original_language_________
+ / \
+ 1 1
+ aiki_sites 1----N aiki_site_languages N-------1 aiki_language
+ 1
+ |
+ N
+ 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).
** 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
+ ____________original_language__________
+ / \
+ 1 1
aiki_sites 1----N aiki_site_languages N-------1 aiki_language
1
|
N
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).
** Changed in: aikiframework
Assignee: (unassigned) => Jakub Jankiewicz (jcubic)
** Changed in: aikiframework
Importance: Undecided => High
--
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
|
N
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
