DROP TABLE IF EXISTS `cron`;
CREATE TABLE `cron` (
                        `id` int NOT NULL AUTO_INCREMENT,
                        `user_id` int NOT NULL,
                        `shop_id` int NOT NULL,
                        `name` varchar(150) NOT NULL,
                        `note` text NOT NULL,
                        `status` tinyint(1) NOT NULL DEFAULT '1',
                        `cron_date` datetime NOT NULL,
                        `sms_time` time NOT NULL,
                        `insert_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
                        `item_id` int NOT NULL,
                        `item` varchar(50) NOT NULL,
                        `count` int NOT NULL DEFAULT '1',
                        `counter` int NOT NULL DEFAULT '0',
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;