DataGeneration_20191204-2136.sql

--
-- Script was generated by Devart dbForge Data Generator for MySQL, Version 2.2.33.0
-- Product Home Page: http://www.devart.com/dbforge/mysql/data-generator
-- Script date 12/4/2019 10:52:37 PM
-- Target server version: 5.5.5-10.1.37-MariaDB
-- Target connection string: User Id=root;Host=localhost;Database=sql12313982;Character Set=utf8
--



SET NAMES 'utf8';
USE sql12313982;
--
-- Delete data from the table 'pay_grade_leave'
--
TRUNCATE TABLE pay_grade_leave;
--
-- Delete data from the table 'leave'
--
TRUNCATE TABLE `leave`;
--
-- Delete data from the table 'employee_email'
--
TRUNCATE TABLE employee_email;
--
-- Delete data from the table 'employee_custom_attributes'
--
TRUNCATE TABLE employee_custom_attributes;
--
-- Delete data from the table 'employee_contact_no'
--
TRUNCATE TABLE employee_contact_no;
--
-- Delete data from the table 'emergency_contact'
--
TRUNCATE TABLE emergency_contact;
--
-- Delete data from the table 'dependent'
--
TRUNCATE TABLE dependent;
--
-- Delete data from the table 'employee'
--
DELETE FROM employee;
--
-- Delete data from the table 'pay_grade'
--
DELETE FROM pay_grade;
--
-- Delete data from the table 'organization_info'
--
TRUNCATE TABLE organization_info;
--
-- Delete data from the table 'leave_type'
--
DELETE FROM leave_type;
--
-- Delete data from the table 'job_title'
--
DELETE FROM job_title;
--
-- Delete data from the table 'employment_status'
--
DELETE FROM employment_status;
--
-- Delete data from the table 'department'
--
DELETE FROM department;
--
-- Delete data from the table 'custom_attribute'
--
DELETE FROM custom_attribute;

--
-- Inserting data into table custom_attribute
--
BEGIN;
INSERT INTO custom_attribute(attribute) VALUES
('GAaSWYkwu'),
('qHQ'),
('t'),
('RnoGQjexHlqO'),
('siFQeOBTLiPQDtrR'),
('dMYx'),
('eDdl'),
('MqXQXcYKCEZIyJeWwPrhccJmNPYgJp'),
('jqoVUxaIxDMQpQQguRjTShnYnBusvdcueLGUyQkczdGVyGnNOP'),
('pXQIFS'),
('PQgsx'),
('XFmdSwqEvUQjvfppFQBHmkjQiYvYYUQcVMkQE'),
('RU'),
('syTnbYruGvxgeHSQ'),
('PcLWjdQvuGLM'),
('wRQAjtGGcmZdEVXrzHhd'),
('ZWPAYwYDhnVDSNYWAmK'),
('sXUiWDNrADCmOjEljJWznBUDpa'),
('txtQP'),
('ADih'),
('WfLLljqNlM'),
('RJmfUzGXoA'),
('FvOGIFcIdTt'),
('sZPBTuqSqLYxSkTnbZsOQ'),
('qBvpsZmNIcxtA'),
('EISZMQZZMKQvUmsA'),
('i'),
('tZLKoXhVRIFPqc'),
('qeaxGPehSZRmdlGhlSgLIkQctYFhaXaMDtwKfOztdhHCsIbZFC'),
('uzAnNgFSDMcliuMMmXaAixY'),
('iCyGkUXPdcrGkucwDdFXVmukypCeayxSXekMe'),
('vNIvEDSnJUMjc'),
('DAScJrAw'),
('cunZYklDh'),
('GG'),
('lULgACABvKTfBHucSpsTXc'),
('UvFkclTVnufoUf'),
('cVbHAHfmskzqsykakhaVOZXpPxTpyPEFMBpZlGWof'),
('OjLncJEGHkXMd'),
('anRDy'),
('EOHVBmiOuDTjZkLbvjCHgBcAsBlZIMXBBVUislzgShjVfNSqlM'),
('ugDyKUAoGbZAAAYZ'),
('JnaImCtMIo'),
('VVjytCTYHJxQJMAaoj'),
('PEXsBBAR'),
('ytA'),
('uSBODmESdxaiAvBEglTn'),
('OEUgoefQisqayiSGrePppZNBEkMtpSpwFaRR'),
('ccrBw'),
('fQwJUXGNsgxbRnkN');

--
-- Inserting data into table department
--
INSERT INTO department(dept_name) VALUES
('Sales'),
('Finance'),
('Research and Development'),
('Manufacturing'),
('Human Resources'),
('Customer Support'),
('Executive'),
('Facilities'),
('Information Technology'),
('Operations'),
('Consulting'),
('Marketing');

--
-- Inserting data into table employment_status
--
INSERT INTO employment_status(employment_status) VALUES
('Permanent-PT'),
('Contract-FT'),
('Freelance'),
('Trainee'),
('Contract-PT'),
('Permanent-FT');

--
-- Inserting data into table job_title
--
INSERT INTO job_title(job_title, access_level) VALUES
('Chief Executive Officer', 'L2'),
('Communication Analyst', 'L2'),
('Product Manager', 'L2'),
('Secretary', 'L1'),
('Site Manager', 'L2'),
('Chief Technology Officer', 'L2'),
('Director of Finance', 'L2'),
('Assistant Vice President', 'L2'),
('Senior Consultant', 'L2'),
('Commercial Manager', 'L1'),
('Business Analyst', 'L2'),
('Channel Sales Manager', 'L2'),
('Human Resources Representative', 'L2'),
('Sales Consultant', 'L2'),
('Specialist', 'L2'),
('Commercial Director', 'L2'),
('Lead Engineer', 'L2'),
('Shop Assistant', 'L2'),
('Purchasing Agent', 'L2'),
('QA Manager', 'L1'),
('Vice President', 'L2'),
('Consultant', 'L1'),
('Chief Financial Officer', 'L2'),
('Budget Analyst', 'L2'),
('Revenue Manager', 'L1'),
('Technical Writer', 'L1'),
('Technical Editor', 'L1'),
('Technology Manager', 'L2'),
('Developer/Programmer', 'L2'),
('Contract Manager', 'L2'),
('Marketing Consultant', 'L1'),
('Research Engineer', 'L1'),
('Technical Consultant', 'L1'),
('Controller', 'L1'),
('Director of Customer Support', 'L1'),
('Project Coordinator', 'L2'),
('Contract Advisor', 'L2'),
('Web Designer', 'L2'),
('Communication Manager', 'L2'),
('Senior Specialist', 'L1'),
('Support Manager', 'L2'),
('Computer Operator', 'L2'),
('Sales Agent', 'L2'),
('Sales Administrator', 'L1'),
('Regional Director', 'L2'),
('Senior Business Analyst', 'L1'),
('Engineer', 'L1'),
('Trainer/Consultant', 'L1'),
('Solution Engineer', 'L2'),
('Security Manager', 'L2');

