

CREATE TABLE Recipes (
  id VARCHAR(36)    NOT NULL,
  name VARCHAR(50)  NOT NULL,
  category TINYINT  NOT NULL,
  description VARCHAR(100),
  user_email VARCHAR(50) NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (user_email) REFERENCES `Users` (email)
);

INSERT INTO Recipes(id, name, category, user_email) VALUES 
    ('aaaaaaaaaaaaa1', 'Recipe A1', 0, 'a@a'),
    ('aaaaaaaaaaaaa2', 'Recipe A2', 1, 'a@a'),
    ('aaaaaaaaaaaaa3', 'Recipe A3', 2, 'a@a'),
    ('bbbbbbbbbbbb3', 'Recipe B1', 0, 'b@b');
