Skip to content
Snippets Groups Projects
user avatar
Rafi authored
Changed code so that the information needed to connect to the database is passed to it by the server class
0fa9e56b
History

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:

-