Unique index not unique

Using my Dolibarr
1

Table: llx_accounting_account
Key: idx_c_country_code_iso on the field code_iso

This key is defined as unique. But the table contents has two rows having the same value for this field: the rows 0 and 164, having the respective labels ‘-’ and ‘Antilles néerlandaises’. The Antilles Néerlandaises record does have a 2 letter code: AN. The 3 letter code should actually be ABW. But that’s already taken by Aruba (having two-letter-code AW) - Aruba actually being part of the former Antilles Néerlandaises.

The Antilles néerlandaises does not exist anymore as a seperate country since 2010. Aruba, Curaçao and Sint Maarten became seperate countries then:

Aruba: AW / ABW.
Curaçao: CW / CUW
Sint Maarten: SX / SXM
The above three do not exist in the Dolibarr countries table. Guess the AN record can be removed and the above three can be added. Don’t know the impact on installations worldwide though.

BTW Saba, Sint Eustatius en Bonaire have become part of the Netherlands.
And, while we’re talking this table: Nerderland should be Nederland.

2

Thanks. We will fix this in 5.0

3

I was too quick with my non-unique index. The cause was a broken database export script which ignored NULL values. Fixed that, now no problems with the key. The remainder of the message still remains, but I suppose correcting this in 5.0 is soon enough. Thanks for your quick comment.