RelationalDesign: dodavanje4.sql

INSERT INTO project.cities
("name")
VALUES('Skopje'),
('Ohrid'),
('Skopje');

INSERT INTO project.vet_centers
("name", description, adress, phonenumber, latitude, longitude, workinghours, citiesid)
VALUES( 'Vet Svet', 'Тhe best for your pets', 'Nikola Parapunov 27', '+389(0)23161019', 41.9966401, 21.41712, 'Monday-Friday 10-19, Saturday 10-15', 4),
( 'Veterinarian Ambulance - Dr.Tonit', 'Your pets are safe with us', 'Bulevar Makedonski Prosvetiteli', '070575881', 41.1196292, 20.7996689, 'Monday-Thursday 08-20, Friday-Saturday 08-07', 5),
( 'Vet In', 'We exist for you and your pets', 'Blvd. Partizanski Odredi 62', '077 698 250', 42.0030601, 21.395752, 'Monday-Friday 9-12, 14-19', 6);

INSERT INTO project.jobs
(description, predictedsalery, vetcentersid)
VALUES('doctor', '1500 EUR', 4),     --9
('secretary', '800 EUR', 4),         --10
('doctor', '1400 EUR', 5),            --11
('developer', '1800 EUR', 6);         --12

INSERT INTO project.roles
("type")
VALUES('admin'),  --5
('standard'),  --6
('manager'),        --7
('employee');      --8

INSERT INTO project.users
("name", lastname, email, password, "number", role_id, jobs_id)     --17 do 24
VALUES('Ana', 'Kirova', 'ana.kirova99@gmail.com', 'Ana@123', '071220234', 2, 6),
('Riste', 'Rizov', 'riste.rizov01@hotmail.com', 'Riste$11', '075450290', 2, 7),
('Keti', 'Atanasova', 'keti.atanasovaaa@gmail.com', 'Keti12@', '078760330', 2, 5),
('Elena', 'Rizova', 'elena.rizova05@gmail.com', 'Rizova12!', '071762110', 3, null),
('Marina', 'Abrasheva', 'marina.abrashevaa@hotmail.com', 'Marina!1', '072324112', 1, null),
('Angela', 'Pavlova', 'angela.pavlova07@hotmail.com', 'Angela@12', '078765240', 1, null),
('Marija', 'Kortova', 'marija.kortova199@gmail.com', 'Marija123&', '072231129', 2, 7),
('Silvana', 'Dodeva', 'silvana.dodeva9@gmail.com', 'Silvana123*', '078231129', 4, null);

INSERT INTO project.blog_post_for_consultations
(date_askes, title, description, users_id)
VALUES('2023-12-11', 'Urinary food', 'Can you recommend a urinary food because my kitten has urinary problems.', 1),
('2023-06-12', 'Frequent vomiting', 'Мy dog is vomiting a lot, despite the therapy from the vet, please advise.', 2),
('2023-04-10', 'Sterilization', 'When is the best time to sterilize a dog, before or after a period.', 3),
('2023-05-09', 'Panleukopenia', 'Мy kitten got sick, he does not want to eat or drink water. The vet suspects panleukopenia despite the negative test. I am asking for your experience.', 8);

INSERT INTO project.blog_post_answers
(parent_id, reply, blogpostconsid, usersid)
VALUES(1, 'Royal Canin', 5, 1),
(2, 'Did you change his food?', 6, 2),
(3, 'before a period', 7, 3),
(4, 'seek advice from another vet!', 8, 1);

INSERT INTO project.pet_cares
(title, description, dateending, usersid, vetcentersid, start_date)
VALUES('Naslov','Moeto mace ima problemi povraka i ima dijareja. Ve molam da ostane kaj vas 3 dena','2023-07-22', 1, 4, '2023-07-19'),
('Naslov','Sakam da go kastriram moeto kuce','2023-08-10', 2, 5,'2023-08-10'),
('Naslov','Zagrizena sum za mojot papagal moze li da go pricuvate 6 dena', '2023-06-18', 3, 6,'2023-06-24');

INSERT INTO project.type_of_pets
(description, kind_of_pet)
VALUES('mace', 'Cat'),
('kuce', 'Dog'),
('papagal', 'Parrot');

INSERT INTO project.pet_status
("type", node)
VALUES('received', 'admitted for examination'),
('weiting','waiting for his turn'),
('weiting','waiting for surgery'),
('received','admitted to surgery'),
('recovers','');

INSERT INTO project.pets
(color, description, dateofbirthday, usersid, typeofpetsid, petstatusid,"name", petcares)
VALUES('white', 'Scottish Fold silver chincilla', '2022-05-20', 1, 1, 1,'Lana',1),
('grey', 'Persian long hair', '2021-06-16', 2, 2, 3,'Riki',2),
('brown', 'Large brown eyes, hanging ears,', '2020-12-30', 3, 3, 2, 'Boba',3);


