Add audit log pruning strategy for large datasets

[nanaf6203-bit]

Design an audit log pruning strategy for performance.

Acceptance Criteria:

• Retention rules and pruning frequency are defined.
• Implementation or migration support is added.
• Old logs can be archived before deletion.
• Tests verify pruning logic if implemented.