--
-- Inserting data into table leave_type
--
INSERT INTO leave_type(leave_type) VALUES
('Annual'),
('Casual'),
('No-Pay'),
('Sick');

--
-- Inserting data into table organization_info
--
INSERT INTO organization_info(`key`, value) VALUES
('Email', 'wCzmEWHKzXW'),
('Name', 'IgVQTGJJDNC'),
('Address', 'cdrWAzGATxj'),
('Telephone', 'JdkwYyPutRv'),
('Reg-No', 'JbxynIxyDw');

--
-- Inserting data into table pay_grade
--
INSERT INTO pay_grade(pay_grade) VALUES
('Grade-1'),
('Grade-2'),
('Grade-4'),
('Grade-3');

--
-- Inserting data into table employee
--
INSERT INTO employee(employee_id, first_name, last_name, nic, addr_house_no, addr_line_1, addr_line_2, addr_city, dob, marital_status, employment_status, active_status, job_title, dept_name, pay_grade, supervisor_id) VALUES
('96821', 'Elwood', 'Coleman', '682112831919', 'PO Box 6309', '87th Floor', 'Manitowoc', 'Selbyville', '1993-10-22', 'Married', 'Contract-FT', 1, 'Human Resources Representative', 'Research and Development', 'Grade-2', '52663'),
('12831', 'Lindsey', 'Fife', '127381159v', 'PO Box 1', '8th FL', 'Pauline', 'Zuni', '1969-07-09', 'Married', 'Contract-FT', 1, 'Developer/Programmer', 'Executive', 'Grade-2', '96821'),
('91981', 'Deedra', 'Severson', '280851871v', 'PO Box 7280', '61th Floor', 'Bernalillo', 'Truman', '1961-11-04', 'Single', 'Trainee', 1, 'Research Engineer', 'Information Technology', 'Grade-4', '97695'),
('27381', 'Rayford', 'Turney', '038589566409', 'P.O. Box 24', '9th Floor', 'Forrest City', 'Canyonville', '1981-03-12', 'Married', 'Contract-PT', 1, 'Trainer/Consultant', 'Information Technology', 'Grade-3', '25316'),
('15938', 'Sonny', 'Mattox', '222531675v', 'P.O. Box 82881', '73th FL', 'Cuba', 'Greenbelt', '1988-10-24', 'Divorced', 'Trainee', 1, 'Channel Sales Manager', 'Facilities', 'Grade-4', '61469'),
('11427', 'Hope', 'Seward', '828423408v', 'PO Box 40', '63th FL', 'Zuni', 'Ark', '1957-04-22', 'Married', 'Contract-PT', 1, 'Technical Consultant', 'Sales', 'Grade-4', '11427'),
('27438', 'Chandra', 'Turpin', '921969519151', 'P.O. Box 6283', '56th FL', 'Clawson', 'Eastpoint', '1950-07-21', 'Married', 'Contract-PT', 1, 'Secretary', 'Finance', 'Grade-1', '49673'),
('98918', 'Charolette', 'Kelsey', '655266373979', 'PO Box 3412', '8th FL', 'Jameson', 'Capac', '1951-07-04', 'Divorced', 'Freelance', 0, 'Secretary', 'Executive', 'Grade-4', '49673'),
('67589', 'Kim', 'Mattson', '967322638v', 'PO Box 4054', '40th FL', 'Whitinsville', 'Leflore', '1977-02-26', 'Single', 'Permanent-FT', 1, 'Purchasing Agent', 'Finance', 'Grade-4', '91427'),
('60676', 'Randolph', 'Overby', '638643937v', 'P.O. Box 225', '71th Floor', 'Forreston', 'Selden', '1979-01-09', 'Married', 'Permanent-FT', 1, 'Chief Executive Officer', 'Executive', 'Grade-2', '39782'),
('25316', 'Jonah', 'Rushing', '982531724v', 'PO Box 25', '7th Floor', 'Bernard', 'Oakes', '1950-09-08', 'Divorced', 'Freelance', 1, 'Trainer/Consultant', 'Executive', 'Grade-1', '60676'),
('75243', 'Adah', 'Cosgrove', '256620908v', 'PO Box 68', '74th Floor', 'Mankato', 'Arkadelphia', '1949-01-31', 'Married', 'Freelance', 0, 'Senior Business Analyst', 'Human Resources', 'Grade-3', '95191'),
('48685', 'Bernard', 'Bohn', '623712893v', 'P.O. Box 62320', '7th FL', 'Jamesport', 'Reedsburg', '1993-04-21', 'Married', 'Permanent-FT', 1, 'Engineer', 'Manufacturing', 'Grade-1', '11427'),
('48708', 'Antonia', 'Kelso', '379903139782', 'P.O. Box 59', '4th Floor', 'Sunapee', 'Morrow', '1954-03-12', 'Married', 'Contract-FT', 1, 'Technical Writer', 'Research and Development', 'Grade-4', '18486'),
('78096', 'Jean', 'Mauldin', '317848851184', 'P.O. Box 526', '50th FL', 'Whitman', 'Oakesdale', '1949-01-14', 'Married', 'Permanent-PT', 1, 'Commercial Manager', 'Facilities', 'Grade-1', '51365'),
('95191', 'Vincenzo', 'Overstreet', '669351614v', 'P.O. Box 946', '6th FL', 'Clay', 'Reedsport', '1986-11-30', 'Married', 'Contract-PT', 1, 'Communication Manager', 'Sales', 'Grade-1', '48685'),
('51365', 'Isaac', 'Russ', '620892081v', 'P.O. Box 4', '6th FL', 'San Jacinto', 'Oakfield', '1957-10-24', 'Divorced', 'Freelance', 1, 'Purchasing Agent', 'Human Resources', 'Grade-1', '73086'),
('52663', 'Terry', 'Coles', '935092102281', 'PO Box 961', '70th FL', 'Paullina', 'Trumann', '1952-05-24', 'Married', 'Contract-FT', 1, 'Budget Analyst', 'Manufacturing', 'Grade-2', '98918'),
('73979', 'Gerry', 'Sewell', '617200670v', 'PO Box 59', '7th Floor', 'San Joaquin', 'Leggett', '1949-01-06', 'Divorced', 'Trainee', 1, 'Business Analyst', 'Human Resources', 'Grade-2', '65934'),
('49673', 'Bernardina', 'Tuttle', '663940219769', 'PO Box 78798', '86th Floor', 'Pauls Valley', 'Morse', '1958-04-08', 'Married', 'Trainee', 1, 'Computer Operator', 'Information Technology', 'Grade-3', '48851'),
('22638', 'Kent', 'Sexton', '125546515419', 'P.O. Box 6', '50th Floor', 'Bernardston', 'Greenbrae', '1971-05-21', 'Single', 'Contract-PT', 1, 'Chief Executive Officer', 'Sales', 'Grade-3', '91853'),
('91427', 'Adolph', 'Tyler', '508393709v', 'P.O. Box 334', '5th FL', 'Manlius', 'Selfridge', '1958-05-27', 'Single', 'Contract-FT', 1, 'Chief Financial Officer', 'Executive', 'Grade-4', '12641'),
('11796', 'Leif', 'Boisvert', '763112738225', 'P.O. Box 13', '85th FL', 'Jamestown', 'Eastpointe', '1990-03-12', 'Married', 'Contract-PT', 1, 'Revenue Manager', 'Manufacturing', 'Grade-2', '78096'),
('49252', 'Adan', 'Kemp', '769480516418', 'PO Box 46484', '8th FL', 'Clay Center', 'Cape Canaveral', '1950-10-09', 'Married', 'Freelance', 1, 'Budget Analyst', 'Research and Development', 'Grade-2', '12641'),
('74078', 'Kathey', 'Maupin', '240312618731', 'PO Box 35', '3rd Floor', 'Manly', 'Lehi', '1987-01-09', 'Married', 'Contract-FT', 1, 'Research Engineer', 'Executive', 'Grade-1', '60676'),
('91853', 'Felisa', 'Coley', '396459050v', 'P.O. Box 8', 'Keith Building', 'Sunbright', 'Reedsville', '1994-01-18', 'Divorced', 'Contract-PT', 1, 'Director of Finance', 'Operations', 'Grade-3', '57980'),
('92568', 'Rachele', 'Kemper', '323932030282', 'P.O. Box 7793', '8th Floor', 'Cuba City', 'Greenbrier', '1950-08-28', 'Married', 'Freelance', 0, 'Controller', 'Information Technology', 'Grade-2', '11427'),
('65934', 'Adaline', 'Overton', '563838047655', 'PO Box 3880', '55th Floor', 'Forsyth', 'Trumansburg', '1971-07-12', 'Married', 'Permanent-FT', 1, 'Budget Analyst', 'Consulting', 'Grade-3', '48851'),
('23539', 'Maynard', 'Figueroa', '182958817v', 'PO Box 1', '84th Floor', 'San Jose', 'Oakham', '1955-12-01', 'Married', 'Permanent-FT', 1, 'Revenue Manager', 'Facilities', 'Grade-4', '65934'),
('09929', 'Dwain', 'Costa', '114182682743', 'PO Box 5434', '78th Floor', 'Whitmire', 'Reese', '1951-06-04', 'Married', 'Contract-FT', 1, 'Communication Analyst', 'Information Technology', 'Grade-1', '74078'),
('49031', 'Karine', 'Seymore', '880262321v', 'P.O. Box 26', '44th FL', 'Sunbury', 'Morton', '1978-09-06', 'Married', 'Permanent-FT', 1, 'Commercial Director', 'Marketing', 'Grade-2', '49673'),
('39782', 'Cordell', 'Russell', '760457285v', 'P.O. Box 128', '8th Floor', 'Bernardsville', 'Lehigh', '1950-09-15', 'Single', 'Freelance', 1, 'Revenue Manager', 'Consulting', 'Grade-4', '25316'),
('53178', 'Chana', 'Owen', '522915439515', 'P.O. Box 45125', '74th Floor', 'Paulsboro', 'Arkansas City', '1965-04-08', 'Single', 'Permanent-FT', 1, 'Revenue Manager', 'Customer Support', 'Grade-4', '98918'),
('48851', 'Kelsi', 'Boland', '694479676672', 'P.O. Box 975', '9th Floor', 'Cudahy', 'Morton Grove', '1987-02-19', 'Single', 'Trainee', 1, 'Budget Analyst', 'Human Resources', 'Grade-2', '98918'),
('18486', 'Lester', 'Tyner', '210014305v', 'P.O. Box 16261', '52th FL', 'San Juan', 'Seligman', '1949-01-02', 'Married', 'Contract-FT', 1, 'Technology Manager', 'Research and Development', 'Grade-1', '91853'),
('69351', 'Adria', 'Finch', '550657906v', 'P.O. Box 7', '9th Floor', 'Forsyth County', 'Cape Charles', '1949-01-05', 'Divorced', 'Permanent-PT', 1, 'Budget Analyst', 'Manufacturing', 'Grade-1', '65934'),
('61469', 'David', 'Seymour', '619249406v', 'PO Box 495', '55th FL', 'Clay City', 'Lehigh Acres', '1982-02-02', 'Single', 'Contract-PT', 1, 'Business Analyst', 'Operations', 'Grade-2', '15938'),
('37873', 'Ferne', 'Costello', '100226955715', 'P.O. Box 892', '91th FL', 'Pavilion', 'Mosca', '1949-04-08', 'Married', 'Contract-FT', 1, 'Chief Financial Officer', 'Human Resources', 'Grade-2', '49673'),
('80270', 'Kent', 'Collado', '961642955v', 'PO Box 43', '60th FL', 'Whitmore Lake', 'Lehigh Valley', '1972-03-04', 'Married', 'Freelance', 1, 'Communication Manager', 'Manufacturing', 'Grade-4', '52663'),
('87829', 'Kizzy', 'Tyree', '912842586220', 'PO Box 49', '9th FL', 'Jamesville', 'Trumbull', '1987-11-30', 'Married', 'Permanent-FT', 0, 'Technical Editor', 'Research and Development', 'Grade-4', '11427'),
('03179', 'Alanna', 'Russo', '615015491v', 'PO Box 288', '7th FL', 'Mannford', 'Oakhurst', '1949-02-27', 'Married', 'Permanent-FT', 1, 'Sales Agent', 'Facilities', 'Grade-1', '27381'),
('99830', 'Reatha', 'Maurer', '476509382085', 'PO Box 75', '94th Floor', 'Jamison', 'Eastport', '1957-06-15', 'Single', 'Freelance', 1, 'Solution Engineer', 'Manufacturing', 'Grade-4', '91853'),
('73086', 'Theron', 'Kendall', '490005154919', 'P.O. Box 528', '2nd FL', 'Suncook', 'Arlee', '1949-02-23', 'Single', 'Permanent-PT', 1, 'Sales Consultant', 'Information Technology', 'Grade-4', '99830'),
('57980', 'Jodee', 'Mauro', '247214899v', 'P.O. Box 2359', '9th FL', 'Whitney', 'Greenbush', '1950-01-18', 'Single', 'Trainee', 1, 'Director of Finance', 'Customer Support', 'Grade-2', '53178'),
('12641', 'Raven', 'Owens', '190319162v', 'PO Box 3', '52th FL', 'San Juan Bautista', 'Eastsound', '1949-09-01', 'Single', 'Permanent-PT', 1, 'Commercial Manager', 'Facilities', 'Grade-1', '27438'),
('97695', 'Ronda', 'Rust', '609218512v', 'PO Box 23', '4th Floor', 'Cuero', 'Selinsgrove', '1987-02-19', 'Single', 'Contract-PT', 0, 'Human Resources Representative', 'Marketing', 'Grade-3', '52663'),
('12554', 'Cody', 'Shackelford', '221138971553', 'PO Box 180', '48th FL', 'Pavillion', 'Cape Coral', '1998-01-16', 'Married', 'Permanent-PT', 1, 'QA Manager', 'Operations', 'Grade-1', '15938'),
('65154', 'Alex', 'Fincher', '183782620v', 'PO Box 713', '54th FL', 'Berne', 'Reform', '1983-11-28', 'Married', 'Contract-FT', 1, 'Technical Writer', 'Consulting', 'Grade-2', '48851'),
('19450', 'Jamel', 'Tyson', '969715350v', 'P.O. Box 3656', '4th FL', 'Manning', 'Trumbull County', '1954-07-23', 'Divorced', 'Contract-FT', 1, 'Contract Advisor', 'Consulting', 'Grade-1', '75243'),
('83937', 'Alfonzo', 'Bolden', '208931051v', 'P.O. Box 67', '4th FL', 'Claymont', 'Moses Lake', '1993-10-31', 'Married', 'Trainee', 1, 'Chief Technology Officer', 'Customer Support', 'Grade-4', '19450');

