Actions
Task #10089
closed
Provides "archived" tables
Start date:
06/09/2015
Due date:
% Done:
0%
Estimated time:
Description
Provides archiving solution for jrequess and jqueues tables
Updated by Chambon Bernard almost 10 years ago
- After a small brainstorming it appears that ...
- Caution when using trigger, mainly in case of foreign key.
- I don't want provide the feature at application level (due to status of current code)
- The solution must be 'simple'
- We decided to limit to jrequests table, using a trigger
Trigger will be fired when request is done (status 140, 150 or 160 and tries >=3)
archived_jrequests will be the same jrequest + a field to store the activation_time from jqueue.
(Obviously php monitoring tool should be adapted to archived_jrequests table)
Updated by Chambon Bernard almost 10 years ago
- Status changed from New to Closed
Done.
A new table 'archived_jrequests' has been created + a trigger wired to jrequests.
Updated by Chambon Bernard almost 10 years ago
- Priority changed from Normal to High
Actions