建立表格时发生错误：第1行的'order（order_id INT UNSIGNED NOT NUL

我正在尝试使用PHP脚本在同一MySQL数据库中创建2个表：具有主键“ user_id”的表“ user”和具有主键“ order_id”和来自“ user”的外键“ user_id”的表“ order”表（一对多关系）。

表用户创建成功，没有问题：

$sql="CREATE TABLE user( user_id INT UNSIGNED NOT NULL AUTO_INCREMENT, type ENUM('member','admin') NOT NULL, username VARCHAR(30) NOT NULL, email VARCHAR(80) NOT NULL, pass VARBINARY(32) NOT NULL, first_name VARCHAR(40) NOT NULL, last_name VARCHAR(40) NOT NULL, date_expires DATE NOT NULL, date_created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, date_modified TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (user_id), UNIQUE (username), UNIQUE (email) )ENGINE=InnoDB DEFAULT CHARSET=utf8"; 但是，我无法创建表顺序：

$sql="CREATE TABLE order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id INT UNSIGNED NOT NULL, transaction_id VARCHAR(19) NOT NULL, payment_status VARCHAR(15) NOT NULL, payment_amount DECIMAL(6,2) UNSIGNED NOT NULL, payment_date_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (order_id), FOREIGN KEY (user_id) REFERENCES user (user_id) )ENGINE=InnoDB DEFAULT CHARSET=utf8"; 我收到以下错误：

Error creating table: 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 'order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ' at line 1 已经检查语法，找不到错误。您能告诉我出什么问题了吗？非常感谢。