Women Community Comments System Setup
⚠️ Important: This script will add the comments system to your Women Community platform.
Make sure your discussions table already exists before running this.
What this will add:
- Comments table with foreign key to discussions
- Comments count column to discussions table
- Automatic comment counting with triggers
- Performance indexes for fast queries
- Sample comments for testing
Features included:
1. Users can comment on any discussion except their own
2. Automatic comments counting
3. Proper database relationships with foreign keys
4. Automatic timestamp updates
5. Performance optimized with indexes
6. Sample data for immediate testing