CREATE TABLE IF NOT EXISTS Useraccounts (
    id INT NOT NULL AUTO_INCREMENT,
    voornaam VARCHAR(50) NOT NULL ,
    achternaam VARCHAR(50) NOT NULL,
    straatnaam VARCHAR(50) NOT NULL,
    huisnr VARCHAR(50) NOT NULL,
    landnaam VARCHAR(50) NOT NULL,
    plaats VARCHAR(50) NOT NULL,
    postcode VARCHAR(50) NOT NULL,
    email VARCHAR(50) NOT NULL,
    telefoonnummer VARCHAR(50) NOT NULL,
    hashed_password VARCHAR(50) NOT NULL,
    PRIMARY KEY (id)
)

CREATE TABLE IF NOT EXISTS usercomments (
    id INT NOT NULL AUTO_INCREMENT,
    userid INT NOT NULL,
    usercomment VARCHAR(255) NOT NULL,
    stockitemid INT NOT NULL,
    PRIMARY KEY(id),
    FOREIGN KEY(stockitemid) REFERENCES StockItems(StockItemID),
    FOREIGN KEY(userid) REFERENCES useraccounts(id)
)