CREATE TABLE `baza1`.`ksiazki` ( `id` INT NOT NULL AUTO_INCREMENT , `tytul` VARCHAR(50) NOT NULL , `imie` VARCHAR(40) NULL , `nazwisko` VARCHAR(50) NULL , `cena` DECIMAL(10,2) NOT NULL,
`rok_wydania` YEAR NOT NULL , `kod` VARCHAR(7) NOT NULL DEFAULT 'BOOK' , PRIMARY KEY (`id`)) ENGINE = InnoDB;

------------------------

CREATE TABLE `ksiazki` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `tytul` varchar(50) COLLATE utf8_polish_ci NOT NULL,
 `imie` varchar(40) COLLATE utf8_polish_ci DEFAULT NULL,
 `nazwisko` varchar(50) COLLATE utf8_polish_ci DEFAULT NULL,
 `cena` decimal(10,2) NOT NULL,
 `rok_wydania` year(4) NOT NULL,
 `kod` varchar(7) COLLATE utf8_polish_ci NOT NULL DEFAULT 'BOOK',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci

------------------

INSERT INTO `ksiazki` (`id`, `tytul`, `imie`, `nazwisko`, `cena`, `rok_wydania`, `kod`) VALUES (NULL, 'Pan Tadeusz', 'Adam', 'Mickiewicz', '56.45', '2022', '123');

----------------------
INSERT INTO `ksiazki` (`id`, `tytul`, `imie`, `nazwisko`, `cena`, `rok_wydania`, `kod`) VALUES
(NULL, 'Dziady', 'Adam', 'Mickiewicz', '56.45', 2025, '123'),
(NULL, 'Potop', 'Henryk', 'Sienkiewicz', '56.45', 2022, 'BOOK123'),
(NULL, 'Pan Wołodyjowski', 'Henryk', 'Sienkiewicz', 56.45, '2022', '12334563487563485634');


--------------------

CREATE TABLE `produkty` (
 `ID` int(11) NOT NULL AUTO_INCREMENT,
 `NazwaProduktu` varchar(80) COLLATE utf8_polish_ci NOT NULL,
 `Cena` decimal(8,2) NOT NULL,
 `DataProdukcji` date DEFAULT NULL,
 `Ilosc` int(11) DEFAULT NULL,
 `Opis` text COLLATE utf8_polish_ci DEFAULT NULL,
 `kod` varchar(5) COLLATE utf8_polish_ci DEFAULT NULL,
 PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci

---------------------------------------------------

INSERT INTO `produkty` (`ID`, `NazwaProduktu`, `Cena`, `DataProdukcji`, `Ilosc`, `Opis`, `kod`) VALUES (NULL, 'Super Zupa Pomidorowa', '67.41', '2025-10-10', '67', NULL, NULL);