INSERT INTO `account` (`id`, `email`, `password`) VALUES
    ('0', 'test@gmail.com', 'passw0rd'),
    ('1', 'test1@yahoo.com', 'pass'),
    ('2', 'user2@gmail.com', 'hunter2'),
    ('3', 'company@name.com', 'zaqwsx'),
    ('4', 'oof@gmail.com', 'ouchowie'),
    ('5', 'dave.cl@hotmail.com', '080385dave'),
    ('6', 'worsalldan@hotmail.com', 'qwerty321'),
    ('7', 'Nygirl42@gmail.com', 'abcd4321'),
    ('8', 'alexnewcombe@hotmail.com', 'qWeRtY123'),
    ('9', 'jonathanblacks@gmail.com', 'passy123'),
    ('10', 'Joanne12@yahoo.com', ennaoj99'),
    ('11', 'bobbyjenkins@outlook.com', 'ilovemydog321'),
    ('12', 'craigdavies@hotmail.co.uk', 'Liverpoolfc'),
    ('13', 'liamberk@hotmail.com', '150499liam'),
    ('14', 'maximusskeet@hotmail.com', 'skeety55'),
    ('15', 'elliejohnson@gmail.com', '556677ellie'),
    ('16', 'Jassarg@outlook.com', 'jasmineisqueen123'),
    ('17', 'HellyHelen@outlook.com', 'Helenssecretpassword99'),
    ('18', 'DVS99@outlook.co.uk', 'daVIDsHAW'),
    ('19', 'T.hales@hotmail.co.uk', 'jlwgb2344'),
    ('20', 'samthesnake@gmail.com', 'hhkkggjj1122');


INSERT INTO `user` (`id`, `first_name`, `second_name`, `gender`, `location`, `phone_number`) VALUES
    ('0', 'Adam', 'Smith', 'M', 'Liverpool', '02746128271'),
    ('1', 'Marlie', 'Durham', 'F', 'Liverpool', '02716583726'),
    ('2', 'Adele', 'Gilmore', 'F', 'Liverpool', '02716583926'),
    ('4', 'Geoffrey', 'Macdonald', 'M', 'Liverpool', '0572816754'),
    ('6', 'Daniel', 'Worsall', 'M', 'Blackpool', '07809321432'),
    ('7', 'Stephanie', 'Richard', 'F', 'Blackpool', '08091654781'),
    ('8', 'Stanley', 'Smith', 'M', 'Liverpool', '01472801321'),
    ('9', 'jonathan', 'black', 'M', 'Southport', '07724564536'),
    ('10', 'Joanne', 'Gorman', 'F', 'Manchester', '02495674267'),
    ('11', 'Bobby', 'Jenkins', 'M', 'London', '01446345366'),
    ('12', 'Craig', 'Davies', 'M', 'Leeds', '03543623235'),
    ('13', 'Liam', 'Berk', 'M', 'Swansea', '04356324677'),
    ('14', 'Max', 'Skeet', 'M', 'Southampton', '02356576563'),
    ('15', 'Ellie', 'Johnson', 'F', 'Lancashire', '06568345678'),
    ('16', 'Jasmine', 'Sargent', 'F', 'Ormskirk', '03534574433'),
    ('17', 'Helen', 'Johnson', 'F', 'Preston', '02357457434'),
    ('18', 'David', 'Shaw', 'M', 'Lancashire', '08279473908'),
    ('19', 'Thomas', 'Hales', 'M', 'Blackpool', '01254636347'),
    ('20', 'Sam', 'Rawsthorne', 'M', 'Liverpool', '06433457344');

INSERT INTO `company` (`id`, `name`, `logo`, `location`) VALUES
    ('3', 'Companyname', 'path_to_logo', 'Location'),
    ('5', 'Companyname', 'path_to_logo', 'Location');

INSERT INTO `recruiter` (`id`, `company`) VALUES
    ('1', '3'),
    ('2', '3'),
    ('6', '5');

INSERT INTO `jobseeker` (`id`, `cv`, `dob`, `description`) VALUES
    ('4', 'path_to_cv', '1998-08-12', 'This is the description'),
    ('0', 'path_to_cv', '1992-01-15', 'Different description'),
    ('7', 'path_to_cv', '1985-05-01', 'Different description'),
    ('8', 'path_to_cv', '1997-04-29', 'Different description');

INSERT INTO `job` (`id`, `title`, `description`, `location`, `pictures`, `category`, `recruiter`) VALUES
    ('0', 'JobTitle', 'description', 'location', 'path_to_pictures', 'Bartender', '1'),
    ('1', 'AnotherJob', 'description', 'location', 'path_to_pictures', 'Unknown', '2'),
    ('2', 'AnotherJob', 'description', 'location', 'path_to_pictures', 'Accountant', '6')


INSERT INTO `posting` (`id`, `title`, `description`, `location`, `pictures`, `salary`, `time_created`, `hours`, `interview_type`, `job`) VALUES
    ('0', 'PostingTitle', 'description', 'Location', 'path_to_pictures', '10000', '2018-11-22 00:00:00', '40', 'Unknown', '1'),
    ('1', 'DifferentPosting', 'description', 'Location', 'path_to_pictures', '40000', '2018-11-23 00:00:00', '30', 'Unknown', '0'),
    ('2', 'DifferentPosting', 'description', 'Location', 'path_to_pictures', '65000', '2018-12-13 00:00:00', '36', 'video call', '2');



INSERT INTO `card` (`id`, `time_created`, `days`, `posting`, `recruiter`) VALUES
    ('0', '2018-11-22 00:00:00', '8', '1', '1'),
    ('1', '2018-11-21 00:00:00', '7', '0', '2'),
    ('2', '2018-12-13 00:00:00', '13' '2', '6');

INSERT INTO `employment` (`id`, `date_start`, `date_end`, `position`, `description`, `company`, `jobseeker`) VALUES
    ('0', '2018-11-04', '2018-11-08', 'Manager', 'Description', '3', '0'),
    ('1', '2018-10-04', '2018-11-08', 'Worker', 'Description', '3', '4'),
    ('2', '2018-12-25', '2019-03-01', 'Accountant', 'Description', '5', '7');

INSERT INTO `match` (`id`, `time_matched`, `interview_description`, `interview_date`, `interview_location`, `time_hired`, `time_disqualified`, `employment`, `jobseeker`, `card`) VALUES
    ('0', '2018-11-21 00:00:00', 'None', '2018-11-22 00:00:00', 'Location', '2018-11-22 07:00:00', NULL, '0', '0', '0'),
    ('1', '2018-11-21 00:00:01', 'None', '2018-11-22 01:00:00', 'Location', NULL, '2018-11-22 07:00:00', '0', '4', '1'),
    ('2', '2018-12-15' 00:00:12', 'None', '2018-12-16 08:00:00', 'Location', '2018-12-14 05:00:00', NULL, '2', '7','2');

INSERT INTO `message` (`id`, `is_delivered`, `is_read`, `time_sent`, `user`, `match`, `content`) VALUES
    ('0', b'1', b'0', '2018-11-22 01:00:00', '0', '0', 'Hi'),
    ('1', b'1, b'1', '2018-12-14 05:01:35', '7', '2', 'Good morning.');