CREATE TABLE queues (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, queue VARCHAR(128) NOT NULL, payload LONGTEXT DEFAULT NULL COMMENT '(DC2Type:json_array)', attempts INT UNSIGNED DEFAULT 0 NOT NULL, reserved_at INT UNSIGNED DEFAULT NULL, available_at INT UNSIGNED NOT NULL, created_at INT UNSIGNED NOT NULL, INDEX queues_queue_idx (queue), INDEX queues_reserved_idx (reserved_at), INDEX queues_available_idx (available_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE queue_job_mail (id INT UNSIGNED AUTO_INCREMENT NOT NULL, report VARCHAR(255) NOT NULL, email VARCHAR(500) NOT NULL, path_file VARCHAR(500) DEFAULT NULL, sended TINYINT(1) NOT NULL, error_execution TINYINT(1) NOT NULL, observation LONGTEXT DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE report_script ADD labels LONGTEXT DEFAULT NULL COMMENT '(DC2Type:array)', ADD is_running TINYINT(1) DEFAULT '0';