Error 1505 in Visual Studio

01/01/2018 20:05 yeyeyeeee#1

Error Number: 1505, State: 1, Class: 16
The CREATE UNIQUE INDEX statement ended because a duplicate key was found for the object name 'dbo.MapType' and the index name 'PK_dbo.MapType'. The value of the duplicate key is (0).
The restriction or index could not be created. See the previous errors.
The instruction was finished.

Can someone help?

That happen when I try to update-database in the new version of opennos...

01/01/2018 20:52 Fizo55#2

Just delete your old database with name "opennos"

01/01/2018 21:05 yeyeyeeee#3

Then if I have shops, crafts etc how I can restore everything?

Or I lost it?

01/01/2018 21:15 Fizo55#4

Save your table with name "shop", "shopitem", "mapnpc", "recipe" and "recipeitem" on your old database and upload on new database