I am working on a dashboard for my team, that allows to get information on our projects. When creating a new project in the dashboard, the user must fill a form with the name, starting date and closing date of the project. However, I have an issue when inserting a project that has a name already existing in database, and I am not able to find a solution as each project has its own index (with an auto-incremented integer column in DB), and the project name column is not a primary key of the table. It works perfectly when using a different name, for example if "project summer" is in DB, inserting "project summer" will fail (leading to an error 502) but "project summer 2" will not. How can I insert new projects with similar names?

I am using NodeJS with express, ajax and request, and my database uses mySQL managed with PHPMyAdmin.

EDIT (03/12/2018): "Name" column appears to be a table index. What can be the consequences on the table if I edit the column to not act as an index anymore? 

[![Table structure](https://i.stack.imgur.com/NwFiX.png)](https://i.stack.imgur.com/NwFiX.png)