

insert into vehicle (VIN, Body, Model, P_Year, Engine, Color, Price, Status, Tax_Nr) values
('WZZ04124124', 'Motorcycle', 'BMW S1000RR', 2015, '999cc', 'white', 16600, false, 'OB15153'),
('WZZ04164123', 'Motorcycle', 'BMW S1000R', 2021, '999cc', 'blue', 21600, false, 'OB15153'),
('WZZ04574121', 'Motorcycle', 'BMW S1000RR', 2024, '999cc', 'red', 28500, false, 'OB15153'),
('WZZ13124666', 'Motorcycle', 'BMW GS310', 2017, '310cc', 'white', 8600, true, 'OB15153'),
('WPY532532EW', 'Motorcycle', 'BMW GS600', 2009, '650cc', 'blue', 5000, true, 'OB15153'),
('PEZ513532RE', 'Car', 'Mercedes E350CDI', 2001, '2998cc', 'red', 4000, false, 'OM15645'),
('PEZ778532MS', 'Car', 'Mercedes C220CDI', 2017, '1999cc', 'purple', 22000, false, 'OM15645'),
('PEZ711532TT', 'Car', 'Mercedes B180CDI', 2012, '1800cc', 'white', 13300, false, 'OM15645'),
('TZZ64127778', 'Van', 'Mercedes Viano', 2020, '2499cc', 'silver', 30000, true, 'OM15645'),
('TZZ04124124', 'Van', 'Mercedes Sprinter', 2020, '3399cc', 'white', 21000, true, 'OM15645'),
('BE135735TTW', 'Car', 'Porsche 911GT3', 2016, '3999cc', 'white', 113600, true, 'OP16262'),
('BE135175XXT', 'Car', 'Porsche 911S', 2012, '2999cc', 'blue', 80600, true, 'OP16262'),
('BE131935SSS', 'Car', 'Porsche Cayman', 2021, '2688cc', 'red', 98600, false, 'OP16262'),
('BE135135RES', 'Car', 'Porsche Cayenne', 2024, '3999cc', 'green', 144500, false, 'OP16262'),
('WQT4124215E', 'Car', 'Volkswagen Passat', 2010, '2000cc', 'magenta', 11300, false, 'OP16262'),
('WZOTY124488', 'Car', 'Mini Cooper', 2023, '1500cc', 'yellow', 35600, true, 'OB15153'),
('WZOTX129991', 'Car', 'Mini Clubman', 2007, '1800cc', 'red', 6600, true, 'OB15153'),
('WZOWR126612', 'Car', 'Mini Cooper', 2024, '1500cc', 'white', 38700, false, 'OB15153'),
('WZOTR121111', 'Car', 'Mini One', 2009, '1999cc', 'blue', 5100, true, 'OB15153'),
('WZOTW126311', 'Car', 'BMW 123d', 2009, '1999cc', 'white', 8900, true, 'OB15153'),
('WZTTR112451', 'Car', 'BMW 330d', 2024, '2999cc', 'red', 87000, true, 'OB15153'),
('WZWTR176789', 'Car', 'BMW 530d', 2017, '2999cc', 'white', 55100, false, 'OB15153'),
('WVCR5332531', 'Van', 'VW Crafter', 2007, '3000cc', 'white', 15100, true, 'OP16262'),
('WUS05215125', 'Truck', 'Scania 770', 2020, '13000cc', 'purple', 120000, false, 'OB15153'),
('TSR1225331E', 'Truck', 'Mercedes Actros', 2013, '12000cc', 'black', 25000, false, 'OM15645'),
('WUS05266546', 'Truck', 'Scania 113', 2008, '13000cc', 'purple', 21000, true, 'OB15153');


insert into agreement (Price, Dependent, Status, Datum, Tax_Nr, VIN, EMBG) values
(16600, array['Ivan Miladinov', 'Radica Miladinova'], true, '2023-01-11', 'OB15153', 'WZZ04124124', '1507995410210'),
(21600, array['Radica Kurcievska'], true, '2023-05-15', 'OB15153', 'WZZ04164123', '1507995410210'),
(28500, array['Ivan Stojanovski'], true, '2023-08-01', 'OB15153', 'WZZ04574121', '2010997410030'),
(120000, array['Risto Mirnovski'], true, '2023-11-15', 'OB15153', 'WUS05215125', '2010997410030'),
(38700, array['Risto Kasapski'], true, '2023-12-22', 'OB15153', 'WZOWR126612', '1107975510760'),
(55100, array['Ratko Korlevski'], true, '2023-07-02', 'OB15153', 'WZWTR176789', '1108456710760'),
(98600, array['Marina Bogoeva'], true, '2023-02-11', 'OP16262', 'BE131935SSS', '1306999410160'),
(144500, array['Marina Bogoeva'], true, '2023-10-10', 'OP16262', 'BE135135RES', '1107977410760'),
(11300, array['Ivan Nasev'], true, '2023-11-22', 'OP16262', 'WQT4124215E', '1107975510760'),
(4000, array['Stojanka Ancevska'], true, '2023-01-06', 'OM15645', 'PEZ513532RE', '1507995410210'),
(22000, array['Ivan Ancevski'], true, '2023-04-26', 'OM15645', 'PEZ778532MS', '1176552310760'),
(13300, array['Ognen Popov'], true, '2023-08-01', 'OM15645', 'PEZ711532TT', '1108456710760'),
(25000, array['Arden Omerit'], true, '2023-09-16', 'OM15645', 'TSR1225331E', '1306999410160');

insert into payment (Bank, Account, Amount, EMBG, A_Id) values
('NLB', 'TUTMK22-152356135893', 16000, '1507995410210', 1),
('NLB', 'TUTMK22-152356135893', 21600, '1507995410210', 2),
('NLB', 'TUTMK22-155236137493', 28500, '2010997410030', 3),
('Sparkasse', 'SPKMK33-174545747793', 120000, '2010997410030', 4),
('Stopanska', 'STPMK77-175845667451', 38700, '1107975510760', 5),
('Stopanska', 'STPMK77-145745745791', 55100, '1108456710760', 6),
('Stopanska', 'STPMK77-197886478491', 98600, '1306999410160', 7),
('Stopanska', 'STPMK77-156865865891', 144500, '1107977410760', 8),
('Stopanska', 'STPMK77-198679345566', 11300, '1107975510760', 9),
('Stopanska', 'STPMK77-664568735476', 4000, '1507995410210', 10),
('Stopanska', 'STPMK77-454745745775', 22000, '1176552310760', 11),
('Stopanska', 'STPMK77-463463466436', 13300, '1108456710760', 12),
('NLB', 'TUTMK22-152356665773', 25000, '1306999410160', 13);