
	    
insert into apartment_owner(ownerid)
values  (11),
		(12),
		(13);

insert into administrator(adminid,adminrole)
values  (9,'mod'),
		(10,'mod');
		
insert into city(cityname)	
values  ('Skopje'),	
        ('Veles'),	
        ('Ohrid'),	
        ('Kumanovo'),	
        ('Stip');	
       
insert into building(cityname,building_adress)	
values  ('Skopje','Blaze Koneski 10'),	
        ('Skopje','Gologanov 24'),	
        ('Ohrid', 'Rade Koncar 1'),	
        ('Kumanovo', 'Gologanov 3'),	
        ('Stip', 'Kiro Gligorov 3');
		
insert into faculty(cityname,fname)	
values  ('Skopje','FINKI'),
		('Skopje','FEIT'),
		('Ohrid','FTU');
		
insert into student(studentid,facultyid,age,gender)
values  (9,1,21,'male'),
		(10,1,21,'male');
	

insert into apartment(buildingid,ownerid,apartment_adress,apartment_size)
values  (1,11,'Vlez 4 Stan 3','60m2'),
		(2,12,'Vlez 1 Stan 12','55m2'),
		(3,13,'Vlez 3 Stan 6','70m2');
insert into apartment_agreement(apartmentid,ownerid,studentid,date_signed,date_expires,apartment_rent)
values  (4,11,9,TO_DATE('10/09/2022', 'DD/MM/YYYY'),TO_DATE('30/06/2023', 'DD/MM/YYYY'),250),
		(5,12,10,TO_DATE('10/09/2022', 'DD/MM/YYYY'),TO_DATE('30/06/2023', 'DD/MM/YYYY'),300);
insert into apartment_agreement(apartmentid,ownerid,studentid,date_signed,date_expires,apartment_rent)
values  (4,11,10,TO_DATE('10/09/2022', 'DD/MM/YYYY'),TO_DATE('30/06/2023', 'DD/MM/YYYY'),250);

insert into student_signs(studentid,agreementid)
values  (9,3),
		(10,3)
		
insert into student_signs(studentid,agreementid)
values  (10,4),
		(10,5);

insert into post(cityname,number_of_roommates,price,date_posted,description)
values  ('Skopje',2,250,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'baram cimer'),
 		('Skopje',2,300,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan'),
 		('Skopje',2,300,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan'),
		('Skopje',2,300,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'baram cimer');


		
insert into post(cityname,number_of_roommates,price,date_posted,description)
values  ('Skopje',3,250,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'baram cimeri');
insert into post(cityname,number_of_roommates,price,date_posted,description)
values  ('Ohrid',4,400,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan');

insert into apartment_photos(photosurl)		
values  ('link1'),
		('link2'),
		('link3');
insert into apartment_photos(photosurl)		
values  ('link4');
		
insert into owner_post(owner_postid,apartmentid,ownerid,apartment_photos)
values  (2,4,11,1),
		(3,5,12,2);
insert into owner_post(owner_postid,apartmentid,ownerid,apartment_photos)
values  (6,6,11,4)

insert into student_post(student_postid,studentid)
values  (1,9),
		(4,10);
insert into student_post(student_postid,studentid)
values  (5,9);

insert into moderates_posts_for(cityname,adminid)
values  ('Skopje',9),
		('Skopje',10),
		('Stip',9),
		('Veles',10);
		

		


