Unique constraints are not created when initiating the database
When the gateway initializes the database, it does not create the unique constraints & the indexes on the tables. This is problematic because it means that unique constraints are not enforced at the database level (they are still enforced at the gateway level).
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information