--
-- Inserting data into table dependent
--
INSERT INTO dependent(nic, employee_id, first_name, last_name, relationship, addr_house_no, addr_line_1, addr_line_2, addr_city, contact_no, email) VALUES
('165688918278', '12554', 'Abraham', 'Mckee', 'daughter', '61407', '6th Floor', 'Margate', 'Kinsley', '0806175530', 'AbrahamAcevedo@example.com'),
('930498944v', '67589', 'Reinaldo', 'Eubanks', 'son', '68850', '5th FL', 'Ystrad Meurig', 'Mena', '0443196961', 'Jude_High169@example.com'),
('912055105223', '52663', 'Elijah', 'Hand', 'son', '29568', '6th FL', 'Buckingham', 'Clyde', '0444670349', 'Bauer@example.com'),
('578434389613', '27381', 'Tanner', 'Abney', 'other', '69679', '64th FL', 'Ballymoney', 'Zuni', '0470523426', 'Alarcon@example.com'),
('224866526v', '65934', 'Jewel', 'Evans', 'mother', '05878', '6th Floor', 'Buckley', 'Ferrum', '0488319438', 'gndd9978@example.com'),
('583016361v', '83937', 'Alfonso', 'Bowens', 'mother', '79736', '7th Floor', 'Wedmore', 'Kinsman', '0058534473', 'Palmer_Lofton@example.com'),
('687443188498', '12641', 'Jason', 'Stanley', 'daughter', '04644', '79th FL', 'Shipley', 'Menahga', '0113695257', 'Abernathy@example.com'),
('601259949v', '65154', 'Rico', 'Handley', 'mother', '38626', '79th Floor', 'Ballynahinch', 'Bigfork', '0520879879', 'Adaline_Abbott@example.com'),
('315281793v', '97695', 'Yasmine', 'Everett', 'mother', '56582', '4th FL', 'Stoke-sub-Hamdon', 'Westland', '0133242615', 'Shayne_Britton589@example.com'),
('310747444714', '11796', 'Darcey', 'Lowry', 'other', '58410', '64th Floor', 'Kington', 'Clymer', '0770936040', 'mxwygtmf_ahjpwboxdy@example.com'),
('933579084v', '48685', 'Rodney', 'Wicks', 'son', '45926', '6th Floor', 'Pencader', 'Kinston', '0329149249', 'Steve.A.Pape@nowhere.com'),
('430747496v', '73979', 'Latoya', 'Abraham', 'son', '91577', '7th FL', 'Ellesmere', 'Menard', '0818979421', 'Ivan.Southern98@example.com'),
('837560210956', '99830', 'Jesus', 'Pelletier', 'daughter', '94604', '96th FL', 'Marianglas', 'Biggs', '0122742126', 'Darell_Centeno27@example.com'),
('518390448440', '48708', 'Olimpia', 'Bower', 'other', '65033', '61th FL', 'Cleadon', 'Richgrove', '0679286411', 'Shanta.Beaver89@nowhere.com'),
('466248744v', '49673', 'Aurelia', 'Hutcheson', 'mother', '81524', '74th Floor', 'Kingussie', 'Coachella', '0898640240', 'GregoryMurrell@example.com'),
('043167250569', '19450', 'Freeman', 'Stanton', 'mother', '73683', '5th Floor', 'Bucknall', 'Highgate Center', '0265666363', 'rfgxqoso9811@example.com'),
('545915210v', '78096', 'Brent', 'Handy', 'daughter', '79788', '9th Floor', 'Market Drayton', 'Kinta', '0846140004', 'Violette_Maxey368@example.com'),
('757092411460', '61469', 'Anglea', 'Everhart', 'daughter', '11888', '42th Floor', 'Bamburgh', 'Menasha', '0758644647', 'Sanderson@example.com'),
('321963833v', '73086', 'Desirae', 'Abrams', 'other', '22491', '7th FL', 'Kinlochleven', 'Okahumpka', '0024118542', 'Dennis@example.com'),
('871118274751', '22638', 'Cleo', 'Bowers', 'son', '93779', '62th FL', 'Shipston-on-Stour', 'Ferrysburg', '0967184483', 'Shifflett@example.com'),
('751687363v', '23539', 'Clint', 'Abreu', 'mother', '59445', '41th FL', 'Wednesbury', 'Kintnersville', '0903450954', 'Abbie.Watts@example.com'),
('450817360v', '37873', 'Patience', 'Wiese', 'other', '78567', '5th Floor', 'Harlow', 'Mendenhall', '0618350147', 'AlessandraNMckenzie72@example.com'),
('992212558v', '60676', 'Agustin', 'Loy', 'son', '15252', '7th FL', 'Stoke Newington', 'Richland', '0555405341', 'mivxztrm_txjxxsw@example.com'),
('233424239v', '95191', 'Josh', 'Hutchings', 'son', '84759', '9th FL', 'Bude', 'Okanogan', '0882279314', 'Killian@nowhere.com'),
('993997484053', '15938', 'Ada', 'Staples', 'son', '28252', '93th Floor', 'Banbridge', 'Stringtown', '0662487448', 'Maness@nowhere.com'),
('126196225v', '25316', 'Margherita', 'Wiggins', 'other', '78811', '8th Floor', 'Budleigh Salterton', 'Highland', '0665329443', 'KimberlieCrocker@nowhere.com'),
('081967643534', '49252', 'Carlita', 'Mckeever', 'daughter', '08208', '4th Floor', 'Penicuik', 'Kinzers', '0213324274', 'oxdngcmz8118@example.com'),
('915365279v', '09929', 'Adolph', 'Peltier', 'son', '26041', '9th FL', 'Banbury', 'Mendham', '0092076979', 'Tiffanie.Romero27@nowhere.com'),
('921269680v', '74078', 'Britt', 'Mckenna', 'daughter', '06419', '9th FL', 'Shoreham-by-Sea', 'Fertile', '0842809051', 'Gable@example.com'),
('198062257890', '91427', 'Blair', 'Stapleton', 'daughter', '47753', '7th FL', 'Welling', 'Biggsville', '0958096443', 'Myrtle_Bernard@example.com'),
('353173549052', '57980', 'Fritz', 'Wilbanks', 'son', '77180', '50th FL', 'Stone', 'Highland Falls', '0435340921', 'Raynor8@example.com'),
('427887987v', '11427', 'Maddie', 'Pemberton', 'mother', '32716', '4th FL', 'Kinross', 'Westley', '0956668959', 'Sipes449@example.com'),
('701292229v', '49031', 'Adrianne', 'Loyd', 'other', '78119', '96th FL', 'Penmaenmawr', 'Coal Center', '0897410903', 'Batson@example.com'),
('516973559v', '80270', 'Mittie', 'Hutchins', 'daughter', '88425', '6th Floor', 'Builth Wells', 'Richland Center', '0923083970', 'ReaReyna391@nowhere.com'),
('098974109v', '91853', 'Ellis', 'Starkey', 'mother', '99120', '9th Floor', 'Shotts', 'Bigler', '0224866526', 'SeeleyJ@example.com'),
('004069830712', '39782', 'Roland', 'Wilbur', 'other', '66063', '75th Floor', 'Ellesmere Port', 'Kiowa', '0684168736', 'AbbieAbel@example.com'),
('903450954236', '51365', 'Samuel', 'Starks', 'father', '28231', '84th Floor', 'Banchory', 'Strong', '0900184657', 'Monty.Swan5@nowhere.com'),
('004194855154', '75243', 'Arthur', 'Hanes', 'daughter', '92216', '8th Floor', 'Harpenden', 'Mendocino', '0075211292', 'SteinerK@example.com'),
('463011450082', '96821', 'Rebecka', 'Mckenney', 'mother', '61584', '4th FL', 'Penrhyndeudraeth', 'Fessenden', '0040737879', 'Daily37@example.com'),
('650229927226', '48851', 'Selena', 'Pena', 'father', '85777', '41th Floor', 'Bungay', 'Westminster', '0171424510', 'AddieTrice329@example.com'),
('195130827v', '87829', 'Albertina', 'Wilburn', 'son', '02871', '69th Floor', 'Wellingborough', 'Coal City', '0726476219', 'Caballero313@example.com'),
('781370829v', '92568', 'Kelley', 'Evers', 'father', '34808', '7th FL', 'Cleator', 'Kirbyville', '0297229927', 'uvrguf247@nowhere.com'),
('037264762v', '53178', 'Felicia', 'Haney', 'son', '16684', 'Nipper Building', 'Kirkby-in-Furness', 'Strong City', '0767813851', 'Jewel.Albers24@nowhere.com'),
('674294361v', '27438', 'Wally', 'Ewing', 'father', '32006', '95th Floor', 'Ellon', 'Okarche', '0106623449', 'Oliva_Caskey572@example.com'),
('813851167749', '18486', 'Oren', 'Starling', 'daughter', '57360', '7th Floor', 'Cleator Moor', 'Highland Mills', '0307800197', 'Nannie_Farr@nowhere.com'),
('751607055610', '03179', 'Dong', 'Hankins', 'mother', '54144', '4th FL', 'Banff', 'Biglerville', '0870924114', 'mcvgy02@example.com'),
('729086995v', '69351', 'Cristobal', 'Ezell', 'other', '71766', '9th Floor', 'Buntingford', 'Festus', '0938351633', 'Mcnamara616@example.com'),
('234958767v', '12831', 'Harley', 'Bowie', 'son', '73570', '97th FL', 'Eltham', 'Highland Park', '0603059784', 'AllenDupree@example.com'),
('389360407975', '98918', 'Cornell', 'Hanks', 'father', '76493', '7th Floor', 'Shrewsbury', 'Westminster Station', '0192634551', 'Rudolph_Abel@nowhere.com'),
('414273437357', '91981', 'Glenn', 'Wilcox', 'son', '43874', '9th FL', 'Cleckheaton', 'Stronghurst', '0216795751', 'Diehl764@nowhere.com');

