it seems like everything correctly written, but I am still getting error code 3734: failed to add the foreign key constraints…
what went wrong here?
create database if not exists sql_store2;
use sql_store2;
drop table if exists customers;
create table if not exists customers
(
custumer_id int primary key auto_increment,
first_name varchar(50) not null,
points int not null default 0,
email varchar(255) not null unique
);
drop table if exists orders;
create table orders
(
order_id int primary key,
customer_id int not null,
FOREIGN KEY fk_orders_customers (customer_id)
REFERENCES customers (customer_id)
ON UPDATE cascade
ON DELETE no action
);