INSERT INTO project.pet_galery
(picture, petsid)
VALUES('https://thumbs.dreamstime.com/z/scottish-fold-cat-special-friendly-cat-breed-famous-their-folded-little-ears-their-extremely-affectionate-139562562.jpg', 1),
('https://cyprusanimals.files.wordpress.com/2011/08/persian.jpg',2),
('https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcTHiFuem-8UxpTNsp3uo1tFYNScsL7CBOPO6hIn5-2XIwzVVI7N',3);


INSERT INTO project.reports
(description, usersid, petsid)
VALUES('Аfter receiving therapy for vomiting and diarrhea, the kitten is better, we will monitor his condition', 8, 1),
('Тhe dog passed the castration well', 8, 2),
('Feel better', 8, 3);

INSERT INTO project."diagnostics"
(description, usersid, vetcenterid)
VALUES('Diarrhea and vomiting', 8,4),
('Castration', 8,5),
('Urinary problems', 8,6);

INSERT INTO project.manufacturers
(name,description, city, state)
VALUES('Sunvet PharmaPrivate','We are themanufacturer of Pharmaceutical Injection', 'Belgrade', 'Serbian'),  
('Macwell Pharmaceuticals Pvt. Ltd','we believe to work according to international quality standards and process reliable','Frankfurt', 'Germany'), --FORTAN,
('SAM S FIELD','Top quality', 'Nuremberg', 'Germany'),
('MMG Healthcare','We are offering Veterinary Injections in both wet and dry formulations. ', 'Nuremberg', 'Germany');



INSERT INTO project.medecines
(name,description, diagnosticsid, manufacturersid)
VALUES('Biomix','Vitamin concentrate for cats with a high content of essential amino acids, vitamins, minerals, trace elements, as ideal as a supplement when feeding cats with raw food.', 1, 1),
('Fortan','For quality, shiny and beautiful fur',2,2),
('Sam ''s field','Functional semi-moist soft snacks for dogs with a reduced percentage of fat, to stimulate the digestive system and to improve skin and fur',3,3);


INSERT INTO project.therapy
(description, appoitmentdate, diagnosticsid, pet_statusid)
VALUES('antibiotic', '2023-12-12', 3, 1),
('anesthesiac', '2022-10-09', 2, 3),
('vitamins', '2023-07-06', 1, 5),
('antibiotic', '2023-10-12', 3, 1);


INSERT INTO project.breeds
("name")
VALUES('scottishfold'),
('beagle'),
('poodle');

INSERT INTO project.products
("name", description, price, isactive, dateadded, category,available_quantity)
VALUES('CAT ROYALE','High quality premium clamping cat litter ', '7 euro', true, '2022-10-09', 'Hygiene and cosmetics', 50),
('Superior Care','Intended for white breed dogs to support full vision function', '3.50 euro', true, '2022-10-08', 'Dietary supplements',100),
('Lifestyle','Intended for adult cats over 1 year of age with a sensitive digestive system', '4.40 euro', true, '2022-10-09', 'Dietary supplements',40),
('Veterinary necklacke', 'for protection', '2 euro', 'false', '2022-10-09', 'Hygiene and cosmetics',0);

INSERT INTO project.orders
(quantity,userid)
VALUES(3,1),
(10,2),
(5,3);

INSERT INTO project.pets_visit_vet_centers
(id_pets, id_vet_centers)
VALUES(1, 4),
(2,5),
(3,6);


INSERT INTO project.product_are_made_orders
(id_products, id_orders)
VALUES(1, 4),
(2,5),
(3,6);



INSERT INTO project.products_there_are_for_typepets
(id_typeofpets, id_products)
VALUES(1, 1),
(2, 2),
(3, 1);



INSERT INTO project.therapy_takes_pets
(id_therapy, id_pets)
VALUES(1, 3),
(2, 2),
(1, 1),
(3, 2);

INSERT INTO project.diagnostics_established_pets
(id_diagnostics, id_pets)
VALUES(1, 1),
(2, 2),
(3, 3);



   INSERT INTO project.users
("name", lastname, email, "password", "number", role_id, jobs_id)
VALUES('Nika', 'Nikova', 'nika12@yahoo.com', 'Nika1!', '334455', 3, null);


INSERT INTO project.users
("name", lastname, email, "password", "number", role_id, jobs_id)
VALUES('elenaaadmin', 'elenaadminn', 'elenaadminn12@yahoo.com', 'Elena11!', '445546666', 1, null);

INSERT INTO project.users
("name", lastname, email, "password", "number", role_id, jobs_id)
VALUES('test12', 'test222', 'ttel@yahoo.com', '', '445756666', 2, null);