Problem about primary address on settings.php

[piwikjapan]

settings.php can set the primary address that is "not" included in maia_users table. Because, maia_users.primary_email_id is set in unique.

proposed measures

1. set maia_users.primary_email_id as non unique.
   -> but it is hard to repair to initial state.
2. suggest to use "adminusers.php -> Link E-mail Address/Alias" to set the primary address when candidates included in maia_users table.
   -> need to reconstruct themes.

possible (initial state)

MariaDB [maia]> select id, user_name, primary_email_id from maia_users;

id	user_name	primary_email_id
1	@.	1
2	yamachan@example.com	2
3	@example.com	3
5	info@example.com	5
6	staff@example.com	6

possible

MariaDB [maia]> select id, user_name, primary_email_id from maia_users;

id	user_name	primary_email_id
1	@.	1
2	yamachan@example.com	11
3	@example.com	3
5	info@example.com	5
6	staff@example.com	6

impossible (because primary_email_id has unique key)

MariaDB [maia]> select id, user_name, primary_email_id from maia_users;

id	user_name	primary_email_id
1	@.	1
2	yamachan@example.com	5 <--
3	@example.com	3
5	info@example.com	5 <--
6	staff@example.com	6

initial state

MariaDB [maia]> select * from users;

id	priority	policy_id	email	maia_user_id	maia_domain_id
1	0	1	@.	1	1
2	12	2	yamachan@example.com	2	0
3	2	3	@example.com	3	2
5	12	5	info@example.com	2	0
6	12	6	staff@example.com	2	0
11	12	11	office@example.com	2	0