2

I'm trying to create a SQL table with the following syntax in MySQL Workbench (in Mac OS),

CREATE TABLE orders (

        order_id                    INT NOT NULL PRIMARY KEY, 
        company_id                  INT  NOT NULL, 
        customer_id                 INT NOT NULL, 
        order_number                VARCHAR(200), 
        order_date                  TIMESTAMP NOT NULL, 
        created                     TIMESTAMP NOT NULL, 
        order_status                INT NOT NULL, 

        CONSTRAINT orders_fk_company 
            FOREIGN KEY (company_id) REFERENCES companies (company_id), 

        CONSTRAINT orders_fk_customer 
            FOREIGN KEY (customer_id) REFERENCES customers (customer_id)

    ); 

When I'm trying to execute this script, I'm getting the following message,

Error code: 1067. Invalid default value for 'created'

What is the issue here and how to create the table properly ? I have other 2 tables namely companies and customers provided below. There are executing properly and no issue there.

CREATE TABLE companies (

company_id                  INT     NOT NULL PRIMARY KEY, 
company_name                VARCHAR(50)         NOT NULL, 
contact_name                VARCHAR(50)         NOT NULL, 
contact_phone               VARCHAR(30)         NOT NULL, 
contact_email               VARCHAR(50)         NOT NULL, 
created                     DATETIME            NOT NULL 

);

CREATE TABLE customers (

customer_id                 INT             NOT NULL PRIMARY KEY, 
company_id                  INT                NOT NULL, 
customer_name               VARCHAR(100)        NOT NULL, 
customer_company            VARCHAR(100), 
CONSTRAINT customers_fk_company 
    FOREIGN KEY (company_id) REFERENCES companies (company_id) 

); 
Blorgbeard
  • 101,031
  • 48
  • 228
  • 272
Arefe
  • 1,029
  • 5
  • 16
  • 30

0 Answers0