DROP TABLE IF EXISTS `bins`;
CREATE TABLE `bins` (
                        `id` int unsigned NOT NULL AUTO_INCREMENT,
                        `bank_code` int NOT NULL,
                        `bank_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_unicode_ci NOT NULL,
                        `bin_number` int NOT NULL,
                        `card_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_unicode_ci NOT NULL,
                        `organization` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_unicode_ci NOT NULL,
                        `is_commercial_card` tinyint(1) NOT NULL DEFAULT '0',
                        `is_support_installment` tinyint(1) NOT NULL DEFAULT '1',
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;