cmpt-370-group-project

- Download and run the MySQL Installer, make sure that MySQL Server is installed (optionally install MySQL Workbench).
- Create a MySQL server and with whatever host address you like and an available port. If your running it locally than you can keep it these values as default.
- In MySQL open the sql file "ScheduleApp.sql" and execute the following commands:
    * create database ScheduleApp;
    * use ScheduleApp;
    * create table Employees(
        employee_ID INT NOT NULL auto_increment,
        first_name varchar(25),
        last_name varchar(25),
        primary key (employee_ID)
        );
    * create table Shifts(
        shift_id INT NOT NULL auto_increment UNIQUE,
        full_date DATE,
        start_time INT,
        end_time INT,
        employee_ID INT,
        PRIMARY KEY (shift_id),
        FOREIGN KEY (employee_ID) REFERENCES Employees(employee_ID)
    );
- Open the 'server' tab at the top and select 'server status', and make sure that the server status is 'Running'