Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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'),
- ('21', 'manosirl@yandex.com', 'Manos1312'),
- ('22', 'John.slith@aol.com', '9423eld'),
- ('23', 'jerdelr@mail.com', '1234jer'),
- ('24', 'proton1312@hotmail.gr', 'energy992');
- 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'),
- ('21', 'Manos', 'Irlidis', 'M', 'Hereford', '02948534127'),
- ('22', 'John', 'Slithes', 'M', 'Lancashire', '04657798800'),
- ('23', 'Jerden', 'Lrodes', 'F', 'Edinburgh', '01314599119'),
- ('24', 'Proton', 'Mouskaris', 'M', 'Norwich', '01603329450');
- 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.');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement