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', '[email protected]');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Will', 'Turner', '[email protected]');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Sam', 'Turley', '[email protected]');

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

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Nixon', 'Samuel', '[email protected]');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Nany', 'Bobbins', '[email protected]');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Nancy', 'Pansy', '[email protected]');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Clark', 'McAsshole', '[email protected]');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Baby', 'Spice', '[email protected]');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('Dr', 'Evil', '[email protected]');

INSERT INTO contacts (firstname, lastname, email)
VALUES ('John', 'Snow', '[email protected]');