Changes between Version 17 and Version 18 of DespoinaLog/2010/12/07


Ignore:
Timestamp:
2010-12-07T16:43:57+01:00 (13 years ago)
Author:
antonak
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DespoinaLog/2010/12/07

    v17 v18  
    1010   * Update db
    1111   * TODO : insert DATA!
    12    *    * mysql> INSERT INTO !`Biobank` VALUES ('Agnes',34,'core','800','2010-11-25','see PLoS ONE 3(10): e3583. !doi:10.1371/journal.pone.0003583',1);ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (!`bbmri`.!`biobank`, CONSTRAINT !`biobank_ibfk_1` FOREIGN KEY (!`id`) REFERENCES !`panel` (!`id`) ON DELETE CASCADE)
    13    *
     12     * * mysql> INSERT INTO !`Biobank` VALUES ('Agnes',34,'core','800','2010-11-25','see PLoS ONE 3(10): e3583. !doi:10.1371/journal.pone.0003583',1);ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (!`bbmri`.!`biobank`, CONSTRAINT !`biobank_ibfk_1` FOREIGN KEY (!`id`) REFERENCES !`panel` (!`id`) ON DELETE CASCADE) *
     13   * batch upload : '''keys are missing: !OntologyTerm.[name]'''
    1414= D2R on gcc model: : Materials conflict =
    1515{{{