title: Error creating table: You have an error in your SQL syntax near 'order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ' at line 1
body: <p>I am trying to create 2 tables in the same MySQL database with a PHP-script:
  table 'user' with primary key 'user_id' and table 'order' with primary key 'order_id' and foreign key 'user_id' from the 'user' table (1 to many relationship).</p>
  
  <p>Table user creates successfully without problems:</p>
  
  <pre><code>$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";
  </code></pre>
  
  <p>However, I am not able to create table order:</p>
  
  <pre><code>$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";
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>Already checked the syntax and cannot find the mistake. Could you please advise what went wrong? Thanks a lot.</p>