DatabaseScript

CREATE TABLE items(
item_id INT NOT NULL AUTO_INCREMENT,
itemName varchar(255) NOT NULL,
itemDescription varchar(255) NOT NULL,
itemPrice double,
itemQuantity int,
itemUrl varchar(255) NOT NULL,
primary key(item_id)
);

CREATE TABLE user(
user_id int NOT NULL AUTO_INCREMENT,
firstName varchar(255) NOT NULL,
lastName varchar(255) NOT NULL,
email varchar(255) NOT NULL,
password varchar(255) NOT NULL,
primary key (user_id)
);

CREATE TABLE wishLists(
list_id int NOT NULL AUTO_INCREMENT,
listName varchar(255) NOT NULL,
primary key (list_id)
);


TEST DATA:

INSERT INTO user (firstName, lastName, email, password )
VALUES ("Sabrina", "Ebbesen", sabrinahammerich@gmail.com "Tysontyson9");

INSERT INTO wish_list (listName)
VALUES ("Birthday");

INSERT INTO items (name_of_item, description_of_item, price, quantity, url)
VALUES ("Nike Shorts", "Lårkorte shorts", 250, 1, "www.nikeshorts.dk");