topic SQL script to purge ACTIVITI tables in Alfresco Archive

SQL script to purge ACTIVITI tables

pbreak75 — Thu, 27 Oct 2016 10:22:09 GMT

Hello,Did ACTIVITI provide a script tu purge the database (Activiti tables) ?Regards._____________________________________________________________________________Bonjour,Existe-il un script pour purger les données ACTIVITI ?Merci d'avance,Cordialement,

Re: SQL script to purge ACTIVITI tables

bpmn — Thu, 03 Nov 2016 07:40:31 GMT

In my app while testing I'm doing like that and it seems to work fine without any side-effects:
<code>
drop table act_ge_bytearray ,act_ge_property ,act_hi_actinst ,act_hi_attachment ,act_hi_comment ,act_hi_detail ,act_hi_procinst ,act_hi_taskinst ,act_hi_varinst ,act_id_group ,act_id_info ,act_id_membership ,act_id_user ,act_re_deployment ,act_re_model ,act_re_procdef ,act_ru_event_subscr,act_ru_execution ,act_ru_identitylink,act_ru_job ,act_ru_task ,act_ru_variable;
</code>

Re: SQL script to purge ACTIVITI tables

pbreak75 — Thu, 24 Nov 2016 10:18:37 GMT

Thank you for your response.
I want to delete by date , not all the database.