Remove unnamed constraint from assets table

[gijswijs]

The assets table has an unnamed uniqueness constraint that contains the primary key and as such has no meaning, since the constraint will always be met (See the initial issue #691). Removing it is hard, since it is unnamed and would require a drop and recreate of the table.

See: #965 (comment)

This is not blocking, but should be addressed some time in the future.