text: INSERT INTO vets (ID, FIRST_NAME, LAST_NAME) VALUES (1, 'James', 'Carter');
  INSERT INTO vets (ID, FIRST_NAME, LAST_NAME) VALUES (2, 'Helen', 'Leary');
  INSERT INTO vets (ID, FIRST_NAME, LAST_NAME) VALUES (3, 'Linda', 'Douglas');
  INSERT INTO vets (ID, FIRST_NAME, LAST_NAME) VALUES (4, 'Rafael', 'Ortega');
  INSERT INTO vets (ID, FIRST_NAME, LAST_NAME) VALUES (5, 'Henry', 'Stevens');
  INSERT INTO vets (ID, FIRST_NAME, LAST_NAME) VALUES (6, 'Sharon', 'Jenkins');
  
  INSERT INTO specialties (ID, NAME) VALUES (1, 'radiology');
  INSERT INTO specialties (ID, NAME) VALUES (2, 'surgery');
  INSERT INTO specialties (ID, NAME) VALUES (3, 'dentistry');
  
  INSERT INTO vet_specialties VALUES (2, 1);
  INSERT INTO vet_specialties VALUES (3, 2);
  INSERT INTO vet_specialties VALUES (3, 3);
  INSERT INTO vet_specialties VALUES (4, 2);
  INSERT INTO vet_specialties VALUES (5, 1);
  
  INSERT INTO types (ID, NAME) VALUES (1, 'cat');
  INSERT INTO types (ID, NAME) VALUES (2, 'dog');
  INSERT INTO types (ID, NAME) VALUES (3, 'lizard');
  INSERT INTO types (ID, NAME) VALUES (4, 'snake');
  INSERT INTO types (ID, NAME) VALUES (5, 'bird');
  INSERT INTO types (ID, NAME) VALUES (6, 'hamster');
  
  INSERT INTO owners (ID, FIRST_NAME, LAST_NAME, ADDRESS, CITY, TELEPHONE) VALUES (1, 'George', 'Franklin', '110 W. Liberty St.', 'Madison', '6085551023');
  INSERT INTO owners (ID, FIRST_NAME, LAST_NAME, ADDRESS, CITY, TELEPHONE) VALUES (2, 'Betty', 'Davis', '638 Cardinal Ave.', 'Sun Prairie', '6085551749');
  INSERT INTO owners (ID, FIRST_NAME, LAST_NAME, ADDRESS, CITY, TELEPHONE) VALUES (3, 'Eduardo', 'Rodriquez', '2693 Commerce St.', 'McFarland', '6085558763');
  INSERT INTO owners (ID, FIRST_NAME, LAST_NAME, ADDRESS, CITY, TELEPHONE) VALUES (4, 'Harold', 'Davis', '563 Friendly St.', 'Windsor', '6085553198');
  INSERT INTO owners (ID, FIRST_NAME, LAST_NAME, ADDRESS, CITY, TELEPHONE) VALUES (5, 'Peter', 'McTavish', '2387 S. Fair Way', 'Madison', '6085552765');
  INSERT INTO owners (ID, FIRST_NAME, LAST_NAME, ADDRESS, CITY, TELEPHONE) VALUES (6, 'Jean', 'Coleman', '105 N. Lake St.', 'Monona', '6085552654');
  INSERT INTO owners (ID, FIRST_NAME, LAST_NAME, ADDRESS, CITY, TELEPHONE) VALUES (7, 'Jeff', 'Black', '1450 Oak Blvd.', 'Monona', '6085555387');
  INSERT INTO owners (ID, FIRST_NAME, LAST_NAME, ADDRESS, CITY, TELEPHONE) VALUES (8, 'Maria', 'Escobito', '345 Maple St.', 'Madison', '6085557683');
  INSERT INTO owners (ID, FIRST_NAME, LAST_NAME, ADDRESS, CITY, TELEPHONE) VALUES (9, 'David', 'Schroeder', '2749 Blackhawk Trail', 'Madison', '6085559435');
  INSERT INTO owners (ID, FIRST_NAME, LAST_NAME, ADDRESS, CITY, TELEPHONE) VALUES (10, 'Carlos', 'Estaban', '2335 Independence La.', 'Waunakee', '6085555487');
  
  
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (1, 'Germany', null, '4735a4c8-e1fc-43ce-8ff9-0bd28d00ce20.Hugo Boss Boss Bottled Night.webp', 'Salmwood, Musky notes, Sandalwood', 'Cardamom, Jasmine, African violet', 'Birch leaf, Lavender', 'male', 'Boss Bottled Night', 'Hugo Boss', 35, 'Eau de Toilette', '100', 2010);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (2, 'Germany', null, '17d6f8a1-aa84-4823-bd18-ccb0fdbe7fe9.Hugo Boss Hugo Man.jpg', 'Moss, Sandalwood, Fir balsam', 'Carnation, Geranium leaf, Jasmine', 'Basil, Grapefruit, Green apple, Mint', 'male', 'Hugo Man', 'Hugo Boss', 21, 'Eau de Toilette', '75', 1995);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (3, 'Germany', null, 'ba9272ca-20af-4e41-89b7-24018be4acb1.Hugo Boss The Scent.jpg', 'Leather', 'Maninka fruit, Lavender', 'Ginger', 'male', 'The Scent', 'Hugo Boss', 45, 'Eau de Toilette', '100', 2015);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (4, 'Germany', null, '540f8e7d-2259-4a20-becf-4ed5cfc2912e.Hugo Boss Boss Woman.jpg', 'Sandalwood, Cedar', 'Freesia, Violet root', 'Mandarin orange, Mango', 'female', 'Boss Woman', 'Hugo Boss', 26, 'Eau de parfum', '90', 2000);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (5, 'Germany', null, '1fb6dd1b-a134-4e6f-8215-60d465d33d72.Hugo Boss Hugo Deep Red.jpg', 'Musk, Sandalwood, Vanilla', 'Freesia, Hibiscus, Ginger', 'Pear, Blood orange, Clementine', 'female', 'Deep Red', 'Hugo Boss', 27, 'Eau de parfum', '90', 2001);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (6, 'Germany', null, '62e9bf9b-8fea-4eb2-9935-21e868e1b93d.Hugo Boss The Scent For Her.jpg', 'Roasted cocoa', 'Osmanthus', 'Peach, Freesia', 'female', 'The Scent For Her', 'Hugo Boss', 47, 'Eau de parfum', '100', 2016);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (7, 'Great Britain', null, '8297191e-ea2d-4f76-a1a0-004cc5beb127.Burberry London For Men.jpg', 'Oak bark, Gaiac wood, Opoponax', 'Leather, Mimosa, Port wine', 'Bergamot, Lavender, Black pepper', 'male', 'London For Men', 'Burberry', 27, 'Eau de Toilette', '100', 2006);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (8, 'Great Britain', null, 'a5f18e03-340d-4e84-a7da-900683ecfe9f.Burberry Mr. Burberry.jpg', 'Sandalwood, Vetiver, Gaiac wood', 'Leather, Mimosa, Port wine', 'Grapefruit, Tarragon, Cardamom', 'male', 'Mr. Burberry', 'Burberry', 20, 'Eau de Toilette', '50', 2016);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (9, 'Great Britain', null, '83a69c92-738a-4b49-a6de-1367050a8c01.Burberry The Beat For Men.jpg', 'Vetiver, Woody notes', 'Geranium, White thyme', 'Black pepper, Citron, Violet leaf', 'male', 'The Beat For Men', 'Burberry', 44, 'Eau de Toilette', '100', 2008);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (10, 'Great Britain', null, 'a52df6cb-470a-43ac-8f6b-b33b56e20539.Burberry My Burberry.jpg', 'Patchouli, Damask rose, Rosa centifolia', 'Geranium leaf, Freesia, Quince', 'Sweet pea, Bergamot', 'female', 'My Burberry', 'Burberry', 35, 'Eau de parfum', '50', 2014);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (11, 'Great Britain', null, '20485cd6-d46a-46f4-82fd-5d952f61269f.Burberry Weekend For Women.jpg', 'Musk, Sandalwood, Cedarwood', 'Cyclamen, Rose hip, Hyacinth, Iris', 'Mandarin orange, Reseda, Sage', 'female', 'Weekend For Women', 'Burberry', 28, 'Eau de parfum', '100', 1997);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (12, 'Great Britain', null, 'd647879a-0bca-4365-becf-06eb1b518033.Burberry Women.jpg', 'Musk, Patchouli, Sandalwood', 'Jasmine, Clementine peel, Peony', 'English garden rose, Honeysuckle', 'female', 'Women', 'Burberry', 29, 'Eau de parfum', '100', 1995);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (13, 'Italy', null, '284737fc-4847-4f7d-b7a7-9e2ac78eeaee.bvlgari-aqva-pour-homme-marine.jpg', 'Mineral amber, White cedarwood', 'Neptune grass, Rosemary blossom', 'Grapefruit, Neroli', 'male', 'Aqva Pour Homme Marine', 'Bvlgari', 36, 'Eau de Toilette', '100', 2008);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (14, 'Italy', null, '0354dc37-7aaa-4020-8022-29a0b9dbd042.Bvlgari Aqva Pour Homme.jpg', 'Mineral amber, Clary sage', 'Santolina, Neptune grass', 'Mandarin orange, Petitgrain', 'male', 'Aqva Pour Homme', 'Bvlgari', 38, 'Eau de Toilette', '100', 2005);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (15, 'Italy', null, '5183288a-6cd8-4db8-ab26-ea5ecf3b6b51.Bvlgari Man In Black.jpg', 'Benzoin, Tonka bean, Gaiac wood', 'Tuberose, Orris absolute, Leather', 'Tobacco, Rum', 'male', 'Man In Black', 'Bvlgari', 49, 'Eau de parfum', '100', 2014);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (16, 'Italy', null, '7e376792-723e-45b1-a22c-b7e549a0b1f8.Bvlgari Goldea the Roman Night Absolute.jpg', 'Black musk, Patchouli, Crystallised moss', 'Jasmine sambac absolute, Bourbon vanilla', 'Orange blossom, Black plum', 'female', 'Goldea the Roman Night Absolute', 'Bvlgari', 48, 'Eau de parfum', '75', 2018);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (17, 'Italy', null, '956bbe26-c07d-4e32-a567-5e4306388c0e.Bvlgari Le Gemme Ashlemah.jpg', 'Musk', 'Orris absolute', 'Lavender', 'female', 'Le Gemme Ashlemah', 'Bvlgari', 171, 'Eau de parfum', '100', 2014);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (18, 'Italy', null, 'a52fcb3f-614e-4214-be80-944173ea8f5f.Bvlgari Omnia Amethyste.webp', 'Heliotrope, Woods', 'Iris, Rose', 'Plant juice, Pink grapefruit', 'female', 'Omnia Amethyste', 'Bvlgari', 36, 'Eau de Toilette', '40', 2007);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (19, 'Italy', null, 'ab055088-8a70-4076-8811-53839b883d60.Bvlgari Splendida Jasmin Noir.jpg', 'Cashmere wood, Patchouli, Tonka bean', 'Jasmine sambac absolute, Almond', 'Gardenia, Plant juice', 'female', 'Splendida Jasmin Noir', 'Bvlgari', 45, 'Eau de parfum', '100', 2017);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (20, 'USA', null, '9b03319b-1b53-4d9c-8033-b3a84ea9e2fa.Calvin Klein CK Free.jpg', 'Oak, Ironwood, Patchouli', 'Buchu, Coffee, Tobacco', 'Absinth, Jackfruit, Star anise', 'male', 'CK Free', 'Calvin Klein', 23, 'Eau de Toilette', '100', 2009);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (21, 'USA', null, 'ea92388e-801e-4435-9d3b-bd41f737acc2.Calvin Klein CK One Shock for Him.jpg', 'Ambreine, Cashmeran, Patchouli, Tobacco', 'Cardamom, Black basil, Black pepper', 'Clementine, Cucumber, Lavender', 'male', 'CK One Shock for Him', 'Calvin Klein', 21, 'Eau de Toilette', '100', 2011);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (22, 'USA', null, '0fb6c514-5253-451a-80ce-b384b87d4821.Calvin Klein Euphoria Men.jpg', 'Amber, Redwood, Patchouli', 'Sage, Black basil, Cedar leaf', 'Ginger, Pepper, Sudachi, Rain accord', 'male', 'Euphoria Men', 'Calvin Klein', 27, 'Eau de Toilette', '100', 2006);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (23, 'USA', null, 'cd2e7815-9944-4d58-942a-405fbff57bbd.Calvin Klein CK IN2U Her.jpg', 'Ambergris, Red cedar, Vanilla', 'Cactus, Orchid', 'Pink grapefruit, Redcurrant leaf, Sicilian bergamot', 'female', 'CK IN2U Her', 'Calvin Klein', 17, 'Eau de Toilette', '100', 2007);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (24, 'USA', null, '13dbc15b-30c6-4500-b733-bc6b8c42a149.Calvin Klein Deep Euphoria.jpg', 'Musk, Patchouli', 'Black rose', 'Mandarin orange leaf, Cascalone, White pepper', 'female', 'Deep Euphoria', 'Calvin Klein', 43, 'Eau de parfum', '100', 2016);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (25, 'USA', null, '9dc64b2f-2b49-4b7f-823f-8072c2921cee.Calvin Klein Sheer Beauty.jpg', 'Musk, Sandalwood, Vanilla blossom', 'Jasmine, Peony, Pink lily', 'Bergamot, Bellini, Red berries', 'female', 'Sheer Beauty', 'Calvin Klein', 26, 'Eau de parfum', '100', 2012);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (26, 'Spain', null, '6524de16-c086-49fe-a6e5-c9efc35f1a02.Carolina Herrera Bad Boy.jpg', 'Tonka bean, Cocoa absolute', 'Cedarwood, Sage', 'Black pepper, White pepper, Italian bergamot', 'male', 'Bad Boy', 'Carolina Herrera', 76, 'Eau de Toilette', '100', 2019);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (27, 'Spain', null, '184c9da2-2445-4b01-87b8-b4f8b5f6ab8c.Carolina Herrera Good Girl.jpg', 'Roasted tonka bean, Cocoa, Sandalwood', 'Tuberose, Bulgarian rose, Jasmine sambac', 'Bergamot, Lemon', 'female', 'Good Girl', 'Carolina Herrera', 156, 'Eau de parfum', '150', 2016);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (28, 'France', null, 'e31f6d6c-e585-40a4-970c-f25322667924.Chanel Allure homme Sport.jpg', 'Amber, Musk, Tonka bean', 'Neroli, Pepper, Cedar', 'Aldehydes, Mandarin orange, Seawater', 'male', 'Allure homme Sport', 'Chanel', 85, 'Eau de Toilette', '100', 2004);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (29, 'France', null, 'ac6c7a11-97f8-44b1-9b10-f96997212dd4.Chanel Bleu de Chanel Eau de Parfum.webp', 'Ginger, Sandalwood, Frankincense', 'Grapefruit, Labdanum, Cedar', 'Pink pepper, Vetiver, Citrus notes', 'male', 'Bleu de Chanel', 'Chanel', 88, 'Eau de parfum', '100', 2014);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (30, 'France', null, '7049225c-03bb-45a7-ba6a-86274f8668b9.Chanel Egoiste Platinum.webp', 'Amber, Oakmoss, Sandalwood', 'Galbanum, Geranium, Jasmine', 'Lavender, Neroli, Petitgrain', 'male', 'Egoiste Platinum', 'Chanel', 70, 'Eau de Toilette', '100', 1993);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (31, 'France', null, 'bcc4bb2a-907d-4531-9d7f-178c765c5ed3.Chanel Chance Eau Fraiche.jpg', 'Amber, Iris, Musk, Patchouli', 'Jasmine, Pink pepper, Water hyacinth', 'Cedar, Citrus fruits', 'female', 'Chance Eau Fraiche', 'Chanel', 90, 'Eau de Toilette', '100', 2007);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (32, 'France', null, '2b5f80ca-e0f3-4e99-b5e4-11ccb9153b00.Chanel Gabrielle Essence.jpg', 'Sandalwood, Vanilla, White musk', 'Tuberose, Jasmine, Ylang-ylang', 'Citrus fruits, Red fruits', 'female', 'Gabrielle Essence', 'Chanel', 104, 'Eau de parfum', '100', 2019);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (33, 'France', null, '4b51181b-5551-4321-b5e7-f7612584c9b2.Chanel N5.jpg', 'Amber, Sandalwood, Vanilla', 'Iris, Grasse jasmine', 'Aldehydes, Bergamot, Neroli', 'female', 'Chanel N5', 'Chanel', 192, 'Eau de parfum', '200', 1921);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (34, 'France', null, 'bdb203a9-0725-4ed4-a71a-db7eeb915fae.Creed Aventus.jpg', 'Ambergris, Oakmoss, Musk', 'Birch, Jasmine, Patchouli', 'Pineapple, Apple, Bergamot, Blackcurrant', 'male', 'Aventus', 'Creed', 152, 'Eau de parfum', '100', 2010);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (35, 'France', null, '162cfbe2-2dc2-4271-8a63-23981a7e3cc4.Creed Bois du Portugal.jpg', 'Sandalwood, Vetiver, Ambergris', 'Cedarwood', 'Bergamot, Lavender', 'male', 'Bois du Portugal', 'Creed', 110, 'Eau de parfum', '100', 1987);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (36, 'France', null, '1d428b77-0ffd-449f-bcaa-04a094b51de7.Creed Original Vetiver.jpg', 'Ambergris, Sandalwood, Musk, Vetiver', 'White pepper, Coriander, Pink pepper', 'Bergamot, Bitter orange, Mandarin orange', 'male', 'Original Vetiver', 'Creed', 97, 'Eau de parfum', '100', 2004);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (37, 'France', null, '5fd3de8e-1022-47a2-ae58-a089a65bd90c.Creed Acqua Fiorentina.webp', 'Grapefruit, Sandalwood, Cedar', 'Bergamot, Pear, Rose', 'Apple, Prune, Greengage plum', 'female', 'Acqua Fiorentina', 'Creed', 100, 'Eau de parfum', '75', 2009);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (38, 'France', null, '7d32f694-9cc3-4770-844a-47400e6f5c6b.Creed Aventus for Her.webp', 'Peach, Blackcurrant, Ylang-ylang', 'Rose, Styrax, Mysore sandalwood', 'Green apple, Violet leaf, Calabrian bergamot', 'female', 'Aventus for Her', 'Creed', 141, 'Eau de parfum', '75', 2016);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (39, 'France', null, 'cbb8efd1-f55a-4db3-8511-f0b5b446533d.Creed Love in Black.jpg', 'Rose, Burgundy blackcurrant, Violet', 'Florentine iris, Clove', 'White violet', 'female', 'Love in Black', 'Creed', 89, 'Eau de parfum', '75', 2008);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (40, 'France', null, '0f0acb70-dc64-474f-878a-1b214d250d94.Creed Love in White.jpg', 'Ambergris, Mysore sandalwood, Vanilla', 'Florentine iris, Yellow narcissus, Magnolia', 'Orange zest', 'female', 'Love in White', 'Creed', 94, 'Eau de parfum', '75', 2005);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (41, 'France', null, '0158183f-2412-4c61-a962-7c96e43c19c3.Dior Fahrenheit.jpg', 'Amber, Leather, Musk', 'Carnation, Honeysuckle, Jasmine', 'Bergamot, Camomile, Lavender, Mandarin orange', 'male', 'Fahrenheit', 'Dior', 62, 'Eau de Toilette', '100', 1988);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (42, 'France', null, '27f0b3d3-2634-4e74-971a-f780c4480482.Dior Homme.jpg', 'Virginia cedar', 'Ecuadorian ambrette seed', 'Florentine iris absolute', 'male', 'Homme', 'Dior', 90, 'Eau de parfum', '100', 2007);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (43, 'France', null, '03e65b3b-7b1f-400c-9bb8-a8956bdaa4be.Dior Sauvage.jpg', 'Ambroxan', 'Bergamot', 'Sichuan Pepper', 'male', 'Sauvage', 'Dior', 62, 'Eau de Toilette', '100', 2015);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (44, 'France', null, '94c85cfd-f090-4d49-b2e9-dcff34eec8c1.Dior Jadore.jpg', 'Vanilla, Cedar, Musk', 'Lily of the valley, Rose, Violet', 'Bergamot, Pear, Melon, Peach', 'female', 'Jadore', 'Dior', 81, 'Eau de parfum', '100', 1999);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (45, 'France', null, '85f8de21-24d5-473b-8d63-6ba6c2d4d25e.Dior Miss Dior.jpg', 'Ambergris, Musk, Patchouli', 'Jasmine, Caramel, Popcorn', 'Pineapple, Cherry, Mandarin orange', 'female', 'Miss Dior', 'Dior', 90, 'Eau de parfum', '100', 2011);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (46, 'France', null, '63534821-1eb9-4b44-afd3-61c3b8ca4a25.Dior Poison Girl.jpg', 'Venezuelan tonka bean', 'Grasse rose', 'Bitter orange', 'female', 'Poison Girl', 'Dior', 75, 'Eau de parfum', '100', 2016);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (47, 'Italy', null, 'edb8d85c-2f43-477e-9d49-9f06b6ddb72e.Dolce&Gabbana K By Dolce&Gabbana.webp', 'Cedarwood, Vetiver, Patchouli', 'Chili, Clary sage, Provençal lavender', 'Blood orange, Sicilian lemon, Juniper berry', 'male', 'K', 'Dolce&Gabbana ', 55, 'Eau de Toilette', '100', 2019);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (48, 'Italy', null, '8873bf9e-7e95-423d-a3ca-074b429308d4.Dolce&Gabbana Pour Homme.jpg', 'Iris, Sandalwood, Tobacco, Tonka bean, Cedar', 'Tarragon, Cardamom, Lavender, Pepper, Sage', 'Bergamot, Mandarin orange, Orange', 'male', 'Pour Homme', 'Dolce&Gabbana', 42, 'Eau de Toilette', '125', 1994);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (49, 'Italy', null, '9ae62ea2-39fa-4c1b-b700-9516ab4ba961.Dolce&Gabbana The One For Men.jpg', 'Amber, Tobacco, Cedar', 'Ginger, Cardamom, Orange blossom', 'Basil, Grapefruit, Coriander', 'male', 'The One For Men', 'Dolce&Gabbana', 43, 'Eau de Toilette', '100', 2008);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (50, 'Italy', null, '1c972eb4-65a3-43bb-8ce8-de74a2ee7b85.Dolce&Gabbana Anthology L`Imperatrice 3.webp', 'Grapefruit wood, Musk, Sandalwood', 'Pink cyclamen, Watermelon', 'Red currant, Kiwi, Rhubarb', 'female', 'Anthology L`Imperatrice 3', 'Dolce&Gabbana', 27, 'Eau de Toilette', '100', 2009);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (51, 'Italy', null, 'a746477f-d071-4150-951f-80083a740d46.Dolce&Gabbana Dolce.jpg', 'Cashmeran, Musk', 'Amaryllis, Water Lily, Narcissus', 'Neroli, Papaya Flower', 'female', 'Dolce', 'Dolce&Gabbana', 41, 'Eau de parfum', '75', 2014);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (52, 'Italy', null, '7010aec6-8c8c-44c2-8d31-9c24bdee077b.Giorgio Armani Acqua di Gio Pour Homme.jpg', 'Amber, Oakmoss, Musk', 'Cyclamen, Freesia, Hyacinth, Coriander', 'Bergamot, Jasmine, Lime', 'male', 'Acqua di Gio Pour Homme', 'Giorgio Armani', 57, 'Eau de Toilette', '100', 1996);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (53, 'Italy', null, 'e2966bc2-6c56-40ce-bb3b-f9473b72dcd8.Giorgio Armani Code.jpg', 'Gaiac wood, Leather, Tobacco, Tonka bean', 'Olive blossom, Star anise', 'Bergamot, Lemon', 'male', 'Code', 'Giorgio Armani', 56, 'Eau de Toilette', '75', 2004);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (54, 'Italy', null, 'c85c9fae-65c6-4bd2-9ea9-0e551b13dab6.Giorgio Armani Emporio Armani Stronger With You.webp', 'Marron glacé, Vanilla', 'Sage', 'Cardamom, Pink pepper, Violet leaf', 'male', 'Stronger With You', 'Giorgio Armani', 54, 'Eau de Toilette', '100', 2017);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (55, 'Italy', null, '8ce1aee8-653a-446d-aa08-f63404b40add.Giorgio Armani Code Women.jpg', 'Honey, Vanilla, Sandalwood', 'Jasmine sambac, Tunisian orange blossom absolute', 'African orange blossom, Italian bitter orange', 'female', 'Code Women', 'Giorgio Armani', 64, 'Eau de parfum', '75', 2006);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (56, 'Italy', null, 'd822de55-d51a-49f7-ab6a-9a598f96a1b9.Giorgio Armani Emporio Armani Because It’s You.jpg', 'Patchouli, Vanilla, White musk', 'Rose absolute', 'Raspberry, Neroli', 'female', 'Because It’s You', 'Giorgio Armani', 58, 'Eau de parfum', '100', 2017);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (57, 'Italy', null, 'e304e856-1512-429a-883b-915dd9922ea6.Giorgio Armani Si.webp', 'Amber, Blond woods, Orcanox, Patchouli', 'May rose absolute, Neroli absolute', 'Mandarin orange, Blackcurrant liqueur', 'female', 'Si', 'Giorgio Armani', 99, 'Eau de parfum', '100', 2013);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (58, 'France', null, '1c99f101-42c1-4764-92f1-8c36b2a72a43.Givenchy Gentleman 2017.jpg', 'Patchouli, Leather, Vanilla', 'Iris, Lavender', 'Pear, Cardamom', 'male', 'Gentleman 2017', 'Givenchy', 45, 'Eau de Toilette', '100', 2017);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (59, 'France', null, '39d4e42c-9f54-4b63-82cc-459903fb28fd.Givenchy Pi.jpg', 'Benzoin, Brown sugar, Almond', 'Aniseed, Geranium, Lily of the valley', 'Aromatic notes, Basil, Blossoms', 'male', 'Pi', 'Givenchy', 49, 'Eau de Toilette', '100', 1998);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (60, 'France', null, 'fe2f0dd4-dea2-4719-862b-14c1030857ac.Givenchy Pour Homme.jpg', 'Labdanum, Cedar', 'Lavender, Vetiver', 'Grapefruit, Coriander, Mandarin orange', 'male', 'Pour Homme', 'Givenchy', 37, 'Eau de Toilette', '100', 2002);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (61, 'France', null, 'a28ff037-77bd-4137-bbdf-06d4a233a2df.Givenchy Ange Ou Demon Le Secret.webp', 'Amber, Vanilla, Driftwood', 'Tiaré, Salty notes', 'Italian lemon, Neroli, Jasmine tea', 'female', 'Ange Ou Demon Le Secret', 'Givenchy', 71, 'Eau de parfum', '100', 2014);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (62, 'France', null, 'ea8ca264-8060-4f04-90c5-d122a81a6679.Givenchy L''Interdit Eau de Parfum.jpg', 'Patchouli, Vetiver, Ambroxan', 'Tuberose', 'Orange blossom, Jasmine sambac', 'female', 'L''Interdit Eau de Parfum', 'Givenchy', 99, 'Eau de parfum', '80', 2018);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (63, 'France', null, '8207ae60-4a0a-4e0c-a3e6-f4bbe8ca88e3.Givenchy Very Irresistible.webp', 'Rose', 'Peony, Rose', 'Anise, Verbena Leaves', 'female', 'Very Irresistible', 'Givenchy', 46, 'Eau de Toilette', '75', 2003);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (64, 'France', null, 'f23fac56-8f9e-4d6b-9856-8ef64eca2dad.Gucci by Gucci Pour Homme.jpg', 'Amber, Elemi resin, Patchouli', 'Jasmine, Tobacco', 'Bergamot, Violet, Cypress', 'male', 'Pour Homme', 'Gucci', 41, 'Eau de Toilette', '90', 2008);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (65, 'France', null, '6d2277c4-ea19-415c-ab0a-55a73e9f8505.Gucci Guilty Black Pour Homme.jpg', 'Leather, Patchouli, Cedar', 'Neroli, Orange blossom', 'Coriander, Lavender', 'male', 'Guilty Black Pour Homme', 'Gucci', 54, 'Eau de Toilette', '90', 2013);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (66, 'France', null, '3ec0d3e0-9cd5-4ed5-9b23-b1bbfa5dbc46.Gucci Made to Measure.webp', 'Labdanum, Patchouli, Leather', 'Sri Lankan nutmeg, Waterlily, Juniper berry', 'Calabrian bergamot, Tunisian orange blossom, French lavender', 'male', 'Made to Measure', 'Gucci', 40, 'Eau de Toilette', '50', 2013);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (67, 'France', null, '7b7aa358-ac56-42c8-971a-d2fffb87a959.Gucci by Gucci.jpg', 'Honey, Musk, Patchouli', 'Tiaré', 'Pear, Guava', 'female', 'by Gucci', 'Gucci', 71, 'Eau de parfum', '75', 2018);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (68, 'France', null, '95d670f7-9e63-432b-94a8-f29748a559f3.Gucci Flora.jpg', 'Patchouli, Sandalwood', 'Osmanthus, Rose', 'Peony, Citrus notes', 'female', 'Flora', 'Gucci', 39, 'Eau de Toilette', '75', 2009);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (69, 'France', null, '77faa2e5-4e4a-4322-8605-68cf8b0ef697.Gucci Rush.jpg', 'Patchouli, Vanilla, Vetiver', 'Jasmine, Coriander, Rose', 'Freesia, Gardenia, Peach', 'female', 'Rush', 'Gucci', 39, 'Eau de Toilette', '75', 2000);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (70, 'France', null, '0e32851e-d9d0-4623-9a63-91b8ac902f72.Hermes Terre d''Hermes Eau Tres Fraiche.jpg', 'Woody notes, Patchouli, Cedar', 'Geranium', 'Orange, Citrus fruits, Aquatic notes', 'male', 'Eau Tres Fraiche', 'Hermes', 68, 'Eau de Toilette', '125', 2014);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (71, 'France', null, 'd5fb8750-0ce8-4615-8115-78f6b71557fc.Hermes Terre d''Hermes Parfum Refill.jpg', 'Benzoin, Woody notes, Oakmoss', 'Flint, Minerals', 'Orange, Grapefruit', 'male', 'Parfum Refill', 'Hermes', 61, 'Eau de parfum', '125', 2009);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (72, 'France', null, 'ef094746-8589-4682-910c-bb0fcdc7c132.Hermes Terre d''Hermes Parfum.jpg', 'Benzoin, Woody notes, Oakmoss', 'Flint, Minerals', 'Orange, Grapefruit', 'male', 'Parfum', 'Hermes', 72, 'Eau de parfum', '75', 2009);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (73, 'France', null, '4c034eb1-d898-4e4b-89e4-2c3b03c32cf8.Hermes Eau des Merveilles.jpg', 'Oakmoss, Fir, Vetiver, Cedar', 'Amber, Pepper, Pink pepper', 'Orange, Lemon', 'female', 'Eau des Merveilles', 'Hermes', 75, 'Eau de Toilette', '100', 2004);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (74, 'France', null, 'cef920a1-efe0-422c-a557-ceb6dccf7755.Hermes Jour d`Hermes Absolu.jpg', 'Apricot blossom', 'Jasmine sambac', 'Gardenia', 'female', 'Jour d`Hermes Absolu', 'Hermes', 53, 'Eau de parfum', '50', 2014);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (75, 'France', null, 'd6b443ff-ca04-4e48-ba17-70f20867adca.Hermes Twilly d`Hermes.webp', 'Ginger', 'Tuberose', 'Sandalwood', 'female', 'Twilly d`Hermes', 'Hermes', 83, 'Eau de parfum', '75', 2017);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (76, 'France', null, '2572526a-e892-43fc-bfa3-317864bf13ea.Jean Paul Gaultier Le Male.jpg', 'Amber, Sandalwood, Tonka bean', 'Caraway, Neroli, Cinnamon', 'Bergamot, Tarragon, Cardamom', 'male', 'Le Male', 'Jean Paul Gaultier', 54, 'Eau de Toilette', '125', 1995);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (77, 'France', null, '776dadf8-16b0-4e74-b27c-7d590b6a2951.Jean Paul Gaultier Ultra Male.jpg', 'Vanilla, Amber, Woods', 'Cumin, Cinnamon, Clary sage', 'Bergamot, Pear, Lavender, Mint', 'male', 'Ultra Male', 'Jean Paul Gaultier', 63, 'Eau de Toilette', '125', 2015);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (78, 'France', null, '8b433478-511c-4d00-8a11-b963f118b10e.Jean Paul Gaultier Classique Eau de Parfum Collector.jpg', 'Ambergris, Tonka Bean, Vanilla, Sandalwood', 'Narcissus, Orchid', 'Rose, Rum, Sicilian mandarin', 'female', 'Classique Eau de Parfum Collector', 'Jean Paul Gaultier', 59, 'Eau de parfum', '50', 2017);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (79, 'France', null, '1d97831f-cd5b-4599-88ba-e3c4b9092b44.Jean Paul Gaultier La Belle.jpg', 'Vanilla', 'Vetiver', 'Pear', 'female', 'La Belle', 'Jean Paul Gaultier', 84, 'Eau de parfum', '100', 2019);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (80, 'France', null, '8dddd016-50a7-48f9-a8d9-dd2ad40d912c.Jean Paul Gaultier Scandal.jpg', 'Patchouli', 'Honey', 'Gardenia, Blood orange', 'female', 'Scandal', 'Jean Paul Gaultier', 64, 'Eau de parfum', '80', 2017);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (81, 'France', null, '5d0b2fe3-d3c5-44df-ba27-0c2ce5c8ade0.Lancome Hypnose Homme.webp', 'Amber, Musk, Patchouli', 'Lavender', 'Bergamot, Cardamom, Mandarin orange, Mint', 'male', 'Hypnose Homme', 'Lancome', 42, 'Eau de Toilette', '75', 2007);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (82, 'France', null, '1e3f8b71-e6dd-4cd8-8229-e88a4d098a33.Lancome La Nuit Tresor.jpg', 'Frankincense, Papyrus, Lychee praliné', 'Tahitian vanilla orchid', 'Black rose', 'female', 'La Nuit Tresor', 'Lancome', 67, 'Eau de parfum', '75', 2015);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (83, 'France', null, '947fbf1a-009a-4357-a830-ae7fc1db811e.Lancome La Vie Est Belle.webp', 'Patchouli, Praliné, Tonka bean, Vanilla', 'Iris, Jasmine, Orange blossom', 'Pear, Blackcurrant', 'female', 'La Vie Est Belle', 'Lancome', 92, 'Eau de parfum', '100', 2012);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (84, 'France', null, '8979007d-14be-4296-a1d6-02e128fe67a2.Lancome Tresor.jpg', 'Sandalwood, Musk', 'Lily of the valley, Vanilla, Heliotrope', 'Rose leaf, Apricot blossom, Peach blossom', 'female', 'Tresor', 'Lancome', 56, 'Eau de parfum', '50', 1990);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (85, 'France', null, '313b26ec-a812-4f27-93fb-de82858f6eee.Paco Rabanne 1 Million.jpg', 'Leather, Amberketal', 'Rose absolute, Cinnamon', 'Red mandarin orange, Peppermint', 'male', '1 Million', 'Paco Rabanne', 41, 'Eau de Toilette', '100', 2008);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (86, 'France', null, '7f130776-3164-4f93-82fd-bd75f63a916f.Paco Rabanne Invictus.jpg', 'Gaiac wood, Oakmoss, Patchouli', 'Bay leaf, Jasmine', 'Grapefruit, Marine notes', 'male', 'Invictus', 'Paco Rabanne', 46, 'Eau de Toilette', '100', 2013);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (87, 'France', null, 'eda32745-2764-496f-bba4-6ca135eec6f5.Paco Rabanne Pure XS.webp', 'White cedar, Myrrh, Sugar', 'Vanilla, Leather, Cinnamon, Liqueur', 'Green notes, Ginger, Thyme', 'male', 'Pure XS', 'Paco Rabanne', 40, 'Eau de Toilette', '100', 2017);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (88, 'France', null, '11b04b2c-7410-4e68-bc38-e6feac0e1ee4.Paco Rabanne Lady Million.jpg', 'Honey, Patchouli', 'Orange blossom, Jasmine sambac', 'Raspberry, Neroli, Bitter orange', 'female', 'Lady Million', 'Paco Rabanne', 56, 'Eau de parfum', '80', 2010);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (89, 'France', null, 'fcfdd1d1-7925-4065-8c08-25d5a0bae53c.Paco Rabanne Olympea.jpg', 'Cashmere wood, Ambergris', 'Salted vanilla, Ginger lily, Water jasmine', 'Green mandarin orange', 'female', 'Olympea', 'Paco Rabanne', 54, 'Eau de parfum', '80', 2015);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (90, 'France', null, '2bca5ec5-d82f-457a-9240-d68733033b70.Paco Rabanne Ultraviolet.jpg', 'Ambergris, Vanilla absolute', 'Osmanthus, Jasmine', 'Chili, Blackberry', 'female', 'Ultraviolet', 'Paco Rabanne', 45, 'Eau de parfum', '80', 1999);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (91, 'Spain', null, '10725eaa-2265-48ad-9cf3-d11d089c4700.Prada L''Homme Prada L''Eau.jpg', 'Cedarwood, Powdery notes, Sandalwood', 'Ambergris, Iris', 'Ginger, Neroli', 'male', 'L''Homme Prada L''Eau', 'Prada', 52, 'Eau de Toilette', '100', 2017);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (92, 'Italy', null, '994244f5-be7d-48e1-8120-84049d2422e6.Prada Luna Rossa Black.jpg', 'Amber', 'Patchouli, Coumarin', 'Bergamot, Angelica', 'male', 'Luna Rossa Black', 'Prada', 39, 'Eau de parfum', '50', 2018);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (93, 'Italy', null, 'bc119144-edb9-4aa1-ad18-38a085c1ccff.Prada Luna Rossa Carbon.jpg', 'Ambroxan, Patchouli', 'Water notes, Lavender, Asphalt notes', 'Bergamot, Pepper', 'male', 'Luna Rossa Carbon', 'Prada', 47, 'Eau de Toilette', '100', 2017);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (94, 'Italy', null, '977a852c-90b4-4d50-a3ca-c95fedd56173.Prada Candy Kiss.webp', 'Musk', 'Orange blossom', 'Vanilla', 'female', 'Candy Kiss', 'Prada', 55, 'Eau de parfum', '80', 2016);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (95, 'Italy', null, '93167727-2473-4e27-805d-1c12ddff0816.Prada Candy.jpg', 'Musk', 'Benzoin', 'Musk', 'female', 'Candy', 'Prada', 53, 'Eau de parfum', '80', 2011);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (96, 'USA', null, '720b38d1-971b-45f4-93b8-12135e18a087.Tom Ford For Men.jpg', 'Amber, Cedar, Patchouli, Vetiver', 'Tunisian orange blossom absolute, Black pepper, Tobacco absolute', 'Citrus notes, Lemon leaf, Italian bergamot', 'male', 'For Men', 'Tom Ford', 52, 'Eau de Toilette', '50', 2007);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (97, 'USA', null, 'db213300-2057-45b7-b2a1-4bace7c82b2f.Tom Ford Grey Vetiver.jpg', 'Amberwood, Oakmoss, Vetiver', 'Iris, Nutmeg, Pimento', 'Orange blossom, Grapefruit, Sage, Woods', 'male', 'Grey Vetiver', 'Tom Ford', 89, 'Eau de parfum', '100', 2009);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (98, 'USA', null, 'f869ee5b-2112-42a7-ac65-5519fc6901b1.Tom Ford Noir.jpg', 'Amber, Styrax, Opoponax', 'Egyptian geranium, Iris, Nutmeg', 'Italian bergamot, Vervain, Caraway', 'male', 'Noir', 'Tom Ford', 91, 'Eau de parfum', '100', 2012);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (99, 'USA', null, 'a5a745ad-2134-4483-bf12-71c299d80ccb.Tom Ford Black Orchid.jpg', 'Balsam, Patchouli, Sandalwood', 'Black orchid, Lotus wood, Floral notes', 'Black truffle, Bergamot, Blackcurrant', 'female', 'Black Orchid', 'Tom Ford', 95, 'Eau de parfum', '100', 2006);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (100, 'USA', null, 'e093a9e4-d61a-4108-a985-97d836125522.Tom Ford Noir Pour Femme.jpg', 'Sandalwood, Mastic resin, Amber, Vanilla', 'Egyptian geranium, Iris, Nutmeg', 'Mandarin orange, Bitter orange, Ginger', 'female', 'Noir Pour Femme', 'Tom Ford', 110, 'Eau de parfum', '100', 2015);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (101, 'USA', null, '24275f61-ba97-4814-9695-592c5501a5d4.Tom Ford Orchid Soleil.jpg', 'Vanilla, Chestnut cream, Patchouli, Orchid', 'Red spiderlily, Tuberose', 'Bitter orange, Pink pepper, Cypress', 'female', 'Orchid Soleil', 'Tom Ford', 151, 'Eau de parfum', '100', 2016);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (102, 'USA', null, '74c50f56-76f9-4d23-8363-2185c34ead66.Tom Ford Velvet Orchid.jpg', 'Labdanum, Myrrh Orpur, Sandalwood', 'Cattleya orchid, Jasmine absolute, Magnolia', 'Bergamot, Honey, Mandarin orange Orpur, Vanilla', 'female', 'Velvet Orchid', 'Tom Ford', 177, 'Eau de parfum', '100', 2014);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (103, 'Italy', null, '26164c0d-f0d9-4d02-8149-235dbb69cd2f.Versace Eros.jpg', 'Bourbon vanilla, Atlas cedar, Virginia cedar', 'Venezuelan tonka bean, Ambroxan, Geranium', 'Mint, Italian lemon, Green apple', 'male', 'Eros', 'Versace', 35, 'Eau de Toilette', '100', 2012);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (104, 'Italy', null, '30f4a944-a3a4-4af3-9ef6-854878e4f4bb.Versace Man Eau Fraiche.webp', 'Ambergris, Musk, Plane tree wood', 'Tarragon, Cedar leaf, Clary sage', 'Rosewood, Starfruit, Lemon', 'male', 'Man Eau Fraiche', 'Versace', 31, 'Eau de Toilette', '100', 2006);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (105, 'Italy', null, '2d378db1-4415-4515-99b5-990b412f1864.Versace Pour Homme.webp', 'Mineral amber, Musk, Tonka bean, Oud', 'Geranium, Hyacinth, Clary sage, Cedarwood', 'Bergamot, Neroli, Lemon, Bitter orange leaf', 'male', 'Pour Homme', 'Versace', 42, 'Eau de Toilette', '100', 2008);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (106, 'Italy', null, 'd26c62b0-583a-4b2c-b4ba-7d4edb42198c.Versace Bright Crystal.jpg', 'Amber, Acajou wood, Musk', 'Lotus, Magnolia, Peony', 'Ice accord, Pomegranate, Yuzu', 'female', 'Bright Crystal', 'Versace', 41, 'Eau de Toilette', '90', 2006);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (107, 'Italy', null, '4536623f-b973-439f-acbc-0d533bb9baf4.Versace Crystal Noir.jpg', 'Sandalwood, Cashmeran, Vanilla, Heliotropin', 'Tuberose, Frangipani, Jasmine', 'Blackcurrant, Black fig, Violet', 'female', 'Crystal Noir', 'Versace', 44, 'Eau de Toilette', '90', 2004);
  INSERT INTO perfumes (id, country, description, filename, fragrance_base_notes, fragrance_middle_notes, fragrance_top_notes, perfume_gender, perfume_title, perfumer, price, type, volume, year) VALUES (108, 'Italy', null, '125b5660-c43d-48c4-90d8-f2b8344892ef.Versace Dylan Blue Pour Femme.png', 'Patchouli, Blond woods, Musk, Styrax', 'Jasmine sambac, Petalia, Peach, Rosyfolia', 'Granny Smith apple, Clover, Blackcurrant sorbet', 'female', 'Dylan Blue Pour Femme', 'Versace', 59, 'Eau de parfum', '100', 2017);
  
  
  
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (1, 'Leo', {ts '2000-09-07'}, 1, 1);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (2, 'Basil', {ts '2002-08-06'}, 6, 2);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (3, 'Rosy', {ts '2001-04-17'}, 2, 3);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (4, 'Jewel', {ts '2000-03-07'}, 2, 3);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (5, 'Iggy', {ts '2000-11-30'}, 3, 4);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (6, 'George', {ts '2000-01-20'}, 4, 5);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (7, 'Samantha', {ts '1995-09-04'}, 1, 6);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (8, 'Max', {ts '1995-09-04'}, 1, 6);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (9, 'Lucky', {ts '1999-08-06'}, 5, 7);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (10, 'Mulligan', {ts '1997-02-24'}, 2, 8);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (11, 'Freddy', {ts '2000-03-09'}, 5, 9);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (12, 'Lucky', {ts '2000-06-24'}, 2, 10);
  INSERT INTO pets (ID, NAME, BIRTH_DATE, TYPE_ID, OWNER_ID) VALUES (13, 'Sly', {ts '2002-06-08'}, 1, 10);
  
  INSERT INTO visits (ID, PET_ID, VISIT_DATE, DESCRIPTION) VALUES (1, 7, {ts '2010-03-04'}, 'rabies shot');
  INSERT INTO visits (ID, PET_ID, VISIT_DATE, DESCRIPTION) VALUES (2, 8, {ts '2011-03-04'}, 'rabies shot');
  INSERT INTO visits (ID, PET_ID, VISIT_DATE, DESCRIPTION) VALUES (3, 8, {ts '2009-06-04'}, 'neutered');
  INSERT INTO visits (ID, PET_ID, VISIT_DATE, DESCRIPTION) VALUES (4, 7, {ts '2008-09-04'}, 'spayed');
  
  ALTER SEQUENCE IF EXISTS HIBERNATE_SEQUENCE RESTART WITH 14;
  