# cmpt-370-group-project

To run the scheduling app properly you must have the database running and the server connected to it.  

How to set up the MySQL database:

    - 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'

How to set up the Scheduling Server: