Guest User

Untitled

a guest
Oct 16th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. CREATE TABLE `oro_workflow_restriction` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `workflow_step_id` int(11) DEFAULT NULL,
  4. `workflow_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  5. `attribute` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  6. `field` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  7. `entity_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  8. `mode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  9. `mode_values` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:json_array)',
  10. PRIMARY KEY (`id`),
  11. UNIQUE KEY `oro_workflow_restriction_idx` (`workflow_name`,`workflow_step_id`,`field`,`entity_class`,`mode`),
  12. KEY `IDX_3D2C17E271FE882C` (`workflow_step_id`),
  13. KEY `IDX_3D2C17E21BBC6E3D` (`workflow_name`),
  14. CONSTRAINT `FK_3D2C17E21BBC6E3D` FOREIGN KEY (`workflow_name`) REFERENCES `oro_workflow_definition` (`name`) ON DELETE CASCADE,
  15. CONSTRAINT `FK_3D2C17E271FE882C` FOREIGN KEY (`workflow_step_id`) REFERENCES `oro_workflow_step` (`id`) ON DELETE CASCADE
  16. ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Add Comment
Please, Sign In to add comment