--
-- Inserting data into table emergency_contact
--
INSERT INTO emergency_contact(nic, employee_id, name, contact_no) VALUES
('442003251825', '12554', 'Mclaurin', '0580787909'),
('951276957189', '67589', 'Kirk', '0022522451'),
('768100256v', '52663', 'Pepper', '0059547291'),
('642014134v', '27381', 'Mclean', '0070767940'),
('767183724266', '65934', 'Mcclelland', '0799409825'),
('184598085v', '83937', 'Perales', '0165069258'),
('419244516590', '12641', 'Mclemore', '0430372933'),
('838149415586', '65154', 'Bronson', '0143734662'),
('331039992v', '97695', 'Kirkland', '0787706837'),
('615243899593', '11796', 'Valle', '0067034699'),
('442690459v', '48685', 'Peralta', '0102527476'),
('474873108v', '73979', 'Shelley', '0586495832'),
('153856628v', '99830', 'Vallejo', '0511003845'),
('328877675671', '48708', 'Mclendon', '0081226513'),
('324117214v', '49673', 'Mcclendon', '0967501035'),
('349689707v', '19450', 'Perdue', '0644531868'),
('270950423v', '78096', 'Gracia', '0459587490'),
('708288140693', '61469', 'Dugger', '0766408150'),
('709949678v', '73086', 'Mcleod', '0709504234'),
('492982753641', '22638', 'Grady', '0084074512'),
('717381703v', '23539', 'Duke', '0043456959'),
('426483541885', '37873', 'Graf', '0385326373'),
('477511003v', '60676', 'Shelton', '0002562140'),
('995658307509', '95191', 'Pereira', '0581925030'),
('069258762709', '15938', 'Mcmahan', '0871721454'),
('602856870405', '25316', 'Kirkpatrick', '0070827536'),
('957645651762', '49252', 'Valles', '0139974984'),
('236753403057', '09929', 'Perez', '0241844969'),
('136137355v', '74078', 'Mcmahon', '0594054433'),
('863219850000', '91427', 'Perkins', '0947645651'),
('905686406918', '57980', 'Shepard', '0078677745'),
('194143734662', '11427', 'Ambrose', '0615858074'),
('381280064526', '49031', 'Mcmanus', '0810209234'),
('327387365115', '80270', 'Mcclintock', '0586829356'),
('580740382v', '91853', 'Van', '0404699251'),
('617227789000', '39782', 'Kirkwood', '0617381703'),
('549843739v', '51365', 'Shephard', '0508841186'),
('750103587v', '75243', 'Brooks', '0305753812'),
('117077059574', '96821', 'Vanburen', '0414576220'),
('083844850v', '48851', 'Shepherd', '0788169493'),
('055569615v', '87829', 'Mccloskey', '0964144424'),
('894925868v', '92568', 'Kiser', '0710297208'),
('579986158v', '53178', 'Vance', '0974371061'),
('387706837v', '27438', 'Ames', '0167647164'),
('212628756v', '18486', 'Perreault', '0347542651'),
('514706558736', '03179', 'Mccloud', '0288140693'),
('487449837v', '69351', 'Dukes', '0578409264'),
('425421261207', '12831', 'Mcmaster', '0582148579'),
('899971821v', '98918', 'Sheppard', '0300368826'),
('323831270622', '91981', 'Perrin', '0556961507');

