Mistři v programování na #hovnokod

SQL #735

Ať žijí kvalitní datové struktury!

CREATE TABLE `" . $this->table . "` (
                     `ID` int(5) NOT NULL AUTO_INCREMENT,
                      `PSC` int(6) NOT NULL,
                      `NAZ_PROV` varchar(100) COLLATE utf8_czech_ci NOT NULL,
                      `OKRES` varchar(100) COLLATE utf8_czech_ci NOT NULL,
                      `ADRESA` varchar(200) COLLATE utf8_czech_ci NOT NULL,
                      `V_PROVOZU` tinyint(1) NOT NULL,
                      `PRODL_DOBA` tinyint(1) NOT NULL,
                      `BANKOMAT` tinyint(1) NOT NULL,
                      `PARKOVISTE` tinyint(1) NOT NULL,
                      `KOMPLET_SERVIS` tinyint(1) NOT NULL,
                      `VIKEND` tinyint(1) NOT NULL,
                      `LOKALITY_PRODL` tinyint(1) NOT NULL,
                      `VYDEJ_NP_OD` varchar(200) COLLATE utf8_czech_ci NOT NULL,
                      `UKL_NP_LIMIT` tinyint(1) NOT NULL,
                      `PSC_NP_NAHR` varchar(100) COLLATE utf8_czech_ci NOT NULL,
                      `NAZ_NP_NAHR` varchar(100) COLLATE utf8_czech_ci NOT NULL,
                      `ABC_BOX` tinyint(1) NOT NULL,
                      `pondeli_od1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `pondeli_do1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `pondeli_od2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `pondeli_do2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `pondeli_od3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `pondeli_do3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `utery_od1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `utery_do1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `utery_od2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `utery_do2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `utery_od3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `utery_do3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `streda_od1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `streda_do1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `streda_od2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `streda_do2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `streda_od3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `streda_do3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `ctvrtek_od1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `ctvrtek_do1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `ctvrtek_od2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `ctvrtek_do2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `ctvrtek_od3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `ctvrtek_do3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `patek_od1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `patek_do1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `patek_od2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `patek_do2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `patek_od3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `patek_do3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `sobota_od1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `sobota_do1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `sobota_od2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `sobota_do2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `sobota_od3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `sobota_do3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `nedele_od1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `nedele_do1` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `nedele_od2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `nedele_do2` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `nedele_od3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      `nedele_do3` varchar(40) COLLATE utf8_czech_ci NOT NULL,
                      PRIMARY KEY (`ID`),
                      FULLTEXT KEY `NAZ_PROV` (`NAZ_PROV`)
                    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

Anonymous,