Listing 1: CREATE TABLE IF NOT EXISTS accounts ( user_id INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY, email VARCHAR ( 255 ) UNIQUE NOT NULL, password VARCHAR ( 50 ) NOT NULL, first_name VARCHAR ( 50 ) NOT NULL, last_name VARCHAR ( 50 ) NOT NULL, created_on TIMESTAMP NOT NULL, last_login TIMESTAMP ); Listing 2: #language: nl-NL Functionaliteit: Het …
Read More »