Project

General

Profile

« Previous | Next » 

Revision 8613

Added by Aaron Marcuse-Kubitza almost 12 years ago

bugfix: schemas/VegCore/VegCore.ERD.mwb: fixed foreign keys without a referenced columns list

View differences:

schemas/VegCore/VegCore.my.sql
11 11 
  `info` SET('hstore') NULL ,
12 12 
  PRIMARY KEY (`id`) ,
13 13 
  CONSTRAINT `fk_collection_source10`
14 
    FOREIGN KEY ()
15 
    REFERENCES `record` ()
14 
    FOREIGN KEY (`id` )
15 
    REFERENCES `record` (`id` )
16 16 
    ON DELETE CASCADE
17 17 
    ON UPDATE CASCADE)
18 18 
ENGINE = InnoDB
......
384 384 
    ON DELETE CASCADE
385 385 
    ON UPDATE CASCADE,
386 386 
  CONSTRAINT `fk_taxon_determination_record1`
387 
    FOREIGN KEY ()
388 
    REFERENCES `taxon_observation` ()
387 
    FOREIGN KEY (`id` )
388 
    REFERENCES `taxon_observation` (`id` )
389 389 
    ON DELETE CASCADE
390 390 
    ON UPDATE CASCADE,
391 391 
  CONSTRAINT `fk_taxon_determination_party1`
......
424 424 
    ON DELETE CASCADE
425 425 
    ON UPDATE CASCADE,
426 426 
  CONSTRAINT `fk_taxon_occurrence_event1`
427 
    FOREIGN KEY ()
428 
    REFERENCES `record` ()
427 
    FOREIGN KEY (`id` )
428 
    REFERENCES `record` (`id` )
429 429 
    ON DELETE CASCADE
430 430 
    ON UPDATE CASCADE,
431 431 
  CONSTRAINT `fk_taxon_occurrence_party1`
......
531 531 
  `code` TEXT NULL ,
532 532 
  PRIMARY KEY (`id`) ,
533 533 
  CONSTRAINT `fk_individual_record1`
534 
    FOREIGN KEY ()
535 
    REFERENCES `taxon_occurrence` ()
534 
    FOREIGN KEY (`id` )
535 
    REFERENCES `taxon_occurrence` (`id` )
536 536 
    ON DELETE CASCADE
537 537 
    ON UPDATE CASCADE)
538 538 
ENGINE = InnoDB
......
550 550 
  PRIMARY KEY (`id`) ,
551 551 
  INDEX `fk_individual_observation_individual1_idx` (`individual` ASC) ,
552 552 
  CONSTRAINT `fk_individual_observation_taxon_occurrence1`
553 
    FOREIGN KEY ()
554 
    REFERENCES `taxon_observation` ()
553 
    FOREIGN KEY (`id` )
554 
    REFERENCES `taxon_observation` (`id` )
555 555 
    ON DELETE CASCADE
556 556 
    ON UPDATE CASCADE,
557 557 
  CONSTRAINT `fk_individual_observation_individual1`
......
628 628 
  PRIMARY KEY (`id`) ,
629 629 
  INDEX `fk_aggregate_observation_taxon_name1_idx` (`taxon` ASC) ,
630 630 
  CONSTRAINT `fk_aggregate_observation_taxon_occurrence1`
631 
    FOREIGN KEY ()
632 
    REFERENCES `taxon_observation` ()
631 
    FOREIGN KEY (`id` )
632 
    REFERENCES `taxon_observation` (`id` )
633 633 
    ON DELETE CASCADE
634 634 
    ON UPDATE CASCADE,
635 635 
  CONSTRAINT `fk_aggregate_observation_taxon_name1`
......
651 651 
  PRIMARY KEY (`id`) ,
652 652 
  INDEX `fk_taxon_presence_taxon_name1_idx` (`taxon` ASC) ,
653 653 
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1`
654 
    FOREIGN KEY ()
655 
    REFERENCES `taxon_observation` ()
654 
    FOREIGN KEY (`id` )
655 
    REFERENCES `taxon_observation` (`id` )
656 656 
    ON DELETE CASCADE
657 657 
    ON UPDATE CASCADE,
658 658 
  CONSTRAINT `fk_taxon_presence_taxon_name1`
......
1107 1107 
  PRIMARY KEY (`id`) ,
1108 1108 
  INDEX `fk_specimen_observation_specimen1_idx` (`specimen` ASC) ,
1109 1109 
  CONSTRAINT `fk_specimen_taxon_occurrence10`
1110 
    FOREIGN KEY ()
1111 
    REFERENCES `taxon_observation` ()
1110 
    FOREIGN KEY (`id` )
1111 
    REFERENCES `taxon_observation` (`id` )
1112 1112 
    ON DELETE CASCADE
1113 1113 
    ON UPDATE CASCADE,
1114 1114 
  CONSTRAINT `fk_specimen_observation_specimen1`

Also available in: Unified diff