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 |
|
---|