x8LKsAa1

1CREATE TABLE IF NOT EXISTS Useraccounts (
2	id INT NOT NULL AUTO_INCREMENT,
3	voornaam VARCHAR(50) NOT NULL ,
4	achternaam VARCHAR(50) NOT NULL,
5	straatnaam VARCHAR(50) NOT NULL,
6	huisnr VARCHAR(50) NOT NULL,
7	landnaam VARCHAR(50) NOT NULL,
8	plaats VARCHAR(50) NOT NULL,
9	postcode VARCHAR(50) NOT NULL,
10	email VARCHAR(50) NOT NULL,
11	telefoonnummer VARCHAR(50) NOT NULL,
12	hashed_password VARCHAR(50) NOT NULL,
13	PRIMARY KEY (id)
14)
15
16CREATE TABLE IF NOT EXISTS usercomments (
17	id INT NOT NULL AUTO_INCREMENT,
18	userid INT NOT NULL,
19	usercomment VARCHAR(255) NOT NULL,
20	stockitemid INT NOT NULL,
21	PRIMARY KEY(id),
22	FOREIGN KEY(stockitemid) REFERENCES StockItems(StockItemID),
23	FOREIGN KEY(userid) REFERENCES useraccounts(id)
24)