Postgresql database used in this application.
DATABASE SCRIPT:
CREATE DATABASE IF NOT EXISTS employee_directory
;
USE employee_directory
;
DROP TABLE IF EXISTS employee
;
CREATE TABLE employee
(
id
INTEGER,
first_name
varchar(45) DEFAULT NULL,
last_name
varchar(45) DEFAULT NULL,
email
varchar(45) DEFAULT NULL,
PRIMARY KEY (id
)
)
INSERT INTO employee
VALUES
(1,'Leslie','Andrews','[email protected]'),
(2,'Emma','Baumgarten','[email protected]'),
(3,'Avani','Gupta','[email protected]'),
(4,'Yuri','Petrov','[email protected]'),
(5,'Juan','Vega','[email protected]');