Changes between Version 4 and Version 5 of DespoinaLog_molgenis35Tomolgenis14

Timestamp:

2013-02-22T11:33:19+01:00 (12 years ago)

Author:

antonak

Comment:

--

DespoinaLog_molgenis35Tomolgenis14

@@ -1 @@
- 1. Copy the new war file to tomcat's directory : 
+ 1. Copy the new war file to tomcat's directory :
  1. data live in the old mysql database (molgenis14 ) so you need to run the steps of the migration script : https://www.dropbox.com/home/BBmri%20App/migration_issue?select=migration-script.rtf) in order to change only the scheme NOT the data
 
@@ -28 +28 @@
 ALTER TABLE Biobank DROP FOREIGN KEY biobank_ibfk_5; 
 
-ALTER TABLE BiobankSubCategory ADD FOREIGN KEY (id) REFERENCES OntologyTerm (id) ON DELETE CASCADE; 
-
+ALTER TABLE BiobankSubCategory ADD FOREIGN KEY (id) REFERENCES OntologyTerm (id) ON DELETE CASCADE;   <----------IF THIS FAILS USE THE NEXT : 
 ALTER TABLE `BiobankSubCategory`  
 ADD CONSTRAINT `biobank_ibfk_5` 
     FOREIGN KEY (`id`) REFERENCES OntologyTerm (id) ON DELETE CASCADE; AUTO UPARXEI HDH APO THN DHMIOURGIA TOU)
 
-ALTER TABLE Biobank ADD FOREIGN KEY (SubCategory) REFERENCES BiobankSubCategory (id) ON DELETE RESTRICT; 
+ALTER TABLE Biobank ADD FOREIGN KEY (SubCategory) REFERENCES BiobankSubCategory (id) ON DELETE RESTRICT; <----------IF THIS FAILS USE THE NEXT : 
+
 
 ALTER TABLE `Biobank`