| 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, | |
| 13 | `polka` tinyint(4) DEFAULT NULL, | |
| 14 | `rzad` tinyint(4) DEFAULT NULL, | |
| 15 | `wycofana` char(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '0', | |
| 16 | `powod` varchar(255) COLLATE utf8_polish_ci DEFAULT NULL, | |
| 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, | |
| 30 | `do` int(11) DEFAULT NULL, | |
| 31 | PRIMARY KEY (`id`,`od`), | |
| 32 | KEY `do` (`do`) | |
| 33 | ); | |
