[Summary] [Package List] [Test Cases]
| Tests | Errors | Failures | Skipped | Success Rate | Time |
|---|---|---|---|---|---|
| 1 | 0 | 1 | 0 | 0% | 1 |
Note: failures are anticipated and checked for with assertions while errors are unanticipated.
[Summary] [Package List] [Test Cases]
| Package | Tests | Errors | Failures | Skipped | Success Rate | Time |
|---|---|---|---|---|---|---|
| 1 | 0 | 1 | 0 | 0% | 1 |
Note: package statistics are not computed recursively, they only sum up all of its testsuites numbers.
| Class | Tests | Errors | Failures | Skipped | Success Rate | Time | |
|---|---|---|---|---|---|---|---|
 |
antrunsql | 1 | 0 | 1 | 0 | 0% | 1 |
[Summary] [Package List] [Test Cases]
 |
antrunsql | 1 |
[sql] Failed to execute: CREATE TABLE core_mail_queue ( id_mail_queue int AUTO_INCREMENT, is_locked smallint default 0, PRIMARY KEY (id_mail_queue) )
[sql] Failed to execute: CREATE INDEX is_locked_core_mail_queue ON core_mail_queue (is_locked)
[sql] Failed to execute: INSERT INTO core_stylesheet (id_stylesheet, description, file_name, source) VALUES (279,'Plan du Site module d\'Administration','admin_site_map_admin.xsl','3C3F786D6C2076657273696F6E3D22312E30223F3E0D0A3C78736C3A7374796C6573686565742076657273696F6E3D22312E302220786D6C6E733A78736C3D22687474703A2F2F7777772E77332E6F72672F313939392F58534C2F5472616E73666F726D223E0D0A3C78736C3A706172616D206E616D653D22736974652D70617468222073656C6563743D22736974652D7061746822202F3E0D0A3C78736C3A7661726961626C65206E616D653D2263757272656E742D706167652D6964222073656C6563743D2263757272656E742D706167652D696422202F3E0D0A0D0A3C78736C3A74656D706C617465206D617463683D22706167655B706167652D6C6576656C3D305D223E200D0A093C6469762069643D22747265652220636C6173733D226A73747265652D64656661756C74223E0D0A09093C6120687265663D227B24736974652D706174687D3F706167655F69643D7B706167652D69647D22207469746C653D227B706167652D6465736372697074696F6E7D22203E0D0A0909093C78736C3A76616C75652D6F662073656C6563743D22706167652D6E616D6522202F3E0D0A0909093C78736C3A696620746573743D226E6F7428737472696E6728706167652D726F6C65293D276E6F6E652729223E200D0A090909093C7374726F6E673E3C78736C3A746578742064697361626C652D6F75747075742D6573636170696E673D22796573223E2D20236931386E7B706F7274616C2E736974652E61646D696E5F706167652E74616241646D696E4D6170526F6C6552657365727665647D3C2F78736C3A746578743E0D0A090909093C78736C3A76616C75652D6F662073656C6563743D22706167652D726F6C6522202F3E3C2F7374726F6E673E0D0A0909093C2F78736C3A69663E2020202020202020202020200D0A09093C2F613E0D0A09093C756C3E0D0A0909093C78736C3A6170706C792D74656D706C617465732073656C6563743D226368696C642D70616765732D6C69737422202F3E0D0A09093C2F756C3E0D0A093C2F6469763E0D0A3C2F78736C3A74656D706C6174653E0D0A202020200D0A3C78736C3A74656D706C617465206D617463683D22706167655B706167652D6C6576656C3E305D22203E0D0A093C78736C3A7661726961626C65206E616D653D22696E646578222073656C6563743D22706167652D696422202F3E0D0A093C78736C3A7661726961626C65206E616D653D226465736372697074696F6E222073656C6563743D22706167652D6465736372697074696F6E22202F3E0D0A090D0A093C6C692069643D226E6F64652D7B24696E6465787D223E0D0A09093C6120687265663D227B24736974652D706174687D3F706167655F69643D7B706167652D69647D22207469746C653D227B246465736372697074696F6E7D223E0D0A09093C78736C3A76616C75652D6F662073656C6563743D22706167652D6E616D6522202F3E0D0A0909093C78736C3A696620746573743D226E6F7428737472696E6728706167652D726F6C65293D276E6F6E652729223E0D0A090909093C7374726F6E673E0D0A0909090920203C78736C3A746578742064697361626C652D6F75747075742D6573636170696E673D22796573223E236931386E7B706F7274616C2E736974652E61646D696E5F706167652E74616241646D696E4D6170526F6C6552657365727665647D3C2F78736C3A746578743E3C78736C3A76616C75652D6F662073656C6563743D22706167652D726F6C6522202F3E0D0A090909093C2F7374726F6E673E0D0A0909093C2F78736C3A69663E0D0A09093C2F613E0D0A09093C78736C3A63686F6F73653E0D0A0909093C78736C3A7768656E20746573743D22636F756E74286368696C642D70616765732D6C6973742F2A293E30223E0D0A090909093C756C3E0D0A090909092020203C78736C3A6170706C792D74656D706C617465732073656C6563743D226368696C642D70616765732D6C69737422202F3E0D0A090909093C2F756C3E0D0A0909093C2F78736C3A7768656E3E0D0A09092020203C78736C3A6F74686572776973653E0D0A090909093C78736C3A6170706C792D74656D706C617465732073656C6563743D226368696C642D70616765732D6C69737422202F3E0D0A09092020203C2F78736C3A6F74686572776973653E0D0A09093C2F78736C3A63686F6F73653E0D0A093C2F6C693E0D0A3C2F78736C3A74656D706C6174653E0D0A202020200D0A3C78736C3A74656D706C617465206D617463683D226368696C642D70616765732D6C697374223E0D0A093C78736C3A6170706C792D74656D706C617465732073656C6563743D227061676522202F3E0D0A3C2F78736C3A74656D706C6174653E0D0A202020200D0A3C2F78736C3A7374796C6573686565743E0D0A')
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('portal.site.site_property.back_images', '\'images/admin/skin/bg_login1.jpg\' , \'images/admin/skin/bg_login2.jpg\' , \'images/admin/skin/bg_login3.jpg\' , \'images/admin/skin/bg_login4.jpg\'')
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.jcaptcha_enable', "true")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.max_notification', "10")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.autologin_after_reinit_password', "true")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.lost_password.notification_template.textblock', "<p>Bonjour ${account.login},</p><p>Vous avez perdu votre mot de passe ? Pour en générer un nouveau, cliquer sur ${url} </p><p>Cordialement.</p><p>L'équipe Paris.fr.</p><p>Ce message a été envoyé automatiquement. Nous vous remercions de ne pas répondre.</p>")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.lost_password.notification_subject', "Votre nouveau mot de passe")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.lost_password.notification_recipients_cc', "")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.lost_password.notification_recipients_bcc', "")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.lost_password.notification_sender_name', "noreply@paris.fr")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.validate_account.notification_template.textblock', "<p>Bonjour ${account.login},</p><p>Votre compte a bien été créé,pour valider définitivement votre inscription, veuillez suivre le lien suivant ${url} </p><p>Cordialement.</p><p>L'équipe Paris.fr.</p><p>Ce message a été envoyé automatiquement. Nous vous remercions de ne pas répondre.</p>")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.validate_account.notification_subject', "Valider mon compte")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.validate_account.notification_recipients_cc', "")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.validate_account.notification_recipients_bcc', "")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.validate_account.notification_sender_name', "noreply@paris.fr")
[sql] Failed to execute: INSERT INTO core_datastore VALUES ('openamidentityclient.site_property.lutece_user_validate_attribute_key', "user.validated")
[sql] Failed to execute: UPDATE core_feature_group SET feature_group_order = feature_group_order + 1 WHERE id_feature_group <>"TICKETING"
[sql] Failed to execute: DELETE FROM core_feature_group WHERE id_feature_group = "TICKETING"
[sql] Failed to execute: INSERT INTO core_admin_right (`id_right`, `name`, `level_right`, `admin_url`, `description`, `is_updatable`, `plugin_name`, `id_feature_group`, `icon_url`, `documentation_url`, `id_order`) VALUES ('TICKETING_MANAGEMENT_MODEL_RESPONSE', 'ticketing.adminFeature.ManageTicketingModelResponse.name', '2', 'jsp/admin/plugins/ticketing/admin/ManageModelResponses.jsp', 'ticketing.adminFeature.ManageTicketingModelResponse.description', '0', 'ticketing', 'APPLICATIONS', NULL, NULL, '5')
[sql] Failed to execute: INSERT INTO core_admin_right (`id_right`, `name`, `level_right`, `admin_url`, `description`, `is_updatable`, `plugin_name`, `id_feature_group`, `icon_url`, `documentation_url`, `id_order`) VALUES ('TICKETING_MANAGEMENT_MARKING', 'ticketing.adminFeature.ManageTicketingMarking.name', '2', 'jsp/admin/plugins/ticketing/admin/ManageMarkings.jsp', 'ticketing.adminFeature.ManageTicketingMarking.description', '0', 'ticketing', 'APPLICATIONS', NULL, NULL, '4')
[sql] Failed to execute: INSERT INTO genatt_entry (id_entry, id_resource, resource_type, id_type, id_parent, title, help_message, comment, mandatory, fields_in_line, pos, id_field_depend, confirm_field, confirm_field_title, field_unique, map_provider, css_class, pos_conditional, error_message, num_row, num_column, is_role_associated, code) VALUES (201, 1, "TICKET_INPUT", 215, NULL, "Relevé d'imposition sur le revenu de l'année N-2", "Veuillez transmettre votre relevé d'imposition sur le revenu de l'année N-2. Si vous ne disposez pas de ce document, vous pourrez le transmettre à nos services ultérieurement.", "", 0, 0, 1, NULL, 0, NULL, 0, "", "", 0, NULL, 0, 0, 0, "IncomeRevenue-Year-2"), (202, 2, "TICKET_INPUT", 206, NULL, "Numéro de compte facil'familles", "Numéro de compte facil'familles", "", 0, 0, 2, NULL, 0, NULL, 0, "", "", 0, NULL, 0, 0, 0, "FFAccountNumber")
[sql] Failed to execute: INSERT INTO genatt_field (id_field, id_entry, title, value, height, width, default_value, max_size_enter, pos, value_type_date, no_display_title, comment, role_key, code) VALUES (201, 201, NULL, NULL, 0, 255, 0, 0, 1, NULL, 0, NULL, NULL, NULL), (202, 201, "max_files", "1", 0, 0, 0, 0, 2, NULL, 0, NULL, NULL, NULL), (203, 201, "file_max_size", "1000000", 0, 0, 0, 0, 3, NULL, 0, NULL, NULL, NULL), (204, 201, "export_binary", "false", 0, 0, 0, 0, 4, NULL, 0, NULL, NULL, NULL)
[sql] Failed to execute: CREATE TABLE ticketing_ticket_address ( id_ticket int(6) NOT NULL, address varchar(255) NULL, address_detail varchar(255) NULL, postal_code varchar(5) NULL, city varchar(255) NULL, PRIMARY KEY (id_ticket) )
[sql] Failed to execute: CREATE TABLE ticketing_ticket ( id_ticket int(6) NOT NULL, ticket_reference varchar(20) NULL, guid varchar(255) NULL, id_customer varchar(100) NULL, id_user_title int(11) NOT NULL, firstname varchar(50) NOT NULL, lastname varchar(50) NOT NULL, email varchar(255) NOT NULL, fixed_phone_number varchar(50) NULL default '', mobile_phone_number varchar(50) NULL default '', id_ticket_category int(11) NOT NULL, id_contact_mode int(11) NOT NULL, ticket_comment LONGVARCHAR NULL , ticket_status int(11) NOT NULL default '0', ticket_status_text varchar(255) NULL default '', priority int(6) NOT NULL default '0', criticality int(6) NOT NULL default '0', date_update timestamp NOT NULL, date_create timestamp NOT NULL, date_close timestamp NULL, id_admin_user int(11) NOT NULL default '-1', id_unit int(11) NOT NULL default '0', user_message LONGVARCHAR NULL, url varchar(4096) NULL, id_channel int(11) NULL, id_assigner_user int(11) NOT NULL default '-1', id_assigner_unit int(11) NOT NULL default '0', nomenclature varchar(3) NULL, id_marking INT(11) DEFAULT '0', PRIMARY KEY (id_ticket) )
[sql] Failed to execute: CREATE TABLE ticketing_instant_response ( id_instant_response int(6) NOT NULL, id_ticket_category int(11) NOT NULL, subject LONGVARCHAR NULL , date_create timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, id_unit int(11) NOT NULL default '0', id_admin_user int(11) NOT NULL default '0', id_channel int(11) NOT NULL, PRIMARY KEY (id_instant_response) )
[sql] Failed to execute: CREATE TABLE ticketing_category ( id_category int(6) NOT NULL, id_parent int(6) NOT NULL, label varchar(255) NOT NULL default '', n_order int(6) DEFAULT 0 NOT NULL, code varchar(50) NULL, id_default_assignee_unit int(6) NOT NULL default '0', id_category_type int(6) NOT NULL default '0', id_workflow int(6) NOT NULL default '0', demand_id int(6) NOT NULL default '0', help_message varchar(500) NULL, is_manageable int(1) DEFAULT 0 NOT NULL, inactive int(1) NOT NULL default '0', PRIMARY KEY (id_category) )
[sql] Failed to execute: CREATE TABLE ticketing_category_type ( id_category_type int(6) NOT NULL, label varchar(255) NOT NULL default '', depth int(6) DEFAULT 0 NOT NULL, PRIMARY KEY (id_category_type) )
[sql] Failed to execute: CREATE TABLE ticketing_user_title ( id_user_title int(6) NOT NULL, label varchar(50) NOT NULL default '', inactive int(1) NOT NULL default '0', PRIMARY KEY (id_user_title) )
[sql] Failed to execute: CREATE TABLE ticketing_ticket_response ( id_ticket INT(6) NOT NULL, id_response INT(6) NOT NULL, PRIMARY KEY (id_ticket, id_response) )
[sql] Failed to execute: CREATE TABLE ticketing_contact_mode ( id_contact_mode int(6) NOT NULL, code varchar(50) NOT NULL default '', required_inputs varchar(150) NULL, confirmation_msg LONGVARCHAR NULL, inactive int(1) NOT NULL default '0', PRIMARY KEY (id_contact_mode) )
[sql] Failed to execute: CREATE TABLE ticketing_support_entity( id_support_entity int(6) NOT NULL, name varchar(50) NOT NULL, level int(2) NOT NULL, id_unit int(6) NOT NULL, id_admin_user int(6) NULL, id_domain int(6) NOT NULL, PRIMARY KEY (id_support_entity) )
[sql] Failed to execute: CREATE TABLE `ticketing_model_reponses` ( `id_model_response` int(6) NOT NULL, `title` varchar(500) NOT NULL DEFAULT '', `reponse` text, `keyword` text, label_ticket_domain VARCHAR(50) DEFAULT '' )
[sql] Failed to execute: ALTER TABLE `ticketing_model_reponses` ADD PRIMARY KEY (`id_model_response`)
[sql] Failed to execute: CREATE TABLE ticketing_channel ( id_channel int(6) NOT NULL, label varchar(50) NOT NULL default '', icon_font varchar(50) NULL default '', inactive int(1) NOT NULL default '0', PRIMARY KEY (id_channel) )
[sql] Failed to execute: CREATE TABLE ticketing_category_input ( id_category int(6) NOT NULL, id_input int(6) NOT NULL, pos int(6) NOT NULL default '0', PRIMARY KEY (id_category, id_input) )
[sql] Failed to execute: CREATE TABLE ticketing_markings ( id_marking INT(6) NOT NULL, title VARCHAR(500) NOT NULL DEFAULT '', label_color VARCHAR(50), background_color VARCHAR(50), PRIMARY KEY (id_marking) )
[sql] Failed to execute: CREATE TABLE ticketing_viewing ( id_viewing int(6) NOT NULL, title varchar(50) default '', message varchar(5000) default '', buton_label varchar(50) default '', channel varchar(50) default '', contact_mode varchar(50) default '', civility varchar(50) default '', domain varchar(50) default '', thematic varchar(50) default '', location varchar(50) default '', PRIMARY KEY (id_viewing) )
[sql] Failed to execute: CREATE TABLE ticketing_form ( id_form int(6) NOT NULL, title LONGVARCHAR, message LONGVARCHAR, button_label LONGVARCHAR, connection SMALLINT, PRIMARY KEY (id_form) )
[sql] Failed to execute: CREATE TABLE ticketing_formentry ( id_formentry int(6) NOT NULL, id_form int(11) default '0' NOT NULL, id_champ varchar(50) default '' NOT NULL, hidden SMALLINT default '0' NOT NULL, mandatory SMALLINT default '0' NOT NULL, hierarchy int(11) default '0' NOT NULL, default_value varchar(500) default '', PRIMARY KEY (id_formentry) )
[sql] Failed to execute: ALTER TABLE ticketing_ticket ADD CONSTRAINT fk_ticketing_ticket_user_title FOREIGN KEY (id_user_title) REFERENCES ticketing_user_title (id_user_title) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE ticketing_ticket ADD CONSTRAINT fk_ticketing_ticket_category FOREIGN KEY (id_ticket_category) REFERENCES ticketing_category (id_category) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE ticketing_ticket ADD CONSTRAINT fk_ticketing_ticket_contact_mode FOREIGN KEY (id_contact_mode) REFERENCES ticketing_contact_mode (id_contact_mode) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE ticketing_ticket ADD CONSTRAINT fk_ticketing_ticket_channel FOREIGN KEY (id_channel) REFERENCES ticketing_channel (id_channel) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE ticketing_instant_response ADD CONSTRAINT fk_ticketing_instant_response_category FOREIGN KEY (id_ticket_category) REFERENCES ticketing_category (id_category) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE ticketing_indexer_action ADD CONSTRAINT fk_ticketing_indexer_action_ticket FOREIGN KEY (id_ticket) REFERENCES ticketing_ticket (id_ticket) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE ticketing_ticket_address ADD CONSTRAINT fk_ticketing_ticket_address FOREIGN KEY (id_ticket) REFERENCES ticketing_ticket (id_ticket) ON DELETE CASCADE
[sql] Failed to execute: DROP FUNCTION IF EXISTS getCategoryChilds
[sql] Failed to execute: DELETE FROM ticketing_user_title
[sql] Failed to execute: INSERT INTO ticketing_user_title (id_user_title, label) VALUES (0, ""), (1, "Mme"), (2, "M.")
[sql] Failed to execute: DELETE FROM ticketing_contact_mode
[sql] Failed to execute: INSERT INTO ticketing_contact_mode (id_contact_mode, code, required_inputs, confirmation_msg) VALUES (1, "email", "email", "<p>Bonjour ${userTitle} ${lastName},</p><p>Nous avons bien reçu votre demande et nous vous remercions de votre confiance.</p><p>Un e-mail de confirmation vous a été envoyé à l'adresse suivante ${email}. Il contient un numéro de suivi qui vous sera demandé au 3975 pour suivre son état d'avancement. Il est également disponible dans votre espace Compte Parisien.</p><p>Nous restons à votre entière disposition pour toute information complémentaire.</p><p>Cordialement,</p><p>Mairie de Paris.</p>"), (2, "courier", "address, postal_code, city", "<p>Bonjour ${userTitle} ${lastName},</p><p>Nous avons bien reçu votre demande et nous vous remercions de votre confiance.</p><p>Un courrier de confirmation vous a été envoyé à l'adresse suivante A COMPLETER. Il contient un numéro de suivi qui vous sera demandé au 3975 pour suivre son état d'avancement. Il est également disponible dans votre espace Compte Parisien.</p><p>Nous restons à votre entière disposition pour toute information complémentaire.</p><p>Cordialement,</p><p>Mairie de Paris.</p>")
[sql] Failed to execute: DELETE FROM ticketing_support_entity
[sql] Failed to execute: INSERT INTO ticketing_support_entity (id_support_entity, name, level, id_unit, id_admin_user, id_domain) VALUES (1, 'SN2 Facil Famille ', 1, 2, -1, 210), (2, 'SN2 Facil Famille tarif. Petite Enfance. ', 2, 21, -1, 210), (3, 'SN2 Facil Famille tarif. périscolaire', 2, 20, -1, 210), (4, 'SN3 DFPE - BEF', 3, 40, -1, 210), (5, 'SN2 Voirie', 2, 30, -1, 120)
[sql] Failed to execute: DELETE FROM ticketing_channel
[sql] Failed to execute: INSERT INTO ticketing_channel (id_channel, label, icon_font) VALUES (1, "Téléphone", "fa fa-phone"), (2, "Visite", "fa fa-user"), (3, "E-mail", "fa fa-envelope"), (4, "Twitter", "fa fa-twitter"), (5, "Facebook", "fa fa-facebook"), (99, "Guichet (Web)", "fa fa-desktop")
[sql] Failed to execute: DELETE FROM ticketing_markings
[sql] Failed to execute: INSERT INTO ticketing_markings VALUES (1, 'NON LU', '#FFFFFF', '#00C0EF')
[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, 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, 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_history, id_task) )
[sql] Failed to execute: CREATE TABLE workflow_task_ticketing_reply_config ( id_task INT DEFAULT 0 NOT NULL, message_direction INT DEFAULT NULL, close_ticket int(1) NOT NULL default '0', PRIMARY KEY (id_task) )
[sql] Failed to execute: CREATE TABLE workflow_task_ticketing_automatic_assignment_config ( id_task INT DEFAULT 0 NOT NULL, assignment_suffix VARCHAR(5) NOT NULL, user_access_code varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (id_task,assignment_suffix) )
[sql] Failed to execute: CREATE TABLE workflow_ticketing_email_external_user ( id_message_external_user INT DEFAULT 0 NOT NULL, id_ticket INT DEFAULT 0 NOT NULL, email_recipients MEDIUMTEXT DEFAULT NULL, email_recipients_cc MEDIUMTEXT DEFAULT NULL, message_question LONGVARCHAR DEFAULT NULL, message_response LONGVARCHAR DEFAULT NULL, is_answered INT DEFAULT 0, PRIMARY KEY (id_message_external_user) )
[sql] Failed to execute: CREATE TABLE workflow_task_ticketing_mark_unread_config ( id_task INT(11) NOT NULL, id_marking INT(11) NOT NULL, PRIMARY KEY (id_task) )
[sql] Failed to execute: CREATE TABLE workflow_workflow ( id_workflow INT AUTO_INCREMENT, name VARCHAR(255) DEFAULT NULL, description LONGVARCHAR DEFAULT NULL, creation_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, is_enabled SMALLINT DEFAULT 0, workgroup_key VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id_workflow) )
[sql] Failed to execute: CREATE TABLE workflow_state ( id_state INT AUTO_INCREMENT, name VARCHAR(255) DEFAULT NULL, description LONGVARCHAR DEFAULT NULL, id_workflow INT DEFAULT NULL, is_initial_state SMALLINT DEFAULT 0, is_required_workgroup_assigned SMALLINT DEFAULT 0, id_icon int DEFAULT NULL, display_order INT DEFAULT 0, PRIMARY KEY (id_state) )
[sql] Failed to execute: CREATE TABLE workflow_action ( id_action INT AUTO_INCREMENT, name VARCHAR(255) DEFAULT NULL, description LONGVARCHAR DEFAULT NULL, id_workflow INT DEFAULT NULL, id_state_before INT DEFAULT NULL, id_state_after INT DEFAULT NULL, 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, 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_before_fk ON workflow_action(id_state_before)
[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: CREATE TABLE workflow_resource_history ( id_history INT AUTO_INCREMENT, id_resource INT DEFAULT NULL, resource_type VARCHAR(255) DEFAULT NULL, id_workflow INT DEFAULT NULL, id_action INT DEFAULT NULL, creation_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, user_access_code VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id_history) )
[sql] Failed to execute: CREATE INDEX history_id_workflow_fk ON workflow_resource_history(id_workflow)
[sql] Failed to execute: CREATE INDEX history_id_action_fk ON workflow_resource_history(id_action)
[sql] Failed to execute: CREATE TABLE workflow_icon ( id_icon INT AUTO_INCREMENT, name VARCHAR(255) DEFAULT NULL, mime_type VARCHAR(50) DEFAULT NULL, file_value LONGVARBINARY, width INT DEFAULT NULL, height INT DEFAULT NULL, PRIMARY KEY (id_icon) )
[sql] Failed to execute: CREATE TABLE workflow_task ( id_task INT AUTO_INCREMENT, task_type_key VARCHAR(50) DEFAULT NULL, id_action INT DEFAULT 0 NOT NULL, display_order INT DEFAULT 0, PRIMARY KEY (id_task) )
[sql] Failed to execute: CREATE INDEX task_id_action_fk ON workflow_task(id_action)
[sql] Failed to execute: ALTER TABLE workflow_state ADD CONSTRAINT fk_state_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_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_before FOREIGN KEY (id_state_before) REFERENCES workflow_state(id_state) 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_workflow ADD CONSTRAINT fk_document_id_workflow FOREIGN KEY (id_workflow) REFERENCES workflow_workflow(id_workflow) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE workflow_resource_workflow ADD CONSTRAINT fk_document_id_state FOREIGN KEY (id_state) REFERENCES workflow_state(id_state) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE workflow_resource_history ADD CONSTRAINT fk_history_id_workflow FOREIGN KEY (id_workflow) REFERENCES workflow_workflow(id_workflow) 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
[sql] Failed to execute: ALTER TABLE workflow_task_comment_value ADD CONSTRAINT fk_comment_value_id_history FOREIGN KEY (id_history) REFERENCES workflow_resource_history(id_history) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE workflow_task_comment_value ADD CONSTRAINT fk_comment_value_id_task FOREIGN KEY (id_task) REFERENCES workflow_task(id_task) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE workflow_assignment_history ADD CONSTRAINT fk_assignment_id_history FOREIGN KEY (id_history) REFERENCES workflow_resource_history(id_history) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: ALTER TABLE workflow_assignment_history ADD CONSTRAINT fk_assignment_id_task FOREIGN KEY (id_task) REFERENCES workflow_task(id_task) ON DELETE RESTRICT ON UPDATE RESTRICT
[sql] Failed to execute: INSERT INTO workflow_icon (name,mime_type,file_value,width,height) VALUES ('Valider','image/png','89504E470D0A1A0A0000000D4948445200000018000000180803000000D7A9CDCA000001BC504C5445FFFFFFFDFDFDFBFBFBFCFCFCF9F9F9F6F6F6F3F3F3D2D2D2FAFAFAEBEBEBD8D8D8D3D3D3B2C7DBB3B3B3B1B1B197B3CE8FAECA779DC0638EB67D7D7D4F7EAA4771984E4E4E0D14190C141B101010F8F8F8F5F5F5F4F4F4F1F1F1F0F0F0EEEEEEEDEDEDEAEAEAE7E7E7E2E2E2E1E1E1D7E2ECDEDEDEDBDBDBD6D6D6D5D5D5D1D1D1CFCFCFC1D2E2CECECECBCBCBCACACABACDDFC5C5C5C3C3C3AFC5CFADC3D8A9C0D6A4BDD5A3BCD4B4B5B5B2B2B2ABABABA9A9A9A8A8A890ADC7A7A7A78CACC98BABC9A3A3A39E9E9E9D9D9D9B9B9B7DA1C29999997A9FC1789DBF769CBF9293937299BD8F90906690B7628DB55F8BB45D8AB48080805987B25886B15785B05584B05483AF7979797777777575754E7DA97373734C79A36E6E6E49749C48739B47729A5B6874476C8D426A8F42698D5F5F5F4066895D5E5E3D62843C608156595B3C5F7E505A605656563556744F4F4F4B4F5233526E33516B32516D404C543A4D5E4848483C41433C3F412941583C3C3C313E49283D51263C51243A4F27394A2639492437492C353B2D30312132422630382C2C2C1C2D3D1B2B3A27272723282C2525252424241C1C1C131E281617170B12180B0C0B080C0E080908CB531B250000000174524E530040E6D866000000FB4944415478DA6360C0029818B00346666CA25C6262161A8C58246C6C8D4B783930C50D13F945BBF9B0E81016149810AE8F29A155CA2FDA6689C555651E02E291BA981AACB3758A3B7959E17C5626881AC602533FF15875B837D8929AB459C036FB9BE5F55AC9C2357056ABD63BB23130B0E79807F5E57223AC66760EE6A9F19263CC72F0CE9CE8C68964A774B9BB67A34F74114F587B9591144A0035080AB5F49B08A54C0A5446712B4B7ABCAFAB817D546D0F1F1BAA07E45B0342424592255235D1829CC9AE4E2426AE52D24901DDCF321569091912F97A2C18B1A6D255D821E9A288259ED99B274770B360893A0E257635561C69809181080000C74B2BF93B2091D60000000049454E44AE426082',14,14)
[sql] Failed to execute: INSERT INTO workflow_icon (name,mime_type,file_value,width,height) VALUES ('Refuser','image/png','89504E470D0A1A0A0000000D4948445200000018000000180803000000D7A9CDCA00000243504C5445FFFFFFFCFCFCFDFDFDFBFBFBC34C36FAFAFAF7F7F7E8E8E8F6F6F6F9F9F9F2F2F2E6E6E6BE3B22BA3A22F1F1F1ECECECEBEBEBE0E0E0DFDFDFC7C7C7B4B4B43B1711E5E5E5E2E2E2E1E1E1D4D4D4CDCDCDCACACAC9C9C9C5C5C5BEBEBEAEAEAEA5A5A5A3A3A3A0A0A0CB7868717171C84E37C64D37C44D366D6D6DC03B22BF3B22BD3B225F5F5FBC3B22BB3B22BA3B22B93B24B739225C5C5CB23821575757545454962E1C4E1D144C1B133C18122D16112D1510F8F8F8F4F4F4F3F3F3EEEEEEEDEDEDE9E9E9E7E7E7E3E3E3DCDCDCD7D7D7D6D6D6D3D3D3D0D0D0CFCFCFC6C6C6C1C1C1B9B9B9B8B8B8B6B6B6B5B5B5B0B0B0AAAAAAA7A7A7A4A4A4DD8D7D9F9F9F9D9D9D9A9A9A999999D17F709494949393938F8F8F8E8E8ED9705BD66F5BCD7261CC72618A8A8ACA6D5BC16E5E848484838383CE6653D3634ED05F497E7E7E7A7A7AB06354787878767676C95641CE523A747474B45B4A7272726E6E6EC24D366C6C6C6A6A6AC2462FC24129636363AD4632BE3F27BD3F28BD3D25C23B22B83E27BD3C24B63D26B93A22B43A23B63922B43922B03720AD3620A23A26A1352151515198311E96311E992F1D94301E922F1E912F1E922C1B8226188226173E3E3E50332E3B3836652419462F2A5C251B35302E57211942201939221E3B1F1A2626263C1D194E160D49160C242424331D18411710371A16351B162E1B182D1916201E1E2C19172E181531171230161137130C251A172618161D1A191F19181919192F0E0724120E280E0A22100D151515230F0C250E0A2C0B052109051D09061809060E569B6F0000000174524E530040E6D866000001734944415478DA6360A02EB0139166638671981819E1123173E76BB0B341D8814B16C87141A5986686649A9B08723001D9BE6B53AA374BF231812518A765E4AB59980A713030C82E8DAB34DBE8C70DD1C23C9D45534B7D46B1389BE0A67883498B54FCA1128CC2EB597878586615BA6C496E98B2B74CD1136A14035784358BB6AEB1E8AE9C8AC93BB382A505604E641688B262D1D3372C2AE8DB57A220C5CF0A772F2B7B9A250B2FAF6AEBB6A9E1C2FCCC485EE4E4365A9CDEC8CB6B6CA921698BEC7726D90D91354D86FA7A6D56B1DC9C48123EFB956B276C152DD5D56EB78E6647D891B450D9A07777AA9128D0D92D6BE4E1AECA9B93D86CB6275BC15B6599BA9666E76A0F2E883F98E625D4F5EC285794629730B150ABEF58252206F5F9EC89FD07AA9464F859D9244CCD55BB56060941CC62945BBE5D27D4CB1168278790CE8A75DDF2E2504BB8DC450264D8C1AEE4100CCB551276808615239F98B33DD4F56CECAE6E4E3648D1C9046333B371B0E24B0700373150EBEAA3E2D40000000049454E44AE426082',14,14)
[sql] Failed to execute: INSERT INTO workflow_icon (name,mime_type,file_value,width,height) VALUES ('Commentaire','image/png','89504E470D0A1A0A0000000D4948445200000020000000200806000000737A7AF40000000467414D410000D904DCB2DA020000067849444154789CC5964D6C13E919C7FFF365C7C4CD879D8F0D64EDB80E34C28BA304A9212840D4224E143801074A94037BD86DC3A16AA54891B85184A05237D96AA52A3D80842A558A90E0C20A11407CE4404C886CC7DE86754C242731AC89673CB6C733F33E3D9044D9ACD776AA7EFCA5F734EFBCCFEF79DE79FEF300FF6709956EDCBF7F7FF7E9D3A74FF03CCFCBB29CD7342DF79F00102BDD78EAD4A9C1919191DFACAEAEE2EDDBB7C9783CFE4D241299999999090483C1D94824F26D3A9D7EBF5D00AECC73E1EAD5ABBF773A9D1F777575FDCAED767F6C1806044180244910840F05CCE572482693CBF178FC9F4B4B4B51C69856EC6C228224495C2010088D8E8E7E590960C3ECEC6C82D654281448370CCA9B26657339CA66B394CBE5289FCF53A150A04A35313111D8C8B00C80E3DCB973BFDEB56B57FDB70B0B48C932E464126C6E0E92D3094E92408C8188C01883AEEB6517C771304D7387CBE56A0D854221BE5C09789E474ED3109D9A82944C627E64047A3E0FB1BA1A2002C771DB5A8C31ECDCB9B3766868E8F3C6C6C676BEBFBFFFC8F1E3C77F590A8288505D5707737C1C5A4B0B2C7D7D0063955C6151711C877038FC5D241259168F1E3D3A32343474F4C68D1B7F49241219599697C7C6C6C600E8EBC1AB2C16581A1AB03A30008769C2AAEB802080E3CA7DC3C5835B2C1684C3E198AEEB09F1D2A54B5763B198E7E2C58B9F757474E0FEFDFBA1E6E6E6B6F1F1F13F2D2C2CA419631045113FEFEA02E338F01FEE10CC34FFED0A00C0ECECEC1C005920A2E5603098AAADAD3DB067CF1EFBDEBD7B1D8661D89A9B9BDB88A8AABFBFFF176EB7BB5E5614643319E83C0FA4D3E02509102AF6B10D0982005555313636762B168B3D1100E88CB185A74F9FBE4EA5529EB6B6B65DBDBDBD1FD5D4D4D8DFBD7B57B76FDF3E9FD3E9B43DBE7F1F862461FE8B2F509D4EA3C6EF07781EDC5A592B5D9224219148D0B56BD7461545F9663D853C11C55EBD7AF52A140AD99D4EE7DE9E9E9EC6EEEE6E573E9FB728B99C24BE7F0FF7D75F63657E1E6DC3C3B055558118DB761788A2886030981A1D1DFD3380E4E61AEA0096161717679E3C79A2582C169FCFE7ABF3783C92AA2848A82AD2990CD29F7C829FFA7CB08A15BBF8868808A228E2D9B367B1898989AF0064B65E220390521425383939199365D9DBD0D0D0E4F178D0E870A0AEB3133FF3FB515D550522DA56E0CD002F5FBE5CBC7DFBF6DF00E48B19110158D175FDEF77EFDEFD5296653C7FFE1C055D87C36E874514C1711C789E2F5BEEADC1D7B5B97D4B3961CEEFF74BBDBDBDF07ABD989E9E46341A85AEEB30D75A5092A492596F5DAC887995BCC8AEAE2EBF2008F07ABDB0D96C98999981AAAAB05AAD989A9AC2891327E072B960180668CD963707DC0A534CA50044BFDFBF6FFDE0A6A6261C3A7408939393181C1C84C3E1402814C2C0C0000E1C3800C6D80F322C0652B16C365BEBF4F4F4DB542A4544448661906118A4280A5DBE7C994451A41D3B76D0912347E8D6AD5B4444649A26699A469AA6513E9FA7DCDA2F5B555552559532990C1111DDBC793300A0AE2440676767FFD2D2124B2693DF03304D938888EEDDBB47BB77EF2600D4DADA4A57AE5C21555549D775D2346D23F83A4026932145518888E8FAF5EBCF00D49404387BF6EC6FB3D92C2D2F2F7F0F6033C49B376F687070900090CFE7A34C26438CB18DEC5555DDD8AF691A99A6498F1F3FD65A5A5AFE00C002941848CE9F3FFFE9C18307BB73B91CEC763B00FCA0BDEAEAEA70F2E449F87C3ED4D6D6429224343737C36AB5823106C330208A220CC300630C8140C03873E6CC578944E2AF004ACE8F96870F1F4E9BA6B95101D3348BAECDE3DAA3478FE8CE9D3B140E87299FCF532A9522455128954A51381CA6E1E1E159007BB0695EFC311F70A8AA5A158FC7CB7EB68C3198A6099EE771F8F0E18D8E2022E8BA8E6C368BB9B939489204C3300200E6F1C1EC4AEA2782201C6B6A6ABAFCE2C58BD5724326638C4CD3245DD7C9300C22225A5D5DA568344A0F1E3CA04824424444C78E1DFBDDD6403FE60319D3341F2493C99542A1F06939DACDF66B9A26D2E9345EBF7E8D743A8D8E8E0EB4B4B4409665168D46E72A0520000680950B172EFCC36EB7B7B3623EBAF92051E4EBEBEB6BDC6E77437B7B7B436767674D5F5F1FAC562B00607171F1BB783C3E5F29C0BADE8742A13FE2836994BB371E4015805A9EE73F72B95C6EAFD7EBF1F97C9E9E9E9EB6582C1601B0B2F5A5ED4F95E525009000D800D801D40368029006300B40FB6F0314D37AB7112AE880FFA9FE054D115D3C36C248200000000049454E44AE426082',14,14)
[sql] Failed to execute: DELETE FROM workflow_task WHERE id_action >= 300 AND id_action < 450 AND id_task != 303
[sql] Failed to execute: DELETE FROM workflow_action WHERE id_workflow >= 300 AND id_workflow < 400
[sql] Failed to execute: DELETE FROM workflow_state WHERE id_workflow >= 300 AND id_workflow < 400
[sql] Failed to execute: DELETE FROM workflow_workflow WHERE id_workflow >= 300 AND id_workflow < 400
[sql] Failed to execute: INSERT INTO workflow_workflow (id_workflow, name, description, creation_date, is_enabled, workgroup_key) VALUES (301,'Workflow GRU','Workflow GRU','2016-01-13 08:36:34',1,'all')
[sql] Failed to execute: INSERT INTO workflow_state (id_state, name, description, id_workflow, is_initial_state, is_required_workgroup_assigned, id_icon, display_order) VALUES (301,'Nouveau','Nouveau',301,1,0,NULL,1), (303,'A traiter','A traiter',301,0,0,NULL,2), (304,'En attente de compléments par l''usager','En attente de compléments par l''usager',301,0,0,NULL,3), (305,'Escaladé niveau 3','Le ticket est escaladé vers un agent de niveau 3',301,0,0,NULL,4), (306,'Traité','Traité',301,0,0,NULL,5)
[sql] Failed to execute: INSERT INTO workflow_action (id_action, name, description, id_workflow, id_state_before, id_state_after, id_icon, is_automatic, is_mass_action, display_order, is_automatic_reflexive_action) VALUES (301,'Initialisation','Initialisation de la sollicitation',301,301,303,1,1,0,1,0), (303,'Requalifier','Requalification de la sollicitation',301,303,303,1,0,0,2,0), (304,'Escalader','Escalade vers un agent de niveau 2',301,303,303,1,0,0,6,0), (305,'Escalader','Escalade vers un agent de niveau 3',301,303,305,1,0,0,7,0), (306,'Assigner à une autre entité','Assignation de la sollicitation à une autre entité',301,303,303,1,0,0,5,0), (307,'Assigner à un autre agent','Assignation de la sollicitation à un autre agent',301,303,303,1,0,0,4,0), (308,'Me l''assigner','Prise en charge de la sollicitation',301,303,303,1,0,0,3,0), (309,'Demander compléments','Demande d''informations complémentaires à l''usager',301,303,304,1,0,0,8,0), (310,'Répondre pour l''usager','Réponse à la place de l''usager',301,304,303,1,0,0,9,0), (311,'Répondre (usager)','Réponse de l''usager à une demande d''informations',301,304,303,1,0,0,10,0), (312,'Répondre à l''usager','Réponse finale à l''usager',301,303,306,1,0,1,11,0), (313,'Répondre à l''escalade', 'Réponse à l''escalade', 301, 305, 303, 1, 0, 0, 12, 0), (314,'Assigner à un autre agent','Assignation de la sollicitation à un autre agent',301,305,305,1,0,0,4,0), -- assignation a autre agent pour tickets escaladés
[sql] Failed to execute: INSERT INTO workflow_task (id_task, task_type_key, id_action, display_order) VALUES (301,'taskTicketingGenerateTicketReference',301,1), -- Initialize
[sql] Failed to execute: INSERT INTO workflow_task_comment_config (id_task, title, is_mandatory, is_richtext) VALUES (343, 'Commentaire', 0, 1), (352, 'Commentaire', 0, 1), (362, 'Commentaire', 0, 1), (372, 'Commentaire', 0, 1), (382, 'Commentaire', 0, 1), (387, 'Commentaire', 0, 1), (442, 'Commentaire', 0, 1), (462, 'Commentaire', 0, 1), (472, 'Commentaire', 0, 1)
[sql] Failed to execute: INSERT INTO workflow_task_ticketing_edit_ticket_config (id_task, message_direction, id_user_edition_action) VALUES (390, 1, 311), -- Ask for user information
[sql] Failed to execute: DELETE FROM workflow_task_ticketing_reply_config
[sql] Failed to execute: INSERT INTO workflow_task_ticketing_reply_config (id_task, message_direction, close_ticket) VALUES (420, 1, 1) -- Reply to user
[sql] Failed to execute: INSERT INTO `core_datastore` (`entity_key`, `entity_value`) VALUES ('ticketing.configuration.workflow.id', '301'), ('ticketing.configuration.states.selected', '303'), ('ticketing.configuration.states.selected.for.role.gru_level_3', '305'), ('ticketing.configuration.state.id.closed', '306'), ('ticketing.configuration.actions.filtered.when.assigned.to.me', '308;315'), ('ticketing.configuration.adminUser.id.front', '5'), ('ticketing.configuration.channel.id.front', '99')
[sql] Failed to execute: DELETE FROM workflow_task_ticketing_mark_unread_config
[sql] Failed to execute: INSERT INTO workflow_task_ticketing_mark_unread_config (id_task, id_marking) SELECT id_task, 1 FROM workflow_task WHERE task_type_key = 'taskTicketingMarkAsUnread' |
