RelationalDesign: polnenje.sql

INSERT INTO project.Bank (BankIme) VALUES
        ('НЛБ Банка АД Скопје'),
        ('Стопанска Банка АД Скопје'),
        ('HALKBANK АД Скопје')
;

INSERT INTO project.DDV (ddvVal) VALUES
        (0),
        (5),
        (18)
;

INSERT INTO project.Grad (GradIme, PostBroj) VALUES
        ('Скопје', 1000),
        ('Битола', 7000),
        ('Прилеп', 7500)
;

INSERT INTO project.Klient (KlientIme, Adresa, GradID, Phone, EMail, EDB) VALUES
        ('Анхоч ДООЕЛ', 'Мирче Ацев 100', 1, '023296655', 'prodazba@anhoch.com', '4030992216019'),
        ('СЕТЕК Се од Техника ДООЕЛ', 'Улица 1523', 1, '023080877', 'b2b@setec.mk', '4057009501106'),
        ('НЕПТУН МАКЕДОНИЈА ДОО', 'Петар Петровиќ Његош 144', 2, '047242114', 'kontakt@neptun.mk', '4080019583676')
;

INSERT INTO project.TipDok VALUES
        (10, 'Влезни Фактури'),
        (20, 'Излезни Фактури'),
        (120, 'Профактури')
;

INSERT INTO project.Vraboteni (Username, Password, Email, DisplayName, isAdmin) VALUES
        ('vrab12', 'vrab123' ,'' ,'Vraboten#12' , false),
        ('admin', 'admin123' ,'admin@admin.com' ,'' , true),
        ('test', 'test123' ,'' ,'' , false)
;

INSERT INTO project.Artikal (Sifra, Artikal_Ime, Cena, CenaSoDDV, ddvID) VALUES
        ('16000', 'Dell Inspiron 14', 15600, 18408, 3),
        ('16001', 'HP Victus 15', 18000, 21240, 3),
        ('16002', 'ASUS VivoBook 15', 19000, 22420, 3)
;

INSERT INTO project.ZiroSmetki (KlientID, BankID, Broj) VALUES
        (1, 3, '210070946040141'),
        (2, 1, '210061554210112'),
        (3, 2, '300000001749231')
;

INSERT INTO project.Stavka (TipID, Created_By, Datum, Broj, KlientID, Cena_Osnova, Cena_DDV, Cena_Vkupno) VALUES
        (10, 1, '2022-10-27', 22, 1, 16000, 2800, 18880),
    (20, 3, '2022-10-30', 26, 3, 23000, 4140, 27140),
    (20, 3, '2022-10-31', 30, 2, 22000, 3960, 18880)
;

INSERT INTO project.LagerList (StavkaID, Artikal_ID, Kolicina, Avg_Cena) VALUES
        (1, 2, 2, 16000),
    (2, 1, 2, 18000),
    (3, 3, 2, 19000)
;