-- Clean up seed data from projects and project_divisions tables
-- Run this SQL to remove all sample data

-- Delete all projects first (due to foreign key constraints)
DELETE FROM projects;

-- Delete all project divisions
DELETE FROM project_divisions;

-- Reset auto-increment counters (optional)
-- ALTER TABLE projects AUTO_INCREMENT = 1;
-- ALTER TABLE project_divisions AUTO_INCREMENT = 1;

-- Verify the cleanup
SELECT COUNT(*) as projects_count FROM projects;
SELECT COUNT(*) as divisions_count FROM project_divisions;