# 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:

    - In the main method in the ScheduleServer input the proper parameters:
        * ip: The local address that you want the server to listen to. If your running the
            server and the client on the same machine set it to "localhost".
        * port: The port that you want the server to listen to.
        * dbURL: "jdbc:mysql://hostname:port/DB_Name". Change 'hostname' to the MySQL
          MySQL server address, Change 'port' to the MySQL server port, and
          'DB_Name' to the MySQL server database. (This should be ScheduleApp)
            to the 
        * dbUser: The user name of the MySQL server.
        * dbPass: The password of the MySQL password.
    - Save, then run the main method.