DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info`
(
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`number` varchar(255) DEFAULT NULL,
`price` varchar(255) DEFAULT NULL,
`send_status` tinyint DEFAULT NULL,
`trade_no` varchar(255) DEFAULT NULL,
`invoice_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`invoice_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`create_time` datetime DEFAULT CURRENT_TIMESTAMP,
`update_time` datetime DEFAULT CURRENT_TIMESTAMP,
`pay_status` tinyint DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB
AUTO_INCREMENT = 4
DEFAULT CHARSET = utf8mb3;
create_time
datetime DEFAULT CURRENT_TIMESTAMP,
mysql版本过低使用CURRENT_TIMESTAMP会报错
默认值只能使用NULL或EMPTY STRING