# Create a MySQL database with Docker
docker run --name employeeSystem -e MYSQL_ROOT_PASSWORD=password -p 30306:3306 -d mysql

# Enter the MySQL container to create the table that will be used. The previous password will be asked.
sudo docker exec -it employeeSystem bash
mysql -u root -p

# Create the database and the table
CREATE DATABASE employeeSystem;
USE employeeSystem;
CREATE TABLE `employeeSystem`.`employees` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` TEXT NOT NULL,
  `age` INT NOT NULL,
  `position` TEXT NOT NULL,
  `wage` INT NOT NULL,
  `country` TEXT NOT NULL,
  PRIMARY KEY (`id`));

# Clone this repository
git clone https://github.com/KelvinNovais/MERN-CRUD
cd MERN-CRUD

# Open a terminal on the server folder and run
yarn
node index.js

# Open a terminal on the client folder and run
yarn
yarn start