1 | insert into dealership (Tax_Nr, D_Name, Email, Pass, CEO, Telephones, Addresses) values
|
---|
2 | ('OB15153', 'BMW M-Kar', 'contact@bmwmcar.com', 'zyzkeq123', 'Ivan Stojanovski', array['077135651'], array['Kacanicki pat bb']),
|
---|
3 | ('OM15645', 'Mak Auto Star', 'contact@merc.com', 'uuusda77', 'Ace Nojkov', array['077551311'], array['Bulevar MK 13']),
|
---|
4 | ('OP16262', 'Porsche MK', 'porsche@vwmk.com', 'prsc512', 'Stefan Videv', array['071311311', '071898351'], array['Rastanska 55']);
|
---|
5 |
|
---|
6 | insert into vehicle (VIN, Body, Model, P_Year, Engine, Color, Price, Status, Tax_Nr) values
|
---|
7 | ('WZZ04124124', 'Motorcycle', 'BMW S1000RR', 2015, '999cc', 'white', 16600, false, 'OB15153'),
|
---|
8 | ('PEZ513532RE', 'Car', 'Mercedes E350 CDI', 2001, '3000cc', 'red', 4000, false, 'OM15645'),
|
---|
9 | ('TZZ04124124', 'Van', 'Mercedes Viano', 2020, '2500cc', 'silver', 30000, true, 'OM15645'),
|
---|
10 | ('BE135135RES', 'Car', 'Porsche 911 GT3', 2016, '4000cc', 'white', 80600, true, 'OP16262'),
|
---|
11 | ('TSR122533E', 'Truck', 'Mercedes Actros', 2013, '12000cc', 'black', 25000, true, 'OM15645'),
|
---|
12 | ('WQT412421E', 'Car', 'Volkswagen Passat', 2010, '2000cc', 'magenta', 11300, true, 'OP16262'),
|
---|
13 | ('WZOTR12421', 'Car', 'Mini Cooper', 2023, '1500cc', 'yellow', 35600, true, 'OB15153'),
|
---|
14 | ('WPY532532EW', 'Motorcycle', 'BMW GS600', 2009, '650cc', 'blue', 8000, true, 'OB15153'),
|
---|
15 | ('WVCR5332531', 'Van', 'VW Crafter', 2007, '3000cc', 'white', 15100, true, 'OP16262'),
|
---|
16 | ('WUS05215125', 'Truck', 'Scania 770', 2020, '13000cc', 'purple', 120000, false, 'OB15153');
|
---|
17 |
|
---|
18 | insert into client (EMBG, C_Name, Email, Pass, Telephone) values
|
---|
19 | ('1507995410210', 'Stefan Petrov', 'stefan123@gmail.com', 'najjakiot512', null),
|
---|
20 | ('2010997410030', 'Ivana Ristevska', 'ivanar12@gmail.com', 'najjakiot512', '077512421'),
|
---|
21 | ('0501987410360', 'Rozana Peralova', 'rozanaper6@hotmail.com', 'najjakiot512', '075151931'),
|
---|
22 | ('1107977410760', 'Ardijan Omerov', 'ardi4om@outlook.com', 'najjakiot512', null),
|
---|
23 | ('1306999410160', 'Marija Stojanovska', 'marijastojanovska124@gmail.com', 'najjakiot512', '078551831');
|
---|
24 |
|
---|
25 | insert into payment (Bank, Account, Amount, EMBG, A_Id) values
|
---|
26 | ('NLB', 'TUTMK22-152356135893', 16000, '1507995410210', 1),
|
---|
27 | ('Sparkasse', 'SPKMK33-162316155793', 110000, '2010997410030', 2),
|
---|
28 | ('Stopanska', 'STPMK77-158316637991', 500, '0501987410360', 3),
|
---|
29 | ('NLB', 'TUTMK22-152356135893', 4000, '1507995410210', 4);
|
---|
30 |
|
---|
31 | insert into agreement (Price, Dependent, Status, Datum, Tax_Nr, VIN, EMBG) values
|
---|
32 | (16000, array['Ivan Miladinov', 'Radica Miladinova'], true, '2023-07-01', 'OB15153', 'WZZ04124124', '1507995410210'),
|
---|
33 | (110000, array['Risto Mirnovski'], true, '2022-03-15', 'OB15153', 'WUS05215125', '2010997410030'),
|
---|
34 | (14500, array['Marina Bogoeva'], false, '2021-11-22', 'OP16262', 'WVCR5332531', '0501987410360'),
|
---|
35 | (4000, array['Stojanka Popova', 'Ana Ancevska'], true, '2019-12-06', 'OM15645', 'PEZ513532RE', '1507995410210'); |
---|