text: INSERT INTO departments VALUES (1, 'Retail');
  
  INSERT INTO administrators VALUES (1, 'admin', 'Admin', 'Admin' , 'administrator@gmail.com', '000-000-0000', 1);
  INSERT INTO administrators VALUES (2, 'jdean', 'Jimmy', 'Dean', 'jdean@gmail.com', '704-923-2368', 1);
  INSERT INTO administrators VALUES (3, 'mlinda', 'Martha', 'Linda' , 'mlinda@gmail.com', '980-555-4392', 1);
  
  INSERT INTO application_users VALUES (1, 'admin', '$2a$10$Y1ZMm7OQpEs5HmwEHc55oeWQa3u8XXFIF18Y5jlCdVi7r8b7iB0E2', 1);
  
  INSERT INTO roles VALUES (1, 'USER', 'application user');
  INSERT INTO roles VALUES (2, 'ADMIN', 'application administrator');
  
  INSERT INTO user_roles VALUES (1, 1, 2);
  
  INSERT INTO employees VALUES (1, 'jcarter', 'James', 'Carter', 'jcarter@gmail.com', '704-923-4432', 1, 1);
  INSERT INTO employees VALUES (2, 'hleary', 'Helen', 'Leary' , 'hleary@gmail.com', '704-923-5092', 1, 1);
  INSERT INTO employees VALUES (3, 'jsmith', 'John', 'Smith', 'jsmith@gmail.com', '704-920-3315', 1, 1);
  INSERT INTO employees VALUES (4, 'athomas', 'Adam', 'Thomas' , 'athomas@gmail.com', '704-920-8883', 1, 1);
  
  INSERT INTO shift_days VALUES (1, 'Monday');
  INSERT INTO shift_days VALUES (2, 'Tuesday');
  INSERT INTO shift_days VALUES (3, 'Wednesday');
  INSERT INTO shift_days VALUES (4, 'Thursday');
  INSERT INTO shift_days VALUES (5, 'Friday');
  INSERT INTO shift_days VALUES (6, 'Saturday');
  INSERT INTO shift_days VALUES (7, 'Sunday');
  
  
  INSERT INTO shifts VALUES (1, '08:00:00.000000', '15:59:00.000000');
  INSERT INTO shifts VALUES (2, '16:00:00.000000', '23:59:00.000000');
  INSERT INTO shifts VALUES (3, '00:00:00.000000', '07:59:00.000000');
  