INSERT INTO `adresy` (`adres_id`, `kod pocztowy`, `miasto`, `ulica i numer domu`) VALUES
(1, '23-234', 'Kraków', 'Botaniczna 60'),
(2, '54-345', 'Kraków', 'Czerwona 32'),
(3, '26-234', 'Kraków', 'Botaniczna 60'),
(4, '58-345', 'Kraków', 'Czerwona 32'),
(5, '54-345', 'Kraków', 'Czerwona 32'),
(6, '54-345', 'Kraków', 'Czerwona 32'),
(7, '54-345', 'Kraków', 'Czerwona 32'),
(8, '54-345', 'Kraków', 'Czerwona 32'),
(9, '54-345', 'Kraków', 'Czerwona 32'),
(10, '54-345', 'Wrocław', 'Czerwona 32'),
(11, '54-345', 'Wrocław', 'Czerwona 32'),
(12, '54-345', 'Wrocław', 'Czerwona 32'),
(13, '54-345', 'Wrocław', 'Czerwona 32'),
(14, '54-345', 'Wrocław', 'Czerwona 32'),
(15, '54-345', 'Wrocław', 'Czerwona 32'),
(16, '54-345', 'Wrocław', 'Czerwona 32'),
(17, '54-345', 'Wrocław', 'Czerwona 32'),
(18, '54-345', 'Wrocław', 'Czerwona 32'),
(19, '54-345', 'Wrocław', 'Czerwona 32'),
(20, '54-345', 'Szczecin', 'Czerwona 32'),
(21, '54-345', 'Szczecin', 'Czerwona 32'),
(22, '54-345', 'Szczecin', 'Czerwona 32'),
(23, '54-345', 'Szczecin', 'Czerwona 32'),
(24, '54-345', 'Szczecin', 'Czerwona 32'),
(25, '54-345', 'Szczecin', 'Czerwona 32'),
(26, '54-345', 'Szczecin', 'Czerwona 32'),
(27, '54-345', 'Szczecin', 'Czerwona 32'),
(28, '54-345', 'Szczecin', 'Czerwona 32'),
(29, '54-345', 'Berlin', 'Czerwona 32'),
(30, '54-345', 'Berlin', 'Czerwona 32'),
(31, '54-345', 'Berlin', 'Czerwona 32'),
(32, '54-345', 'Berlin', 'Czerwona 32'),
(33, '54-345', 'Berlin', 'Czerwona 32'),
(34, '54-345', 'Berlin', 'Czerwona 32'),
(35, '54-345', 'Berlin', 'Czerwona 32'),
(36, '54-345', 'Berlin', 'Czerwona 32'),
(37, '54-345', 'Częstochowa', 'Czerwona 32'),
(38, '54-345', 'Częstochowa', 'Czerwona 32'),
(39, '54-345', 'Częstochowa', 'Czerwona 32'),
(40, '54-345', 'Częstochowa', 'Czerwona 32');

INSERT INTO `kategorie` (`kategoria_id`, `nazwa kategorii`) VALUES
(1, 'Dysk twardy'),
(2, 'Karta graficzna'),
(3, 'Procesor'),
(4, 'Płyta główna'),
(5, 'Pamięć RAM'),
(6, 'Obudowa'),
(7, 'Zasilacz'),
(8, 'Chłodzenie'),
(9, 'Karta dzwiękowa'),
(10, 'Monitor'),
(11, 'Myszka'),
(12, 'Klawiatura'),
(13, 'Słuchawki'),
(14, 'Głośniki');

INSERT INTO `klienci` (`klient_id`, `login`, `hasło`, `osoba_id`) VALUES
(1, 'adf', 'asdf', 7),
(2, 'sdfg', 'sdfg', 4),
(3, 'sdfg', 'djgfd', 12),
(4, 'dfjd', 'sad', 17),
(5, 'dsfhg', 'hsdfh', 6),
(6, 'hgj', 'lhjkl', 34),
(7, 'dfty', 'etrue', 25),
(8, 'erty', 'dgs', 16),
(9, 'ghjyu', 'asdf', 38),
(10, '3rser', 'serj7r', 19),
(11, 'tukt', '23fa', 22),
(12, 'fesrty', 'dsfg54w', 14),
(13, 'miu', '6r7d', 30),
(14, 'gsrt', 'drth', 8),
(15, 'dfh', 'jtrj', 40),
(16, 'j67m', 'wb4t', 11),
(17, 'fh43t', 't3w4bt', 24);

