title: [23000][1062] Duplicate entry '0' for key 'PRIMARY'
body: <p>when I filled out the database, I received a problem in the form of duplication of the primary key entry, but the fact is that the field "status" field in my database is not the primary key or its part. </p>
  
  <h2><strong>DB Script</strong></h2>
  
  <blockquote>
  <pre>CREATE TABLE IF NOT EXISTS travel.`users` (
    `login` VARCHAR(25) NOT NULL,
    `password` VARCHAR(25) NOT NULL,
    `email` VARCHAR(40) NOT NULL,
    `name` VARCHAR(20) NOT NULL,
    `surname` VARCHAR(20) NOT NULL,
    `telephone` VARCHAR(20) NOT NULL,
    `role` VARCHAR(30) NOT NULL,
    `status` TINYINT(1) NOT NULL,
    `image` VARCHAR(250) NOT NULL,
    PRIMARY KEY (`login`),
    UNIQUE INDEX `login_UNIQUE` (`login` ASC))
    ENGINE = InnoDB;</pre>
  </blockquote>
  
  <h2><strong>SQL Query</strong></h2>
  
  <blockquote>
  <pre>INSERT INTO users VALUES
    (login = 'admin', password = 'admin', email = 'admin@gmail.com', name = 'Иван',
     surname = 'Иванов', telephone = '+380674002092', role = 'ADMINISTRATOR', status = '0',
     image = 'D:/server/admin.img');
  
  INSERT INTO users VALUES
    (login = 'manager', password = 'manager', email = 'manager@gmail.com', name = 'Петров',
     surname = 'Пётр', telephone = '+380964002092', role = 'MANAGER', status = '0',
     image = 'D:/server/manager.img');</pre>
  </blockquote>
  
  <p>During execution of the second INSERT I receive the following error <code>[23000][1062] Duplicate entry '0' for key 'PRIMARY'</code></p>