-- WARNING: This will delete ALL data from projects and project_divisions tables
-- Use with caution - this removes both seed and user data

-- Disable foreign key checks temporarily
SET FOREIGN_KEY_CHECKS = 0;

-- Delete all projects
DELETE FROM projects;

-- Delete all project divisions
DELETE FROM project_divisions;

-- Re-enable foreign key checks
SET FOREIGN_KEY_CHECKS = 1;

-- Reset auto-increment counters
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;