INSERT INTO `kontakty` (`kontakt_id`, `e-mail`, `numer telefonu 1`, `numer telefonu 2`) VALUES
(1, 'jtyj@op.pl', 345673567, 224362256),
(2, 'dasef@gmail.com', 342526526, 265245627),
(3, 'sfdhs@op.pl', 345673567, 224362256),
(4, 'hffhjk@gmail.com', 342526526, 265245627),
(5, 'sfdhs@op.pl', 345673567, 224362256),
(6, 'jdfyk@gmail.com', 342526526, 265245627),
(7, 'djsfass@op.pl', 345673567, 224362256),
(8, 'ndf@gmail.com', 342526526, 265245627),
(9, 'mgfzss@op.pl', 345673567, 224362256),
(10, 'safadsf@gmail.com', 342526526, 265245627),
(11, 'gfrta@op.pl', 345673567, 224362256),
(12, 'ndty@gmail.com', 342526526, 265245627),
(13, 'syuos@op.pl', 345673567, 224362256),
(14, 'vfgnek@gmail.com', 342526526, 265245627),
(15, 'tyurs@op.pl', 345673567, 224362256),
(16, 'zvxck@gmail.com', 342526526, 265245627),
(17, 'ftshhs@op.pl', 345673567, 224362256),
(18, 'fgzjk@gmail.com', 342526526, 265245627),
(19, 'sfzdfs@op.pl', 345673567, 224362256),
(20, 'hdfsgk@gmail.com', 342526526, 265245627);

INSERT INTO `osoby` (`osoba_id`, `imię`, `nazwisko`, `pesel`, `adres_id`, `kontakt_id`) VALUES
(1, 'Tomasz', 'Kowalski', '87234782732', 1, 1),
(2, 'Adrian', 'Nowak', '87345782732', 2, 2),
(3, 'Adrian', 'Kowalski', '87345743634', 3, 3),
(4, 'Adrian', 'Kowalski', '87345743634', 4, 4),
(5, 'Adrian', 'Kowalski', '87345743634', 5, 5),
(6, 'Adrian', 'Kowalski', '87345743634', 6, 6),
(7, 'Adrian', 'Kowalski', '87345743634', 7, 7),
(8, 'Adrian', 'Kowalski', '87345743634', 8, 8),
(9, 'Adrian', 'Kowalski', '87345743634', 9, 9),
(10, 'Adrian', 'Kowalski', '87345743634', 10, 10),
(11, 'Adrian', 'Kowalski', '87234782732', 11, 11),
(12, 'Adrian', 'Kowalski', '87234782732', 12, 12),
(13, 'Adrian', 'Kowalski', '87234782732', 13, 13),
(14, 'Adrian', 'Kowalski', '87234782732', 14, 14),
(15, 'Adrian', 'Kowalski', '87234782732', 15, 15),
(16, 'Adrian', 'Kowalski', '87234782732', 16, 16),
(17, 'Adrian', 'Kowalski', '87234782732', 17, 17),
(18, 'Adrian', 'Kowalski', '87234782732', 18, 18),
(19, 'Adrian', 'Kowalski', '87234782732', 19, 19),
(20, 'Adrian', 'Kowalski', '87234782732', 20, 20),
(21, 'Adrian', 'Kowalski', '87234782732', 21, 12),
(22, 'Adrian', 'Kowalski', '87234782732', 22, 13),
(23, 'Adrian', 'Kowalski', '87234782732', 23, 14),
(24, 'Adrian', 'Kowalski', '87234782732', 24, 15),
(25, 'Adrian', 'Kowalski', '87234782732', 25, 16),
(26, 'Adrian', 'Kowalski', '87234782732', 26, 17),
(27, 'Adrian', 'Kowalski', '87234782732', 27, 18),
(28, 'Adrian', 'Kowalski', '87234782732', 28, 19),
(29, 'Adrian', 'Kowalski', '87234782732', 29, 20),
(30, 'Adrian', 'Kowalski', '87234782732', 30, 13),
(31, 'Adrian', 'Kowalski', '87234782732', 31, 14),
(32, 'Adrian', 'Kowalski', '87234782732', 32, 15),
(33, 'Adrian', 'Kowalski', '87234782732', 33, 16),
(34, 'Adrian', 'Kowalski', '87234782732', 34, 17),
(35, 'Adrian', 'Kowalski', '87234782732', 35, 18),
(36, 'Adrian', 'Kowalski', '87234782732', 36, 19),
(37, 'Adrian', 'Kowalski', '87234782732', 37, 20),
(38, 'Adrian', 'Kowalski', '87234782732', 38, 19),
(39, 'Adrian', 'Kowalski', '87234782732', 39, 20),
(40, 'Adrian', 'Kowalski', '87234782732', 40, 20);

