Failed to create table

  • myblissbaking

    (@myblissbaking)


    9 years, 1 month ago

    Can you please help me? I cant get a table to create.

    CREATE TABLE wp_schedule (
    time text NOT NULL COMMENT ‘ ‘,
    activity text NOT NULL COMMENT ‘ ‘,
    staff text NOT NULL COMMENT ‘ ‘,
    task text NOT NULL COMMENT ‘ ‘,
    behavior 3 pt scale text NOT NULL COMMENT ‘ ‘,
    behavior notes text NOT NULL,
    created datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’ COMMENT ‘Created Datetime’,
    updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘Updated Datetime’,
    PRIMARY KEY(time) )
    ENGINE=CSV DEFAULT CHARSET=utf8;

The topic ‘Failed to create table’ is closed to new replies.