workflow.sql

来自「PHP 知识管理系统（基于树结构的知识管理系统）, 英文原版的PHP源码。」· SQL 代码 · 共 8 行

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`);