INSERT INTO `podzespoły` (`podzespół_id`, `nazwa produktu`, `cena`, `opis`, `prokat_id`) VALUES
(1, '', 1, '', 1),
(2, '3qfq2v3r', 213, '', 2),
(3, 'wqwe53', 21, '', 3),
(4, 'qv3rvq3', 63, '', 4),
(5, '6vt', 9, '', 5),
(6, 'yb76', 789, '', 6),
(7, 'ybgu7', 87, '', 7),
(8, 'btb87bn', 43, '', 8),
(9, 'b6879n', 90, '', 9),
(10, 'dusdhfiu', 12, '', 10),
(11, 'duid89', 34, '', 11),
(12, '8n77b', 721, '', 12),
(13, 'dwen897', 25, '', 13),
(14, '3n2798', 532, '', 14),
(15, 'nec721y', 672, '', 15),
(16, 'q7w7', 817, '', 16),
(17, 'dq7b8c', 891, '', 17),
(18, '73nyei', 121, '', 18),
(19, 'e892y', 234, '', 19),
(20, 'n8y293', 621, '', 20),
(21, 'r9823', 298, '', 21),
(22, 'je8n92', 421, '', 22),
(23, 'e89n23', 897, '', 23),
(24, 'n89e23', 798, '', 24),
(25, 'nw87bci', 871, '', 25),
(26, 'q9q89b37e', 723, '', 26),
(27, '8q9wen', 273, '', 27),
(28, 'neuwbir', 235, '', 28),
(29, 'weurioi', 678, '', 29),
(30, 'nnweir', 972, '', 30),
(31, 'wqmneuio', 792, '', 31),
(32, 'ncwq98', 821, '', 32),
(33, 'unas89d', 234, '', 33),
(34, 'b7wq89', 547, '', 34),
(35, 'w78byr', 237, '', 35),
(36, 'wqiube', 731, '', 36),
(37, 'wreuy9', 21, '', 37),
(38, 'wein89', 71, '', 38),
(39, 'nw8r7', 214, '', 39),
(40, 'm78wa', 789, '', 40),
(41, 'vae4d', 432, '', 41),
(42, 'ybiwauef', 321, '', 42),
(43, '7b865v', 778, '', 43),
(44, '6a875', 213, '', 44),
(45, '76v5fwqcr', 643, '', 45),
(46, 'DB78QWI7', 532, '', 46),
(47, 'd7we8b9', 534, '', 47),
(48, 'efw7', 2638, '', 48),
(49, 'b6w7v', 345, '', 49),
(50, 'sb86ti7i', 3243, '', 50),
(51, 'sb8657', 8273, '', 51),
(52, '78wb', 723, '', 52),
(53, 'na89sdy', 2344, '', 53);

INSERT INTO `pracownicy` (`pracownik_id`, `uprawnienia`, `wynagrodzenie`, `login`, `hasło`, `data zatrudnienia`, `data zwolnienia`, `konto aktywne`, `osoba_id`) VALUES
(0, 'admin', 10000, 'sad', 'asd', '2018-11-12 23:00:00', '0000-00-00 00:00:00', 1, 2),
(1, 'admin', 10000, 'sad', 'asd', '2018-11-12 23:00:00', '0000-00-00 00:00:00', 1, 2),
(2, 'podstawowe', 3000, 'asd', 'aasdsd', '2018-11-12 23:00:00', '0000-00-00 00:00:00', 1, 1);

INSERT INTO `premia` (`premia_id`, `usługa`, `ilość (PLN)`, `pracownik_id`) VALUES
(1, 0, 300, 1);

INSERT INTO `producenci` (`producent_id`, `nazwa producenta`) VALUES
(1, 'Acer'),
(2, 'Asus'),
(3, 'Apple'),
(4, 'Benq'),
(5, 'Corsair'),
(6, 'Dell'),
(7, 'Nvidia'),
(8, 'Panasonic'),
(9, 'Samsung'),
(10, 'Sony'),
(11, 'Intel'),
(12, 'Lenovo');

INSERT INTO `producenci_kategorie` (`prokat_id`, `kategoria_id`, `producent_id`) VALUES
(1, 1, 1),
(2, 1, 3),
(3, 1, 2),
(4, 1, 4),
(5, 1, 5),
(6, 1, 6),
(7, 1, 7),
(8, 1, 8),
(9, 1, 9),
(10, 1, 10),
(11, 1, 11),
(12, 1, 12),
(13, 2, 1),
(14, 2, 3),
(15, 2, 2),
(16, 2, 4),
(17, 2, 5),
(18, 2, 6),
(19, 2, 7),
(20, 2, 8),
(21, 2, 9),
(22, 2, 10),
(23, 2, 11),
(24, 2, 12),
(25, 3, 1),
(26, 3, 3),
(27, 3, 2),
(28, 3, 4),
(29, 3, 5),
(30, 3, 6),
(31, 3, 7),
(32, 3, 8),
(33, 3, 9),
(34, 3, 10),
(35, 3, 11),
(36, 3, 12),
(37, 4, 1),
(38, 4, 3),
(39, 4, 2),
(40, 4, 4),
(41, 4, 5),
(42, 4, 6),
(43, 4, 7),
(44, 4, 8),
(45, 4, 9),
(46, 4, 10),
(47, 4, 11),
(48, 4, 12),
(49, 5, 1),
(50, 5, 3),
(51, 5, 2),
(52, 5, 4),
(53, 5, 5),
(54, 5, 6),
(55, 5, 7),
(56, 5, 8),
(57, 5, 9),
(58, 5, 10),
(59, 5, 11),
(60, 5, 12);

