CREATE OR REPLACE TABLE `USER` (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
username CHAR(30) NOT NULL,
password CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
CREATE OR REPLACE TABLE `PRODUCT` (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
description TEXT NOT NULL,
price DECIMAL(6,2),
currency CHAR(3),
PRIMARY KEY (id)
);
CREATE OR REPLACE TABLE `CART` (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
product_id MEDIUMINT,
user_id MEDIUMINT,
PRIMARY KEY (id)
);
INSERT INTO USER (username, password) VALUES ("betty_97", "betty_surfer_2024");
INSERT INTO PRODUCT (
name,
description,
price,
currency
) VALUES
(
"Surfboard",
"Amzaing blue surfboard",
55.00,
"EUR"
),
(
"Skateboard",
"Amzaing red skateboard",
15.00,
"EUR"
);
SELECT id from USER where username = 'betty_97' and password = 'betty_surfer_2024'