1 | insert into Vidovi(vid_id, vid_otsustvo)
|
---|
2 | values(1, 'Boleduvanje');
|
---|
3 | insert into Vidovi(vid_id, vid_otsustvo)
|
---|
4 | values(2, 'Godisen odmor');
|
---|
5 | insert into Vidovi(vid_id, vid_otsustvo)
|
---|
6 | values(3, 'Opravdano');
|
---|
7 | insert into Vidovi(vid_id, vid_otsustvo)
|
---|
8 | values(4, 'Neopravdano');
|
---|
9 |
|
---|
10 | insert into Firmi(f_id, f_ime, f_grad, f_email, f_telefon, f_edb, f_kontakt, f_username, f_password, f_valid)
|
---|
11 | values(1, 'MSoft', 'Kocani', 'msoft@email.com', '075555555', '4013990000000', 'Mile', 'msoft12', '111111', '2022.12.31');
|
---|
12 | insert into Firmi(f_id, f_ime, f_grad, f_email, f_telefon, f_edb, f_kontakt, f_username, f_password, f_valid)
|
---|
13 | values(2, 'SeverJug', 'Vinica', 'sever@email.com', '070555000', '4013992222222', 'Goce', 'sever15', '222222', '2023.12.31');
|
---|
14 |
|
---|
15 | insert into Oddeli(oddel_id, oddel_naziv, f_id)
|
---|
16 | values(1, 'Knigovodstvo', 1);
|
---|
17 | insert into Oddeli(oddel_id, oddel_naziv, f_id)
|
---|
18 | values(2, 'Proizvodtsvo', 1);
|
---|
19 | insert into Oddeli(oddel_id, oddel_naziv, f_id)
|
---|
20 | values(3, 'Knigovodstvo', 2);
|
---|
21 | insert into Oddeli(oddel_id, oddel_naziv, f_id)
|
---|
22 | values(4, 'Trgovija', 2);
|
---|
23 |
|
---|
24 | insert into Vraboteni(v_id, v_ime, v_prezime, v_mesto, v_telefon, v_embg, v_odmor, v_aktiven, f_id)
|
---|
25 | values(1, 'Klara', 'Manasieva', 'Kocani', '078888458', '2310987333333', 20 , 1 , 1);
|
---|
26 | insert into Vraboteni(v_id, v_ime, v_prezime, v_mesto, v_telefon, v_embg, v_odmor, v_aktiven, f_id)
|
---|
27 | values(2, 'Ana', 'Anova', null , null , '0606987666666', 22 , 1 , 1);
|
---|
28 | insert into Vraboteni(v_id, v_ime, v_prezime, v_mesto, v_telefon, v_embg, v_odmor, v_aktiven, f_id)
|
---|
29 | values(3, 'Simeon', 'Simeonov', 'Orizari' , null , '1212987222222', 18 , 1 , 1);
|
---|
30 | insert into Vraboteni(v_id, v_ime, v_prezime, v_mesto, v_telefon, v_embg, v_odmor, v_aktiven, f_id)
|
---|
31 | values(4, 'John', 'Naveed', 'London' , null , '0808987888888', 21 , 1 , 2);
|
---|
32 |
|
---|
33 | insert into Otsustva(o_id, o_datum, o_casovi, o_opis, v_id, vid_id)
|
---|
34 | values(1, '2021-03-02', 5, null, 1, 3);
|
---|
35 | insert into Otsustva(o_id, o_datum, o_casovi, o_opis, v_id, vid_id)
|
---|
36 | values(2, '2021-03-05', 3, null, 1, 4);
|
---|
37 | insert into Otsustva(o_id, o_datum, o_casovi, o_opis, v_id, vid_id)
|
---|
38 | values(3, '2021-03-03', 8, 'Povreda', 3, 1);
|
---|
39 |
|
---|
40 | insert into Vraboten_vo_oddel(vraboten_od, vraboten_do, v_id, oddel_id)
|
---|
41 | values('2020-05-01', null, 1, 1);
|
---|
42 | insert into Vraboten_vo_oddel(vraboten_od, vraboten_do, v_id, oddel_id)
|
---|
43 | values('2020-05-01', null, 4, 3);
|
---|
44 | insert into Vraboten_vo_oddel(vraboten_od, vraboten_do, v_id, oddel_id)
|
---|
45 | values('2020-08-01', null, 3, 2);
|
---|