我正试图将我的SQL模型转发给我无所事事的Laravel宅基地phpMyAdmin数据库。但是,我得到的错误代码是1064。数据库MySQL版本是5.7.2,Laravel 5.8,MySQLWorkbench版本8.0.12。从MySQLWorkbench自动生成的MySQL脚本怎么了?
消息日志:
Executing SQL script in server
ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNSIGNED NOT NULL AUTO_INCREMENT,`created_at` DATETIME NOT NULL DEFAULT CURRE' at line 5
SQL Code:
-- -----------------------------------------------------
-- Table `mydb`.`asset_types`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`asset_types` (
`id` INT(11) UNIQUE UNSIGNED NOT NULL AUTO_INCREMENT,`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,`updated_at` DATETIME NULL,`deleted_at` DATETIME NULL,`name` VARCHAR(255) NOT NULL,`system_name` VARCHAR(255) NOT NULL,PRIMARY KEY (`id`),UNIQUE INDEX `id_UNIQUE` (`id` ASC),UNIQUE INDEX `system_name_UNIQUE` (`system_name` ASC))
SQL script execution finished: statements: 8 succeeded,1 failed
Fetching back view definitions in final form.
Nothing to fetch