| 1 | insert into appuser(ime,prezime,pass,phone_number,city_of_residency,datumragj)
|
|---|
| 2 | values ('Filip','Trajkovski','ft12','111-111-111','Skopje',TO_DATE('15/04/2001', 'DD/MM/YYYY')),
|
|---|
| 3 | ('Blagoja','Nikolovski','bn12','111-111-111','Skopje',TO_DATE('01/01/2001', 'DD/MM/YYYY')),
|
|---|
| 4 | ('Darko','Nikolov','dn23','123-234-444','Ohrid',TO_DATE('02/06/1979', 'DD/MM/YYYY')),
|
|---|
| 5 | ('Aleksandar','Aleksandrov','aa23','222-222-222','Veles',TO_DATE('05/05/1994', 'DD/MM/YYYY')),
|
|---|
| 6 | ('Ana','Ristova','ar23','444-222-111','Bitola',TO_DATE('11/12/1989', 'DD/MM/YYYY'));
|
|---|
| 7 |
|
|---|
| 8 | insert into apartment_owner(ownerid)
|
|---|
| 9 | values (11),
|
|---|
| 10 | (12),
|
|---|
| 11 | (13);
|
|---|
| 12 |
|
|---|
| 13 | insert into administrator(adminid,adminrole)
|
|---|
| 14 | values (9,'mod'),
|
|---|
| 15 | (10,'mod');
|
|---|
| 16 |
|
|---|
| 17 | insert into city(cityname)
|
|---|
| 18 | values ('Skopje'),
|
|---|
| 19 | ('Veles'),
|
|---|
| 20 | ('Ohrid'),
|
|---|
| 21 | ('Kumanovo'),
|
|---|
| 22 | ('Stip');
|
|---|
| 23 |
|
|---|
| 24 | insert into building(cityname,building_adress)
|
|---|
| 25 | values ('Skopje','Blaze Koneski 10'),
|
|---|
| 26 | ('Skopje','Gologanov 24'),
|
|---|
| 27 | ('Ohrid', 'Rade Koncar 1'),
|
|---|
| 28 | ('Kumanovo', 'Gologanov 3'),
|
|---|
| 29 | ('Stip', 'Kiro Gligorov 3');
|
|---|
| 30 |
|
|---|
| 31 | insert into faculty(cityname,fname)
|
|---|
| 32 | values ('Skopje','FINKI'),
|
|---|
| 33 | ('Skopje','FEIT'),
|
|---|
| 34 | ('Ohrid','FTU');
|
|---|
| 35 |
|
|---|
| 36 | insert into student(studentid,facultyid,age,gender)
|
|---|
| 37 | values (9,1,21,'male'),
|
|---|
| 38 | (10,1,21,'male');
|
|---|
| 39 |
|
|---|
| 40 |
|
|---|
| 41 | insert into apartment(buildingid,ownerid,apartment_adress,apartment_size)
|
|---|
| 42 | values (1,11,'Vlez 4 Stan 3','60m2'),
|
|---|
| 43 | (2,12,'Vlez 1 Stan 12','55m2'),
|
|---|
| 44 | (3,13,'Vlez 3 Stan 6','70m2');
|
|---|
| 45 | insert into apartment_agreement(apartmentid,ownerid,studentid,date_signed,date_expires,apartment_rent)
|
|---|
| 46 | values (4,11,9,TO_DATE('10/09/2022', 'DD/MM/YYYY'),TO_DATE('30/06/2023', 'DD/MM/YYYY'),250),
|
|---|
| 47 | (5,12,10,TO_DATE('10/09/2022', 'DD/MM/YYYY'),TO_DATE('30/06/2023', 'DD/MM/YYYY'),300);
|
|---|
| 48 | insert into apartment_agreement(apartmentid,ownerid,studentid,date_signed,date_expires,apartment_rent)
|
|---|
| 49 | values (4,11,10,TO_DATE('10/09/2022', 'DD/MM/YYYY'),TO_DATE('30/06/2023', 'DD/MM/YYYY'),250);
|
|---|
| 50 |
|
|---|
| 51 | insert into student_signs(studentid,agreementid)
|
|---|
| 52 | values (9,3),
|
|---|
| 53 | (10,3)
|
|---|
| 54 |
|
|---|
| 55 | insert into student_signs(studentid,agreementid)
|
|---|
| 56 | values (10,4),
|
|---|
| 57 | (10,5);
|
|---|
| 58 |
|
|---|
| 59 | insert into post(cityname,number_of_roommates,price,date_posted,description)
|
|---|
| 60 | values ('Skopje',2,250,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'baram cimer'),
|
|---|
| 61 | ('Skopje',2,300,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan'),
|
|---|
| 62 | ('Skopje',2,300,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan'),
|
|---|
| 63 | ('Skopje',2,300,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'baram cimer');
|
|---|
| 64 |
|
|---|
| 65 |
|
|---|
| 66 |
|
|---|
| 67 | insert into post(cityname,number_of_roommates,price,date_posted,description)
|
|---|
| 68 | values ('Skopje',3,250,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'baram cimeri');
|
|---|
| 69 | insert into post(cityname,number_of_roommates,price,date_posted,description)
|
|---|
| 70 | values ('Ohrid',4,400,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan');
|
|---|
| 71 |
|
|---|
| 72 | insert into apartment_photos(photosurl)
|
|---|
| 73 | values ('link1'),
|
|---|
| 74 | ('link2'),
|
|---|
| 75 | ('link3');
|
|---|
| 76 | insert into apartment_photos(photosurl)
|
|---|
| 77 | values ('link4');
|
|---|
| 78 |
|
|---|
| 79 | insert into owner_post(owner_postid,apartmentid,ownerid,apartment_photos)
|
|---|
| 80 | values (2,4,11,1),
|
|---|
| 81 | (3,5,12,2);
|
|---|
| 82 | insert into owner_post(owner_postid,apartmentid,ownerid,apartment_photos)
|
|---|
| 83 | values (6,6,11,4)
|
|---|
| 84 |
|
|---|
| 85 | insert into student_post(student_postid,studentid)
|
|---|
| 86 | values (1,9),
|
|---|
| 87 | (4,10);
|
|---|
| 88 | insert into student_post(student_postid,studentid)
|
|---|
| 89 | values (5,9);
|
|---|
| 90 |
|
|---|
| 91 | insert into moderates_posts_for(cityname,adminid)
|
|---|
| 92 | values ('Skopje',9),
|
|---|
| 93 | ('Skopje',10),
|
|---|
| 94 | ('Stip',9),
|
|---|
| 95 | ('Veles',10);
|
|---|
| 96 |
|
|---|
| 97 |
|
|---|
| 98 |
|
|---|
| 99 |
|
|---|
| 100 |
|
|---|