DROP TABLE IF EXISTS `project_list`;
CREATE TABLE `project_list` (
                                `id` int NOT NULL AUTO_INCREMENT,
                                `deadline` datetime NOT NULL,
                                `start_date` datetime NOT NULL,
                                `spent_time` datetime DEFAULT NULL,
                                `shop_id` int NOT NULL,
                                `status` tinyint(1) NOT NULL,
                                `customer_name` varchar(100) NOT NULL,
                                `title` varchar(150) NOT NULL,
                                `description` mediumtext NOT NULL,
                                `website_url` varchar(150) NOT NULL,
                                `ftp_username` varchar(150) NOT NULL,
                                `ftp_password` varchar(150) NOT NULL,
                                `progress` int NOT NULL,
                                `price` decimal(15,4) NOT NULL,
                                `time_status` tinyint(1) DEFAULT NULL,
                                `time_id` int DEFAULT NULL,
                                `logo` varchar(150) DEFAULT NULL,
                                `customer_id` int DEFAULT NULL,
                                `bid_date` datetime DEFAULT NULL,
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;