· 7 years ago · Feb 25, 2019, 06:44 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Wersja serwera: 10.1.32-MariaDB - mariadb.org binary distribution
4-- Serwer OS: Win32
5-- HeidiSQL Wersja: 9.5.0.5196
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Zrzut struktury tabela zsedziennik.ksiazki
15CREATE TABLE IF NOT EXISTS `ksiazki` (
16 `tytul` varchar(50) DEFAULT NULL,
17 `autor` varchar(50) DEFAULT NULL,
18 `rok_wydania` varchar(50) DEFAULT NULL
19) ENGINE=InnoDB DEFAULT CHARSET=latin1;
20
21-- Zrzucanie danych dla tabeli zsedziennik.ksiazki: ~4 rows (około)
22/*!40000 ALTER TABLE `ksiazki` DISABLE KEYS */;
23INSERT INTO `ksiazki` (`tytul`, `autor`, `rok_wydania`) VALUES
24 ('aaaa', 'aaaa', '2000'),
25 ('bbbb', 'bbbb', '2000'),
26 ('cccc', 'cccc', '2000'),
27 ('dddd', 'dddd', '2000');
28/*!40000 ALTER TABLE `ksiazki` ENABLE KEYS */;
29
30/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
31/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
32/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;