Create table failed

  • Resolved artmuns

    (@artmuns)


    3 years, 8 months ago

    ERROR: CREATE TABLE failed.

    Here’s the script.

    CREATE TABLE sb_incidents
    (incident_id int(4) NOT NULL AUTO_INCREMENT
    ,date date(8) NULL
    ,reported_by text NULL
    ,address text(20) NULL
    ,violation text(20) NULL
    ,note text(500) NULL
    ,PRIMARY KEY (incident_id)
    ) ENGINE InnoDB DEFAULT CHARACTER SET latin1 COLLATE=latin1_swedish_ci;

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Art,

    The Data Designer allows you to add a max length to any column type, which it shouldn’t. Please leave the max length empty for date and text fields. If you want to limit the size of a text field, please use column type varchar. Sorry, I need to fix this!

    Does this help?
    Peter

    Thread Starter artmuns

    (@artmuns)

    That fixed it Peter. Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Create table failed’ is closed to new replies.