Contacts Database

db.sql

DROP TABLE 
IF EXISTS contacts;

CREATE TABLE contacts (
  id        serial NOT NULL PRIMARY KEY,
  firstname varchar(40) NOT NULL,
  lastname  varchar(40) NOT NULL,
  email     varchar(40) NOT NULL
);

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Bill', 'Turner', 'Burner@gmail.com');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Will', 'Turner', 'WTUner@gmail.com');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Sam', 'Turley', 'saley@gmail.com');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Jillian', 'Carmichal', 'Jilmichal');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Nixon', 'Samuel', 'Saxon@gmail.com');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Nany', 'Bobbins', 'doodo@gmail.com');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Nancy', 'Pansy', 'gogo@gmail.com');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Clark', 'McAsshole', 'dolphinparty@gmail.com');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Baby', 'Spice', 'bubblegun@gmail.com');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Dr', 'Evil', 'evil@gmail.com');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('John', 'Snow', 'snowblowshowdoe@gmail.com');