pluf/tms

ALTER TABLE `tms_activities` 
   DROP FOREIGN KEY `fk__og7ly066n56jt9dt523wpges6`;

ALTER TABLE `tms_activities` 
   ADD CONSTRAINT `fk__og7ly066n56jt9dt523wpges6` 
   FOREIGN KEY (`assign_id`) 
   REFERENCES `user_accounts` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_activities` 
   DROP FOREIGN KEY `fk__9fwkg6uqt3e098ojf2b3dh9i5`;

ALTER TABLE `tms_activities` 
   ADD CONSTRAINT `fk__9fwkg6uqt3e098ojf2b3dh9i5` 
   FOREIGN KEY (`project_id`) 
   REFERENCES `tms_projects` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_activities` 
   DROP FOREIGN KEY `fk__9rxl1b3tntof3dm905torkt1f`;

ALTER TABLE `tms_activities` 
   ADD CONSTRAINT `fk__9rxl1b3tntof3dm905torkt1f` 
   FOREIGN KEY (`test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;
   
   

ALTER TABLE `tms_activity_user_account_assoc` 
   DROP FOREIGN KEY `fk__jvknee78ba55plotl51nj0qu4`;

    
ALTER TABLE `tms_activity_user_account_assoc` 
   ADD CONSTRAINT `fk__jvknee78ba55plotl51nj0qu4` 
   FOREIGN KEY (`user_account_id`) 
   REFERENCES `user_accounts` (`id`)
   ON DELETE CASCADE;
   
   
ALTER TABLE `tms_activity_user_account_assoc` 
   DROP FOREIGN KEY `fk__ox2ponhfpqn8m1omyp6knuk2c`;

ALTER TABLE `tms_activity_user_account_assoc` 
   ADD CONSTRAINT `fk__ox2ponhfpqn8m1omyp6knuk2c` 
   FOREIGN KEY (`tms_activity_id`) 
   REFERENCES `tms_activities` (`id`)
   ON DELETE CASCADE;
/*
* Add foreign keys
*/

ALTER TABLE `tms_activity_comments` 
   DROP FOREIGN KEY `fk__bt69hs89orb56yfj1824g2m7y` ;
   
ALTER TABLE `tms_activity_comments` 
   ADD CONSTRAINT `fk__bt69hs89orb56yfj1824g2m7y`
   FOREIGN KEY (`activity_id`) 
   REFERENCES `tms_activities` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_activity_comments` 
   DROP FOREIGN KEY `fk__cuyhcl61bou6lb9s1koy4wm7e`;

ALTER TABLE `tms_activity_comments` 
   ADD CONSTRAINT `fk__cuyhcl61bou6lb9s1koy4wm7e`
   FOREIGN KEY (`writer_id`) 
   REFERENCES `user_accounts` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_activity_logs` 
   DROP FOREIGN KEY `fk__i1b0ngrql34xk7b5sa73orw9i`; 

ALTER TABLE `tms_activity_logs` 
   ADD CONSTRAINT `fk__i1b0ngrql34xk7b5sa73orw9i` 
   FOREIGN KEY (`activity_id`) 
   REFERENCES `tms_activities` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_activity_logs` 
   DROP FOREIGN KEY `fk__rdwocioirdhr884ejtjiqrbk1`;
    
ALTER TABLE `tms_activity_logs` 
   ADD CONSTRAINT `fk__rdwocioirdhr884ejtjiqrbk1` 
   FOREIGN KEY (`project_id`) 
   REFERENCES `tms_projects` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_activity_logs` 
   DROP FOREIGN KEY `fk__51cp3re0jd666kke82rnygmxj`;
    
ALTER TABLE `tms_activity_logs` 
   ADD CONSTRAINT `fk__51cp3re0jd666kke82rnygmxj` 
   FOREIGN KEY (`test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_activity_logs` 
   DROP FOREIGN KEY `fk__64e2cpdi6c2uvwfayo2l5w0h1`;
    
ALTER TABLE `tms_activity_logs` 
   ADD CONSTRAINT `fk__64e2cpdi6c2uvwfayo2l5w0h1` 
   FOREIGN KEY (`writer_id`) 
   REFERENCES `user_accounts` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_activity_outputs` 
   DROP FOREIGN KEY `fk__b59db444utbewexb09qlf4n4y`; 

ALTER TABLE `tms_activity_outputs` 
   ADD CONSTRAINT `fk__b59db444utbewexb09qlf4n4y` 
   FOREIGN KEY (`activity_id`) 
   REFERENCES `tms_activities` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_activity_steps` 
   DROP FOREIGN KEY `fk__fwk5k8uf2xrenfu8samwulcam`;
    
ALTER TABLE `tms_activity_steps` 
   ADD CONSTRAINT `fk__fwk5k8uf2xrenfu8samwulcam` 
   FOREIGN KEY (`activity_id`) 
   REFERENCES `tms_activities` (`id`)
   ON DELETE CASCADE;

ALTER TABLE `tms_projects` 
   DROP FOREIGN KEY `fk__mq8rbfm4b44ak989oc0mjkmg2`;
    
ALTER TABLE `tms_projects` 
   ADD CONSTRAINT `fk__mq8rbfm4b44ak989oc0mjkmg2` 
   FOREIGN KEY (`manager_id`) 
   REFERENCES `user_accounts` (`id`)
   ON DELETE SET NULL;

ALTER TABLE `tms_project_user_account_assoc` 
   DROP FOREIGN KEY `fk__othxp8u3q5k7fey8irj0bqqw7`; 

ALTER TABLE `tms_project_user_account_assoc` 
   ADD CONSTRAINT `fk__othxp8u3q5k7fey8irj0bqqw7` 
   FOREIGN KEY (`tms_project_id`) 
   REFERENCES `tms_projects` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_project_user_account_assoc` 
   DROP FOREIGN KEY `fk__mruh0lawqnd51vb1v2d5ah112`;
    
ALTER TABLE `tms_project_user_account_assoc` 
   ADD CONSTRAINT `fk__mruh0lawqnd51vb1v2d5ah112` 
   FOREIGN KEY (`user_account_id`) 
   REFERENCES `user_accounts` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_requirements` 
   DROP FOREIGN KEY `fk__a7wh19e81i7tg0yxxwpipqj6v`;
    
ALTER TABLE `tms_requirements` 
   ADD CONSTRAINT `fk__a7wh19e81i7tg0yxxwpipqj6v` 
   FOREIGN KEY (`project_id`) 
   REFERENCES `tms_projects` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_scenarios` 
   DROP FOREIGN KEY `fk__c37ta975yrwt1vejw58x1x6a4`;
    
ALTER TABLE `tms_scenarios` 
   ADD CONSTRAINT `fk__c37ta975yrwt1vejw58x1x6a4` 
   FOREIGN KEY (`virtual_user_id`) 
   REFERENCES `tms_virtual_users` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_tests` 
   DROP FOREIGN KEY `fk__p0erxajbtqxu9l3rd8qq60t0k`;
    
ALTER TABLE `tms_tests` 
   ADD CONSTRAINT `fk__p0erxajbtqxu9l3rd8qq60t0k` 
   FOREIGN KEY (`project_id`) 
   REFERENCES `tms_projects` (`id`)
   ON DELETE CASCADE;

ALTER TABLE `tms_tests` 
   DROP FOREIGN KEY `fk__apu43sh7fqk3u1q6c2jc6sxlt`;
    
ALTER TABLE `tms_tests` 
   ADD CONSTRAINT `fk__apu43sh7fqk3u1q6c2jc6sxlt` 
   FOREIGN KEY (`responsible_id`) 
   REFERENCES `user_accounts` (`id`)
   ON DELETE SET NULL;


ALTER TABLE `tms_test_user_account_assoc` 
   DROP FOREIGN KEY `fk__ja59utr7r1sa9cvlh322r48bi`;
    
ALTER TABLE `tms_test_user_account_assoc` 
   ADD CONSTRAINT `fk__ja59utr7r1sa9cvlh322r48bi` 
   FOREIGN KEY (`tms_test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_test_user_account_assoc` 
   DROP FOREIGN KEY `fk__3jb55dp4svrxerknbb6t9d13i`;
    
ALTER TABLE `tms_test_user_account_assoc` 
   ADD CONSTRAINT `fk__3jb55dp4svrxerknbb6t9d13i` 
   FOREIGN KEY (`user_account_id`) 
   REFERENCES `user_accounts` (`id`)
   ON DELETE CASCADE;
   

ALTER TABLE `tms_test_acceptance_criteria` 
   DROP FOREIGN KEY `fk__qtdxy4frlgewvobpoocw1an4o`;
    
ALTER TABLE `tms_test_acceptance_criteria` 
   ADD CONSTRAINT `fk__qtdxy4frlgewvobpoocw1an4o` 
   FOREIGN KEY (`test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_test_attachments` 
   DROP FOREIGN KEY `fk__tdg3amjhin0i92bvnolw3yxkv`;
    
ALTER TABLE `tms_test_attachments` 
   ADD CONSTRAINT `fk__tdg3amjhin0i92bvnolw3yxkv` 
   FOREIGN KEY (`test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_test_comments` 
   DROP FOREIGN KEY `fk__5yub80cobh1hb8qdtvri4tonv`;
    
ALTER TABLE `tms_test_comments` 
   ADD CONSTRAINT `fk__5yub80cobh1hb8qdtvri4tonv` 
   FOREIGN KEY (`test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_test_comments` 
   DROP FOREIGN KEY `fk__pklix22imprv4nkc0ww7fm0c4`;
    
ALTER TABLE `tms_test_comments` 
   ADD CONSTRAINT `fk__pklix22imprv4nkc0ww7fm0c4` 
   FOREIGN KEY (`writer_id`) 
   REFERENCES `user_accounts` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_test_histories` 
   DROP FOREIGN KEY `fk__8ws7vxxyxmxg41jwpdb2yic6f`;
    
ALTER TABLE `tms_test_histories` 
   ADD CONSTRAINT `fk__8ws7vxxyxmxg41jwpdb2yic6f` 
   FOREIGN KEY (`test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_test_histories` 
   DROP FOREIGN KEY `fk__2u4njawdjwd5g19pk6299eopu`;
    
ALTER TABLE `tms_test_histories` 
   ADD CONSTRAINT `fk__2u4njawdjwd5g19pk6299eopu` 
   FOREIGN KEY (`account_id`) 
   REFERENCES `user_accounts` (`id`)
   ON DELETE SET NULL;


ALTER TABLE `tms_requirement_tms_test_assoc` 
   DROP FOREIGN KEY `fk__5qw7sb02epcyki90pces7mkfo`;
  
    
ALTER TABLE `tms_requirement_tms_test_assoc` 
   ADD CONSTRAINT `fk__5qw7sb02epcyki90pces7mkfo` 
   FOREIGN KEY (`tms_requirement_id`) 
   REFERENCES `tms_requirements` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_requirement_tms_test_assoc` 
   DROP FOREIGN KEY `fk__tblpvqnos732t2l331gv1vc47`;
    
ALTER TABLE `tms_requirement_tms_test_assoc` 
   ADD CONSTRAINT `fk__tblpvqnos732t2l331gv1vc47` 
   FOREIGN KEY (`tms_test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_test_risks` 
   DROP FOREIGN KEY `fk__6jq70kkr375mc0agpr0dkkhnr`;
    
ALTER TABLE `tms_test_risks` 
   ADD CONSTRAINT `fk__6jq70kkr375mc0agpr0dkkhnr` 
   FOREIGN KEY (`test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_test_run_reports` 
   DROP FOREIGN KEY `fk__2n71mvbqp9dj9hjkwdd3x42sl`;
    
ALTER TABLE `tms_test_run_reports` 
   ADD CONSTRAINT `fk__2n71mvbqp9dj9hjkwdd3x42sl` 
   FOREIGN KEY (`test_run_id`) 
   REFERENCES `tms_test_runs` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_test_runs` 
   DROP FOREIGN KEY `fk__qshkrcst8jyrgdu6tobs1m5yh`;
    
ALTER TABLE `tms_test_runs` 
   ADD CONSTRAINT `fk__qshkrcst8jyrgdu6tobs1m5yh` 
   FOREIGN KEY (`test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_test_variables` 
   DROP FOREIGN KEY `fk__hbldml5x76ht2gvcpicm9l5kx`;
    
ALTER TABLE `tms_test_variables` 
   ADD CONSTRAINT `fk__hbldml5x76ht2gvcpicm9l5kx` 
   FOREIGN KEY (`test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;


ALTER TABLE `tms_virtual_users` 
   DROP FOREIGN KEY `fk__t5yyi6221wuwvj4a6lfxgbcml`;
    
ALTER TABLE `tms_virtual_users` 
   ADD CONSTRAINT `fk__t5yyi6221wuwvj4a6lfxgbcml` 
   FOREIGN KEY (`test_id`) 
   REFERENCES `tms_tests` (`id`)
   ON DELETE CASCADE;