DROP TABLE IF EXISTS `calendar`;
CREATE TABLE `calendar` (
                            `id` int NOT NULL AUTO_INCREMENT,
                            `user_id` int NOT NULL,
                            `insert_user_id` int NOT NULL,
                            `schooll_id` int NOT NULL,
                            `customer_id` int NOT NULL,
                            `product_group_id` int NOT NULL,
                            `order_id` int NOT NULL,
                            `start_date` datetime NOT NULL,
                            `end_date` datetime NOT NULL,
                            `title` varchar(250) NOT NULL,
                            `color` varchar(50) NOT NULL,
                            `type` varchar(10) NOT NULL COMMENT 'saha,magaza',
                            `car_id` int NOT NULL,
                            `note` text NOT NULL,
                            `description` text NOT NULL,
                            `status` tinyint(1) NOT NULL DEFAULT '0',
                            `insert_date` datetime NOT NULL,
                            PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;