--
-- Inserting data into table employee_contact_no
--
INSERT INTO employee_contact_no(employee_id, contact_no) VALUES
('12554', '0928461241'),
('67589', '0926354476'),
('52663', '0412702664'),
('27381', '0545755371'),
('65934', '0527221778'),
('83937', '0680830021'),
('12641', '0263019517'),
('65154', '0947828148'),
('97695', '0421538791'),
('11796', '0420892912'),
('48685', '0977521719'),
('73979', '0193038327'),
('99830', '0359381772'),
('48708', '0362334161'),
('49673', '0911598312'),
('19450', '0253161339'),
('78096', '0777719958'),
('61469', '0519929452'),
('73086', '0697408422'),
('22638', '0158899567'),
('23539', '0170934015'),
('37873', '0170206081'),
('60676', '0816750813'),
('95191', '0120221155'),
('15938', '0459668013'),
('25316', '0869083368'),
('49252', '0173184366'),
('09929', '0162731579'),
('74078', '0071181319'),
('91427', '0322402463'),
('57980', '0419558861'),
('11427', '0104082334'),
('49031', '0829710577'),
('80270', '0876683082'),
('91853', '0799258456'),
('39782', '0361010898'),
('51365', '0509822077'),
('75243', '0865015179'),
('96821', '0246425785'),
('48851', '0008863920'),
('87829', '0596067381'),
('92568', '0602170032'),
('53178', '0922399441'),
('27438', '0462322395'),
('18486', '0229672464'),
('03179', '0272485069'),
('69351', '0520812404'),
('12831', '0096765387'),
('98918', '0816087596'),
('91981', '0896015727');

--
-- Inserting data into table employee_custom_attributes
--
INSERT INTO employee_custom_attributes(employee_id, attribute, value) VALUES
('94731', 'uSBODmESdxaiAvBEglTn', 'gdVmalzPhNFSZGHCdXXYqohijeMZvUkeAjAzBEZCLUcyXNSwhK'),
('03175', 'jqoVUxaIxDMQpQQguRjTShnYnBusvdcueLGUyQkczdGVyGnNOP', 'xOECXnYMcb'),
('99642', 'sXUiWDNrADCmOjEljJWznBUDpa', 'mKjnyxjSyraxpbUNIaYXUQ'),
('88655', 'RnoGQjexHlqO', 'rkwWUjpw'),
('33671', 'tZLKoXhVRIFPqc', 'MHZVoLofYoxN'),
('22085', 'fQwJUXGNsgxbRnkN', 'ucruY'),
('67173', 'PEXsBBAR', 'v'),
('80927', 'OEUgoefQisqayiSGrePppZNBEkMtpSpwFaRR', 'CsnUjTWhK'),
('27349', 'ytA', 'UaH'),
('26403', 'FvOGIFcIdTt', 'LRcyPiICRydqnkB'),
('08389', 'RU', 'Qgl'),
('67161', 'txtQP', 'NcVLWSVeYmjL'),
('35911', 'ugDyKUAoGbZAAAYZ', 'aWUVGY'),
('99863', 'syTnbYruGvxgeHSQ', 'YxMcCzymPGqasPpXinChODrccUsyejCgRUR'),
('54585', 'ADih', 'N'),
('94047', 'ccrBw', 'jmzhbfbAQRLtdfTHUSrUXornddftQsibcCFXTXjBgvnMRQOpkP'),
('93954', 'PcLWjdQvuGLM', 'PiXYpqspWjjECto'),
('75489', 'UvFkclTVnufoUf', 'ALMYtrKeQnm'),
('61988', 'JnaImCtMIo', 'cKWt'),
('68576', 'WfLLljqNlM', 'OvraR'),
('11083', 'qeaxGPehSZRmdlGhlSgLIkQctYFhaXaMDtwKfOztdhHCsIbZFC', 'NtHQz'),
('44894', 'cVbHAHfmskzqsykakhaVOZXpPxTpyPEFMBpZlGWof', 'LHzML'),
('11004', 'pXQIFS', 'arOINDFdY'),
('19536', 'wRQAjtGGcmZdEVXrzHhd', 'UQgk'),
('41899', 'siFQeOBTLiPQDtrR', 'KaSAUjiunO'),
('72124', 'PQgsx', 'JFDVJbokJAsemvosEVdxOqQyZAICFQglDOyvPoXClbdVNvIjaB'),
('16342', 'sZPBTuqSqLYxSkTnbZsOQ', 'vnsEltAaOAVBCQvfiwzdnGjzyY'),
('43610', 'uzAnNgFSDMcliuMMmXaAixY', 'DDNyvKBcLOTBuvRXSCoaEjUdmDPpFhrGyAhdCVNL'),
('21450', 'qBvpsZmNIcxtA', 'PWSaoGCdVtYvxTAHbXMJcErYLSZVZbKnqZpYIfylTfgkDuhXq'),
('58886', 'RJmfUzGXoA', 'oOHZ'),
('42944', 'VVjytCTYHJxQJMAaoj', 'dMSsyRpdNrJmLRPzoCWJ'),
('57878', 'dMYx', 'FdPNTjJcOBwefXXaCDmXHKeXFhAXhA'),
('39848', 'iCyGkUXPdcrGkucwDdFXVmukypCeayxSXekMe', 'bbqBzlBIfIFiKJNyQ'),
('50797', 'OjLncJEGHkXMd', 'iLkjvOKkvajQSkjjl'),
('65701', 'EISZMQZZMKQvUmsA', 'aeWlcsAQHfI'),
('30344', 'vNIvEDSnJUMjc', 'KPsUeoPcsLMIpPaJVIyIaPKVbq'),
('30664', 'ZWPAYwYDhnVDSNYWAmK', 'M'),
('61144', 'XFmdSwqEvUQjvfppFQBHmkjQiYvYYUQcVMkQE', 'kEzFp'),
('27992', 'GAaSWYkwu', 'dB'),
('64683', 'cunZYklDh', 'KB'),
('85726', 'anRDy', 'LhzkBppZLh'),
('99833', 'i', 'WqA'),
('35040', 'DAScJrAw', 'hnCbDqULPdhslyAtxOE'),
('75249', 'eDdl', 'BZvGkPPQiqLeLmWAznTGjvhkFRYtTTBJWHLrNeqFlcqknKIkk'),
('00392', 'GG', 'm'),
('79877', 'EOHVBmiOuDTjZkLbvjCHgBcAsBlZIMXBBVUislzgShjVfNSqlM', 'buJMVcCHqKaTYapgsOgYxenYjdZKZlTadEZDkvqWumsMoFsQCa'),
('32865', 'lULgACABvKTfBHucSpsTXc', 'kvJTtdhsbHNTRaNciSkhKFDOzrmszkAjbux'),
('41578', 'qHQ', 'AviFYLFpCvIdUcuDUcqhksCOyjurRFEPyUoiJVRw'),
('66974', 'MqXQXcYKCEZIyJeWwPrhccJmNPYgJp', 'aXFQfNepjRvRnhuln'),
('59510', 't', 'nEDDlwmJCJMHbaYyfmSevSwrrhNntfImopDoxWUTTJfGhnMHWE');

