--
-- Script run when an upgrade of Dolibarr is done. Whatever is the Dolibarr version.
--

DELETE FROM llx_rights_def WHERE perms = 'document' AND module = 'einvoicing' AND id >= 9502004;

UPDATE llx_rights_def SET perms = 'document' WHERE perms = 'call' AND module = 'einvoicing';

ALTER TABLE llx_einvoicing_call ADD COLUMN batchlimit integer NOT NULL DEFAULT 1;

UPDATE llx_einvoicing_document SET flow_type = 'sync' WHERE flow_type IS NULL;

ALTER TABLE llx_einvoicing_document MODIFY COLUMN flow_type varchar(64);

ALTER TABLE llx_einvoicing_document ADD COLUMN response_for_debug text;

ALTER TABLE llx_einvoicing_call MODIFY COLUMN totalflow integer NULL DEFAULT NULL;

ALTER TABLE llx_einvoicing_routing ADD COLUMN routing_type varchar(12) NOT NULL DEFAULT 'thirdparty';

ALTER TABLE llx_einvoicing_extlinks ADD COLUMN override_routing_id varchar(255) NULL DEFAULT NULL;

ALTER TABLE llx_einvoicing_document MODIFY COLUMN tracking_idref varchar(255);

ALTER TABLE llx_einvoicing_call ALTER COLUMN entity SET DEFAULT 1;

ALTER TABLE llx_einvoicing_extlinks ADD COLUMN ap_precheck_status varchar(50) DEFAULT NULL;

ALTER TABLE llx_einvoicing_extlinks ADD COLUMN ap_precheck_result text DEFAULT NULL;
