InsertScript.sql

-- smazání všech záznamů z tabulek

CREATE or replace FUNCTION clean_tables() RETURNS void AS $$
declare
l_stmt text;
begin
select 'truncate ' || string_agg(format('%I.%I', schemaname, tablename) , ',')
into l_stmt
from pg_tables
where schemaname in ('public');

execute l_stmt || ' cascade';
end;
$$ LANGUAGE plpgsql;
select clean_tables();

-- reset sekvenci

CREATE or replace FUNCTION restart_sequences() RETURNS void AS $$
DECLARE
i TEXT;
BEGIN
FOR i IN (SELECT column_default FROM information_schema.columns WHERE column_default SIMILAR TO 'nextval%')
  LOOP
         EXECUTE 'ALTER SEQUENCE'||' ' || substring(substring(i from '''[a-z_]*')from '[a-z_]+') || ' '||' RESTART 1;';
END LOOP;
END $$ LANGUAGE plpgsql;
select restart_sequences();
-- konec resetu

insert into payment (id_payment_type, payment_type, printed_invoice) values (default, 'Bank transfer', true);
insert into payment (id_payment_type, payment_type, printed_invoice) values (default, 'Bank transfer', false);
insert into payment (id_payment_type, payment_type, printed_invoice) values (default, 'Card', true);
insert into payment (id_payment_type, payment_type, printed_invoice) values (default, 'Card', false);
insert into payment (id_payment_type, payment_type, printed_invoice) values (default, 'Cash', true);
insert into payment (id_payment_type, payment_type, printed_invoice) values (default, 'Cash', false);
select setval(pg_get_serial_sequence('payment', 'id_payment_type'), 6);

insert into breakdown (id_breakdown, breakdown_type) values (default, 'Cracked screen');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Battery failure');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Broken touchscreen');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Ingress of moisture');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Sim card problem');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Broken speaker');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Broken camera');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Broken button');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Broken body');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Overheating');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Software failure');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Charging port failure');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'WI-FI module failure');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Gyroscope module failure');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Broken microphone');
insert into breakdown (id_breakdown, breakdown_type) values (default, 'Bluetooth module failure');
select setval(pg_get_serial_sequence('breakdown', 'id_breakdown'), 16);

insert into city (id_city, city_name) values (default, 'London');
insert into city (id_city, city_name) values (default, 'Birmingham');
insert into city (id_city, city_name) values (default, 'Leeds');
insert into city (id_city, city_name) values (default, 'Glasgow');
insert into city (id_city, city_name) values (default, 'Liverpool');
select setval(pg_get_serial_sequence('city', 'id_city'), 5);

insert into address (id_address, id_city, building_number, street, district, postal_code) values (1, 1, 1704, 'Dayton', 'England', 'BD23');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (2, 2, 1161, 'Sullivan', 'England', 'BS37');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (3, 3, 145, 'Southridge', 'England', 'DN36');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (4, 4, 793, 'Eggendart', 'England', 'NN4');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (5, 5, 770, 'Mariners Cove', 'England', 'LS9');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (6, 1, 1571, 'Blue Bill Park', 'England', 'LN6');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (7, 1, 494, 'Russell', 'England', 'OX12');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (8, 1, 892, 'Heath', 'England', 'NG34');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (9, 1, 1360, 'Center', 'England', 'LS9');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (10, 1, 80, 'Steensland', 'England', 'DN36');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (11, 2, 1665, 'Wayridge', 'England', 'DL10');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (12, 2, 462, 'Village', 'England', 'S1');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (13, 2, 268, 'Veith', 'England', 'DN22');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (14, 3, 549, 'Tomscot', 'England', 'M34');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (15, 3, 1514, 'Texas', 'England', 'DN36');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (16, 3, 1286, 'Swallow', 'England', 'S33');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (17, 4, 784, 'Springview', 'England', 'LE14');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (18, 4, 1296, 'Elka', 'England', 'WF9');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (19, 4, 1001, 'Kennedy', 'England', 'CH48');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (20, 5, 1235, 'Mallory', 'England', 'DL10');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (21, 5, 835, 'Sachtjen', 'England', 'W1F');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (22, 5, 181, 'Fuller', 'England', 'LS9');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (23, 1, 191, 'Mccormick', 'England', 'RG20');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (24, 1, 1459, 'Surrey', 'England', 'S33');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (25, 2, 33, 'Talisman', 'England', 'DN36');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (26, 2, 615, 'Granby', 'England', 'SN1');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (27, 3, 1507, 'Esker', 'England', 'DT10');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (28, 3, 1595, 'Maple', 'England', 'S8');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (29, 4, 1739, 'Warrior', 'England', 'BD7');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (30, 5, 729, 'Declaration', 'England', 'NE46');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (31, 5, 876, 'Granby', 'England', 'S1');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (32, 5, 65, 'Eagle Crest', 'England', 'LS6');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (33, 5, 318, 'Muir', 'England', 'BD7');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (34, 1, 804, 'Meadow Vale', 'England', 'L33');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (35, 2, 805, 'Summer Ridge', 'England', 'SN13');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (36, 2, 980, 'Pepper Wood', 'England', 'WC1B');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (37, 3, 1445, 'Mockingbird', 'England', 'LE14');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (38, 4, 135, 'Trailsway', 'England', 'SW1E');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (39, 4, 668, 'Columbus', 'England', 'LN6');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (40, 5, 239, 'Cherokee', 'England', 'NR34');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (41, 1, 589, 'Pond', 'England', 'L74');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (42, 2, 1047, 'Fordem', 'England', 'LN6');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (43, 3, 1893, 'Londonderry', 'England', 'BS37');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (44, 3, 1228, 'Evergreen', 'England', 'BH21');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (45, 4, 520, 'Forest', 'England', 'M34');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (46, 4, 1426, '8th', 'England', 'CT16');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (47, 4, 1167, 'Cordelia', 'England', 'EC3M');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (48, 5, 31, 'Lerdahl', 'England', 'LN6');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (49, 1, 478, 'Granby', 'England', 'CV35');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (50, 1, 1241, 'Beilfuss', 'England', 'SW19');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (51, 1, 1370, 'Hagan', 'England', 'SW1E');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (52, 2, 487, 'Almo', 'England', 'CT16');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (53, 2, 349, 'Pine View', 'England', 'BS41');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (54, 2, 1193, 'Reinke', 'England', 'DL10');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (55, 2, 1119, 'Myrtle', 'England', 'ST20');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (56, 3, 1726, 'American Ash', 'England', 'LS9');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (57, 3, 1572, 'Warner', 'England', 'OX12');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (58, 4, 491, 'Pierstorff', 'England', 'B40');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (59, 4, 70, 'Village', 'England', 'B12');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (60, 1, 97, 'Ruskin', 'England', 'NG34');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (61, 1, 909, 'Memorial', 'England', 'BH21');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (62, 2, 754, 'Susan', 'England', 'GL54');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (63, 2, 1413, 'Killdeer', 'England', 'LS9');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (64, 2, 90, 'Raven', 'England', 'DL8');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (65, 2, 1327, 'Nova', 'England', 'B12');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (66, 2, 668, 'Logan', 'England', 'NN4');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (67, 2, 1763, 'Hauk', 'England', 'N3');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (68, 2, 1112, 'Canary', 'England', 'SG4');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (69, 2, 756, 'Kinsman', 'England', 'S33');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (70, 3, 1200, 'Arrowood', 'England', 'GL54');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (71, 1, 895, 'Michigan', 'England', 'LE15');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (72, 2, 814, 'Carberry', 'England', 'NG22');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (73, 2, 68, 'Washington', 'England', 'WF9');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (74, 3, 500, 'Derek', 'England', 'M14');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (75, 4, 465, 'Comanche', 'England', 'DT10');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (76, 5, 240, 'Towne', 'England', 'CV35');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (77, 5, 142, 'Ohio', 'England', 'LS9');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (78, 5, 97, 'Straubel', 'England', 'DN22');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (79, 5, 691, 'Paget', 'England', 'S1');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (80, 1, 457, 'Mayfield', 'England', 'BH21');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (81, 3, 1512, 'Luster', 'England', 'LE15');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (82, 2, 253, 'Sommers', 'England', 'TF6');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (83, 5, 1460, 'Monument', 'England', 'L74');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (84, 4, 931, 'New Castle', 'England', 'NN4');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (85, 3, 10, 'Waxwing', 'England', 'S8');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (86, 1, 1238, 'Farragut', 'England', 'WF9');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (87, 4, 203, 'Haas', 'England', 'DL8');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (88, 2, 550, 'Anhalt', 'England', 'DN36');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (89, 2, 1394, 'Clove', 'England', 'DL8');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (90, 3, 1811, 'Bobwhite', 'England', 'WC1B');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (91, 1, 1610, 'Harper', 'England', 'RH5');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (92, 4, 1151, 'Bowman', 'England', 'W1F');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (93, 5, 1121, 'Stang', 'England', 'EC1V');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (94, 1, 1911, 'Knutson', 'England', 'LE15');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (95, 2, 747, 'Blackbird', 'England', 'CV35');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (96, 2, 1801, 'Northland', 'England', 'EC3M');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (97, 4, 1166, 'Express', 'England', 'NR29');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (98, 1, 961, 'Autumn Leaf', 'England', 'NR34');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (99, 4, 1496, 'Debs', 'England', 'CT16');
insert into address (id_address, id_city, building_number, street, district, postal_code) values (100, 5, 1706, 'Browning', 'England', 'LE14');
select setval(pg_get_serial_sequence('address', 'id_address'), 100);

insert into branch (id_branch, id_address, spare_parts, building_year) values (default, 1, true, 2005);
insert into branch (id_branch, id_address, spare_parts, building_year) values (default, 2, true, 1985);
insert into branch (id_branch, id_address, spare_parts, building_year) values (default, 3, true, 2012);
insert into branch (id_branch, id_address, spare_parts, building_year) values (default, 4, true, 2000);
insert into branch (id_branch, id_address, spare_parts, building_year) values (default, 5, false, 2001);
insert into branch (id_branch, id_address, spare_parts, building_year) values (default, 6, true, 1996);
insert into branch (id_branch, id_address, spare_parts, building_year) values (default, 7, false, 1958);
select setval(pg_get_serial_sequence('branch', 'id_branch'), 7);

insert into person (id_person, id_address, first_name, last_name, phone, email) values (1, 82, 'Jakob', 'Giraudy', '2085150492', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (2, 73, 'Eolande', 'O-Fihillie', '7466017824', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (3, 29, 'Gwendolin', 'Cucinotta', '5079242579', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (4, 72, 'Philis', 'Keen', '8739784919', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (5, 44, 'Callida', 'Arthan', '7533441918', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (6, 93, 'Vicki', 'Goublier', '9642394940', 'vgoublier5@linkedin.com');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (7, 78, 'Blinny', 'Davids', '4782711055', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (8, 85, 'Carolus', 'Schelle', '3157466046', 'cschelle7@abc.net.au');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (9, 8, 'Celle', 'Longega', '4133992150', 'clongega8@irs.gov');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (10, 80, 'Agatha', 'Patinkin', '2797426311', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (11, 75, 'Crin', 'Pash', '3889804376', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (12, 31, 'Brodie', 'Wiltshier', '9987629135', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (13, 75, 'Gina', 'Mackness', '1246771734', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (14, 39, 'Land', 'Tynemouth', '7947553634', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (15, 56, 'Felicio', 'Tuckwell', '4089814758', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (16, 57, 'Vonny', 'Wicher', '4474021940', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (17, 56, 'Salmon', 'Stockin', '8951694120', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (18, 46, 'Bard', 'Petrasch', '1141335520', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (19, 85, 'Fairfax', 'Daye', '9212057478', 'fdayei@odnoklassniki.ru');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (20, 91, 'Isac', 'Lievesley', '1598428508', 'ilievesleyj@gravatar.com');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (21, 86, 'Bobette', 'Brigstock', '3567271712', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (22, 58, 'Alexandre', 'Brownrigg', '7892728328', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (23, 51, 'Calv', 'Pernell', '1409781444', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (24, 48, 'Christyna', 'Bitten', '5747072124', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (25, 39, 'Wendye', 'Haimes', '6213649978', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (26, 38, 'Joella', 'Telezhkin', '6203210945', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (27, 79, 'Karilynn', 'Mourgue', '4613396022', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (28, 69, 'Gil', 'Manby', '9276714521', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (29, 51, 'Evonne', 'Malitrott', '5747609046', 'emalitrotts@friendfeed.com');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (30, 57, 'Thayne', 'Truswell', '3624729233', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (31, 77, 'Berton', 'Horning', '3062564923', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (32, 50, 'Noach', 'Fitzsimmons', '2388463686', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (33, 52, 'Andras', 'Growy', '8751763355', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (34, 92, 'Danila', 'Braznell', '6631454133', 'dbraznellx@shop-pro.jp');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (35, 79, 'Maridel', 'Shoute', '2846310172', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (36, 23, 'Jeanne', 'Phethean', '9158666142', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (37, 78, 'Joleen', 'Stonier', '6709982480', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (38, 63, 'Winslow', 'Lalonde', '6946203087', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (39, 31, 'Verena', 'Barbery', '8771371364', 'vbarbery12@sphinn.com');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (40, 50, 'Archibold', 'Crigin', '6399360859', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (41, 73, 'Di', 'Drohane', '2983171872', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (42, 18, 'Wit', 'Dosedale', '2905784342', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (43, 88, 'Myrtle', 'Rosenwasser', '6751112416', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (44, 49, 'Millicent', 'Neenan', '6319900026', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (45, 88, 'Tadd', 'Klaff', '1687504192', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (46, 36, 'Henrik', 'Drysdell', '9717758121', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (47, 35, 'Marietta', 'Derye-Barrett', '6505268087', 'mderyebarrett1a@microsoft.com');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (48, 96, 'Saundra', 'Read', '2105129458', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (49, 63, 'Margareta', 'Lainton', '2844461306', 'mlainton1c@vistaprint.com');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (50, 26, 'Boycey', 'Stannion', '5399304459', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (51, 93, 'Stephanie', 'Vondrys', '1556296049', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (52, 66, 'Geordie', 'Falconar', '5037863239', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (53, 51, 'Marcel', 'Peyzer', '5909950504', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (54, 47, 'Hatty', 'Kleyn', '9762895781', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (55, 10, 'Louie', 'Amber', '5976672051', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (56, 53, 'Roseline', 'Methven', '9452434847', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (57, 80, 'Renae', 'Applegarth', '1548440711', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (58, 45, 'Parry', 'Else', '7233494783', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (59, 65, 'Bell', 'Dalton', '4789223114', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (60, 40, 'Khalil', 'Loche', '3426025211', 'kloche1n@craigslist.org');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (61, 27, 'Dorey', 'Lambrick', '7901997801', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (62, 19, 'Tani', 'Bukowski', '8374201706', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (63, 93, 'Jacqui', 'Ritelli', '2966412594', 'jritelli1q@flickr.com');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (64, 54, 'Currey', 'Parlatt', '8234226281', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (65, 69, 'Rayshell', 'Carletto', '6249986895', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (66, 64, 'Tomaso', 'Joysey', '4125429959', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (67, 8, 'Bessy', 'Battabee', '6894596106', 'bbattabee1u@europa.eu');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (68, 79, 'Ivie', 'Gyford', '7479901147', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (69, 58, 'Fielding', 'Langforth', '5336271685', 'flangforth1w@aboutads.info');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (70, 12, 'Huntley', 'Leadston', '6913370241', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (71, 10, 'Rollins', 'Pass', '9681487854', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (72, 22, 'Jaquenette', 'Navarijo', '5659352431', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (73, 86, 'Eleonore', 'Luter', '3842985176', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (74, 89, 'Jaquelyn', 'Alpin', '2247154105', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (75, 75, 'Fairleigh', 'Cufflin', '3598049070', 'fcufflin22@fema.gov');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (76, 83, 'Albina', 'Orbine', '9905782682', 'aorbine23@admin.ch');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (77, 100, 'Zane', 'Sellek', '3615652880', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (78, 21, 'Hildy', 'Crownshaw', '6586904578', 'hcrownshaw25@photobucket.com');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (79, 75, 'Bernetta', 'Yitzovicz', '1342585049', 'byitzovicz26@cdc.gov');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (80, 85, 'Melba', 'Brockelsby', '1432957986', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (81, 59, 'Isaac', 'Mustoo', '1132926937', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (82, 22, 'Kim', 'Danskine', '5472514781', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (83, 10, 'Lorin', 'Tortice', '1432632601', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (84, 95, 'Moore', 'Tatterton', '8535258967', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (85, 76, 'Dede', 'Shouler', '8742849914', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (86, 20, 'Abbey', 'Pond-Jones', '3734061716', 'apondjones2d@uiuc.edu');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (87, 100, 'Patrice', 'Airy', '3429065002', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (88, 31, 'Alethea', 'Colyer', '9233673142', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (89, 8, 'Odell', 'Berendsen', '2911727724', 'oberendsen2g@vkontakte.ru');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (90, 76, 'Loree', 'Daughtery', '9053113927', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (91, 29, 'Gorden', 'Renton', '2094418757', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (92, 63, 'Ruthi', 'Bestiman', '9168617846', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (93, 52, 'Cris', 'Fosbraey', '5241786357', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (94, 10, 'Saundra', 'Normanvill', '4473226776', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (95, 40, 'Merle', 'Cartmell', '2734365441', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (96, 19, 'Christiano', 'Sakins', '6068332725', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (97, 33, 'Jennine', 'Enoksson', '9107976058', 'jenoksson2o@quantcast.com');
insert into person (id_person, id_address, first_name, last_name, phone, email) values (98, 10, 'Rivalee', 'Styan', '8859088023', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (99, 43, 'Chickie', 'Merwood', '4383654058', null);
insert into person (id_person, id_address, first_name, last_name, phone, email) values (100, 91, 'Madge', 'Dorricott', '4501025796', null);
select setval(pg_get_serial_sequence('person', 'id_person'), 100);

insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (1, 1, null, 'Manager', 3000, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (2, 1, 1, 'Technician', 1500, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (3, 1, 1, 'Technician', 1800, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (4, 1, 1, 'Technician', 1200, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (5, 1, 1, 'Technician', 2015, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (6, 1, 1, 'Technician', 1840, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (7, 2, null, 'Manager', 2680, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (8, 2, 7, 'Technician', 1400, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (9, 2, 7, 'Technician', 2300, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (10, 2, 7, 'Technician', 1006, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (11, 3, null, 'Manager', 4000, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (12, 3, 11, 'Technician', 1679, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (13, 3, 11, 'Technician', 2014, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (14, 4, null, 'Manager', 3562, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (15, 4, 14, 'Technician', 2370, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (16, 4, 14, 'Technician', 1632, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (17, 5, null, 'Manager', 2290, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (18, 5, 17, 'Technician', 1421, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (19, 5, 17, 'Technician', 1830, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (20, 6, null, 'Manager', 4108, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (21, 6, 20, 'Technician', 1461, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (22, 6, 20, 'Technician', 2193, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (23, 7, null, 'Manager', 2574, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (24, 7, 23, 'Technician', 1680, '2021-01-01');
insert into employee (id_person, id_branch, is_subordinated_to, employee_position, employee_salary, employment_date) values (25, 7, 23, 'Technician', 2312, '2021-01-01');

insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (1, 98, 1, 102, '2021-01-04', '2:14 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (2, 45, 1, 475, '2021-01-12', '5:12 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (3, 36, 6, 23, '2021-02-07', '12:19 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (4, 92, 4, 105, '2021-02-09', '1:00 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (5, 30, 1, 109, '2021-02-28', '1:22 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (6, 66, 5, 384, '2021-01-26', '5:13 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (7, 72, 3, 31, '2021-01-07', '3:09 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (8, 37, 3, 228, '2021-01-04', '12:57 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (9, 75, 5, 119, '2021-02-26', '2:58 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (10, 74, 2, 338, '2021-02-22', '3:17 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (11, 53, 6, 343, '2021-02-09', '10:12 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (12, 32, 5, 36, '2021-01-29', '11:31 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (13, 100, 1, 494, '2021-01-25', '9:28 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (14, 46, 4, 73, '2021-01-17', '11:21 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (15, 96, 2, 240, '2021-01-15', '12:08 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (16, 43, 6, 500, '2021-01-22', '1:18 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (17, 53, 5, 91, '2021-01-27', '9:47 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (18, 79, 5, 253, '2021-02-04', '2:57 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (19, 89, 3, 437, '2021-02-10', '4:03 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (20, 48, 2, 186, '2021-01-25', '5:45 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (21, 51, 3, 184, '2021-02-12', '11:22 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (22, 56, 6, 477, '2021-02-13', '12:48 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (23, 45, 3, 112, '2021-01-29', '4:07 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (24, 36, 5, 40, '2021-01-25', '11:03 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (25, 55, 2, 214, '2021-02-01', '12:03 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (26, 46, 4, 210, '2021-01-20', '9:43 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (27, 48, 1, 238, '2021-02-25', '1:46 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (28, 98, 3, 41, '2021-02-25', '10:40 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (29, 89, 5, 126, '2021-02-21', '10:37 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (30, 90, 2, 352, '2021-02-19', '9:32 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (31, 58, 1, 405, '2021-01-08', '2:21 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (32, 67, 2, 226, '2021-02-10', '3:37 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (33, 65, 4, 297, '2021-02-18', '11:01 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (34, 89, 2, 469, '2021-02-04', '1:23 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (35, 47, 6, 250, '2021-01-21', '1:17 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (36, 66, 5, 466, '2021-02-22', '12:28 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (37, 91, 2, 231, '2021-02-28', '3:36 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (38, 35, 5, 71, '2021-01-23', '10:10 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (39, 57, 1, 166, '2021-01-04', '12:12 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (40, 30, 3, 265, '2021-01-30', '9:05 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (41, 47, 1, 388, '2021-01-22', '11:35 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (42, 52, 6, 129, '2021-02-22', '1:46 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (43, 36, 5, 71, '2021-01-02', '2:03 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (44, 62, 4, 21, '2021-01-17', '3:13 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (45, 38, 5, 132, '2021-02-14', '4:43 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (46, 87, 6, 291, '2021-02-01', '11:17 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (47, 58, 4, 233, '2021-01-12', '5:10 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (48, 36, 1, 103, '2021-01-28', '12:15 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (49, 42, 3, 297, '2021-01-09', '12:27 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (50, 28, 3, 359, '2021-02-27', '10:00 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (51, 44, 5, 404, '2021-01-16', '1:21 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (52, 84, 6, 435, '2021-01-08', '3:18 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (53, 27, 5, 291, '2021-01-07', '2:58 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (54, 40, 1, 132, '2021-01-07', '10:33 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (55, 63, 3, 132, '2021-02-27', '1:36 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (56, 65, 2, 146, '2021-02-12', '11:37 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (57, 30, 4, 285, '2021-02-22', '11:34 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (58, 33, 5, 362, '2021-02-15', '12:04 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (59, 61, 1, 445, '2021-01-12', '10:00 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (60, 44, 4, 183, '2021-02-17', '9:20 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (61, 94, 6, 81, '2021-02-24', '3:07 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (62, 46, 3, 493, '2021-02-02', '4:01 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (63, 89, 5, 432, '2021-02-22', '5:27 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (64, 91, 6, 273, '2021-02-13', '1:01 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (65, 100, 5, 453, '2021-02-01', '11:37 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (66, 47, 4, 320, '2021-01-13', '1:04 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (67, 77, 4, 38, '2021-01-01', '1:08 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (68, 67, 4, 203, '2021-01-09', '9:54 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (69, 45, 2, 321, '2021-01-25', '3:14 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (70, 89, 2, 315, '2021-01-17', '12:17 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (71, 39, 2, 35, '2021-01-15', '1:29 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (72, 88, 5, 182, '2021-01-23', '1:17 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (73, 30, 5, 152, '2021-02-17', '12:12 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (74, 25, 5, 159, '2021-01-04', '12:15 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (75, 35, 6, 245, '2021-02-16', '5:03 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (76, 79, 1, 314, '2021-02-13', '12:50 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (77, 26, 3, 295, '2021-01-24', '9:51 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (78, 52, 5, 444, '2021-02-13', '9:19 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (79, 36, 4, 175, '2021-02-15', '10:05 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (80, 72, 5, 166, '2021-02-16', '5:10 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (81, 88, 4, 145, '2021-01-11', '12:00 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (82, 67, 6, 113, '2021-01-27', '11:08 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (83, 92, 6, 62, '2021-02-28', '10:00 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (84, 35, 2, 459, '2021-01-24', '5:51 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (85, 67, 5, 231, '2021-02-25', '5:51 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (86, 57, 4, 193, '2021-02-01', '4:01 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (87, 52, 3, 159, '2021-02-17', '1:20 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (88, 51, 1, 342, '2021-02-05', '12:54 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (89, 41, 3, 144, '2021-02-23', '12:08 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (90, 87, 4, 61, '2021-01-05', '11:07 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (91, 65, 1, 347, '2021-02-10', '5:03 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (92, 77, 5, 476, '2021-01-01', '1:57 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (93, 80, 5, 408, '2021-01-03', '9:45 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (94, 67, 6, 114, '2021-02-26', '10:48 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (95, 51, 4, 75, '2021-02-12', '9:14 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (96, 43, 6, 321, '2021-01-26', '9:01 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (97, 74, 5, 482, '2021-01-19', '3:49 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (98, 50, 4, 287, '2021-01-20', '11:28 AM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (99, 70, 2, 428, '2021-01-14', '4:04 PM');
insert into service (id_service, id_person, id_payment_type, service_cost, service_date, service_time) values (100, 91, 5, 111, '2021-01-16', '10:17 AM');
select setval(pg_get_serial_sequence('service', 'id_service'), 100);

insert into service_employee (id_service, id_person) values (1, 12);
insert into service_employee (id_service, id_person) values (2, 9);
insert into service_employee (id_service, id_person) values (3, 2);
insert into service_employee (id_service, id_person) values (4, 11);
insert into service_employee (id_service, id_person) values (5, 10);
insert into service_employee (id_service, id_person) values (6, 21);
insert into service_employee (id_service, id_person) values (7, 10);
insert into service_employee (id_service, id_person) values (8, 10);
insert into service_employee (id_service, id_person) values (9, 18);
insert into service_employee (id_service, id_person) values (10, 9);
insert into service_employee (id_service, id_person) values (11, 22);
insert into service_employee (id_service, id_person) values (12, 10);
insert into service_employee (id_service, id_person) values (13, 14);
insert into service_employee (id_service, id_person) values (14, 15);
insert into service_employee (id_service, id_person) values (15, 5);
insert into service_employee (id_service, id_person) values (16, 21);
insert into service_employee (id_service, id_person) values (17, 15);
insert into service_employee (id_service, id_person) values (18, 16);
insert into service_employee (id_service, id_person) values (19, 11);
insert into service_employee (id_service, id_person) values (20, 15);
insert into service_employee (id_service, id_person) values (21, 11);
insert into service_employee (id_service, id_person) values (22, 9);
insert into service_employee (id_service, id_person) values (23, 8);
insert into service_employee (id_service, id_person) values (24, 6);
insert into service_employee (id_service, id_person) values (25, 21);
insert into service_employee (id_service, id_person) values (26, 1);
insert into service_employee (id_service, id_person) values (27, 24);
insert into service_employee (id_service, id_person) values (28, 25);
insert into service_employee (id_service, id_person) values (29, 6);
insert into service_employee (id_service, id_person) values (30, 11);
insert into service_employee (id_service, id_person) values (31, 9);
insert into service_employee (id_service, id_person) values (32, 4);
insert into service_employee (id_service, id_person) values (33, 10);
insert into service_employee (id_service, id_person) values (34, 4);
insert into service_employee (id_service, id_person) values (35, 18);
insert into service_employee (id_service, id_person) values (36, 6);
insert into service_employee (id_service, id_person) values (37, 7);
insert into service_employee (id_service, id_person) values (38, 8);
insert into service_employee (id_service, id_person) values (39, 21);
insert into service_employee (id_service, id_person) values (40, 9);
insert into service_employee (id_service, id_person) values (41, 4);
insert into service_employee (id_service, id_person) values (42, 21);
insert into service_employee (id_service, id_person) values (43, 9);
insert into service_employee (id_service, id_person) values (44, 3);
insert into service_employee (id_service, id_person) values (45, 13);
insert into service_employee (id_service, id_person) values (46, 9);
insert into service_employee (id_service, id_person) values (47, 18);
insert into service_employee (id_service, id_person) values (48, 7);
insert into service_employee (id_service, id_person) values (49, 1);
insert into service_employee (id_service, id_person) values (50, 12);
insert into service_employee (id_service, id_person) values (51, 24);
insert into service_employee (id_service, id_person) values (52, 15);
insert into service_employee (id_service, id_person) values (53, 4);
insert into service_employee (id_service, id_person) values (54, 15);
insert into service_employee (id_service, id_person) values (55, 7);
insert into service_employee (id_service, id_person) values (56, 19);
insert into service_employee (id_service, id_person) values (57, 9);
insert into service_employee (id_service, id_person) values (58, 1);
insert into service_employee (id_service, id_person) values (59, 2);
insert into service_employee (id_service, id_person) values (60, 18);
insert into service_employee (id_service, id_person) values (61, 21);
insert into service_employee (id_service, id_person) values (62, 21);
insert into service_employee (id_service, id_person) values (63, 18);
insert into service_employee (id_service, id_person) values (64, 18);
insert into service_employee (id_service, id_person) values (65, 9);
insert into service_employee (id_service, id_person) values (66, 7);
insert into service_employee (id_service, id_person) values (67, 6);
insert into service_employee (id_service, id_person) values (68, 8);
insert into service_employee (id_service, id_person) values (69, 12);
insert into service_employee (id_service, id_person) values (70, 3);
insert into service_employee (id_service, id_person) values (71, 11);
insert into service_employee (id_service, id_person) values (72, 14);
insert into service_employee (id_service, id_person) values (73, 15);
insert into service_employee (id_service, id_person) values (74, 19);
insert into service_employee (id_service, id_person) values (75, 20);
insert into service_employee (id_service, id_person) values (76, 7);
insert into service_employee (id_service, id_person) values (77, 1);
insert into service_employee (id_service, id_person) values (78, 17);
insert into service_employee (id_service, id_person) values (79, 21);
insert into service_employee (id_service, id_person) values (80, 5);
insert into service_employee (id_service, id_person) values (81, 4);
insert into service_employee (id_service, id_person) values (82, 20);
insert into service_employee (id_service, id_person) values (83, 19);
insert into service_employee (id_service, id_person) values (84, 12);
insert into service_employee (id_service, id_person) values (85, 4);
insert into service_employee (id_service, id_person) values (86, 7);
insert into service_employee (id_service, id_person) values (87, 4);
insert into service_employee (id_service, id_person) values (88, 23);
insert into service_employee (id_service, id_person) values (89, 16);
insert into service_employee (id_service, id_person) values (90, 24);
insert into service_employee (id_service, id_person) values (91, 16);
insert into service_employee (id_service, id_person) values (92, 2);
insert into service_employee (id_service, id_person) values (93, 23);
insert into service_employee (id_service, id_person) values (94, 17);
insert into service_employee (id_service, id_person) values (95, 12);
insert into service_employee (id_service, id_person) values (96, 11);
insert into service_employee (id_service, id_person) values (97, 7);
insert into service_employee (id_service, id_person) values (98, 8);
insert into service_employee (id_service, id_person) values (99, 15);
insert into service_employee (id_service, id_person) values (100, 16);

insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (1, 48, 'Charging cable', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (2, 56, 'Power adapter', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (3, 26, 'Power adapter', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (4, 53, 'Headphones', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (5, 53, 'Charging cable', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (6, 37, 'Power adapter', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (7, 63, 'Charging cable', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (8, 41, 'Charging cable', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (9, 92, 'Charging cable', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (10, 23, 'Headphones', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (11, 98, 'Power adapter', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (12, 22, 'Headphones', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (13, 12, 'Charging cable', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (14, 59, 'Case', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (15, 29, 'Screen protector', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (16, 65, 'Charging cable', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (17, 69, 'Case', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (18, 94, 'Car holder', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (19, 73, 'Screen protector', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (20, 53, 'Charging cable', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (21, 37, 'Charging cable', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (22, 40, 'Case', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (23, 53, 'Charging cable', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (24, 82, 'Power adapter', false);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (25, 51, 'Charging cable', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (26, 5, 'Charging cable', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (27, 82, 'Headphones', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (28, 67, 'Headphones', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (29, 9, 'Screen protector', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (30, 35, 'Power adapter', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (31, 80, 'Car holder', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (32, 93, 'Charging cable', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (33, 6, 'Headphones', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (34, 5, 'Car holder', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (35, 65, 'Car holder', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (36, 64, 'Car holder', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (37, 25, 'Case', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (38, 28, 'Headphones', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (39, 81, 'Charging cable', true);
insert into accessory_purchase (id_accessory, id_service, accessory_type, special_wrap) values (40, 40, 'Power adapter', true);
select setval(pg_get_serial_sequence('accessory_purchase', 'id_accessory'), 40);

insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('714601407', 1, 'Apple', 'Pfi-188', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('938847760', 2, 'Samsung', '7YX-353', 2020);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('408995053', 3, 'Vivo', 'kA0-799', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('011346471', 4, 'Apple', '4Fb-871', 2009);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('583910602', 5, 'Apple', 'CzV-767', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('759181781', 6, 'Huawei', 'zQ2-298', 2013);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('926701070', 7, 'OnePlus', 'xnD-931', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('853037609', 8, 'OnePlus', 'NUv-877', 2012);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('523074796', 9, 'Huawei', '5TA-314', 2017);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('791996246', 10, 'Apple', 'kY9-391', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('755041900', 11, 'Apple', 'gRY-918', 2010);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('114429849', 12, 'Xiaomi', '6Fx-436', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('644706008', 13, 'Xiaomi', 'El7-170', 2010);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('097312124', 14, 'Huawei', 'hxA-071', 2010);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('892465153', 15, 'Apple', 'mOM-820', 2020);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('364859442', 16, 'OnePlus', 'y7i-674', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('014070787', 17, 'Apple', 'rlF-984', 2016);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('854987029', 18, 'HTC', 'Jsf-384', 2012);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('559680773', 19, 'Google', 'uH2-388', 2014);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('372335135', 20, 'Apple', 'PkH-321', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('017183066', 21, 'OnePlus', 'Qyr-141', 2016);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('010916825', 22, 'Huawei', 'X3A-613', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('948116545', 23, 'Huawei', '1yh-549', 2016);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('532141895', 24, 'Xiaomi', 'edx-346', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('514966186', 25, 'Apple', 'p2K-369', 2017);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('477701465', 26, 'LG', '3Zy-925', 2013);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('300196358', 27, 'Apple', 'XXh-922', 2011);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('486752279', 28, 'Fly', 's0Z-417', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('535443460', 29, 'Xiaomi', 'O9v-406', 2016);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('894235963', 30, 'Apple', 'OiY-970', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('495259335', 31, 'Asus', 'YcM-918', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('868245113', 32, 'Huawei', '94A-732', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('123292699', 33, 'Redmi', 'yge-552', 2012);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('454332544', 34, 'Huawei', 'EOD-270', 2014);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('018876127', 35, 'Oppo', '59k-178', 2009);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('907424932', 36, 'Xiaomi', 'tgA-053', 2011);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('904284021', 37, 'Huawei', 'Ug9-321', 2012);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('680092765', 38, 'Meizu', '2Ub-086', 2013);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('247359926', 39, 'Honor', 'Ajr-483', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('303822185', 40, 'Apple', 'D9N-244', 2014);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('193755570', 41, 'Huawei', 'Wlz-003', 2015);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('586523116', 42, 'Huawei', 'hbr-251', 2010);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('197838040', 43, 'Apple', 'aW4-779', 2017);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('598498389', 44, 'Xiaomi', 't64-164', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('751978658', 45, 'Honor', 'ZnY-841', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('222951931', 46, 'Huawei', 'TtN-250', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('498762238', 47, 'Xiaomi', 'M9c-749', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('197178896', 48, 'Apple', 'sjy-816', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('888779693', 49, 'Nokia', 'M93-508', 2013);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('745230879', 50, 'Nokia', 'UuJ-086', 2017);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('838090033', 51, 'Apple', 'giL-091', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('718829029', 52, 'Vertu', 'YhH-999', 2017);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('555439898', 53, 'Huawei', 'J2w-913', 2010);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('755935892', 54, 'Doogee', 'sll-399', 2020);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('878918424', 55, 'Apple', '5Z0-044', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('395517457', 56, 'Huawei', '0ZL-075', 2015);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('510562094', 57, 'Huawei', 'X4z-268', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('000102343', 58, 'Apple', 'AIh-066', 2014);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('433665812', 59, 'Xiaomi', 'Gf4-621', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('693460800', 60, 'Xiaomi', 'MRR-730', 2010);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('113686783', 61, 'Huawei', 'EUA-116', 2017);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('598604472', 62, 'Huawei', 'JeY-252', 2014);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('207035074', 63, 'Apple', 'DAu-958', 2013);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('474462329', 64, 'Asus', 'lWS-829', 2009);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('500427545', 65, 'Realme', 'kL4-947', 2014);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('883312597', 66, 'Apple', 'JDg-788', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('134001849', 67, 'Huawei', 'cLV-274', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('380192096', 68, 'Xiaomi', 'VWj-208', 2012);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('255888995', 69, 'Apple', 'zou-204', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('533050538', 70, 'Xiaomi', 'vh4-177', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('503286346', 71, 'Realme', '5rl-759', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('987212820', 72, 'Apple', 'gUF-214', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('089738207', 73, 'Realme', 'kbY-564', 2011);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('544875978', 74, 'Huawei', 'A0L-279', 2020);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('686233670', 75, 'Huawei', '4ya-166', 2016);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('014813207', 76, 'Sharp', '1lq-508', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('968840969', 77, 'Apple', 'W51-801', 2009);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('435475365', 78, 'Sony', 'wkz-313', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('926748450', 79, 'Apple', 'LS1-636', 2010);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('324735952', 80, 'Huawei', 'J9J-181', 2009);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('888030178', 81, 'Apple', 'ja5-728', 2020);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('280452307', 82, 'Huawei', 'fBb-344', 2015);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('605128203', 83, 'Apple', 'syZ-524', 2017);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('003985639', 84, 'Sharp', 'Krx-293', 2010);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('664973996', 85, 'Xiaomi', 'gB0-636', 2013);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('914993043', 86, 'Apple', 'YIP-786', 2015);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('905415664', 87, 'Huawei', 'Em5-045', 2015);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('013788538', 88, 'Huawei', 'ZXa-937', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('783704358', 89, 'Motorola', 'Anl-623', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('976874608', 90, 'Apple', '6Ef-278', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('961816785', 91, 'Xiaomi', 'YuX-656', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('923018497', 92, 'Apple', '1xb-864', 2017);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('485255425', 93, 'Huawei', 'Um6-389', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('572509062', 94, 'Huawei', 'jeE-106', 2014);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('450553410', 95, 'Apple', 'aZr-383', 2009);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('204847117', 96, 'Apple', 'OFC-703', 2010);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('165738235', 97, 'Xiaomi', 'lvH-509', 2016);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('740248146', 98, 'Motorola', 'iKl-072', 2015);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('580156041', 99, 'Huawei', 'I0C-798', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('918425229', 100, 'Nokia', 'ekl-166', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('807606743', 1, 'Apple', 'YbR-958', 2010);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('701906181', 2, 'Honor', '7SW-369', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('120588998', 3, 'Huawei', 'GXm-643', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('812273481', 4, 'Apple', 'bQs-778', 2020);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('415698070', 5, 'Huawei', 'VAx-929', 2014);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('212337666', 6, 'Honor', 'L7A-426', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('434126972', 7, 'Pocophone', 'S9z-659', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('530461756', 8, 'Apple', 'Qt1-182', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('576960259', 9, 'LG', 'kve-198', 2012);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('353889651', 10, 'Sony', 'hTC-182', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('881726770', 11, 'Apple', 'd6L-313', 2016);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('526444378', 12, 'Huawei', 'erl-301', 2016);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('985002528', 13, 'Sony', 'tap-305', 2018);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('437700761', 14, 'Huawei', '4oy-773', 2016);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('384441807', 15, 'Huawei', '0TG-957', null);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('739148798', 16, 'Apple', '9pE-895', 2021);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('157517644', 17, 'Sony', 'unf-596', 2013);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('556988521', 18, 'YotaPhone', 'UYv-418', 2011);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('081342090', 19, 'Apple', '1HX-793', 2019);
insert into gadget_repair (gadget_imei, id_service, manufacturer, gadget_model, release_year) values ('746856602', 20, 'Google', 'WSj-180', 2011);

insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('714601407', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('938847760', 2);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('408995053', 3);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('011346471', 4);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('583910602', 5);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('759181781', 6);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('926701070', 7);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('853037609', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('523074796', 4);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('791996246', 11);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('755041900', 15);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('114429849', 3);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('644706008', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('097312124', 6);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('892465153', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('364859442', 2);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('014070787', 4);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('854987029', 7);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('559680773', 5);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('372335135', 10);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('017183066', 11);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('010916825', 12);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('948116545', 14);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('532141895', 15);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('514966186', 2);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('477701465', 3);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('300196358', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('486752279', 6);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('535443460', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('894235963', 2);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('495259335', 6);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('868245113', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('123292699', 2);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('454332544', 14);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('018876127', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('907424932', 11);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('904284021', 12);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('680092765', 13);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('247359926', 3);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('303822185', 4);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('193755570', 15);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('586523116', 10);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('197838040', 7);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('598498389', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('751978658', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('222951931', 3);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('498762238', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('197178896', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('888779693', 13);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('745230879', 7);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('838090033', 3);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('718829029', 10);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('555439898', 3);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('755935892', 4);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('878918424', 7);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('395517457', 6);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('510562094', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('000102343', 4);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('433665812', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('693460800', 10);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('113686783', 7);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('598604472', 4);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('207035074', 3);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('474462329', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('500427545', 14);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('883312597', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('134001849', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('380192096', 12);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('255888995', 4);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('533050538', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('503286346', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('987212820', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('089738207', 11);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('544875978', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('686233670', 6);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('014813207', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('968840969', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('435475365', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('926748450', 10);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('324735952', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('888030178', 7);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('280452307', 15);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('605128203', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('003985639', 10);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('664973996', 13);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('914993043', 15);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('905415664', 15);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('013788538', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('783704358', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('976874608', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('961816785', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('923018497', 7);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('485255425', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('572509062', 14);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('450553410', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('204847117', 10);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('165738235', 6);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('740248146', 5);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('580156041', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('918425229', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('807606743', 10);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('701906181', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('120588998', 3);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('812273481', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('415698070', 4);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('212337666', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('434126972', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('530461756', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('576960259', 2);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('353889651', 9);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('881726770', 6);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('526444378', 6);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('985002528', 8);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('437700761', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('384441807', 2);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('739148798', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('157517644', 3);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('556988521', 1);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('081342090', 11);
insert into gadget_repair_breakdown (gadget_imei, id_breakdown) values ('746856602', 12);

commit;