Skip to content

Опечатка в миграции таблицы backgroundtasks_task  #401

@IljaPHP

Description

@IljaPHP

Syntax error near 'UNSIGNED NOT NULL, name VARCHAR(255) NOT NULL, description' at line 5
http://joxi.ru/krDx8nbFKeB9Lr

CREATE TABLE `backgroundtasks_task` (
        `id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
        `action` VARCHAR(255) NOT NULL,
        `type`  enum('EVENT','REPEAT') NOT NULL DEFAULT 'EVENT',
        `initiator` INT UNSIGNED UNSIGNED NOT NULL,
        `name` VARCHAR(255) NOT NULL,
        `description` TEXT DEFAULT NULL,
        `params` TEXT DEFAULT NULL,
        `init_event` VARCHAR(255) DEFAULT NULL,
        `cron_expression` VARCHAR(255) DEFAULT NULL,
        `status`  enum('ACTIVE','STOPPED','RUNNING','FAILED','COMPLETED', 'PROCESS') NOT NULL DEFAULT 'ACTIVE',
        `ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        `fail_counter` TINYINT UNSIGNED NOT NULL DEFAULT'0',
        `options` TEXT,
        KEY `name` (`name`)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB

UNSIGNED UNSIGNED - два раза

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions