DROP TABLE IF EXISTS `osakonnad`; CREATE TABLE `osakonnad` ( `id` tinyint(4) unsigned NOT NULL default '0', `lnimi` varchar(100) NOT NULL default '', `nimi` varchar(100) NOT NULL default '', `rank` tinyint(3) unsigned NOT NULL default '0', `posakond` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf-8;