Open IljaPHP opened 3 years ago
Syntax error near 'UNSIGNED NOT NULL, name VARCHAR(255) NOT NULL, description' at line 5 http://joxi.ru/krDx8nbFKeB9Lr
name
description
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 - два раза
Syntax error near 'UNSIGNED NOT NULL,
name
VARCHAR(255) NOT NULL,description
' at line 5 http://joxi.ru/krDx8nbFKeB9LrUNSIGNED UNSIGNED - два раза