Changes between Version 11 and Version 12 of UseCase212034
- Timestamp:
- 12/27/23 23:11:38 (11 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCase212034
v11 v12 8 8 {{{#!div style="font-size: 80%" 9 9 {{{#!sql 10 insert into Lugje(l_ime, l_prezime, l_email, l_adresa, l_telefon, l_is_admin, l_lozinka)11 values ('petar ', 'gruevski', 'petar@gmail.com', 'dracevo', '072261214',false, 'tt');10 insert into Korisnik (k_ime, k_adresa, k_telefon, k_email, k_embg, k_is_admin, k_lozinka) 11 values ('petar gruevski', 'dracevo', '072261214', 'petar@gmail.com','1010110100101' ,false, 'tt'); 12 12 13 13 insert into Vozac(l_id); … … 16 16 17 17 18 {{{#!div style="font-size: 80%"19 {{{#!sql20 insert into Dokument(d_broj_na_dok, d_koj_go_izdal, d_datum_izd, d_datum_ist, l_id)21 values ('A012345', 'MVR test', '2022-12-22', '2027-12-21', 5);22 }}}23 }}}24 25 18 26 19 [[Image(registracija_212034.2.png)]] 27 20 28 [[Image(VnesDokument_212034.png)]]29 21 30 22 === Чекор 2: Најава на патник … … 32 24 {{{#!div style="font-size: 80%" 33 25 {{{#!sql 34 select l_id from project. Lugje where l_email = 'test@test.com' and l_lozinka = 'tt';26 select l_id from project.Korisnik where k_email = 'test@test.com' and k_lozinka = 'tt'; 35 27 }}} 36 28 }}} … … 43 35 {{{#!div style="font-size: 80%" 44 36 {{{#!sql 45 select li_id from DnevniRuti46 join Linija on DnevniRuti.li_id37 select li_id from InstancaNaLinija 38 join Linija on InstancaNaLinija.inl_id 47 39 }}} 48 40