
delete from REZERVACIJA_USLUGI;
delete from VRABOTENI_USLUGI;
delete from TERMIN;
delete from REZERVACIJA;
delete from BEAUTYCENTER;
delete from UPLATA;
delete from OCENA;
delete from USLUGI;
delete from KLIENTI;
delete from VRABOTENI;
	  
insert into klienti(User_ID,ime,prezime,tel_br,e_mail) values
   (1, 'Marija', 'Siljanovska', '075224114', 'siljanovskam@gmail.com'),
   (4, 'Lence', 'Kuzmanoska', '078988753', 'lenka22@gmail.com'),
   (5, 'Stefanija', 'Siljanovska', '075777888', 'siljanovskastefi@gmail.com'),
    (6, 'Matea', 'Simik', '078666666', 'matea_1@gmail.com');
 	
   
insert into beautycenter(Salon_ID, Adresa, Tel_br, E_mail) values 
	('P1106', 'bul. Partizanski Odredi br.60', '02/345331', 'bc@gmail.com'),
	('I2201', 'bul.Teodosij Gologanov br.80/2', '02/778855', 'bcilindenska@gmail.com');
	

  insert into vraboteni(User_ID, first_name, middle_name, prezime, e_mail, tel_br,rab_iskustvo,salon_id,raboti_od, raboti_do) 
 values (2, 'Tamara', '', 'Simikj', 'simiktt@gmail.com', '076555444',2,'P1106','2021-04-26',null),
		(3, 'Teona', 'Ana','Atanasova', 'teonaat@gmail.com', '071219555',null,'I2201','2021-11-11',null ),
	 	(7, 'Jovan', 'Joce', 'Jovanovski', 'jovanovvj@gmail.com', '074568954',3,'P1106','2020-05-01','2022-02-10'),
	    (8, 'Mite', '','Mitrev', 'mitrevm@gmail.com', '072678987',null,'P1106','2020-08-02',null),
	   	(9, 'Ivana','','Todorovska','todorovska1@yahoo.com','071456988',null,'I2201','2021-10-15',null ),
	   	(10,'Sara','','Mitrevska','saram@hotmail.com','076543214',1,'I2201','2021-02-05','2021-12-05' );
	  

insert into uplata(informacii) values 
 ('Izvrsena e uplata za frizerska usluga'),
 ('Izvrsena e uplata za sminkerska usluga'),
 ('Online uplata'),
 ('Online uplata2') , 
 ('uspesno realizirana uplata'),
 ('Uplata za termin9'),
 ('Uplata za termin11'),
 ('Uplata za termin13'),
 ('Uplata za termin14'),
 ('Uplata za termin17');
 

 insert into termini( pocetok, vremetraenje,User_ID_vraboten) values 
	('2022-01-15 10:00:00',2,2),
    ('2022-01-15 12:00:00', null ,3),
	('2022-02-15 13:00:00',1,2),
    ('2022-03-10 13:30:00', null ,3),
	('2021-04-04 10:00:00',1,8),
	('2021-08-10 13:40:00',3,8),
	('2021-07-18 17:30:00',3,9),
	('2020-12-12 15:00:00',1,9),
	('2020-12-12 12:15:00',null,10),
	('2022-01-25 08:00:00',5,10),
	('2020-05-03 18:10:00',4,7),
	('2020-05-04 09:30:00',1,7),
	('2021-06-29 11:20:00',2,7),
	('2022-04-04 13:00:00',1,8),
	('2022-05-05 10:00:00',1,8),
	('2022-06-20 15:00:00',2,8),
	('2022-08-10 13:30:00',3,8),
	('2022-07-19 12:30:00',3,9),
	('2022-09-10 08:15:00',4,9),
	('2022-12-12 15:00:00',1,9),
	('2022-12-12 12:15:00',null,10),
	('2022-10-10 10:10:00',1,10),
	('2022-10-12 12:15:00',null,2),
	('2022-10-05 16:10:00',2,3),
	('2022-11-25 08:00:00',5,2),
	('2022-05-03 18:10:00',4,7),
	('2022-05-04 09:30:00',1,7),
	('2022-06-29 11:20:00',2,7);
	
insert into rezervacija(User_ID_klient,Termin_ID,Uplata_ID,User_ID_vraboten) values  
  (1,1,2,2),
  (1,2,1,3),
  (6,3,3,2),
  (5,4,null,3),
  (6,5,4,8),
  (6,6,5,8),
  (4,8,null,9),
  (1,9,6,10),
  (4,10,null,10),
  (6,11,7,7),
  (5,12,null,7),
  (1,13,8,7),
  (4,14,9,8),
  (6,15,null,8),
  (5,16,null,8),
  (4,17,10,8);

insert into uslugi(usluga_id, dejnost, cena) values 
	('F12default', 'Frizerska', '500'),
	('S22def', 'Sminkerska', '1000'),
	('M32', 'Masaza', '900'),
	('T42lash', 'Lash Lifting', '1200');


insert into ocena(vrednost, komentar,User_ID_klient,Usluga_ID,br_rez) values  ---- termini 1 -28 klienti 1,4,5,6  vraboteni 2,3,7,8,9,10
	(5,  'Mnogu sum zadovolna od uslugata',4,'F12default',null),
	(3, 'Super bese se, no vrabotenite mnogu ozboruvaa',1,'S22def',null),
	(4,  'Zadovolna od uslugata',6,'F12default',null),
	(3, 'Nisto posebno',5,'T42lash',null),
	(5, 'Odlicno',1,'T42lash',null),
	(5, 'Odlicno',4,'M32',null),
	(2, 'Loso',6,'M32',null),
	(5, 'Odlicno',4,'M32',null),
	(4, 'Odlicno',5,'F12default',null),
	(5, 'Odlicni ste',1,'S22def',null),
	(3, 'Pomalku od ocekuvanoto',5,'S22def',null);

  insert into vraboteni_uslugi(User_ID_vraboten,Usluga_ID)
  values 	(3,'S22def'),
			(3,'T42lash'),
			(2,'T42lash'),
      	    (2,'F12default'),
      	   (7,'S22def'),
			(8,'M32'),
			(9,'T42lash'),
      	    (10,'F12default');
      	
insert into rezervacija_uslugi(Br_rez, Usluga_ID) -- rez 1-16   
values (1,'F12default'),
		(1,'T42lash'),
		(2,'S22def'),
		(2,'T42lash'),
		(3 , 'T42lash'),		
		(4, 'T42lash'),
		(5, 'M32'),
		(6, 'M32'),
		(7, 'T42lash'),
		(8, 'F12default'),
	    (9, 'F12default'),
	    (10, 'S22def'),
	    (11, 'S22def'),
	    (12, 'S22def'),
	    (13, 'M32'),
	     (14, 'M32'),
	     (15, 'M32'),
	     (16, 'M32');
	



