initial_setup.sql

CREATE DATABASE "web-sec";

 \c web-sec;

CREATE TABLE "benutzer" (
    customerid SERIAL NOT NULL,
    vorname text NOT NULL,
    nachname text NOT NULL,
    email varchar(255) NOT NULL,
    PRIMARY KEY(customerid)
);

INSERT INTO 
    "benutzer" (vorname, nachname, email)
VALUES
    ('Alice','Apple', 'alice@apple.net'),
    ('Bob','Banana', 'bob@banana.net'),
    ('Mallory','Mango', 'mallory@mango.net');