

insert into admin_table (id_user) values
(1),
(2),
(3);

insert into surendee (id_user) values
(4),
(5),
(6);

insert into donor (id_user, is_from_organisation, name_organisation_donor) values 
(7, false, null),
(8, true, 'Save The Birds Organisation'),
(9, false, null);

insert into organisation (name_organisation, email_organisation, billing_information) values 
('AnimalHelp', 'animalhelp@contact.org', '200001234567890'),
('National Shelters Macedonia', 'shelters@contact.org.mk', '300001234567890'),
('Dog Rescue', 'dog.rescue@contact.org', '400001234567890');

insert into shelter (address_shelter, telephone_shelter, id_organisation, name_shelter, email_shelter) values 
('st. Street n. 5, Skopje, Macedonia', '123-456-789', 2, 'Skopje City Shelter', 'skopje-shelters@contact.org.mk'),
('st. Street n. 4, Bitola, Macedonia', '223-456-789', 2, 'Bitola City Shelter', 'bitola-shelters@contact.org.mk'),
('st. Street n. 8, Ohrid, Macedonia', '323-456-789', 2, 'Ohrid City Shelter', 'ohrid-shelters@contact.org.mk'),
('st. SomeStreet n.9, Skopje, Macedonia', '072-072-072', null, 'Animal Rescue - Independent Shelter Skopje', 'animal-rescue-skopje@contact.org');

insert into adopter (id_user, free_time, funds, has_other_pets, has_kids, housing, 
	physical_activity_adopters, will_foster, is_verified, verified_by_employee) values 
(16, null, null, null, null, null, null, null, true, 10),
(17, 2, 0, true, false, 1, 2, true, true, 14),
(18, 0, 2, false, false, 0, 1, false, true, 15),
(19, 1, 1, false, true, 1, 0, true, true, 12),
(20, null, null, null, null, null, null, null, false, null),
(21, 2, 2, true, true, 1, 2, true, true, 14);

insert into adoption (start_date, end_date_foster, approved, id_adopter) values 
(to_date('2022-12-23', 'YYYY-MM-DD'), null, true, 16),
(to_date('2022-12-11', 'YYYY-MM-DD'), to_date('2022-05-11', 'YYYY-MM-DD'), true, 17),
(to_date('2023-10-17', 'YYYY-MM-DD'), null, true, 18),
(to_date('2023-01-10', 'YYYY-MM-DD'), to_date('2022-04-10', 'YYYY-MM-DD'), true, 19),
(to_date('2022-10-23', 'YYYY-MM-DD'), null, true, 20),
(to_date('2022-12-11', 'YYYY-MM-DD'), null, true, 21),
(to_date('2021-8-17', 'YYYY-MM-DD'), null, true, 18),
(to_date('2023-6-10', 'YYYY-MM-DD'), null, true, 19),
(to_date('2022-9-23', 'YYYY-MM-DD'), null, true, 20),
(to_date('2022-1-14', 'YYYY-MM-DD'), null, true, 20),
(to_date('2022-9-9', 'YYYY-MM-DD'), null, true, 20),
(to_date('2022-2-14', 'YYYY-MM-DD'), null, true, 19),
(to_date('2021-4-17', 'YYYY-MM-DD'), null, true, 19),
(to_date('2023-8-20', 'YYYY-MM-DD'), null, true, 16);

insert into pet (url_pet_image, age_group, size_pet, breed, name_pet, 
	species, gender, can_be_fostered, id_adoption, id_shelter) values 
(null, 0, 1, null, 'Mittens', 0, 1, true, 1, 4),
(null, 2, 3, 'German Shepherd', 'Brownie', 1, 0, false, null, 1),
(null, 1, 2, 'Ragdoll', 'Whiskers', 0, 0, false, 3, null),
(null, 0, 3, null, null, 1, 1, true, 2, 2),
(null, 0, 3, null, null, 1, 1, true, 4, 2),
(null, 1, 0, 'African Gray Parrot', 'Biscuit', 2, 0, false, 1, 4),
(null, 2, 3, 'Golden Retriver', 'Bert', 1, 0, false, 5, 1),
(null, 1, 2, 'Persian', 'Fluff', 0, 0, false, 6, null),
(null, 0, 3, null, 'Roki', 2, 0, false, 7, null),
(null, 0, 1, null, 'Bella', 1, 1, false, 8, 3),
(null, 2, 0, 'Chihuahua', 'Majlo', 1, 0, false, 13, 1),
(null, 0, 1, null, 'Marin', 1, 1, false, 18, 3);

insert into post (date_post, url_thumbanail, id_pet, id_surendee, id_employee) values 
(to_date('2022-10-07', 'YYYY-MM-DD'), null, 1, null, 15),
(to_date('2020-05-04', 'YYYY-MM-DD'), null, 2, null, 10),
(to_date('2022-08-23', 'YYYY-MM-DD'), null, 3, 5, null),
(to_date('2022-07-23', 'YYYY-MM-DD'), null, 4, null, 12),
(to_date('2022-07-23', 'YYYY-MM-DD'), null, 5, null, 12),
(to_date('2021-12-29', 'YYYY-MM-DD'), null, 6, null, 15);
 
insert into category (name_category) values 
('gray'),
('brown'),
('black'),
('friendly'),
('good with kids'),
('needs extra care');

insert into food (manufacturer, name_food, type_food) values 
('Purrfect Bistro', 'Senior Cat Food', 1),
('Kibbles', 'Tasty Dog Food', 0),
('Cesar', 'High Quality', 0);

insert into therapy (health_problem, start_date, end_date) values 
('leg surgery', null, null),
('diabetes treatment', null, null),
('3 month therapy to treat parasite', to_date('2023-01-03', 'YYYY-MM-DD'), to_date('2021-04-03', 'YYYY-MM-DD'));

insert into vet_clinic (telephone_vet_clinic, address_vet_clinic, name_vet_clinic) values 
('1234-567-890', 'st.Street n.6', 'PetCare - Veterinary Clinic'),
('2345-567-890', 'st.Street n.9', 'Tail Wags'),
('3456-567-890', 'st.Street n.12', 'The Pet Doctors');

insert into personal_profile (id_pet, friendly_to_kids, friendly_to_pets, 
	attention, physical_activity, grooming_needed) values 
(1, 1, 0, 0, 0, 0),
(2, 2, 2, 2, 0, 1),
(3, 2, 1, 1, 1, 2),
(4, 1, 2, 2, 0, 1),
(5, 1, 2, 0, 2, 1),
(6, 0, 0, 2, 1, 0);

insert into donor_donates_to_organisation (id_user, id_organisation) values 
(7, 1),
(8, 1),
(8, 2),
(9, 3);

insert into pet_belongs_to_category (id_pet, id_category) values 
(2, 2),
(6, 2),
(2, 5),
(4, 6);

insert into pet_needs_therapy (id_pet, id_therapy) values 
(4, 3),
(5, 3),
(4, 1),
(2, 2);

insert into pet_preferably_eats_food (id_pet, id_food, quantity_a_day) values 
(2, 3, 500),
(1, 3, 200),
(2, 2, 150);

insert into pet_needs_intervention_in_vet_clinic (id_pet, 
	id_vet_clinic, date_of_interventing, description) values 
(4, 2, to_date('2023-02-12', 'YYYY-MM-DD'), 'spay'),
(5, 2, to_date('2023-02-12', 'YYYY-MM-DD'), 'spay'),
(4, 3, to_date('2023-01-22', 'YYYY-MM-DD'), 'leg surgery');