[sql] Failed to execute: /*==============================================================*/ /* Table structure for table workflow_task_notify_gru_cf */ /*==============================================================*/ CREATE TABLE workflow_task_notify_gru_cf( id_task INT NOT NULL, id_spring_provider VARCHAR(255) DEFAULT NULL, marker_provider_ids VARCHAR(1000) NULL, demand_status INT DEFAULT NULL, crm_status_id INT DEFAULT 1, set_onglet SMALLINT NULL DEFAULT NULL, message_guichet TEXT COLLATE utf8_unicode_ci DEFAULT NULL, status_text_guichet VARCHAR(255) DEFAULT NULL, sender_name_guichet VARCHAR(255) DEFAULT NULL, subject_guichet VARCHAR(255) DEFAULT NULL, demand_max_step_guichet SMALLINT NULL DEFAULT 1, demand_user_current_step_guichet SMALLINT NULL DEFAULT 1, is_active_onglet_guichet SMALLINT NULL DEFAULT 0, status_text_agent VARCHAR(255) DEFAULT NULL, message_agent text COLLATE utf8_unicode_ci, is_active_onglet_agent SMALLINT NOT NULL DEFAULT 0, subject_email VARCHAR(255) DEFAULT NULL, message_email text COLLATE utf8_unicode_ci, sender_name_email VARCHAR(255) DEFAULT NULL, recipients_cc_email VARCHAR(255) DEFAULT NULL, recipients_cci_email VARCHAR(255) DEFAULT NULL, is_active_onglet_email SMALLINT NULL DEFAULT 0, message_sms text COLLATE utf8_unicode_ci, billing_account_sms VARCHAR(255) DEFAULT NULL, billing_group_sms VARCHAR(255) DEFAULT NULL, is_active_onglet_sms SMALLINT NOT NULL DEFAULT 0, id_mailing_list_broadcast INT DEFAULT NULL, email_broadcast VARCHAR(255) DEFAULT NULL, sender_name_broadcast VARCHAR(255) DEFAULT NULL, subject_broadcast VARCHAR(255) DEFAULT NULL, message_broadcast text COLLATE utf8_unicode_ci, recipients_cc_broadcast VARCHAR(255) DEFAULT NULL, recipients_cci_broadcast VARCHAR(255) DEFAULT NULL, is_active_onglet_broadcast SMALLINT NULL DEFAULT 0, PRIMARY KEY (id_task) )
[sql] Failed to execute: CREATE TABLE workflow_task_notify_gru_history( id_history INT NOT NULL, id_task INT DEFAULT NULL, crm_status_id INT DEFAULT 1, message_guichet TEXT COLLATE utf8_unicode_ci DEFAULT NULL, status_text_guichet VARCHAR(255) DEFAULT NULL, sender_name_guichet VARCHAR(255) DEFAULT NULL, subject_guichet VARCHAR(255) DEFAULT NULL, demand_max_step_guichet SMALLINT NULL DEFAULT 1, demand_user_current_step_guichet SMALLINT NULL DEFAULT 1, is_active_onglet_guichet SMALLINT NULL DEFAULT 0, status_text_agent VARCHAR(255) DEFAULT NULL, message_agent text COLLATE utf8_unicode_ci, is_active_onglet_agent SMALLINT NOT NULL DEFAULT 0, subject_email VARCHAR(255) DEFAULT NULL, message_email text COLLATE utf8_unicode_ci, sender_name_email VARCHAR(255) DEFAULT NULL, recipients_cc_email VARCHAR(255) DEFAULT NULL, recipients_cci_email VARCHAR(255) DEFAULT NULL, is_active_onglet_email SMALLINT NULL DEFAULT 0, message_sms text COLLATE utf8_unicode_ci, billing_account_sms VARCHAR(255) DEFAULT NULL, billing_group_sms VARCHAR(255) DEFAULT NULL, is_active_onglet_sms SMALLINT NOT NULL DEFAULT 0, id_mailing_list_broadcast INT DEFAULT NULL, email_broadcast VARCHAR(255) DEFAULT NULL, sender_name_broadcast VARCHAR(255) DEFAULT NULL, subject_broadcast VARCHAR(255) DEFAULT NULL, message_broadcast text COLLATE utf8_unicode_ci, recipients_cc_broadcast VARCHAR(255) DEFAULT NULL, recipients_cci_broadcast VARCHAR(255) DEFAULT NULL, is_active_onglet_broadcast SMALLINT NULL DEFAULT 0, code_event VARCHAR(45) NULL , type_event VARCHAR(45) NULL , message_event TEXT NULL , content_cleaned SMALLINT NULL DEFAULT 0, PRIMARY KEY (id_history, id_task) )
[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