Page History

...

1. export the GeoPoint entity with webtools export.
2. drop the table
3. restart the system.
4. Import the exported file

R1647271 Refactoring of Visit/Visitor/ServerHit* (and related) entities in order to be able to maintain them in a database separate from the main transactional database:

Added a new entity group ("org.ofbiz.stats") for the Visit/Visitor/ServerHit* (and related) entities; for now the group is not active so that the entities are still in the same database as before; however assigning them to a different database is now a matter of uncommenting the group file definition in framework/webapp/ofbiz-component.xml and provide the new datasource definition

 Removed foreign key relationship from/to this group of entities and the other entities of the OFBiz data model; the fields are still available but they are not enforced by a foreign key constraint

ALTER TABLE CONTENT_SEARCH_RESULT DROP FOREIGN KEY CNT_SCHRES_VST;

ALTER TABLE TRACKING_CODE_VISIT DROP FOREIGN KEY TKNG_CODVST_VST;

ALTER TABLE CART_ABANDONED_LINE DROP FOREIGN KEY CART_ABLN_VST;

ALTER TABLE SHOPPING_LIST DROP FOREIGN KEY SHLIST_VSTR;

ALTER TABLE PARTY_NEED DROP FOREIGN KEY PARTY_NEED_VSIT;

ALTER TABLE PARTY_DATA_SOURCE DROP FOREIGN KEY PARTY_DATSRC_VST;

ALTER TABLE INVENTORY_ITEM_TEMP_RES DROP FOREIGN KEY INV_ITEM_TR_VIS;

ALTER TABLE PRODUCT_SEARCH_RESULT DROP FOREIGN KEY PROD_SCHRES_VST;

ALTER TABLE OLD_PRODUCT_KEYWORD_RESULT DROP FOREIGN KEY PROD_KWDRES_VST;

ALTER TABLE WORK_EFFORT_SEARCH_RESULT DROP FOREIGN KEY WEFF_SCHRES_VST;

ALTER TABLE OLD_PRODUCT_KEYWORD_RESULT DROP FOREIGN KEY PROD_KWDRES_VST;

ALTER TABLE VISIT DROP FOREIGN KEY VISIT_CIP_STPRV;

ALTER TABLE VISIT DROP FOREIGN KEY VISIT_CIP_CNTRY;

ALTER TABLE VISIT DROP FOREIGN KEY VISIT_CONT_MECH;

ALTER TABLE VISIT DROP FOREIGN KEY VISIT_PARTY;

ALTER TABLE VISIT DROP FOREIGN KEY VISIT_ROLE_TYPE;

ALTER TABLE VISIT DROP FOREIGN KEY VISIT_PARTY_ROLE;

ALTER TABLE VISITOR DROP FOREIGN KEY VISITOR_PARTY;

ALTER TABLE SERVER_HIT DROP FOREIGN KEY SERVER_HIT_STATUS;

ALTER TABLE SERVER_HIT DROP FOREIGN KEY SERVER_HIT_USER;

R1709192 "SalaryStep entity was missing From and Thru dates"

Jira
server ASF JIRA serverId 5aa69414-a9e9-3523-82ec-879b028fb15b key OFBIZ-5758

...