Revision 8559
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 745 | 745 |
-- ----------------------------------------------------- |
| 746 | 746 |
CREATE TABLE IF NOT EXISTS `geovalidation` ( |
| 747 | 747 |
`id` TEXT NOT NULL , |
| 748 |
`named_place` TEXT NOT NULL , |
|
| 748 | 749 |
`coordinates` TEXT NOT NULL , |
| 749 |
`named_place` TEXT NOT NULL , |
|
| 750 | 750 |
PRIMARY KEY (`id`) , |
| 751 | 751 |
INDEX `fk_geovalidation_coordinates1` (`coordinates` ASC) , |
| 752 | 752 |
INDEX `fk_geovalidation_placename1` (`named_place` ASC) , |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: geovalidation: put named_place before coordinates so they would be in path order (one named_place can have many coordinates in it)