 );
 
 CREATE TABLE user (
-  id INTEGER PRIMARY KEY,
+  id INTEGER AUTO_INCREMENT PRIMARY KEY,
   username TEXT NOT NULL,
   first_name TEXT NOT NULL,
   last_name TEXT NOT NULL,

);

CREATE TABLE product (
  id INTEGER PRIMARY KEY,
  identifier TEXT NOT NULL,
  type INTEGER NOT NULL,
  production_id INTEGER NOT NULL,

);

CREATE TABLE role (
  id INTEGER AUTO_INCREMENT PRIMARY KEY,
  name TEXT NOT NULL
);

CREATE TABLE user_role (
  id INTEGER AUTO_INCREMENT PRIMARY KEY,
  user_id INTEGER NOT NULL,
  role_id INTEGER NOT NULL,
  FOREIGN KEY(user_id) REFERENCES user(id),
