CREATE TABLE `triedy` ( `ID` int(10) unsigned NOT NULL auto_increment, `nazov` char(2) collate cp1250_czech_cs NOT NULL, `ucebna` smallint(5) unsigned NOT NULL, `triedny` varchar(45) collate cp1250_czech_cs NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs; CREATE TABLE `ziaci` ( `ID` int(10) unsigned NOT NULL auto_increment, `meno` varchar(45) collate cp1250_czech_cs NOT NULL, `trieda` int(10) unsigned NOT NULL, `pohlavie` tinyint(1) NOT NULL, `rok` smallint(5) unsigned NOT NULL, `cj1` char(2) collate cp1250_czech_cs default NULL, `cj2` char(2) collate cp1250_czech_cs default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs; CREATE TABLE `prihlaseni` ( `id` int( 11 ) NOT NULL AUTO_INCREMENT , `meno` varchar( 30 ) NOT NULL , `email` varchar( 25 ) DEFAULT NULL , `turnus` varchar( 20 ) DEFAULT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MyISAM DEFAULT CHARSET = utf8;