﻿CREATE TABLE `clanekserial` (
`id` VARCHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`vlastnik` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`priv` TINYINT( 1 ) NULL ,
`fin` TINYINT( 1 ) NULL ,
`pp` TINYINT( 3 ) NULL ,
`prijmeni1` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno1` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`prijmeni2` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno2` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`prijmeni3` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno3` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`pocet` TINYINT( 1 ) NULL ,
`nazev` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`nazevzdroj` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`rok` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`rocnik` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`cislo` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`rozsah` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`poznamky` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`www` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`issn` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`klicslova` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`soubor` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL
) ENGINE = innodb;

CREATE TABLE `monografie` (
`id` VARCHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`vlastnik` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`priv` TINYINT( 1 ) NULL ,
`fin` TINYINT( 1 ) NULL ,
`pp` TINYINT( 3 ) NULL ,
`prijmeni1` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno1` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`prijmeni2` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno2` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`prijmeni3` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno3` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`pocet` TINYINT( 1 ) NULL ,
`nazev` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`sekodp` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`vydani` VARCHAR( 5 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`typvyd` VARCHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`misto` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`nakladatel` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`rok` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`pocetstran` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`prilohy` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`edice` VARCHAR( 5 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`poznamky` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`www` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`isbn` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`klicslova` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`soubor` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL
) ENGINE = innodb;

CREATE TABLE `estranka` (
`id` VARCHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`vlastnik` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`priv` TINYINT( 1 ) NULL ,
`fin` TINYINT( 1 ) NULL ,
`pp` TINYINT( 3 ) NULL ,
`prijmeni1` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno1` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`prijmeni2` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno2` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`prijmeni3` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno3` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`pocet` TINYINT( 1 ) NULL ,
`nazev` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`misto` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`vydavatel` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`rok` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`poznamky` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`aktualizace` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`citovano` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`www` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`klicslova` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`soubor` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL
) ENGINE = innodb;

CREATE TABLE `psbornik` (
`id` VARCHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`vlastnik` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ,
`priv` TINYINT( 1 ) NULL ,
`fin` TINYINT( 1 ) NULL ,
`pp` TINYINT( 5 ) NULL ,
`prijmeni1` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno1` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`prijmeni2` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno2` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`prijmeni3` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`jmeno3` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`pocet` TINYINT( 1 ) NULL ,
`nazev` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`autorisp` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`nazevzdroj` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`vydani` VARCHAR( 5 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`typvyd` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`misto` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`nakladatel` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`rok` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`rozsah` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`poznamky` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`www` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`isbn` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`klicslova` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL ,
`soubor` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL
) ENGINE = innodb;


Pozn: Datovou velikost je treba rozsirit.




















