-- accounts
CREATE TABLE accounts (
    user_id serial PRIMARY KEY,
    username VARCHAR ( 50 ) UNIQUE NOT NULL,
    password VARCHAR ( 50 ) NOT NULL,
    email VARCHAR ( 255 ) UNIQUE NOT NULL,
    created_on TIMESTAMP NOT NULL,
        last_login TIMESTAMP
);


INSERT INTO accounts
(username, "password", email, created_on, last_login)
VALUES('test1', 'test1', 'test@test.com', now(), NULL);

INSERT INTO accounts
(username, "password", email, created_on, last_login)
VALUES('test2', 'test1', 'test@test.com', now(), NULL);

SELECT * FROM accounts