DROP TABLE IF EXISTS `schooll`;
CREATE TABLE `schooll` (
                           `id` int NOT NULL AUTO_INCREMENT,
                           `il` varchar(100) NOT NULL,
                           `zone_id` int NOT NULL,
                           `ilce` varchar(100) NOT NULL,
                           `district_id` int NOT NULL,
                           `name` varchar(150) NOT NULL,
                           `address` text NOT NULL,
                           `telephone` varchar(25) NOT NULL,
                           `mernis` varchar(20) NOT NULL,
                           `website` varchar(100) NOT NULL,
                           `type` varchar(20) NOT NULL,
                           PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;