| commit | author | age | ||
| 175a52 | 1 | CREATE TABLE `ksiazki` ( |
| JK | 2 | `id` mediumint(8) unsigned NOT NULL, |
| 3 | `tytul` varchar(255) COLLATE utf8_polish_ci NOT NULL, | |
| 4 | `autor` varchar(255) COLLATE utf8_polish_ci NOT NULL, | |
| 5 | `jezyk` varchar(255) COLLATE utf8_polish_ci NOT NULL, | |
| 6 | `rok` year(4) DEFAULT NULL, | |
| 7 | `miejsce` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL, | |
| 8 | `wydawnictwo` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL, | |
| 9 | `wydanie` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL, | |
| 10 | `ISBN` decimal(13,0) unsigned DEFAULT NULL, | |
| 11 | `ISSN` decimal(13,0) unsigned DEFAULT NULL, | |
| 12 | `regal` char(5) COLLATE utf8_polish_ci DEFAULT NULL, | |
| 381239 | 13 | `polka` decimal(2,0) unsigned DEFAULT NULL, |
| JK | 14 | `rzad` decimal(2,0) unsigned DEFAULT NULL, |
| 15 | `wycofana` enum('0','1') CHARACTER SET ascii NOT NULL DEFAULT '0', | |
| 175a52 | 16 | `powod` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL, |
| JK | 17 | PRIMARY KEY (`id`), |
| 18 | KEY `ISBN` (`ISBN`), | |
| 19 | KEY `wycofana` (`wycofana`), | |
| 20 | KEY `ISSN` (`ISSN`), | |
| 21 | FULLTEXT KEY `tytul` (`tytul`), | |
| 22 | FULLTEXT KEY `autor` (`autor`), | |
| 23 | FULLTEXT KEY `wydawnictwo` (`wydawnictwo`) | |
| 24 | ); | |
| 25 | ||
| 26 | CREATE TABLE `pozycz` ( | |
| 27 | `id` mediumint(8) unsigned NOT NULL, | |
| 28 | `kto` varchar(255) COLLATE utf8_polish_ci NOT NULL, | |
| 29 | `od` int(11) NOT NULL, | |
| 381239 | 30 | PRIMARY KEY (`id`,`od`) |
| JK | 31 | ); |
| 32 | ||
| 33 | CREATE TABLE `pozycz_historia` ( | |
| 34 | `id` mediumint(8) unsigned NOT NULL, | |
| 35 | `kto` varchar(255) COLLATE utf8_polish_ci NOT NULL, | |
| 36 | `od` int(11) NOT NULL, | |
| 175a52 | 37 | `do` int(11) DEFAULT NULL, |
| JK | 38 | PRIMARY KEY (`id`,`od`), |
| 39 | KEY `do` (`do`) | |
| 40 | ); | |
