Changes between Version 2 and Version 3 of DespoinaLog/2011/03/29

Timestamp:

2011-03-29T15:14:12+02:00 (14 years ago)

Author:

antonak

Comment:

--

DespoinaLog/2011/03/29

@@ -8 +8 @@
 || melanoma || GenoMEL || Core Biobanks || Population, development, birth and growth || lala || 1200 || dna || 600 || blabla || bla blabla bla ||
 || melanoma || POLYGENE || Core Biobanks || Aging || blabla || 800 || plasma || 197 || blabla || bla ||
+
+
+
+compare -- diff bbmri_29_march.mysql ~/Desktop/bbmri_gcc_22march_backup.mysql : except from the capitalized constraint in every CONSTRAINT, there are differences that may produce this problem : 
+
+added constrain in Measurement entity : 
+
+<   KEY !`targettypeAllowedForRelation` (!`targettypeAllowedForRelation`),
+
+'''<   CONSTRAINT !`measurement_ibfk_3` FOREIGN KEY (!`targettypeAllowedForRelation`) REFERENCES !`molgenisentity` (!`id`),'''
+
+<   CONSTRAINT !`measurement_ibfk_1` FOREIGN KEY (!`id`) REFERENCES !`observablefeature` (!`id`) ON DELETE CASCADE,
+
+<   CONSTRAINT !`measurement_ibfk_2` FOREIGN KEY (!`unit`) REFERENCES !`ontologyterm` (!`id`)
+
+---
+
+>   CONSTRAINT !`Measurement_ibfk_1` FOREIGN KEY (!`id`) REFERENCES !`ObservableFeature` (!`id`) ON DELETE CASCADE,
+
+>   CONSTRAINT !`Measurement_ibfk_2` FOREIGN KEY (!`unit`) REFERENCES !`OntologyTerm` (!`id`)
+
+----------------------------removed constraint from entity 812,813c795,797<   UNIQUE KEY !`name` (!`name`),<   CONSTRAINT !`observationtarget_ibfk_1` FOREIGN KEY (!`id`) REFERENCES !`observationelement` (!`id`) ON DELETE CASCADE--->   UNIQUE KEY !`Investigation_name` (!`Investigation`,!`name`),>   CONSTRAINT !`ObservationTarget_ibfk_1` FOREIGN KEY (!`id`) REFERENCES !`ObservationElement` (!`id`) ON DELETE CASCADE,>   CONSTRAINT !`ObservationTarget_ibfk_2` FOREIGN KEY (!`Investigation`) REFERENCES !`Investigation` (!`id`)