-- Add status columns to existing tables
ALTER TABLE news_submissions ADD COLUMN status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending';
ALTER TABLE edit_submissions ADD COLUMN status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending';
ALTER TABLE suggestions ADD COLUMN status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending';

-- Update existing records to have 'pending' status
UPDATE news_submissions SET status = 'pending' WHERE status IS NULL;
UPDATE edit_submissions SET status = 'pending' WHERE status IS NULL;
UPDATE suggestions SET status = 'pending' WHERE status IS NULL; 