This repository has been archived on 2024-11-28. You can view files and clone it, but cannot push or open issues or pull requests.
Incam_SGD/sql/mysql/upgrade/2.99.2/workflow.sql

8 lines
579 B
MySQL
Raw Permalink Normal View History

ALTER TABLE `workflow_states` ADD COLUMN `inform_descriptor_id` int(11) default NULL;
ALTER TABLE `workflow_transitions` CHANGE COLUMN `guard_permission_id` `guard_permission_id` int(11) default '0'; # was int(11) NOT NULL default '0'
ALTER TABLE `workflow_transitions` ADD COLUMN `guard_group_id` int(11) default '0';
ALTER TABLE `workflow_transitions` ADD COLUMN `guard_role_id` int(11) default '0';
ALTER TABLE `workflow_transitions` ADD COLUMN `guard_condition_id` int(11) default NULL;
ALTER TABLE `workflow_transitions` ADD INDEX `guard_condition` (`guard_condition_id`);