INSERT INTO `reklamacje` (`reklamacja_id`, `data złożenia reklamacji`, `zamówienie_id`) VALUES
(1, '2018-11-25 18:29:54', 6),
(2, '2018-11-25 18:29:54', 3),
(3, '2018-11-25 18:29:54', 16),
(4, '2018-11-25 18:29:54', 9),
(5, '2018-11-25 18:29:54', 26),
(6, '2018-11-25 18:29:54', 15),
(7, '2018-11-25 18:29:54', 40),
(8, '2018-11-25 18:29:54', 55),
(9, '2018-11-25 18:29:54', 81),
(10, '2018-11-25 18:29:54', 93);

INSERT INTO `zamówienia` (`zamówienie_id`, `data zamówienia`, `data wysłania`, `klient_id`, `podzespół_id`) VALUES
(0, '2018-11-25 17:51:06', '0000-00-00 00:00:00', 5, 14),
(1, '2018-11-25 17:54:32', '0000-00-00 00:00:00', 14, 9),
(2, '2018-11-25 17:53:05', '0000-00-00 00:00:00', 7, 43),
(3, '2018-11-25 17:53:05', '0000-00-00 00:00:00', 12, 52),
(5, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 1, 21),
(6, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 2, 22),
(7, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 3, 23),
(8, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 4, 24),
(9, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 5, 26),
(10, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 6, 27),
(11, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 7, 28),
(12, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 8, 29),
(13, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 9, 30),
(14, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 10, 31),
(15, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 11, 32),
(16, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 12, 33),
(17, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 13, 34),
(18, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 14, 35),
(19, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 15, 36),
(20, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 16, 37),
(21, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 17, 38),
(22, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 13, 39),
(23, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 11, 40),
(24, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 6, 41),
(25, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 5, 42),
(26, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 10, 43),
(27, '2018-11-25 18:11:42', '0000-00-00 00:00:00', 2, 44),
(28, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 1, 1),
(29, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 2, 2),
(30, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 3, 3),
(31, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 4, 4),
(32, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 5, 5),
(33, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 6, 6),
(34, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 7, 7),
(35, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 8, 8),
(36, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 9, 9),
(37, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 10, 11),
(38, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 11, 12),
(39, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 12, 13),
(40, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 13, 14),
(41, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 14, 15),
(42, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 15, 16),
(43, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 16, 17),
(44, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 17, 21),
(45, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 13, 22),
(46, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 11, 23),
(47, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 6, 24),
(48, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 5, 25),
(49, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 10, 26),
(50, '2018-11-25 18:16:03', '0000-00-00 00:00:00', 2, 27),
(51, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 3, 1),
(52, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 7, 3),
(53, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 9, 4),
(54, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 11, 5),
(55, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 13, 6),
(56, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 15, 7),
(57, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 16, 8),
(58, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 14, 9),
(59, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 12, 11),
(60, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 10, 12),
(61, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 8, 13),
(62, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 6, 14),
(63, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 4, 15),
(64, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 2, 16),
(65, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 1, 17),
(66, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 10, 21),
(67, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 13, 22),
(68, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 11, 23),
(69, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 6, 24),
(70, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 5, 25),
(71, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 10, 26),
(72, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 2, 27),
(73, '2018-11-25 18:21:11', '0000-00-00 00:00:00', 5, 2),
(74, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 3, 12),
(75, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 5, 34),
(76, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 7, 34),
(77, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 9, 21),
(78, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 11, 47),
(79, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 13, 12),
(80, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 15, 42),
(81, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 16, 32),
(82, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 14, 9),
(83, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 12, 11),
(84, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 10, 12),
(85, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 8, 13),
(86, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 6, 38),
(87, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 4, 18),
(88, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 2, 39),
(89, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 1, 51),
(90, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 10, 21),
(91, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 13, 36),
(92, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 11, 41),
(93, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 6, 33),
(94, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 5, 1),
(95, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 10, 2),
(96, '2018-11-25 18:28:18', '0000-00-00 00:00:00', 2, 29);