Hi , Many database platforms have support for geometry / geography types that can enhance functionality of OFBiz.
Eg GeoPoint entity has longitude/latitude varchar fields which can also be stored in a "geography(Point,4326)" type supported in postgres via postgis extension. Such types supports many spatial functions and indexes that makes many operations effortless. My Question is what is the suggested way of extending OFBiz entities for adding columns in a way which can be maintained across OFBiz upgrades. At this moment i maintain a separate namespace other than ofbiz tables for storing such DB and application specific fields that are linked to ofbiz tables by primary key (generally). Is there other ways of doing this? regds mallah.
