DROP TABLE IF EXISTS `notes`;
CREATE TABLE `notes` (
                         `id` int NOT NULL AUTO_INCREMENT,
                         `note` varchar(155) NOT NULL,
                         `description` text NOT NULL,
                         `date_added` datetime NOT NULL,
                         `shop_id` int NOT NULL DEFAULT '1',
                         PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;