CREATE TABLE customers
(
customerid INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
firstname VARCHAR (20) NOT NULL,
lastname VARCHAR(30) NOT NULL,
phonenr VARCHAR(16) NOT NULL,
email VARCHAR (40) NOT NULL
);
CREATE TABLE products
(
productid INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
cathegory VARCHAR(15) NOT NULL,
productname VARCHAR (25) NOT NULL,
description TEXT NOT NULL,
color VARCHAR (10) NOT NULL,
price DECIMAL (5,2) NOT NULL);

CREATE TABLE purchases
(
purchaseid INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
customerid INTEGER NOT NULL,
productid INTEGER NOT NULL,
purchasedate TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
amount INTEGER NOT NULL,
    
FOREIGN KEY (customerid)
REFERENCES customers (customerid)
ON DELETE RESTRICT,

FOREIGN KEY (productid)
REFERENCES products (productid)
ON DELETE RESTRICT 
);