| 1 |
|
|---|
| 2 | delete from REZERVACIJA_USLUGI;
|
|---|
| 3 | delete from VRABOTENI_USLUGI;
|
|---|
| 4 | delete from TERMIN;
|
|---|
| 5 | delete from REZERVACIJA;
|
|---|
| 6 | delete from BEAUTYCENTER;
|
|---|
| 7 | delete from UPLATA;
|
|---|
| 8 | delete from OCENA;
|
|---|
| 9 | delete from USLUGI;
|
|---|
| 10 | delete from KLIENTI;
|
|---|
| 11 | delete from VRABOTENI;
|
|---|
| 12 | delete from USERS;
|
|---|
| 13 |
|
|---|
| 14 |
|
|---|
| 15 | insert into users(username,upassword)
|
|---|
| 16 | values ('m_siljan', 'masil123'),
|
|---|
| 17 | ('simikt', 'tams123'),
|
|---|
| 18 | ('teonaana', 'anateona#'),
|
|---|
| 19 | ('kuzlence', 'lenka22'),
|
|---|
| 20 | ('stefiS', 'stefi123'),
|
|---|
| 21 | ('mateass', 'matea123'),
|
|---|
| 22 | ('jovanJov','jovan123'),
|
|---|
| 23 | ('MitrevM', 'mite123'),
|
|---|
| 24 | ('Ivana_t','ivana123'),
|
|---|
| 25 | ('Sara.ss','sara123');
|
|---|
| 26 |
|
|---|
| 27 | insert into klienti(User_ID,ime,prezime,tel_br,e_mail) values
|
|---|
| 28 | (1, 'Marija', 'Siljanovska', '075224114', 'siljanovskam@gmail.com'),
|
|---|
| 29 | (4, 'Lence', 'Kuzmanoska', '078988753', 'lenka22@gmail.com'),
|
|---|
| 30 | (5, 'Stefanija', 'Siljanovska', '075777888', 'siljanovskastefi@gmail.com'),
|
|---|
| 31 | (6, 'Matea', 'Simik', '078666666', 'matea_1@gmail.com');
|
|---|
| 32 |
|
|---|
| 33 |
|
|---|
| 34 | insert into beautycenter(Salon_ID, Adresa, Tel_br, E_mail) values
|
|---|
| 35 | ('P1106', 'bul. Partizanski Odredi br.60', '02/345331', 'bc@gmail.com'),
|
|---|
| 36 | ('I2201', 'bul.Teodosij Gologanov br.80/2', '02/778855', 'bcilindenska@gmail.com');
|
|---|
| 37 |
|
|---|
| 38 |
|
|---|
| 39 | insert into vraboteni(User_ID, first_name, middle_name, prezime, e_mail, tel_br,rab_iskustvo,salon_id,raboti_od, raboti_do)
|
|---|
| 40 | values (2, 'Tamara', '', 'Simikj', 'simiktt@gmail.com', '076555444',2,'P1106','2021-04-26',null),
|
|---|
| 41 | (3, 'Teona', 'Ana','Atanasova', 'teonaat@gmail.com', '071219555',null,'I2201','2021-11-11',null ),
|
|---|
| 42 | (7, 'Jovan', 'Joce', 'Jovanovski', 'jovanovvj@gmail.com', '074568954',3,'P1106','2020-05-01','2022-02-10'),
|
|---|
| 43 | (8, 'Mite', '','Mitrev', 'mitrevm@gmail.com', '072678987',null,'P1106','2020-08-02',null),
|
|---|
| 44 | (9, 'Ivana','','Todorovska','todorovska1@yahoo.com','071456988',null,'I2201','2021-10-15',null ),
|
|---|
| 45 | (10,'Sara','','Mitrevska','saram@hotmail.com','076543214',1,'I2201','2021-02-05','2021-12-05' );
|
|---|
| 46 |
|
|---|
| 47 |
|
|---|
| 48 | insert into uplata(informacii) values
|
|---|
| 49 | ('Izvrsena e uplata za frizerska usluga'),
|
|---|
| 50 | ('Izvrsena e uplata za sminkerska usluga'),
|
|---|
| 51 | ('Online uplata'),
|
|---|
| 52 | ('Online uplata2') ,
|
|---|
| 53 | ('uspesno realizirana uplata'),
|
|---|
| 54 | ('Uplata za termin9'),
|
|---|
| 55 | ('Uplata za termin11'),
|
|---|
| 56 | ('Uplata za termin13'),
|
|---|
| 57 | ('Uplata za termin14'),
|
|---|
| 58 | ('Uplata za termin17');
|
|---|
| 59 |
|
|---|
| 60 |
|
|---|
| 61 | insert into termini( pocetok, vremetraenje,User_ID_vraboten) values
|
|---|
| 62 | ('2022-01-15 10:00:00',2,2),
|
|---|
| 63 | ('2022-01-15 12:00:00', null ,3),
|
|---|
| 64 | ('2022-02-15 13:00:00',1,2),
|
|---|
| 65 | ('2022-03-10 13:30:00', null ,3),
|
|---|
| 66 | ('2021-04-04 10:00:00',1,8),
|
|---|
| 67 | ('2021-08-10 13:40:00',3,8),
|
|---|
| 68 | ('2021-07-18 17:30:00',3,9),
|
|---|
| 69 | ('2020-12-12 15:00:00',1,9),
|
|---|
| 70 | ('2020-12-12 12:15:00',null,10),
|
|---|
| 71 | ('2022-01-25 08:00:00',5,10),
|
|---|
| 72 | ('2020-05-03 18:10:00',4,7),
|
|---|
| 73 | ('2020-05-04 09:30:00',1,7),
|
|---|
| 74 | ('2021-06-29 11:20:00',2,7),
|
|---|
| 75 | ('2022-04-04 13:00:00',1,8),
|
|---|
| 76 | ('2022-05-05 10:00:00',1,8),
|
|---|
| 77 | ('2022-06-20 15:00:00',2,8),
|
|---|
| 78 | ('2022-08-10 13:30:00',3,8),
|
|---|
| 79 | ('2022-07-19 12:30:00',3,9),
|
|---|
| 80 | ('2022-09-10 08:15:00',4,9),
|
|---|
| 81 | ('2022-12-12 15:00:00',1,9),
|
|---|
| 82 | ('2022-12-12 12:15:00',null,10),
|
|---|
| 83 | ('2022-10-10 10:10:00',1,10),
|
|---|
| 84 | ('2022-10-12 12:15:00',null,2),
|
|---|
| 85 | ('2022-10-05 16:10:00',2,3),
|
|---|
| 86 | ('2022-11-25 08:00:00',5,2),
|
|---|
| 87 | ('2022-05-03 18:10:00',4,7),
|
|---|
| 88 | ('2022-05-04 09:30:00',1,7),
|
|---|
| 89 | ('2022-06-29 11:20:00',2,7);
|
|---|
| 90 |
|
|---|
| 91 | insert into rezervacija(User_ID_klient,Termin_ID,Uplata_ID,User_ID_vraboten) values
|
|---|
| 92 | (1,1,2,2),
|
|---|
| 93 | (1,2,1,3),
|
|---|
| 94 | (6,3,3,2),
|
|---|
| 95 | (5,4,null,3),
|
|---|
| 96 | (6,5,4,8),
|
|---|
| 97 | (6,6,5,8),
|
|---|
| 98 | (4,8,null,9),
|
|---|
| 99 | (1,9,6,10),
|
|---|
| 100 | (4,10,null,10),
|
|---|
| 101 | (6,11,7,7),
|
|---|
| 102 | (5,12,null,7),
|
|---|
| 103 | (1,13,8,7),
|
|---|
| 104 | (4,14,9,8),
|
|---|
| 105 | (6,15,null,8),
|
|---|
| 106 | (5,16,null,8),
|
|---|
| 107 | (4,17,10,8);
|
|---|
| 108 |
|
|---|
| 109 | insert into uslugi(usluga_id, dejnost, cena) values
|
|---|
| 110 | ('F12default', 'Frizerska', '500'),
|
|---|
| 111 | ('S22def', 'Sminkerska', '1000'),
|
|---|
| 112 | ('M32', 'Masaza', '900'),
|
|---|
| 113 | ('T42lash', 'Lash Lifting', '1200');
|
|---|
| 114 |
|
|---|
| 115 |
|
|---|
| 116 | 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
|
|---|
| 117 | (5, 'Mnogu sum zadovolna od uslugata',4,'F12default',null),
|
|---|
| 118 | (3, 'Super bese se, no vrabotenite mnogu ozboruvaa',1,'S22def',null),
|
|---|
| 119 | (4, 'Zadovolna od uslugata',6,'F12default',null),
|
|---|
| 120 | (3, 'Nisto posebno',5,'T42lash',null),
|
|---|
| 121 | (5, 'Odlicno',1,'T42lash',null),
|
|---|
| 122 | (5, 'Odlicno',4,'M32',null),
|
|---|
| 123 | (2, 'Loso',6,'M32',null),
|
|---|
| 124 | (5, 'Odlicno',4,'M32',null),
|
|---|
| 125 | (4, 'Odlicno',5,'F12default',null),
|
|---|
| 126 | (5, 'Odlicni ste',1,'S22def',null),
|
|---|
| 127 | (3, 'Pomalku od ocekuvanoto',5,'S22def',null);
|
|---|
| 128 |
|
|---|
| 129 | insert into vraboteni_uslugi(User_ID_vraboten,Usluga_ID)
|
|---|
| 130 | values (3,'S22def'),
|
|---|
| 131 | (3,'T42lash'),
|
|---|
| 132 | (2,'T42lash'),
|
|---|
| 133 | (2,'F12default'),
|
|---|
| 134 | (7,'S22def'),
|
|---|
| 135 | (8,'M32'),
|
|---|
| 136 | (9,'T42lash'),
|
|---|
| 137 | (10,'F12default');
|
|---|
| 138 |
|
|---|
| 139 | insert into rezervacija_uslugi(Br_rez, Usluga_ID) -- rez 1-16
|
|---|
| 140 | values (1,'F12default'),
|
|---|
| 141 | (1,'T42lash'),
|
|---|
| 142 | (2,'S22def'),
|
|---|
| 143 | (2,'T42lash'),
|
|---|
| 144 | (3 , 'T42lash'),
|
|---|
| 145 | (4, 'T42lash'),
|
|---|
| 146 | (5, 'M32'),
|
|---|
| 147 | (6, 'M32'),
|
|---|
| 148 | (7, 'T42lash'),
|
|---|
| 149 | (8, 'F12default'),
|
|---|
| 150 | (9, 'F12default'),
|
|---|
| 151 | (10, 'S22def'),
|
|---|
| 152 | (11, 'S22def'),
|
|---|
| 153 | (12, 'S22def'),
|
|---|
| 154 | (13, 'M32'),
|
|---|
| 155 | (14, 'M32'),
|
|---|
| 156 | (15, 'M32'),
|
|---|
| 157 | (16, 'M32');
|
|---|
| 158 |
|
|---|
| 159 |
|
|---|
| 160 |
|
|---|
| 161 |
|
|---|
