DROP TABLE IF EXISTS `shelf`;
CREATE TABLE `shelf` (
                         `id` int NOT NULL AUTO_INCREMENT,
                         `name` varchar(155) NOT NULL,
                         `code` varchar(50) NOT NULL,
                         `description` text NOT NULL,
                         `warehouse_id` int NOT NULL,
                         `status` tinyint(1) NOT NULL DEFAULT '1',
                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;