DROP TABLE IF EXISTS `product_suppliers`;
CREATE TABLE `product_suppliers` (
                                     `id` int NOT NULL AUTO_INCREMENT,
                                     `status` tinyint(1) NOT NULL,
                                     `supplier_company_name` varchar(20) NOT NULL,
                                     `email_name` varchar(50) NOT NULL,
                                     `telephone_number` varchar(15) NOT NULL,
                                     `tax_office` varchar(50) NOT NULL,
                                     `tax_number` int NOT NULL,
                                     `address` text NOT NULL,
                                     `description` text NOT NULL,
                                     `date_added` datetime NOT NULL,
                                     `date_edit` datetime NOT NULL,
                                     `shop_id` int NOT NULL DEFAULT '1',
                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;