--
-- Inserting data into table employee_email
--
INSERT INTO employee_email(employee_id, email) VALUES
('12554', 'Natasha.IHomer@example.com'),
('67589', 'tllnvs9090@example.com'),
('52663', 'Elrod67@nowhere.com'),
('27381', 'Varney@nowhere.com'),
('65934', 'rouqq3066@nowhere.com'),
('83937', 'HathawayC825@nowhere.com'),
('12641', 'Theodora.Stock@example.com'),
('65154', 'Compton@example.com'),
('97695', 'Hilary.U_Andrus@nowhere.com'),
('11796', 'BobetteBain@example.com'),
('48685', 'Pennington494@example.com'),
('73979', 'Adena.Flynn8@example.com'),
('99830', 'DelmySchuler94@example.com'),
('48708', 'KenethGee@example.com'),
('49673', 'Lombardo@example.com'),
('19450', 'BereniceAbbott@example.com'),
('78096', 'Newton_Martins@example.com'),
('61469', 'Carey@nowhere.com'),
('73086', 'RudolphDejesus593@nowhere.com'),
('22638', 'Ezequiel.Cummings@example.com'),
('23539', 'BrunoAltman94@nowhere.com'),
('37873', 'LouisGross396@example.com'),
('60676', 'Lennon96@example.com'),
('95191', 'bidysns0@example.com'),
('15938', 'AllanOconner@example.com'),
('25316', 'Adalberto.Fox41@example.com'),
('49252', 'Criswell@nowhere.com'),
('09929', 'HolderV@nowhere.com'),
('74078', 'MilfordWBarbosa1@nowhere.com'),
('91427', 'Lewandowski79@example.com'),
('57980', 'BeckyK_Gaddis@example.com'),
('11427', 'ntsrxqve_lbqpg@example.com'),
('49031', 'JeannieAbney@nowhere.com'),
('80270', 'Gagne@example.com'),
('91853', 'IleneBynum@example.com'),
('39782', 'AgnusAli@nowhere.com'),
('51365', 'Valentin@example.com'),
('75243', 'Woodbury@example.com'),
('96821', 'Willett6@nowhere.com'),
('48851', 'Cornell255@example.com'),
('87829', 'Bourne1@example.com'),
('92568', 'Abernathy@nowhere.com'),
('53178', 'Shannon@nowhere.com'),
('27438', 'Whitehead356@example.com'),
('18486', 'ShizueCambell85@example.com'),
('03179', 'WilburnDiehl75@nowhere.com'),
('69351', 'Clair_Dorsey@example.com'),
('12831', 'Tempie_Means@nowhere.com'),
('98918', 'HurdE@example.com'),
('91981', 'Abbie_Kroll762@example.com');

