SELECT 'LOADING Klienci' as 'INFO';
INSERT INTO `Klienci` (`idklienta`,`haslo`,`nazwa`,`miasto`,`kod`,`adres`,`telefon`,`fax`,`nip`,`regon`) VALUES
("1","VMW81CN1H","Marek","Krakow","54015","Norymberska","123 998 880","180 476 3948-45","1742285071406","591872685"),
("2","IHG46EM5Z","Adam","Skawina","66400","Kosciuszki","189 512 699","118 289 6504-98","2335620358120","606709594"),
("3","EZO08CG0X","Ewa","Poznan","63629","Czeresniowa","132 774 734","167 251 1067-70","1334804066456","203941957"),
("4","RYS91MS5G","Monika","Warszawa","03450","Kombatantow","133 520 435","177 826 2561-98","7031014276668","960003162"),
("5","KXT62FX3P","Darek","Katowice","54058","Sobieskiego","144 673 446","198 878 2143-87","7352632754482","196040048"),
("6","HMT69JK2S","Kasia","Torun","12455","Kosynierow Gdynskich","118 956 640","119 547 4739-81","3507931302301","378143819"),
("7","UAA88ZI5Q","Ewelina","Bydgoszcz","55200","Wroblewskiego","197 507 397","117 257 4021-21","9151695977896","843890627"),
("8","UAA11ZI4Q","Dominika","Wieliczka","55200","Andrzejewskiego","157 577 497","217 357 4321-20","9451455977896","843209627"),
("9","YWU28BW3V","Lukasz","Gdansk","12345","Czarnowiejska","123 596 394","145 913 6247-09","8362019143998","560639441"),
("10","HGD46PK2X","Grzesiek","Gdynia","04067","Goetla Walerego","119 352 567","152 761 9746-89","7250296661164","282926647"),
("11","XNR94YL7M","Teresa","Zakopane","57390","Dekerta","196 771 476","194 656 2694-45","5795989258214","516177587"),
("12","LMZ31SD2D","Asia","Wroclaw","98314","Walczaka","139 474 877","170 174 3069-04","9501634174026","594340930"),
("13","VXJ08TU3P","Martyna","Legnica","55276","Teatralna","192 571 880","157 144 6121-74","4003680289722","628549275"),
("14","ZQN88AP0X","Kuba","Lublin","1195","Dietla","115 570 461","164 236 1803-89","1259381748735","185159324"),
("15","WZQ95DR5M","Pawel","Lodz","56700","Pomorska","150 149 734","187 255 8885-48","8920768133364","503507728");

SELECT 'LOADING Kompozycje' as 'INFO';
INSERT INTO `Kompozycje` (`idkompozycji`,`nazwa`,`opis`,`cena`,`minimum`,`stan`) VALUES
("1","Oranzeria","Istnieje możliwość dołączenia kartki z życzeniami", 49.99, 10, 200),
("2","Podarunek","Istnieje możliwość dołączenia kartki z życzeniami", 79.99, 4, 1000),
("3","Koszyk","Istnieje możliwość dołączenia kartki z życzeniami", 59.50, 4, 500),
("4","Kwiatowy Gaj","Istnieje możliwość dołączenia kartki z życzeniami", 84.49, 10, 300),
("5","Zlota jesien","Istnieje możliwość dołączenia kartki z życzeniami", 129.49, 15, 250),
("6","Sloneczna","Istnieje możliwość dołączenia kartki z życzeniami", 55.49, 20, 150),
("7","Subtelna","Istnieje możliwość dołączenia kartki z życzeniami", 50.40, 30, 50),
("8","Bajkowa","Istnieje możliwość dołączenia kartki z życzeniami", 139.99, 2, 10),
("9","Radosc","Istnieje możliwość dołączenia kartki z życzeniami", 159.99, 1, 18),
("10","Wspomnienie lata","Istnieje możliwość dołączenia kartki z życzeniami", 347.19, 25, 50),
("11","Niezapominajka","Istnieje możliwość dołączenia kartki z życzeniami", 449.99, 30, 10),
("12","Pelnia radosci","Istnieje możliwość dołączenia kartki z życzeniami", 649.99, 40, 45),
("13","Angielski ogrod","Istnieje możliwość dołączenia kartki z życzeniami", 99.99, 35, 30),
("14","Barwna","Istnieje możliwość dołączenia kartki z życzeniami", 60.00, 40, 15),
("15","Promienna","Istnieje możliwość dołączenia kartki z życzeniami", 70.00, 80, 100);

SELECT 'LOADING Kompozycje' as 'INFO';
INSERT INTO `Odbiorcy` (`idodbiorcy`,`nazwa`,`miasto`,`kod`,`adres`) VALUES
("1","Marek","Skawina","66400","Norymberska"),
("2","Adam","Skawina","66400","Kosciuszki"),
("3","Krzysiek","Poznan","63629","Czeresniowa"),
("4","Monika","Warszawa","03450","Kombatantow"),
("5","Darek","Katowice","54058","Sobieskiego"),
("6","Justyna","Torun","12455","Kosynierow Gdynskich"),
("7","Ewelina","Bydgoszcz","55200","Wroblewskiego"),
("8","Dominika","Wieliczka","55200","Andrzejewskiego"),
("9","Lukasz","Gdansk","12345","Czarnowiejska"),
("10","Arek","Gdynia","04067","Goetla Walerego"),
("11","Mariusz","Walbrzych","57390","Dekerta"),
("12","Asia","Wroclaw","98314","Walczaka"),
("13","Martyna","Legnica","55276","Teatralna"),
("14","Kuba","Lublin","1195","Dietla"),
("15","Oskar","Krakow","56700","Brzozowska");

SELECT 'LOADING Zamowienia' as 'INFO';
INSERT INTO `Zamowienia` (`idzamowienia`,`idklienta`,`idodbiorcy`,`idkompozycji`,`termin`,`cena`,`zaplacone`,`uwagi`) VALUES
("1","15","1","5","2017-05-12", 555.40, TRUE, "Brak"),
("2","14","2","5","2017-06-13", 300.14, FALSE, "Brak"),
("3","13","3","10","2017-06-22", 40.00, FALSE, "Brak"),
("4","12","4","11","2017-07-02", 54.99, TRUE, "Brak"),
("5","11","5","14","2017-07-25", 78.49, TRUE, "Brak"),
("6","10","6","6","2017-08-13", 15.89, FALSE, "Brak"),
("7","9","7","4","2017-05-18", 89.39, FALSE, "Brak"),
("8","8","8","3","2017-07-31", 115.19, FALSE, "Brak"),
("9","7","9","6","2017-05-15", 499.79, TRUE, "Brak"),
("10","6","10","13","2017-05-18", 584.48, TRUE, "Brak"),
("11","5","11","13","2017-06-12", 934.29, FALSE, "Brak"),
("12","4","12","7","2017-06-03", 25.30, FALSE, "Brak"),
("13","3","13","1","2017-06-06", 578.59, FALSE, "Brak"),
("14","2","14","1","2017-07-09", 45.99, FALSE, "Brak"),
("15","1","15","9","2017-08-10", 51.88, TRUE, "Brak");