
	    
insert into apartment_owner(ownerid)
values  (1),
		(2),
		(3);

insert into administrator(adminid,adminrole)
values  (4,'mod'),
		(5,'mod'),
		(6,'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(facultyname,cityname)	
values  ('FINKI','Skopje'),
		('PMF','Skopje'),
		('Gastronomija','Ohrid');
		
insert into student(studentid,facultyid,age,gender)
values  (2,1,21,'male'),
		(1,1,21,'male');
	

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

insert into student_signs(studentid,agreementid)
values  (2,3),
		(1,3);
		
insert into student_signs(studentid,agreementid)
values  (2,4),
		(1,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 owner_post(owner_postid,apartmentid,ownerid)
values  (2,4,1),
		(3,5,2);
insert into owner_post(owner_postid,apartmentid,ownerid)
values  (6,6,3);

insert into apartment_photos(postid,photosurl)		
values  (2,'link1'),
		(3,'link3');
insert into apartment_photos(postid,photosurl)		
values  (6,'link4');

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

insert into moderates_posts_for(cityname,adminid)
values  ('Skopje',4),
		('Skopje',5),
		('Stip',6);
		

		


