orders_table

CREATE TABLE orders
(

  ID          int NOT NULL AUTO_INCREMENT,
  order_date  DATE,
  sum         FLOAT,
  user_ID     INT,
  PRIMARY KEY (ID),
  FOREIGN KEY (user_ID) REFERENCES users (ID)

);