Project

General

Profile

« Previous | Next » 

Revision 11378

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: place.locality: moved to geopath, because this is actually a rank of place (i.e. below municipality) rather than a field that every place could have

View differences:

schemas/VegCore/VegCore.my.sql
264 264 
  `state_province` varbinary(767) DEFAULT NULL,
265 265 
  `county` varbinary(767) DEFAULT NULL,
266 266 
  `municipality` varbinary(767) DEFAULT NULL,
267 
  `locality` varbinary(767) DEFAULT NULL,
267 268 
  `ranks` set('hstore') COLLATE utf8_bin DEFAULT NULL,
268 269 
  PRIMARY KEY (`id`)
269 270 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A named region';
......
619 620 
  `rank` varbinary(767) DEFAULT NULL,
620 621 
  `name` varbinary(767) DEFAULT NULL,
621 622 
  `geopath` varbinary(767) DEFAULT NULL,
622 
  `locality` varbinary(767) DEFAULT NULL,
623 623 
  `verbatim` set('hstore') COLLATE utf8_bin DEFAULT NULL COMMENT 'for verbatim coordinates, etc.',
624 624 
  PRIMARY KEY (`id`),
625 625 
  KEY `fk_place1_idx` (`parent`),
schemas/VegCore/VegCore.pg.sql
266 266 
  "state_province" text DEFAULT NULL,
267 267 
  "county" text DEFAULT NULL,
268 268 
  "municipality" text DEFAULT NULL,
269 
  "locality" text DEFAULT NULL,
269 270 
  "ranks" hstore DEFAULT NULL,
270 271 
  PRIMARY KEY ("id")
271 272 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A named region'*/;
......
621 622 
  "rank" text DEFAULT NULL,
622 623 
  "name" text DEFAULT NULL,
623 624 
  "geopath" text DEFAULT NULL,
624 
  "locality" text DEFAULT NULL,
625 625 
  "verbatim" hstore DEFAULT NULL /*COMMENT 'for verbatim coordinates, etc.'*/,
626 626 
  PRIMARY KEY ("id"),
627 627 
  /*KEY "fk_place1_idx" ("parent")*/CHECK (true),

Also available in: Unified diff