/usr/share/pegasus/sql/alter_stampede_4.0.sql is in pegasus-wms 4.4.0+dfsg-7.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 | -- UPDATE THE STAMPEDE DATABASE TO ADD CASCADED DELETES
-- TO BE RUN ONLY BY AN ADMIN on existing V4.0 Stampede SCHEMA DB in MYSQL
-- Example invocation is mysql -u username -p -h hostname databasename < upgrade_stampede_4.0.sql
--
-- Table structure for table `file`
--
ALTER TABLE `file` DROP FOREIGN KEY `file_ibfk_1`;
ALTER TABLE `file` ADD CONSTRAINT `file_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `task` (`task_id`) ON DELETE CASCADE;
--
-- Table structure for table `host`
--
ALTER TABLE `host` DROP FOREIGN KEY `host_ibfk_1`;
ALTER TABLE `host` ADD CONSTRAINT `host_ibfk_1` FOREIGN KEY (`wf_id`) REFERENCES `workflow` (`wf_id`) ON DELETE CASCADE;
--
-- Table structure for table `invocation`
--
ALTER TABLE `invocation` DROP FOREIGN KEY `invocation_ibfk_1`;
ALTER TABLE `invocation` DROP FOREIGN KEY `invocation_ibfk_2`;
ALTER TABLE `invocation` ADD CONSTRAINT `invocation_ibfk_1` FOREIGN KEY (`job_instance_id`) REFERENCES `job_instance` (`job_instance_id`) ON DELETE CASCADE;
ALTER TABLE `invocation` ADD CONSTRAINT `invocation_ibfk_2` FOREIGN KEY (`wf_id`) REFERENCES `workflow` (`wf_id`) ON DELETE CASCADE;
--
-- Table structure for table `job`
--
ALTER TABLE `job` DROP FOREIGN KEY `job_ibfk_1`;
ALTER TABLE `job` ADD CONSTRAINT `job_ibfk_1` FOREIGN KEY (`wf_id`) REFERENCES `workflow` (`wf_id`) ON DELETE CASCADE;
--
-- Table structure for table `job_edge`
--
ALTER TABLE `job_edge` DROP FOREIGN KEY `job_edge_ibfk_1`;
ALTER TABLE `job_edge` ADD CONSTRAINT `job_edge_ibfk_1` FOREIGN KEY (`wf_id`) REFERENCES `workflow` (`wf_id`) ON DELETE CASCADE;
--
-- Table structure for table `job_instance`
--
ALTER TABLE `job_instance` DROP FOREIGN KEY `job_instance_ibfk_1`;
ALTER TABLE `job_instance` ADD CONSTRAINT `job_instance_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `job` (`job_id`) ON DELETE CASCADE;
--
-- Table structure for table `jobstate`
--
ALTER TABLE `jobstate` DROP FOREIGN KEY `jobstate_ibfk_1`;
ALTER TABLE `jobstate` ADD CONSTRAINT `jobstate_ibfk_1` FOREIGN KEY (`job_instance_id`) REFERENCES `job_instance` (`job_instance_id`) ON DELETE CASCADE;
--
-- Table structure for table `task`
--
ALTER TABLE `task` DROP FOREIGN KEY `task_ibfk_2`;
ALTER TABLE `task` ADD CONSTRAINT `task_ibfk_2` FOREIGN KEY (`wf_id`) REFERENCES `workflow` (`wf_id`) ON DELETE CASCADE;
--
-- Table structure for table `task_edge`
--
ALTER TABLE `task_edge` DROP FOREIGN KEY `task_edge_ibfk_1`;
ALTER TABLE `task_edge` ADD CONSTRAINT `task_edge_ibfk_1` FOREIGN KEY (`wf_id`) REFERENCES `workflow` (`wf_id`) ON DELETE CASCADE;
--
-- Table structure for table `workflow`
--
ALTER TABLE `workflow` DROP FOREIGN KEY `workflow_ibfk_1`;
ALTER TABLE `workflow` ADD CONSTRAINT `workflow_ibfk_1` FOREIGN KEY (`parent_wf_id`) REFERENCES `workflow` (`wf_id`) ON DELETE CASCADE;
--
-- Table structure for table `workflowstate`
--
ALTER TABLE `workflowstate` DROP FOREIGN KEY `workflowstate_ibfk_1`;
ALTER TABLE `workflowstate` ADD CONSTRAINT `workflowstate_ibfk_1` FOREIGN KEY (`wf_id`) REFERENCES `workflow` (`wf_id`) ON DELETE CASCADE;
|