Changes between Version 11 and Version 12 of UseCase212034


Ignore:
Timestamp:
12/27/23 23:11:38 (11 months ago)
Author:
212034
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCase212034

    v11 v12  
    88{{{#!div style="font-size: 80%"
    99  {{{#!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');
     10insert into Korisnik (k_ime, k_adresa, k_telefon, k_email, k_embg, k_is_admin, k_lozinka)
     11values ('petar gruevski', 'dracevo', '072261214', 'petar@gmail.com','1010110100101' ,false, 'tt');
    1212
    1313insert into Vozac(l_id);
     
    1616
    1717
    18 {{{#!div style="font-size: 80%"
    19   {{{#!sql
    20 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 
    2518
    2619[[Image(registracija_212034.2.png)]]
    2720
    28 [[Image(VnesDokument_212034.png)]]
    2921
    3022=== Чекор 2: Најава на патник
     
    3224{{{#!div style="font-size: 80%"
    3325  {{{#!sql
    34 select l_id from project.Lugje where l_email = 'test@test.com' and l_lozinka = 'tt';
     26select l_id from project.Korisnik where k_email = 'test@test.com' and k_lozinka = 'tt';
    3527  }}}
    3628}}}
     
    4335{{{#!div style="font-size: 80%"
    4436  {{{#!sql
    45 select li_id from DnevniRuti
    46 join Linija on DnevniRuti.li_id
     37select li_id from InstancaNaLinija
     38join Linija on InstancaNaLinija.inl_id
    4739  }}}
    4840