[ 
https://issues.apache.org/jira/browse/OFBIZ-1313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12532533
 ] 

Si Chen commented on OFBIZ-1313:
--------------------------------

Do you think there will be a way to remove old Visits and keep the 
TrackingCodeVisit tables.  Should we just temporarily drop the constraint and 
readding it later with a SQL script?

> Remove some Visit-related foreign keys
> --------------------------------------
>
>                 Key: OFBIZ-1313
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1313
>             Project: OFBiz
>          Issue Type: Improvement
>            Reporter: Si Chen
>            Assignee: Si Chen
>            Priority: Minor
>
> I would recommend that we remove the foreign keys to the Visit entity, so old 
> Visit records can be safely deleted without affecting data in 
> TrackingCodeVisit, which might be useful for statistical and reporting 
> purposes.  It should not affect the core entities.  The visits would only no 
> longer be available after some time has passed.
> If no one has any objections I'll take care of this.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to