Loading...
Loading...
Search for a command to run...
Implement soft delete pattern with data recovery
Implement soft delete for these tables:
**Tables:**
```sql
{{TABLE_SCHEMA}}
```
**Requirements:**
- Retention period: {{RETENTION}}
- Recovery needs: {{RECOVERY_NEEDS}}
- Audit requirements: {{AUDIT}}
**Database System:** {{DATABASE_SYSTEM}}
**ORM/Framework:** {{ORM}}
Please provide:
1. Schema modifications for soft delete
2. DELETE query rewrites
3. SELECT query modifications (exclude soft-deleted)
4. Index adjustments
5. View for hiding soft-deleted records
6. Cascading soft delete for related records
7. Recovery/restore procedures
8. Permanent deletion (purge) process
9. ORM configuration
10. Migration from hard delete
11. Performance considerationsOr press ⌘C to copy
Replace these placeholders with your own content before using the prompt.
{{TABLE_SCHEMA}{{RETENTION}{{RECOVERY_NEEDS}{{AUDIT}{{DATABASE_SYSTEM}{{ORM}Copy this prompt and paste it into your favorite AI tool