DROP TABLE IF EXISTS `redirect`;
CREATE TABLE `redirect` (
                            `id` int NOT NULL AUTO_INCREMENT,
                            `code` varchar(50) NOT NULL,
                            `presenter` varchar(100) NOT NULL,
                            `path` varchar(150) NOT NULL,
                            `broken_url` varchar(150) NOT NULL,
                            `referrer` varchar(150) NOT NULL,
                            `viewed` int NOT NULL,
                            `status` tinyint(1) NOT NULL DEFAULT '0',
                            `shop_id` int NOT NULL,
                            `date_added` datetime NOT NULL,
                            `date_edit` datetime NOT NULL,
                            PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;