1 | INSERT INTO project.Bank (BankIme) VALUES
|
---|
2 | ('НЛБ Банка АД Скопје'),
|
---|
3 | ('Стопанска Банка АД Скопје'),
|
---|
4 | ('HALKBANK АД Скопје')
|
---|
5 | ;
|
---|
6 |
|
---|
7 | INSERT INTO project.DDV (ddvVal) VALUES
|
---|
8 | (0),
|
---|
9 | (5),
|
---|
10 | (18)
|
---|
11 | ;
|
---|
12 |
|
---|
13 | INSERT INTO project.Grad (GradIme, PostBroj) VALUES
|
---|
14 | ('Скопје', 1000),
|
---|
15 | ('Битола', 7000),
|
---|
16 | ('Прилеп', 7500)
|
---|
17 | ;
|
---|
18 |
|
---|
19 | INSERT INTO project.Klient (KlientIme, Adresa, GradID, Phone, EMail, EDB) VALUES
|
---|
20 | ('Анхоч ДООЕЛ', 'Мирче Ацев 100', 1, '023296655', 'prodazba@anhoch.com', '4030992216019'),
|
---|
21 | ('СЕТЕК Се од Техника ДООЕЛ', 'Улица 1523', 1, '023080877', 'b2b@setec.mk', '4057009501106'),
|
---|
22 | ('НЕПТУН МАКЕДОНИЈА ДОО', 'Петар Петровиќ Његош 144', 2, '047242114', 'kontakt@neptun.mk', '4080019583676')
|
---|
23 | ;
|
---|
24 |
|
---|
25 | INSERT INTO project.TipDok VALUES
|
---|
26 | (10, 'Влезни Фактури'),
|
---|
27 | (20, 'Излезни Фактури'),
|
---|
28 | (120, 'Профактури')
|
---|
29 | ;
|
---|
30 |
|
---|
31 | INSERT INTO project.Vraboteni (Username, Password, Email, DisplayName, isAdmin) VALUES
|
---|
32 | ('vrab12', 'vrab123' ,'' ,'Vraboten#12' , false),
|
---|
33 | ('admin', 'admin123' ,'admin@admin.com' ,'' , true),
|
---|
34 | ('test', 'test123' ,'' ,'' , false)
|
---|
35 | ;
|
---|
36 |
|
---|
37 | INSERT INTO project.Artikal (Sifra, Artikal_Ime, Cena, CenaSoDDV, ddvID) VALUES
|
---|
38 | ('16000', 'Dell Inspiron 14', 15600, 18408, 3),
|
---|
39 | ('16001', 'HP Victus 15', 18000, 21240, 3),
|
---|
40 | ('16002', 'ASUS VivoBook 15', 19000, 22420, 3)
|
---|
41 | ;
|
---|
42 |
|
---|
43 | INSERT INTO project.ZiroSmetki (KlientID, BankID, Broj) VALUES
|
---|
44 | (1, 3, '210070946040141'),
|
---|
45 | (2, 1, '210061554210112'),
|
---|
46 | (3, 2, '300000001749231')
|
---|
47 | ;
|
---|
48 |
|
---|
49 | INSERT INTO project.Stavka (TipID, Created_By, Datum, Broj, KlientID, Cena_Osnova, Cena_DDV, Cena_Vkupno) VALUES
|
---|
50 | (10, 1, '2022-10-27', 22, 1, 16000, 2800, 18880),
|
---|
51 | (20, 3, '2022-10-30', 26, 3, 23000, 4140, 27140),
|
---|
52 | (20, 3, '2022-10-31', 30, 2, 22000, 3960, 18880)
|
---|
53 | ;
|
---|
54 |
|
---|
55 | INSERT INTO project.LagerList (StavkaID, Artikal_ID, Kolicina, Avg_Cena) VALUES
|
---|
56 | (1, 2, 2, 16000),
|
---|
57 | (2, 1, 2, 18000),
|
---|
58 | (3, 3, 2, 19000)
|
---|
59 | ; |
---|