Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • The performance of the Self-Service Portal for users with a lot of companies associated (100+ companies) has been improved.

Database

  • Breaking change: Execute these statements after the update:

Expand
titleSQL statement
Code Block
languagesql
SELECT COUNT(*) INTO @index_exists
FROM information_schema.statistics
WHERE table_name = 'taskscheduler_task_workitem_lock'
  AND index_name = 'IDX_22ACA89994B19A8683918539C5E9C67AE6C72D6E_GENERATED';

-- Conditionally drop the index
SET @drop_stmt = IF(@index_exists > 0, 'ALTER TABLE taskscheduler_task_workitem_lock DROP INDEX IDX_22ACA89994B19A8683918539C5E9C67AE6C72D6E_GENERATED', 'SELECT ''Index does not exist.''');
PREPARE stmt FROM @drop_stmt;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

INSERT IGNORE INTO api_action__api_security_resource	(api_action_id, api_security_resource_id) VALUES
	 (0x31F72A7AF0B0FDCF5A0FEAFB2D147472E5539FAC,2),
	 (0xC41B3D04D9A121AFE0BA91D72B2CC09F1F3A45ED,2),
	 (0xDFE5E829287B840C672FAAD1E4060606D66C8478,2);