-- Seed data for URUP Estimator.
-- Import this in phpMyAdmin AFTER db/schema.sql, so no terminal is needed.
-- Every account below starts with the password: ChangeMe123!
-- Change it on first sign in.

INSERT INTO skills (code, name, hourly_rate, sort_order, active) VALUES
  ('BA',     'Business analysis',    950.00,  10, 1),
  ('UX',     'UX and UI design',     950.00,  20, 1),
  ('FE',     'Front end',           1050.00,  30, 1),
  ('BE',     'Back end',            1100.00,  40, 1),
  ('MOB',    'Mobile',              1150.00,  50, 1),
  ('INT',    'Integration',         1200.00,  60, 1),
  ('DATA',   'Data and reporting',  1100.00,  70, 1),
  ('QA',     'Test and QA',          850.00,  80, 1),
  ('DEVOPS', 'DevOps',              1150.00,  90, 1),
  ('PM',     'Project management',   950.00, 100, 1)
ON DUPLICATE KEY UPDATE name = VALUES(name), sort_order = VALUES(sort_order);

INSERT INTO users (name, email, password_hash, role, can_estimate, active) VALUES
  ('Gary Hawkridge', 'gary.hawkridge@urupconnect.com', '$2a$10$aXmoKPHqjbGFd4RL.UwNc.Q9f5hTLZAHVE2U8gjx2CvEXyHryYjrW', 'production_manager', 1, 1),
  ('Craig McKenzie', 'craig.mckenzie@urupconnect.com', '$2a$10$aXmoKPHqjbGFd4RL.UwNc.Q9f5hTLZAHVE2U8gjx2CvEXyHryYjrW', 'developer',          1, 1),
  ('Heidi Kruger',   'heidi.kruger@urupconnect.com',   '$2a$10$aXmoKPHqjbGFd4RL.UwNc.Q9f5hTLZAHVE2U8gjx2CvEXyHryYjrW', 'developer',          1, 1),
  ('Andre',          'andre@urupconnect.com',          '$2a$10$aXmoKPHqjbGFd4RL.UwNc.Q9f5hTLZAHVE2U8gjx2CvEXyHryYjrW', 'admin',              1, 1)
ON DUPLICATE KEY UPDATE name = VALUES(name), role = VALUES(role), can_estimate = VALUES(can_estimate);