SQLQuery1.SQL.Text:='CREATE TABLE IF NOT EXISTS clients('+
'client_id INT AUTO_INCREMENT,'+
'client_email VARCHAR(50),'+
'client_password VARCHAR(50),'+
'PRIMARY KEY(client_id));';
SQLQuery1.ExecSQL;
SQLQuery1.SQL.Text:='CREATE TABLE IF NOT EXISTS recipes('+
'recipe_id INT PRIMARY KEY,'+
'client_id INT,'+
'recipe_name VARCHAR(50),'+
'FOREIGN KEY(client_id) REFERENCES clients(client_id) '+
'ON DELETE CASCADE);';
SQLQuery1.ExecSQL;
SQLQuery1.SQL.Text:='CREATE TABLE IF NOT EXISTS ingredients('+
'ingredient_id INT PRIMARY KEY,'+
'recipe_id INT,'+
'ingredient_name VARCHAR(50),'+
'amount FLOAT,'+
'FOREIGN KEY(recipe_id) REFERENCES recipes(recipe_id) '+
'ON DELETE CASCADE);';
SQLQuery1.ExecSQL;