[sql] Failed to execute: CREATE TABLE `workflow_task_formspdf_cf` ( `id_task` INT(11) NOT NULL DEFAULT '0', `id_forms` INT(11) NULL DEFAULT '0', `format` VARCHAR(15) NULL DEFAULT NULL, `id_template` INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id_task`) )
[sql] Failed to execute: CREATE TABLE `workflow_task_formspdf_template` ( `id_template` INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1), `name` VARCHAR(255) NOT NULL, `id_form` INT(11) NOT NULL DEFAULT -1, `is_generic` SMALLINT NOT NULL DEFAULT 1, `content` LONGTEXT, `is_rte` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (`id_template`) )
[sql] Failed to execute: DELETE FROM workflow_task_formspdf_template
[sql] Failed to execute: INSERT INTO workflow_task_formspdf_template (name, id_form, is_generic, is_rte, content) VALUES ('Default Template',-1,1,0,'<!DOCTYPE html>n<#-- Example of default macro override for specific display -->n<#macro displayEntryTypeDate entry, list_responses >n <#if list_responses?has_content>n <#assign iteration = 0>n <#list list_responses as response>n <#if response.responseValue??>n <#if iteration != 0 && response.file.title?has_content>n <span>; </span>n </#if>n <#assign iteration = iteration + 1>n <span>${response.responseValue?number?number_to_date?string(''dd-MM-yyyy'')}</span>n </#if>n </#list>n </#if>n</#macro>nnn<html>n<head>n <title>Export PDF ${form_title} - ${creation_date!}</title>n <style>body { }</style>n</head>n<body>n <h1 style="font-size: 30px; text-align: center; background-color: #f0f0f0;font-family: Arial, Helvetica, sans-serif;">${form_title} (${creation_date!})</h1>n nn <div id="form-response-summary" style="margin-bottom: 3em;font-family: Arial, Helvetica, sans-serif;">n <#list question_list as question_key,question_title >n <h2 style="font-size: 18px;">${question_title!}</h2>n <p><@displayEntry q=.vars[question_key]/></p> n </#list>n </div>n nn <div id="copyright" style="position: fixed; bottom: 0; width: 100%; text-align: center; background-color: #f0f0f0; padding: 5px;"> Copyright (c) 2002-2023, City of Paris. All rights reserved</div>n</body>n</html>n');
[sql] Failed to execute: CREATE TABLE workflow_action ( id_action INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1), name VARCHAR(255) DEFAULT NULL, description LONGVARCHAR DEFAULT NULL, id_workflow INT DEFAULT NULL, id_state_after INT DEFAULT NULL, id_alternative_state_after INT NOT NULL DEFAULT -1, id_icon INT DEFAULT NULL, is_automatic SMALLINT DEFAULT 0, is_mass_action SMALLINT DEFAULT 0, display_order INT DEFAULT 0, is_automatic_reflexive_action SMALLINT DEFAULT 0, uid_action VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id_action) )
[sql] Failed to execute: CREATE INDEX action_id_workflow_fk ON workflow_action(id_workflow)
[sql] Failed to execute: CREATE INDEX action_id_state_after_fk ON workflow_action(id_state_after)
[sql] Failed to execute: CREATE INDEX action_id_icon_fk ON workflow_action(id_icon)
[sql] Failed to execute: ALTER TABLE workflow_action ADD CONSTRAINT fk_action_id_workflow FOREIGN KEY (id_workflow) REFERENCES workflow_workflow(id_workflow) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE workflow_action ADD CONSTRAINT fk_action_id_state_after FOREIGN KEY (id_state_after) REFERENCES workflow_state(id_state) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE workflow_action ADD CONSTRAINT fk_action_id_icon FOREIGN KEY (id_icon) REFERENCES workflow_icon(id_icon) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE workflow_resource_history ADD CONSTRAINT fk_history_id_action FOREIGN KEY (id_action) REFERENCES workflow_action(id_action) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE workflow_task ADD CONSTRAINT fk_task_id_action FOREIGN KEY (id_action) REFERENCES workflow_action(id_action) ON DELETE RESTRICT ON UPDATE RESTRICT 
