Project

General

Profile

« Previous | Next » 

Revision 8568

schemas/VegCore/VegCore.ERD.mwb: validatable_place: added unique index on identifying columns

View differences:

schemas/VegCore/VegCore.my.sql
740 740
  PRIMARY KEY (`id`) ,
741 741
  INDEX `fk_geovalidation_place_path1` (`path` ASC) ,
742 742
  INDEX `fk_geovalidation_coordinates1` (`coordinates` ASC) ,
743
  UNIQUE INDEX `validatable_place_unique` (`path` ASC, `coordinates` ASC) ,
743 744
  CONSTRAINT `fk_geovalidation_place_path1`
744 745
    FOREIGN KEY (`path` )
745 746
    REFERENCES `place_path` (`id` )

Also available in: Unified diff