--
-- Inserting data into table `leave`
--
INSERT INTO `leave`(employee_id, date, leave_type, reason, state) VALUES
('95191', '2018-01-01', 'Casual', 'Ipsum iste non. Velit voluptatem;', 'rejected'),
('12554', '2018-01-02', 'Casual', 'Voluptates cupiditate laborum.', 'approved'),
('39782', '2018-01-03', 'No-Pay', 'Tenetur eos minus. Sit incidunt est.', 'rejected'),
('91427', '2018-01-04', 'Sick', 'Dolor non sunt. Cum facere nulla! Et...', 'rejected'),
('92568', '2018-01-05', 'Sick', 'Ut hic labore. Eos rem rerum! In.', 'approved'),
('99830', '2018-01-06', 'No-Pay', 'Suscipit tempora eius. Omnis qui quam.', 'pending'),
('53178', '2018-01-07', 'Annual', 'Modi quibusdam veritatis. Repellendus.', 'rejected'),
('12641', '2018-01-08', 'No-Pay', 'Ducimus qui minima. Aliquid numquam.', 'approved'),
('83937', '2018-01-09', 'Sick', 'Est velit animi. Consectetur.', 'rejected'),
('61469', '2018-01-10', 'Sick', 'Doloremque tenetur tempore; veniam est.', 'rejected'),
('73086', '2018-01-11', 'Sick', 'Sit inventore error. Dolores et odio?', 'rejected'),
('65154', '2018-01-12', 'Annual', 'Officiis rerum nostrum. Laudantium!', 'pending'),
('97695', '2018-01-13', 'Casual', 'Similique doloremque natus; asperiores?', 'approved'),
('98918', '2018-01-14', 'Casual', 'Ullam aspernatur voluptates; omnis.', 'pending'),
('19450', '2018-01-15', 'No-Pay', 'Alias magni autem laboriosam.', 'pending'),
('91981', '2018-01-16', 'Sick', 'Accusamus repellendus aliquid. Eveniet!', 'pending'),
('67589', '2018-01-17', 'Sick', 'Beatae sit minus qui.', 'pending'),
('27381', '2018-01-18', 'Sick', 'Neque expedita suscipit. Possimus.', 'rejected'),
('37873', '2018-01-19', 'Casual', 'Quia maiores perspiciatis.', 'rejected'),
('60676', '2018-01-20', 'No-Pay', 'Perspiciatis labore dolore. Deleniti?', 'approved'),
('57980', '2018-01-21', 'No-Pay', 'Quo eos natus. Harum sunt provident.', 'rejected'),
('65934', '2018-01-22', 'Annual', 'Aut tempora qui. Esse ut optio; nihil.', 'approved'),
('15938', '2018-01-23', 'Annual', 'Voluptatem aliquam dolore. Voluptatem.', 'rejected'),
('51365', '2018-01-24', 'Annual', 'Quisquam quo soluta. Eveniet a nemo.', 'rejected'),
('80270', '2018-01-25', 'No-Pay', 'Omnis sed sint; sint magni animi.', 'rejected'),
('11796', '2018-01-26', 'Sick', 'Enim iste et; nisi non ducimus.', 'pending'),
('48851', '2018-01-27', 'Annual', 'Consequatur sit amet. Dolorem.', 'pending'),
('25316', '2018-01-28', 'Casual', 'Iste ipsa vitae. Ipsa obcaecati quas.', 'approved'),
('75243', '2018-01-29', 'No-Pay', 'Culpa ut explicabo non omnis error.', 'rejected'),
('87829', '2018-01-30', 'Annual', 'In magni distinctio. Et architecto!', 'approved'),
('23539', '2018-01-31', 'Annual', 'Autem non autem. Corporis qui natus.', 'rejected'),
('18486', '2018-02-01', 'Sick', 'Error fuga aspernatur. Perspiciatis!', 'rejected'),
('03179', '2018-02-02', 'Annual', 'Eum autem amet. Dolor illum ratione.', 'rejected'),
('52663', '2018-02-03', 'Sick', 'Et sunt nostrum; ducimus quae ut.', 'rejected'),
('69351', '2018-02-04', 'No-Pay', 'Aut qui deserunt. Veniam natus nemo?', 'rejected'),
('49252', '2018-02-05', 'Sick', 'Quis blanditiis quia; eveniet voluptas.', 'approved'),
('09929', '2018-02-06', 'Annual', 'Suscipit sed quidem. Ullam accusantium.', 'pending'),
('48685', '2018-02-07', 'Annual', 'Error aut saepe.', 'pending'),
('74078', '2018-02-08', 'No-Pay', 'Cum fugit id. Hic ex vel! Quis ad quod.', 'pending'),
('49031', '2018-02-09', 'Casual', 'Rerum amet ut. Quod eligendi quibusdam.', 'pending'),
('91853', '2018-02-10', 'Annual', 'Aut magnam voluptate. Ut et aliquid.', 'pending'),
('11427', '2018-02-11', 'No-Pay', 'Recusandae incidunt amet. Ipsa quo.', 'rejected'),
('96821', '2018-02-12', 'No-Pay', 'Dolorum et corporis. Autem et quis!', 'pending'),
('73979', '2018-02-13', 'Sick', 'Eius rerum recusandae. Omnis.', 'pending'),
('48708', '2018-02-14', 'Annual', 'Omnis sit dolores. Sit nobis aut!', 'rejected'),
('49673', '2018-02-15', 'Casual', 'Dolor sit porro. Ducimus unde quo?', 'rejected'),
('27438', '2018-02-16', 'Annual', 'Consequatur quia aut. Voluptatem illo?', 'rejected'),
('78096', '2018-02-17', 'Sick', 'Natus nesciunt consequatur. Ullam?', 'pending'),
('22638', '2018-02-18', 'No-Pay', 'Laudantium vel exercitationem. Ex.', 'approved'),
('12831', '2018-02-19', 'Casual', 'Saepe deserunt neque. Est beatae!', 'pending');

--
-- Inserting data into table pay_grade_leave
--
INSERT INTO pay_grade_leave(pay_grade, leave_type, `limit`) VALUES
('Grade-4', 'Sick', 56),
('Grade-3', 'No-Pay', 72),
('Grade-3', 'Casual', 86),
('Grade-4', 'Casual', 80),
('Grade-1', 'Sick', 85),
('Grade-4', 'No-Pay', 99),
('Grade-4', 'Annual', 86),
('Grade-2', 'Annual', 76),
('Grade-2', 'Sick', 41),
('Grade-1', 'Annual', 60),
('Grade-3', 'Annual', 16),
('Grade-3', 'Sick', 43),
('Grade-2', 'Casual', 57),
('Grade-1', 'Casual', 11),
('Grade-2', 'No-Pay', 58),
('Grade-1', 'No-Pay', 12);
COMMIT;